Re: ORACLE_SID and Windows NT

On the server you can use a connect string of the format "2:SID" to connect to different SIDs on
the same server without using SQL*Net. But if your application is reading the registry, you need
to change that behavior.

Sylvain Leclerc, DBA
INT Systèmes d'information
Membre du Groupe Magrit
sleclerc_at_magrit.com

> -----Original Message-----
> From: Vincent Duret [SMTP:vduret_at_trivium.fr]
> Posted At: Friday, October 23, 1998 3:55 AM
> Posted To: server
> Conversation: ORACLE_SID and Windows NT
> Subject: ORACLE_SID and Windows NT
>
> 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 Fri Oct 23 1998 - 07:52:49 CDT