Hi there everybody,
I am running a primary and a standby database both on 8.1.7.4, win2k server and on separate servers.
I have configured the standby database so it in managed recover and is waiting for an archive log.
I seem to be getting an ORA-12505 error message when the primary database is trying to send the log to the standby database.
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
The primary databases TNSlistener.ora:
# TNSNAMES.ORA Network Configuration File: D:\Oracle\ora817\network\a
dmin\tnsna
mes.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.**
********* =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
INST1_HTTP.************* =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION =
http://admin)
)
)
TR2.*************** =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tr2)
)
)
STANDBY1 = (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)
(PORT=5112) (HOST=TEST-SERVER))
(CONNECT_DATA=(SID=standby
1)))
The standby databases listener.ora
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\ad
min\listen
er.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test-server)(PORT = 1521))
)
)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(PO
RT=5112)(H
OST=test-s
erver)))
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = test-server)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=standby1)
(ORACLE_HOME=\ORACLE\ORA81
))
(SID_DESC =
(GLOBAL_DBNAME = standby1.global)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = standby1)
)
)
STANDBY_LISTENER = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(PO
RT=5112)(H
OST=test-s
erver)))
SID_LIST_STBY1_LISTENER = (SID_LIST=
(SID_DESC=(SID_NAME=standb
y1)(ORACLE
_HOME=\ORA
CLE\ORA81)
))
The only other error that I could find on either of the server is a: TNS-12564: TNS:connection refused in the sqlnet.ora on the primary database.
I really need a fresh pair of eyes to look that this as I am sure that I am missing something very simple.
Thanks in advance
Eddy