Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2017
    Posts
    8

    Unanswered: Oracle 12: dbconsole is not accessible

    Newbie question, no doubt.

    Here is my setup:

    $ lsnrctl status

    LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-JAN-2017 15:43:36

    Copyright (c) 1991, 2014, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
    Start Date 31-JAN-2017 11:43:04
    Uptime 0 days 4 hr. 0 min. 31 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
    Listener Log File /home/oracle/app/oracle/diag/tnslsnr/oracle12c/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle12 c.mydomain.com)(PORT=1521)))
    Services Summary...
    Service "oradb2" has 1 instance(s).
    Instance "oradb2", status READY, has 1 handler(s) for this service...
    The command completed successfully


    SQL> show parameter dispatchers

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    dispatchers string (PROTOCOL=TCP) (SERVICE=oradb2
    XDB)
    max_dispatchers integer
    SQL> select dbms_xdb_config.gethttpsport () from dual;

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

    ...but the url https://<IP_address>:5500/em is not working, plus the port 5500 is not responding to telnet.

    I suspect that my listener.ora is not quite right:

    ORADB2 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = oracle12c.mydomain.com)
    (PORT = 1521)
    )
    )
    )
    (CONNECT_DATA =
    (SID = oradb2)
    )
    )


    Please advise....

    Thanks,

    George

  2. #2
    Join Date
    Jun 2004
    Posts
    812
    Provided Answers: 1
    Is port 5500 open?
    Has the DBConsole service started?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2017
    Posts
    8
    Quote Originally Posted by cis_groupie View Post
    Is port 5500 open?
    Has the DBConsole service started?
    Port 5500 doesn't look open, it doesn't respond to telnet.

    I didn't know there WAS a DBConsole service.... I have seen no mention of it in any Oracle doc...

    How does one start it?

    I see info about an "emctl" utility, but I can't find such a file in my entire oracle installation.
    Last edited by gdevelek1; 02-01-17 at 07:20.

  4. #4
    Join Date
    Jun 2004
    Posts
    812
    Provided Answers: 1
    I suspect from what you're saying that the culprit here is Port 5500. If it isn't open then traffic can't pass through it. Basically, you're trying to access DBConsole but the door is firmly closed.
    Open the port, then try again.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Jun 2004
    Posts
    812
    Provided Answers: 1
    Addendum - it may also be that you haven't configured the database's HTTPS port. Run this command:

    select dbms_xdb_config.getHttpsPort() from dual;

    It should be set to 5500
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Jan 2017
    Posts
    8
    Quote Originally Posted by cis_groupie View Post
    I suspect from what you're saying that the culprit here is Port 5500. If it isn't open then traffic can't pass through it. Basically, you're trying to access DBConsole but the door is firmly closed.
    Open the port, then try again.
    There's nothing blocking that port. It's not responding because nothing is listening on it. It's not accessible from anywhere, including the host itself. There is no HW or SW firewall.

    You mentioned the DBConsole service, how does one enable/start it?

  7. #7
    Join Date
    Jan 2017
    Posts
    8
    Quote Originally Posted by cis_groupie View Post
    Addendum - it may also be that you haven't configured the database's HTTPS port. Run this command:

    select dbms_xdb_config.getHttpsPort() from dual;

    It should be set to 5500
    In my initial post you can see that the output is indeed 5500.

    Is my listener OK? Should it perhaps have an extra entry for HTTPS?

    How come I don't seem to have the emctl utility? Where is it normally installed? It is always installed?

  8. #8
    Join Date
    Jun 2004
    Posts
    812
    Provided Answers: 1
    In my initial post you can see that the output is indeed 5500
    Sorry, I missed that.

    You don't need to have an entry for HTTPS in your Listener file.

    The emctl utility is normally an option on install, if you use DBCA to create your database then it should be under "Management Options". If you can't find the emctl file then it's likely that emctl wasn't installed. (As I have only played briefly with 12c I don't know which directory the emctl utility should be in so I can't point you to where it should be.)
    By the way, with 12c it is now called Enterprise Manager Database Express (instead of DBConsole).

    If you don't have EM Express installed then you can still administer the database via SQL Developer - it has a DBA option within it that allows you to do just about all that you need to do.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •