Here is my oracle 11.2.0 config
Listener.ora:
LISTENER_ORCL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
)
)
Tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
I am starting OracleServieORCL as admin user on windows 8 machine. Then on the same system i am using sqldevloper (4.0.1) to connect to SID ORCL with user name system and password admin (admin is the password given during installation)
I get error ORA-12518:TNS:Listener could not hand off client connection.
I tried to reinstall the software but that did not help. I got Java 8 (8-101) version installed on my box.
lsnrctl services
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 14-SEP-2016 12:02:11
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: <system_name>, pid: 2808>
(ADDRESS=(PROTOCOL=tcp)(HOST= <system_name>)(PORT=52707))
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:17 refused:0 state:ready
LOCAL SERVER
The command completed successfully
ORA-12518:TNS:listener could not hand off client connection.
Basically only local connections can avoid the listener (ie you have to be already logged on to the machine that the database instance is running on). Rather than relying on a listener to fork out a process to act on behalf of the connection, this is done by the local process.
Listener tracing can be enabled dynamically through 'set trc_level' command in lsnrctl utility. Independent if ADR is or not enabled, the trace is created with timestamps. Please note that if the ADMIN_RESTRICTIONS_<listener_name> is set to ON for the Listener, then this cannot be done.
Ok after days of debugging, finally got to know the installation did not register with system registry and when i re installed it via admin privileges it worked ok.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With