RE: Local connect to database (default connection)

From: Grant Allen <Grant.Allen_at_towersoft.com.au>
Date: Wed, 19 Nov 2003 20:59:59 -0800
Message-ID: <F001.005D7332.20031119205959@fatcity.com>

VirVit,

Looks to me like ORACLE_SID isn't specified in your windows environment.

Check the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 for a string key called ORACLE_SID. If it's there, set it to your SID. If it's not, add it and set it to your SID. Alternatively, set an environment variable named ORACLE_SID to your desired SID.

Ciao
Fuzzy
:-)

---

The contents of this post are my opinions only

      If swallowed seek medical advice

> -----Original Message-----
> From: VirVit [mailto:virvit_at_prodtorg.udm.net]
> Sent: Thursday, 20 November 2003 15:40
> To: Multiple recipients of list ORACLE-L
> Subject: Local connect to database (default connection)
>
>
> Hello!
>
> I have next problem: I've setup Listener and TNS Names and I
> can connect to
> database but only when SID is specified. I want to specify
> default database
> to connect to.
>
> D:\Backup\oracle>sqlplus cheques/cheques
> SQL*Plus: Release 9.0.1.3.0 - Production on ½?Ô  À 20 08:33:55 2003
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> D:\Backup\oracle>sqlplus cheques/cheques_at_virvitdb
> SQL*Plus: Release 9.0.1.3.0 - Production on ½?Ô  À 20 08:34:56 2003
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.4.0 - Production

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: Grant.Allen_at_towersoft.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Nov 19 2003 - 22:59:59 CST