Re: Mulitple Instances on Windows NT

Its not so much that you have trouble setting up multiple instances, the problem is connecting to a specific instance. I was at a dba class this week, I had the same problem. The trainers said that its a problem that has been reported to oracle and apparently only affects NT. Setting TNSnames.ora with bequeth will not work. You need to go to a DOS shell and set your ORACLE_SID to the appropriate instance, and then you can connect to the correct instance.

Unfortunately, you will have to use this work around until Oracle fixes the problem.

John Tatar
Argonne National Laboratory
tatar_at_dis.anl.gov
Jeremiah P. O'Connell wrote:

> I am having trouble setting up multiple instances on a Windows NT
> server. I believe my problem is in my listeners.ora file. Both of the
> instances are running on the server but I can only connect to one of
> them from client machine. I could not find any information in the
> manuals on how to do this. Does anyone know where I could find
> information on how to do this?
>
> Thanks
> Jerry O'Connell
> jpoconnell_at_fnal.gov
Received on Sat Sep 20 1997 - 00:00:00 CDT