connection error [message #478221] |
Thu, 07 October 2010 05:17 |
luker
Messages: 8 Registered: October 2010
|
Junior Member |
|
|
Hi all, i have a problem reguarding my db. It is installed on two machines in a balance configuration. I get an error when i try to connect, the error i get is this:
ORA-12516, TNS:listener could not find available handler with matching protocol stack
The Connection descriptor used by the client was:
(DESCRIPTION=(LOAD_BALANCE=on) (FAILOVER=on) (ADDRESS= (PROTOCOL=tcp)(HOST=XXX.XXX.XXX.XXX) (PORT=1521)) (ADDRESS= (PROTOCOL=tcp)(HOST=XXX.XXX.XXX.XXX) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=XXXXX) (FAILOVER_MODE= (TYPE=select) (METHOD=basic))))
I do not have access to this machine via ssh or telnet, the only access i have is via toad using the connection string written above.
Can anyone help me?
Thanks
|
|
|
|
|
|
|
Re: connection error [message #478246 is a reply to message #478232] |
Thu, 07 October 2010 07:52 |
|
Michel Cadot
Messages: 68684 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Check to make sure that the service handlers (e.g. dispatchers)
for the given SERVICE_NAME are registered with the listener, are accepting
connections, and that they are properly configured to support the desired
protocols.
Use lsnrctl command.
Regards
Michel
|
|
|