Cannot connect to Oracle XDB service
Error Messages:
===============
C:\Users\shelleyd>sqlplus system/xxxxxxx@localhost:1521/dunkxdb
SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 6 08:51:39 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12518: TNS:listener could not hand off client connection
Error Message in listener.log:
==============================
06-MAR-2015 08:51:39 * (CONNECT_DATA=(SERVICE_NAME=dunkxdb)(CID=(PROGRAM=C:\app\shelleyd\product\12.1.0\dbhome_1\bin\sqlplus.exe)(HOST=xxxxxxxx)(USER=shelleyd))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58784)) * establish * dunkxdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12533: TNS:illegal ADDRESS parameters
From listener.ora file:
=======================
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\shelleyd\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\shelleyd\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
From tnsnames.ora file:
=======================
LISTENER_DUNK =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
DUNK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dunk)
)
)
DUNKXDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dunkxdb)
)
)
LSNRCTL STATUS:
===============
C:\Users\shelleyd>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 06-MAR-2015 08:48
:12
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Produ
ction
Start Date 06-MAR-2015 08:46:39
Uptime 0 days 0 hr. 1 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\shelleyd\product\12.1.0\dbhome_1\network\admin\
listener.ora
Listener Log File C:\app\shelleyd\diag\tnslsnr\SHELLEYD2\listener\alert\
log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)(POR
T=5500))(Security=(my_wallet_directory=C:\APP\SHELLEYD\admin\dunk\xdb_wallet))(P
resentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dunk" has 1 instance(s).
Instance "dunk", status READY, has 1 handler(s) for this service...
Service "dunkXDB" has 1 instance(s).
Instance "dunk", status READY, has 1 handler(s) for this service...
The command completed successfully
Making Sure That the XML Database option is installed and valid:
================================================================
sys@dunk> DESC RESOURCE_VIEW
Name Null?
Type
------------------------------------------------------------------------- -----
--- -------------------------------------------------
RES
XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/XD
BResource.xsd" Element "Resource")
ANY_PATH
VARCHAR2(4000)
RESID
RAW(16)
sys@dunk> -- Check status of XDB
sys@dunk> select comp_name, version, status
2 from dba_registry
3 where comp_id = 'XDB';
COMP_NAME
--------------------------------------------------------------------------------
-----------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle XML Database
12.1.0.2.0 VALID
sys@dunk> -- Check for invalid objects
sys@dunk> select owner, object_name, object_type, status
2 from dba_objects
3 where status = 'INVALID'
4 and owner in ('SYS', 'XDB');
no rows selected
sys@dunk> -- Show dispatchers
sys@dunk> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=dunkXDB)
sys@dunk> -- Show local_listener
sys@dunk> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_DUNK