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:[EMAIL PROTECTED]
> 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/[EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
