Home » RDBMS Server » Networking and Gateways » ERROR, ORA-12520: TNS:listener could not find available handler for requested type of server
ERROR, ORA-12520: TNS:listener could not find available handler for requested type of server [message #288258] Sun, 16 December 2007 13:56 Go to next message
geeklol
Messages: 59
Registered: March 2005
Member
i just did a migration from 9i to 10g.
The export, import all went well.
Then i am trying to change the listener port from 1521 to 2958.
It is a clustered database database.
I have 2 listener's.
Once is the default listener which listens on 1521.
Second listener is supposed to listen on 2958.

After i changed the listener.ora and tnsnames.ora on the server to the requested port, all looks good. It is listening on the new listener,

On server, when i do tnsping it is listening to the new port,
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dashgp) (INSTANCE_NAME = dashgp1)))
OK (10 msec)

My listener status shows,
LSNRCTL> set current_listener LISTENERS_DASHGP
Current Listener is LISTENERS_DASHGP
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=stgas4odb01-vip)(PORT=2598))
STATUS of the LISTENER
------------------------
Alias LISTENER_STGAS4ODB01
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 16-DEC-2007 10:08:53
Uptime 0 days 1 hr. 37 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/local/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/10.2.0/network/log/listener_stgas4odb01.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.56)(PORT=2598)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.55)(PORT=2598)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dashgp" has 2 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Instance "dashgp2", status READY, has 1 handler(s) for this service...
Service "dashgpXDB" has 2 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Instance "dashgp2", status READY, has 1 handler(s) for this service...
Service "dashgp_XPT" has 2 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Instance "dashgp2", status READY, has 1 handler(s) for this service...
The command completed successfully


and my local listener shows,
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 16-DEC-2007 10:02:20
Uptime 0 days 1 hr. 44 min. 36 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/local/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stgas4odb01)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "dashgp" has 1 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Service "dashgpXDB" has 1 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Service "dashgp_XPT" has 1 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Service "lcecgd3" has 2 instance(s).
Instance "lcecgd31", status READY, has 2 handler(s) for this service...
Instance "lcecgd32", status READY, has 1 handler(s) for this service...
Service "lcecgd3XDB" has 2 instance(s).
Instance "lcecgd31", status READY, has 1 handler(s) for this service...
Instance "lcecgd32", status READY, has 1 handler(s) for this service...
Service "lcecgd3_XPT" has 2 instance(s).
Instance "lcecgd31", status READY, has 2 handler(s) for this service...
Instance "lcecgd32", status READY, has 1 handler(s) for this service...
Service "rcat" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
Service "rcatXDB" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
Service "rcat_XPT" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
The command completed successfully

so it is configured correctly.

I am using a client TNS file and that entry shows,
# TNSNAMES.ORA Network Configuration File: C:\oracle\product\920\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

dashgp1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.2.55)(PORT = 2598))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)
(INSTANCE_NAME = dashgp1)
)
)


dashgp2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.101.2.57)(PORT = 2598))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)
(INSTANCE_NAME = dashgp2)
)
)
------------------------

now, when i connect from the server after setting the ORACLE_SID to dashgp1, i am able to connect.

But when i connect from SQL plus using the above tns entry, i cannot connect it gives me error,
ORA-12520: TNS:listener could not find available handler for requested type of server

If in my local tnsfile i change the port to 1521 it connect fine.

I did stop and start the listener and the instance a few times but nothing changes.

What am i doing incorrect?

Myself and the other DBA here thinks it has to do with the network/firewall problem. Please help!

Re: ERROR, ORA-12520: TNS:listener could not find available handler for requested type of server [message #288284 is a reply to message #288258] Sun, 16 December 2007 22:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. stop your local listener services and try
if problem exists then
2. increase processes parameter value & restart oracle db and try.

[Updated on: Sun, 16 December 2007 22:38]

Report message to a moderator

Re: ERROR, ORA-12520: TNS:listener could not find available handler for requested type of server [message #288479 is a reply to message #288284] Mon, 17 December 2007 13:25 Go to previous messageGo to next message
geeklol
Messages: 59
Registered: March 2005
Member
I tried stopping and starting the local listener.
I set the sys parameter to 299, still doesn;t work.
Is there anything i need to do in portlist.ini, if i am changin the default listener port from 1521 to something else?
Re: ERROR, ORA-12520: TNS:listener could not find available handler for requested type of server [message #289528 is a reply to message #288258] Sun, 23 December 2007 11:38 Go to previous messageGo to next message
vishal_nitj04
Messages: 3
Registered: December 2007
Junior Member
Check out the entry of parameter NAMES.PREFERRED_SERVERS in sqlnet.ora and checkout the port number there.
Re: ERROR, ORA-12520: TNS:listener could not find available handler for requested type of server [message #291907 is a reply to message #288258] Mon, 07 January 2008 03:30 Go to previous message
vishym_68
Messages: 8
Registered: September 2007
Location: India
Junior Member
Hi,
If you want PMON to register with a local listener that does not use TCP/IP, port 1521,configure the LOCAL_LISTENER parameter in the initialization parameter file to locate the local listener.

Set the LOCAL_LISTENER parameter as follows:
LOCAL_LISTENER=listener_alias.

For example, if the listener is configured to listen on port 1421 rather than port 1521,you can set the LOCAL_LISTENER parameter in the initialization parameter file as
follows:
LOCAL_LISTENER=listener1

You can then resolve listener_alias <listener1> in the local tnsnames.ora as follows:
listener1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1421)))

Cheers,
Vishy
Previous Topic: Establishing Connection with Oracle on a Remote Server
Next Topic: ORA-12154: TNS:could not resolve service name when trying to connect to a newly created database
Goto Forum:
  


Current Time: Sun Dec 04 10:59:28 CST 2016

Total time taken to generate the page: 0.13436 seconds