Installing Oracle 9i Developer In Windows Xp

Install Oracle 9i developer in windows xp To install Oracle developer 9i in your pc and make sure it will work, you need to make 3 steps, the first step is to install the it, the second step is to configure it to be connected to the database then the last step is to install JInitiator. First step: installing the developer 9i: As with most Windows installation programs, inserting the CD-ROM into the CD-ROM drive automatically executes the setup program. If this does not happen, use the Windows Explorer to view the contents of your CD-ROM drive and double click on the "setup" program there. After this you will get the following screen; chose Install Oracle9iDS

This will launch the Oracle Universal Installer

Click on the Next button to move to the File Locations screen as shown below; in this screen the Source and Destination locations must be selected. The Source path should reflect either your CD-ROM or the directory in which you unzipped the source files. Leave this as the default. For the Destination, it is recommended that you create a new Oracle Home. In this installation I select the Name and path as shown below.

Click on the Next button to load the Product information. This may take up to 2 minutes (depending on the speed of your machine). Once the product information has been read, the following 4 Installation Types are presented:

The four types are: • •

• •

J2EE Development: Uses JDeveloper with Oralce's "Oracle Containers for Java" (OC4J) Java code to create Java 2 Enterprise Edition applications. Business Intelligence: Includes the Warehouse builder, Discoverer tools (OLAP client) and Clickstream Intelligence Builder along with the core OC4J code. (No forms development software or CASE tools are included) Rapid Application Development: CASE tools (Designer), Forms and Reports development tools, JDeveloper and OC4J. Complete: Installs all of the above.

For this installation, we chose the complete installation. Click on the Next button then you will be asked to enter e-mail address

Oracle Reports can be distributed using an SMTP mail relay. If you have your outgoing email mandler handy, put in its host name or IP address. If not, it is OK to leave this blank as you can fill it in later. Click on the Next button

At this point, the installer has everything it needs. Click on the "Install" button to start the install.

After waiting you will be prompted to insert the next CD. You may also notice that 1 or 2 Windows Command Prompts (cmd.exe) will open up. These are commands that are unpacking files. Do not close these. The installer will close them automatically once they have completed.

After some time you will be asked to make a configuration, don’t change the default values, we will edit it later, so just click next

Now, the installation should be complete:

Click on the "Exit" button to exit the Oracle Universal Installer

Second step: Configure the 9iDS to be connected to database: To connect the developer with the database, you will need to configure a Net Services Name under 9iDS to point to the Oracle9i database. Before you start, make sure you understand which Oracle Home was used to install your database and which was used to install your 9iDS. First of all make sure you have a local host listener running for your Oracle9i Database. This can be done in several steps. First, make sure the Windows Services related to the oracle database and Listener are running. Within the Windows Control Panel, go to "Administrative Tools" and then run the "Services".

Note that your Service names may be slightly different depending on your preferneces when you installed the database. Notice that the database instance named ORCL.

Now let us create “Local Net service Name configuration”: 1. Follow the link Start -> programs -> Oracle - Orahome90 -> Configuration and Migration Tools -> Net Configuration Assistant (if you use 9i database) Or start -> All programs -> Oracle-Oracle10g_home1 -> Configuration and Migration Tools -> Net Configuration Assistant (if you use 10g database like the picture below)

Then the Configuration Assistant will open

2. Select the "Local Net Service Name" as shown below:

3. Choose "Add" as shown below and click the Next button:

4. Choose "Oracle8i or later Database" and click the Next button.

5. Type in the Service Name you gave the oracle9i Database when you installed it. The default is almost always "orcl".

6. Choose the TCP Protocol and click the Next button.

7. Since the database is running on your own PC, you can use the "localhost" as the host name. If this does not work, you can also try the localhost IP address of 127.0.0.1. Use the default port of 1521 unless you changed this when you installed your database.

8. You may choose to perform a test at this point (not shown here). As a final step, give the new net service name (this will be used in the "Database" field in 9iDS Forms or Reports when you first log in).

9. From this point on, just choose "No" to stop configuring Net Service Names and then Finish to exit out of the Net Configuration Assistant.

Third step: installing the JInitiator: Another step you will need to take (although it can be handled automatically), is to install Oralce's JInititor. Look for a file called jinit.exe in your 9iDS Home (under directory jinit). Jinit is a plugin Java runtime environment for MS IE and Netscape. It needs to be installed before you can view any forms or reports. It is best if you install this before beginning any development in 9iDS.