Printable View
I am trying to connect to test database where I running two instances. I also update both TNSNAME.ORA and LISTNER.ORA. From some reason when I try to connect through sql from client side to one of the instance giving an error….
ORA-12513: TNS: service handler found but it has registered for a different protocol
But I can connect to other instance without any problem.
I’m not sure what is wrong…any idea?
can you give us more detail.
Thanks
They seems to have the different protocol. i.e check the tnsnames.ora and listener.ora files and make sure that the service_name that you are trying to call uses the same protocol. If they both are the same, then check your parameter file for the instance in the initSID.ora and make sure that you have specified the correct protocol adaptor name in the MTS_DISPATCHER parameter, incase if you are using the Multi threaded server option.
Hope this would fix your problem. If not let us know.
Sam
I think problem is in listener.ora. Both of my instances are running of my same ORACLE_HOME. Could it be the problem? Here is copy of my listner.ora…..
I can tnsping both of my instances without any problem and locally I can connect through sql on both instance. It is when I connect from a client through sql I can connect to only one instance. My listener is running and both services is up.
Thanks
################
# Filename......: listener
# Name..........:
# Date..........:
################
SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=ipc)
(KEY= db03.world)
)
(ADDRESS=
(PROTOCOL=ipc)
(KEY= db03)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= testdb.world)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= testdb)
)
(ADDRESS =
(COMMUNITY = db03.world)
(PROTOCOL = tcp)
(Host = xxx.xxx.xxx.22)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = db03.world)
(SID_NAME = db03)
(ORACLE_HOME = /xtrn5/u01/home/oracle/product/8.0.5)
(PRESPAWN_MAX = 10)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = testdb.world)
(SID_NAME = testdb)
(ORACLE_HOME = /xtrn5/u01/home/oracle/product/8.0.5)
(PRESPAWN_MAX = 10)
)
)
It could be an issue with the db03.world. At one point you seems to be calling it using the IPC and at another point you are calling the same instance with the TCP. Check that out.
Sam