ORA-12518: TNS:listener could not hand off client connection
Hi,
I'm on 10g R2 on winXP Pro.
I followed this link to create standby on the same host :
http://www.mid.main.vsu.ru/docs/oracle/server.816/a76995/standbys.htm#29841
When I try to connect to standby I receive ORA-12518 error :
C:\Documents and Settings\user>set ORACLE_SID=stdby1
C:\Documents and Settings\user>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Dim. Ao¹t 5 09:30:43 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys/change_on_install@standby1
ERROR:
ORA-12518: TNS:listener could not hand off client connection
Here is my listener.ora :
///////////////////////////////////////////////
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME=orcl2)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME =orcl2)
)
(SID_DESC=
(SID_NAME=stdby1)
(ORACLE_HOME= C:\oracle\product\10.2.0\db_1)
)
)
SID_LIST_STBY1_LISTENER = (SID_LIST= (SID_DESC=(SID_NAME=stdby1)(ORACLE_HOME= C:\oracle\product\10.2.0\db_1)))
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP.b-a-w.com)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL=ipc) (KEY=kstdby1))
)
)
DIRECT_HANDOFF_TTC_LISTENER = OFF
////////////////////////////////////////////
Here is tnsnames.ora for standby1 :
standby1 = (DESCRIPTION=
(ADDRESS=(PROTOCOL=ipc) (KEY=kstdby1))
(CONNECT_DATA=(SID=stdby1)))
/////////////////////////////////////////
if I tnsping standby1 :
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=ipc) (KEY=kstdby1)) (CONNECT_DATA=(SID=stdby1)))
OK (0 msec)
////////////////////////////////////////////
Here are services :
Le service "PLSExtProc" comporte 1 instance(s).
L'instance "PLSExtProc", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
Gestionnaire(s) :
"DEDICATED" Útabli : 0 refusÚ : 0
LOCAL SERVER
Le service "stdby1" comporte 1 instance(s).
L'instance "stdby1", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
Gestionnaire(s) :
"DEDICATED" Útabli : 0 refusÚ : 1
LOCAL SERVER
La commande a rÚussi///////////////////////////////
many thanks for your help.