Hello everyone I'm unable to connect to my Oracle Server remotely using SQL developer ....while I can connect from SQL developer when I'm in the server directly ....I get the following error when I try to test my TNS listener
ORA-12520: TNS:listener could not find available handler for requested type of server
I followed the Oracle help ...and I found out that My Oracle service ORCL is registered
this is from Oracle support
ORA-12520: TNS:listener could not find available handler for requested type of server
Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection. Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.
this is the output of lsnrctl services
`
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-
SEP-2017 16:49
:00
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: OSAMA-PC, pid: 3240>
(ADDRESS=(PROTOCOL=tcp)(HOST=osama-PC)(PORT=49212))
The command completed successfully
Lnsrctl status output `
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-SEP-2017
18:2
:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 -
Prod
ction
Start Date 17-SEP-2017 17:39:16
Uptime 0 days 0 hr. 48 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
C:\app\MOD\product\11.2.0\dbhome_1\network\admin\list
ner.ora
Listener Log File c:\app\mod\diag\tnslsnr\osama-
PC\listener\alert\log.x
l
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=osama-PC)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Windows\system32>
tnsping orcl result
C:\Windows\system32>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-
SEP-2
017 18:29:11
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\MOD\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =
TCP)
(HOST = osama-PC)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (20 msec)
C:\Windows\system32>
lsnrctl status
?lsnrctl status
andtnsping orcl