Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 159 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 471 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Cannot connect to Oracle XDB service

Cannot connect to Oracle XDB service
Error Messages:
===============
C:\Users\shelleyd>sqlplus system/[email protected]: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:
================================================================
[email protected]> 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)
[email protected]> -- Check status of XDB
[email protected]> 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
[email protected]> -- Check for invalid objects
[email protected]> select owner, object_name, object_type, status
2 from dba_objects
3 where status = 'INVALID'
4 and owner in ('SYS', 'XDB');
no rows selected
[email protected]> -- Show dispatchers
[email protected]> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=dunkXDB)
[email protected]> -- Show local_listener
[email protected]> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_DUNK
Answers
-
is database limited by PROCESSES value?
-
Hi,
You only have tcp dispatchers but tcps xdb config by the look of it - that might be part of the problem.
Hold on - looking again - you don;t use sqlplus to connect to the xdb service - you use http/https
just use dunk rather than dunkxdb in your sqlplus session.
or try https://localhost:5500 in a browser and see what you get
Cheers,
Rich
-
Please run
select dbms_xdb.gethttpport
from dual;
If the outcome is
0
you need to run
exec dbms_xdb.sethttpport(8080) -- or some other high value
--------------
Sybrand Bakker
Senior Oracle DBA
-
I posted this problem because I could not log into EM Express on the new 12c database that I created. I am following the steps in the Oracel doc "Troubleshooting Why EM Express is not Working (Doc ID 1604062.1)". I have done steps 1-4. Step 5 is "5- Connect to the XDB service as the SYSTEM user". It showes that you should be able to connect to XDB database using system id:
SQL> conn system/[email protected]
Connected.
This is the step that is not working for me.
I was asked if this is limited by PROCESSES value and I do not think it is:
[email protected]> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 450I was asked to try https. I used this command in both IE and Chrome and could not connect to EM Express
IE gave this error message:
This page can't be displayed
- Make sure the web address https://localhost:5500 is correct.
- Look for the page with your search engine.
- Refresh the page in a few minutes.
- Make sure TLS and SSL protocols are enabled. Go to Tools > Internet Options > Advanced > Settings > Security
I was asked to check the http port. Here is the result
[email protected]> select dbms_xdb.gethttpport from dual;
GETHTTPPORT
-----------
0The HTTPS port for EM Express (XDBO is setup:
[email protected]> SELECT dbms_xdb_config.gethttpsport() FROM dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500Any other suggestion would be appreciated.