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
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.