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  |
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 #291907 is a reply to message #288258] |
Mon, 07 January 2008 03:30  |
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
|
|
|
|
Goto Forum:
Current Time: Thu Apr 18 19:11:43 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
