Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Database Networking (MOSC)

ORA-12516: TNS:listener could not find available handler with matching protocol stack

Feb 27, 2016 6:53PM edited Mar 4, 2016 7:36AM in Database Networking (MOSC) 2 commentsAnswered ✓

Hi,

We have a test database in 2 node RAC. we are unable to connect it using listener.

sqlplus apps/xxxxx@TEST

SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 27 17:49:14 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:

ORA-12516: TNS:listener could not find available handler with matching protocol

stack

tnsping test1

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 27-FEB-2016 17:50:36

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:

/TEST_oracle/oratest/racdb/product/11.2.0/network/admin/TEST1_st2dlxkn64/sqlnet_ifile.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=st2dlxkn64.connectria.com)(PORT=1527)) (CONNECT_DATA= (SERVICE_NAME=TEST) (INSTANCE_NAME=TEST1)))

Tagged:

moscmove

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month