ORA-12516: TNS:listener could not find available handler with matching prot
894623Nov 7 2011 — edited Nov 7 2011Hi,
Im using oracle 11g, on linux 64 bit
Im getting this error
ORA-12516: TNS:listener could not find available handler with matching protocol stack
When i connect to oracle db as sysdba, Its connecting in idle instance
SQL> connect / as sysdba
Connected to an idle instance.
When i run lsnrctl commands
-----------
$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-NOV-2011 11:15:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 17-OCT-2011 19:44:42
Uptime 20 days 16 hr. 30 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/list ener.ora
Listener Log File /u01/app/diag/tnslsnr/ip-10-114-47-248/listener/alert/ log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-10-114-47-248)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-10-114-47-248)(PORT=8080))(Presen tation=HTTP)(Session=RAW))
Services Summary...
Service "RSDB1" has 1 instance(s).
Instance "RSDB1", status READY, has 1 handler(s) for this service...
Service "RSDB1XDB" has 1 instance(s).
Instance "RSDB1", status READY, has 1 handler(s) for this service...
Service "RSDB1_XPT" has 1 instance(s).
Instance "RSDB1", status READY, has 1 handler(s) for this service...
The command completed successfully
-----
$ lsnrctl service
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-NOV-2011 11:15:52
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "RSDB1" has 1 instance(s).
Instance "RSDB1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3197 refused:0 state:blocked
LOCAL SERVER
Service "RSDB1XDB" has 1 instance(s).
Instance "RSDB1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:120 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: ip-10-114-47-248, pid: 2195>
(ADDRESS=(PROTOCOL=tcp)(HOST=ip-10-114-47-248)(PORT=22548))
Service "RSDB1_XPT" has 1 instance(s).
Instance "RSDB1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3197 refused:0 state:blocked
LOCAL SERVER
The command completed successfully
Please let me know to solve this issue.
thanks
Edited by: praveenb on Nov 7, 2011 10:22 PM
Edited by: praveenb on Nov 7, 2011 10:24 PM