Re: Connecting to Local Database under windows95

Using Personal Oracle in Windows 95 is kind of a unique scenario. You can have only one instance up and running at a given point in time in Windows 95. So when you start SQL plus, it automatically picks up the current active instance. I have configured my PO7 to handle 2 databases, of course only one at a time. When I start SQL*Plus (a generic icon), it automatically connects to the active instance.

In UNIX when you bring up an instance, you specify the ORACLE_SID and no SQL*Net is necessary. But even on the same Unix machine, if you are connected to one instance (or database) and you are referring to an object in another instance (or database), using a connect string, you still need to configure SQL*Net, because with SQL*Net config, you not only identify the IP address of the machine and protocol, you specify the SID also. So connecting to a second database on the same machine needs SQL*Net, atleast for SID name.

In PO7, you may enter 2: for connect string, which will specify that the database is local. And 2: is the default, in Personal Oracle. If you want more information on Windows 95 instance, you may want to look in your registry (Start --> Run --> REGEDIT --> HKEY_LOCAL_MACHINE --> SOFTWARE --> ORACLE. If you highlight ORACLE, you will see entries like ORACLE_SID, DBA_AUTHORIZATION etc).

Hope this helps.
CM

In article <3530C02D.BF7_at_ibm.net>,
  azaman <azaman_at_ibm.net> wrote:
>
> Hi Folks
>
> Can someone explain to me how sqlplus logs on to a local database
> on a PC ?
>
> I am running Personal Oracle for windows95. When connect string
> is left blank, sqlplus logs me on to local database. I want to
> understand the mechanism. For example, on unix, if you are
> connecting to different database on the same machine, you don't
> need anr SQL*Net software. Does it work the same way on the
> PC ?
>
> I will appreciate an e-mail. Thanking in advance
>
> Arif Zaman
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 13 1998 - 11:48:13 CDT