Set either ORACLE_SID or LOCAL to your "default" SID in either Windows environment variables or registry.
The general difference between ORACLE_SID and LOCAL is that, with ORACLE_SID you can specify only instances in local server, but with LOCAL you can set any TNS alias (the same as TWO_TASK in Unix) Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 20, 2003 6:39 AM > 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 > > > virvitdb - my local DB on my machine. > Here tnsnames.ora file: > VIRVITDB = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = virvit)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = virvitdb.prodtorg.udm.net) > ) > ) > > EXTPROC_CONNECTION_DATA = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0)) > ) > (CONNECT_DATA = > (SID = PLSExtProc) > (PRESENTATION = RO) > ) > ) > > And Listener.ora: > LISTENER = > (DESCRIPTION_LIST = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) > ) > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = virvit)(PORT = 1521)) > ) > ) > > SID_LIST_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = D:\oracle\ora92) > (PROGRAM = extproc) > ) > (SID_DESC = > (GLOBAL_DBNAME = virvitdb.prodtorg.udm.net) > (ORACLE_HOME = D:\oracle\ora92) > (SID_NAME = virvitdb) > ) > ) > > > -- > Поцелуев Виталий Игоревич (VirVit) > Oracle 9i DBA beginner > > > -- > Please see the official ORACLE-L FAQ [EMAIL PROTECTED] vices--858-538-5051httpwww.fatcity.zl6SanDiego,California--Mailinglistandweb hostingservices------------------------------------------------------------- -------- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
