Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ORACLE: Listener could not hand off Connection error

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
like image 413
user1224036 Avatar asked Sep 13 '16 12:09

user1224036


People also ask

What is ORA 12518?

ORA-12518:TNS:listener could not hand off client connection.

Can I connect to Oracle database without listener?

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.

How do I turn on listener tracing?

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.


1 Answers

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.

like image 75
user1224036 Avatar answered Oct 15 '22 18:10

user1224036