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: http://www.orafaq.net
--
Author: VirVit
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).
