Thanks for videos. They are very easy to follow for a newbie like me. Please keep up the good work. I am following the videos and installing the ebussiness suite, I want to know how to install the oracle developer 6i and sql developer. can any one provide the steps for it as a continuation of the Installation and also the links for software.
Thanks in advance.

Hi Archana,

To work with forms and reports, you have to download
Oracle Developer Suite 10g (10.1.2.0.2).

Here is the link:
http://www.oracle.com/technology/software/products/ids/htdocs/101202winsoft.html

(download Oracle Developer Suite 10g (10.1.2.0.2) for Microsoft Windows)

Oracle SQL Developer 2.1 is pretty simple just download it from
http://www.oracle.com/technology/software/products/sql/index.html

(download Oracle SQL Developer for 32-bit Windows (This zip file includes the JDK1.6._11))

Cheers!
Shanmuga

Thanks for the prompt reply Shanmuga.
I have Linux installed on Vmware and then the Ebussiness suite( I am on this step now ). Do I install deveoper 10g on the server (linux) or on the client (windows vista ).
As I don't work in Oracle Environment,I just want to know in real work environment where toad,sqldeveloper and deveoper 10g is installed. Is it responsibility of a programmer or is it DBA's responsibility. If it is programmer's responsibility , when we get hired do we have all this setup or do we have to install these and set these up on our own.

Thanks in advance

Hi Archana,

Download windows version of DEV 10g and install it on the client machine.
In fact Install all utilities and tools like Putty(SSH clinet),Sqldev,Forms/Reports DEV on client machine.

Moreover even you access e-business suite (from client machine's Internet explorer)

Cheers!
Shanmuga

In an enterprise environment, DBAs will have the responsibility to install software including the one you mentioned (the database software, Developer 2000 Forms & Reports 6i Forms/Reports 6i/9i/10g, Oracle Discoverer EUL or Discoverer Server 4i etc…, assuming you are only interested in Oracle products and related products such as Toad.
Programmers do not get involved in installing or setting up software programs. Programmers just develop software application programs (front end) including Forms, Reports, Discoverer, XML applications. They also write code for the backend (database) and the front end (applications). They also perform customisation tasks.

Most companies would install Oracle databases and Oracle ERPs on Linux or Solaris platform, which is more stable and more secure than Microsoft platform.

Software like Toad, SQL Developer and Developer 10g are installed on windows platform on the client machine.

For learning and practice purposes, I would advise you install Oracle database, Forms and Reports 10g on your Windows XP. Oracle Forms and Oracle reports connect to Oracle Database. You may have to do a small configuration on Listener.ora and TNSnames.ora text files to provoke the link Forms and Reports 6i/9i/10g to Oracle database.

You don’t have to install SQL Developer separately when you already have Oracle database or Oracle Forms or Reports 6i/9i/10g installed.

If you install Oracle Apps 11i or Oracle Apps R12 on Windows platform, you will automatically have installed, Oracle database, Oracle Vista database, Oracle Forms and Reports 6i, Oracle Discoverer 4 EUL and Oracle Discoverer Server 4i, etc… I don’t know how it is when you install Oracle Apps on Linux platform.
I hope this is informative to you.

Cheers,
Gavrobere

very informative Gavrobere, Thanks much.

Very informative indeed. Thanks Gavrobere and Shanguma for sharing your knowledge.