Re: ORACLE_SID and Windows NT

Hi:

You specify the sid to connect to like so:

Oracle7.x: connect userid/password_at_2:sid (uses a "bequeath" connection, essentially IPC)
Oracle8.x: connect userid/password_at_sid.world . Set up an IPC descriptor in the listener.ora file for this sid, and a matching alias in the local tnsnames.ora file. IPC means "inter-process communication", so this only works locally. It asks the NET8 listener for a connection, but since's IPC is local only, it attaches directly to the instance process.

Good luck,
--

David C. Sisk
http://www.ipass.net/~davesisk/ORACLEonNT.htm

Vincent Duret wrote in message <70pcn6$2sg$1_at_jaydee.iway.fr>...
>Hello,
>
>A ProC software connects to an oracle database on a windows NT machine.
>The software and the database are running on the same machine. So SqlNet is
>not installed.
>For the moment, the software uses the registry key ORACLE_SID.
>It works fine because there is only one database running on the server.
>In the case of two databases the ORACLE_SID registry key points on one of
>the
>two databases at the same time.
>
>My question is :
>How can I do to make the software connect to the database without using the
>ORACLE_SID registry key ?
>If possible, a solution without installing SqlNet.
>
>Thanks
>
>-------------------------------------------------------------
>Vincent Duret (vduret_at_trivium.fr)
>TriVium - Les Arbres de Connaissances
>-------------------------------------------------------------
>
>
>
>
Received on Sun Oct 25 1998 - 20:32:57 CST