OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » connection error (oracle 10g on Oracle Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: connection error [message #478227 is a reply to message #478221]

Thu, 07 October 2010 05:45

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12516: TNS:listener could not find available handler with matching protocol stack
 *Cause: None of the known and available service handlers for the given
 SERVICE_NAME support the client's protocol stack: transport, session,
 and presentation protocols.
 *Action: 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.

Regards
Michel

Report message to a moderator

Re: connection error [message #478229 is a reply to message #478221]

Thu, 07 October 2010 06:01

luker
Messages: 8
Registered: October 2010

Junior Member

Thanks, but how can i do this? Wich commands should i run to verify the configuration?

Report message to a moderator

Re: connection error [message #478231 is a reply to message #478229]

Thu, 07 October 2010 06:06

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ask someone that has access to the server.

Regards
Michel

Report message to a moderator

Re: connection error [message #478232 is a reply to message #478231]

Thu, 07 October 2010 06:11

luker
Messages: 8
Registered: October 2010

Junior Member

I was curious about how to do it... can you provide us the solution, if you know it obviously.

Thanks.

Report message to a moderator

Re: connection error [message #478246 is a reply to message #478232]

Thu, 07 October 2010 07:52

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Database link throws ORA-04052 ORA-00604 ORA-12170
Next Topic:	Issues with component--11.2.0.2 upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 18:56:28 CST 2025