Skip to Main Content
  • Questions
  • Installing Oracle 8i and Developer 2000

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Dhanesh.

Asked: June 30, 2000 - 12:48 am UTC

Last updated: August 04, 2005 - 9:22 am UTC

Version: 8.1.5

Viewed 1000+ times

You Asked

Hi,

I need help in installing Oracle 8i and Developer 2000 in WinNT 4.0 machine. Please note that this is for testing purpose only. So need to install it in the same machine.

So I need to know -
(1) Procedure to do it
(2) How to configure Developer 2000 to point to Oracle Database
(3) Any additional tips and/or tricks you can recommend

Actually I attempted in installing, the result was that Developer 2000 (Forms) is not able to connect to the database.

Cheers
Dhanesh Shah

and Tom said...

Oracle8i is release 8.1.

D2K is based on 8.0.

You can install either first/second -- they will be installed into separate Oracle Homes. (separate directories).

You will need to use SQL*net to connect D2k to the database as the products are 2 different versions.

You'll setup and configure the Oracle8i listener using the configuration files in $ORACLE_HOME\network\admin (oracle home for the oracle8i instance). You can use the Oracle Home Selector tool to set your default Oracle home to the database. You'll be setting up the listener.ora. Once you have the sqlnet listener running, you'll be ready for the next step.

Use the Oracle Home selector now to set the default Oracle Home to the D2k Oracle home. You would now setup the tnsnames.ora file in the oracle_home\net80\admin (not network\admin, net80\admin). You'll have this point to the Oracle8i instance on your machine. You can use the tnsping tool to test this connection. Now you are ready to run d2k and connect to the 8i instance.

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

d2k+oracle9i

jasdeep, January 28, 2004 - 11:06 am UTC

i have win 2000 os and
oracle 9i installed on it
when install d2k on it it works fine
but when database is shutdown and restarted
listener doesn't starts
can anybody suggest some remedy.

Different Oracle Homes

Raghavarao RV, August 03, 2005 - 10:28 am UTC

Hi Tom

When we install Oracle 8.1.7 and D2k, the oracle creates it own home directory Oracle_Home and after that if we install, D2k, it tries to create its own home Default_home. If we install in this order (first oracle and second d2k) both are not working because of two homes.

When I installed the same in reverse order i.e., D2k first with "Default_home" and next Oracle 8.1.7 with Oracle_Home both are working fine.

Why it is so?

Another related query:

If because of some problem if I uninstall and remove all the registery entries (as d2k doesn't remove the registry entries and folders and icons) and try to re-install the Oracle 8.1.7, it shows all the oracle_homes which are previously installed like in this example, oracle_home and default home. If we give a new home as Ora_home, it is also coming in the next installation.

My question is after removing the *_home entries from the registry and removing all the oracle related folders, where are these homes stored? and how to remove those entries also?

Thanks in Advance




Tom Kyte
August 03, 2005 - 11:56 am UTC



define "not working", it could be a matter as simple as "you have to use the oracle home selector to set up your default oracle home"

but installation and configuration issues --> best handled by support. I haven't installed d2k in years and years (and pretty much the same with 817)

different homes

Ragahvarao RV, August 04, 2005 - 2:32 am UTC

Hi Tom

1. "Not working" in sense, I am not able to connect to the database or enterprise manager. It gives an error related to "NLS" and comes out. The application doesn't work.

2. This problem even I have got while installing Oracle 9i client in a client machine. After installation, as the system is not showing oracle driver in ODBC drivers list, I have uninstalled and remove the registry entries and I installed the client again giving different home. While installing, it was showing the previous homes and a particular folder is attached to each home.
For example I have installed oracle 9i client in c:\ora9i with oracle_home.
In the next install (second time install), I changed the directory folder to c:\ora90 and home as Ora_home as the installer not allowing to change the home name to different name with the same folder.
My question is where these home names are stored even after deleting the registry entries?
Request you to please provide a solution or any link which can give some information related to this. Why because, I am not able to configure oracle 9i client and oracle 9i drive in a client machine.

Thanks and regards
Raghav




Tom Kyte
August 04, 2005 - 9:22 am UTC

1) too vague, I cannot respond to that.

My car won't start.
It makes a funny noise.
Why won't it start?

You likely have a configuration issue (eg: back to oracle home selector)

2) please utilize support for installation and configuration issues, especially with software so old.

Different Homes

Raghavarao RV, August 05, 2005 - 5:51 am UTC

Hi Tom

Sorry to trouble you by giving the same sort of query. I have expected that you might give a link to get the solution. However, with your inspiration, I have tried my self and found the solution for the different homes problem.
While installing, the software creates a folder called oracle\inventory in local machine - program files folder, and stores some pages with the information related to the installation whcih stores the *.homes, directories which will be referred at the time of next installation. By deleting those files / entire that oracle\inventory folder, the traces left out were also cleaned up and in the next installation, it treat it as fresh installation. This has sorted out my problem.

Thanks and Regards
Raghav


More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library