Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to resolve "ORA-12516 in cluster"

User_C75NNFeb 28 2012 — edited Mar 1 2012

Hi,

Getting below error while connecting to database using tns.
"ORA-12516: TNS:listener could not find available handler with matching protocol stack"

apl11764a001:ORA37a > tnsping ora37_ap

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 28-FEB-2012 13:11:02

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

Used parameter files:
/grid/product/crs/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = apl11764clu01-scan-oravip.nat.bt.com)(PORT = 61901)) (CONNECT_DATA = (SERVICE_NAME = ORA37_ap)))
OK (0 msec)
apl11764a001:ORA37a > sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Feb 28 13:11:04 2012

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

Enter user-name: outln@ora37_ap
Enter password:
ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol stack

apl11764a001:ORA37a > lsnrctl status LISTENER_ORA37

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 28-FEB-2012 13:14:21

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ORA37)))
STATUS of the LISTENER
------------------------
Alias LISTENER_ORA37
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 27-FEB-2012 03:54:41
Uptime 1 days 9 hr. 19 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid/product/crs/network/admin/listener.ora
Listener Log File /grid/product/crs/log/diag/tnslsnr/apl11764a001/listener_ora37/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ORA37)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.169.4)(PORT=62037)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.169.7)(PORT=62037)))
The listener supports no services
The command completed successfully

This database is registered with 11.2.0.2 cluster.

apl11764a001:ORA37a > crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.2.0]

I tried to reload, stop and start the listener and still not supporting any services.

Please help me in resolving this issue.

Thank you.

Regards,
Dasarath

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2012

Added on Feb 28 2012

#oracle-clusterware, #performance-availability

7 comments

6,365 views