Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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: http://www.orafaq.net -- Author: VirVit INET: virvit_at_prodtorg.udm.net 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:39:55 CST
![]() |
![]() |