Hi Experts
I need help to get my 2nd DB up and running again and be able to connect to it.
I have one server with 2 10g DBs. Both are under the same Oracle Home. I recently patched my first DB up to release 10.2.0.2.0. This has the SID=ora10gdb1
Only a week ago I configured my 2nd DB using the dbca. It came up OK and seemed fine. I could access it through sqlplus and it showed up in EM. I then performed a shutdown immediate in order to perform a catalog upgrade, and since then I have not been able to connect to it again. It has the SID=Geneva.
All I get is the following error:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor
I have tried to register the database service through netmgr util. I have tried to manually register the service by entering the 2nd DB to listener.ora:
SID_LIST_LISTNER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/oracle/product/10.2.0
/ora10g_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Geneva)
(ORACLE_HOME = /app/oracle/product/10.2.0
/ora10g_1)
(SID_NAME = Geneva)
)
)
As you can see, my 1st DB is not registered here, but registers automatically.
lsnrctl services
LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 09-JUL-2006 19:27:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HO
ST=)(PORT=
1521))
Services Summary...
Service "ora10gdb1" has 1 instance(s).
Instance "ora10gdb1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:6 refused:0 state:ready
LOCAL SERVER
Service "ora10gdb1XDB" has 1 instance(s).
Instance "ora10gdb1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: oracle.anonymous.com, pid: 32239>
(ADDRESS=(PROTOCOL=tcp)(HO
ST=oracle.
anonymous.
com)(PORT=
59203))
Service "ora10gdb1_XPT" has 1 instance(s).
Instance "ora10gdb1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:6 refused:0 state:ready
LOCAL SERVER
Tnsnames exists for both instances:
ORA10GDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.anonymous.com)(PORT
= 1521))
)
(CONNECT_DATA =
(SID = ORA10GDB1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
GENEVA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.anonymous.com)(PORT
= 1521))
)
(CONNECT_DATA =
(SID = GENEVA)
)
)
I don't seem to be able to get the listener to find my 2nd DB so I would appreciate any help I could get.
Regards
KMS
Start Free Trial
