Forum Stats

  • 3,768,285 Users
  • 2,252,771 Discussions
  • 7,874,515 Comments

Discussions

Cannot connect to Oracle XDB service

user1434332
user1434332 Member Posts: 2
edited Mar 10, 2015 12:09PM in General Database Discussions

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

Skender Kollcaku

Answers

  • Unknown
    edited Mar 6, 2015 12:34PM

    is database limited by PROCESSES  value?

  • Richard Harrison .
    Richard Harrison . Member Posts: 2,065 Gold Trophy
    edited Mar 6, 2015 12:44PM

    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

  • Unknown
    edited Mar 6, 2015 12:54PM

    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

  • user1434332
    user1434332 Member Posts: 2
    edited Mar 10, 2015 12:09PM

    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     450

    I was asked to try https.  I used this command in both IE and Chrome and could not connect to EM Express

    https://localhost:5500/em

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

    The HTTPS port for EM Express (XDBO is setup:

    [email protected]> SELECT dbms_xdb_config.gethttpsport() FROM dual;

    DBMS_XDB_CONFIG.GETHTTPSPORT()
    ------------------------------
                              5500

    Any other suggestion would be appreciated.

This discussion has been closed.