1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Inability to connect to the database

Discussion in 'Server Administration and Options' started by TorchTT, Nov 14, 2013.

  1. TorchTT

    TorchTT Guest

    Installed Oracle 11g.

    When you open localhost:1158/em - the message:
    "The database is down. Please specify the host credentials to access database restart and diagnostics tools."

    After entering the command:
    Code (Text):
    emctl status dbconsole
    It is reported that Oracle Enterprise Manager 11g is running.

    When you type:
    Code (Text):
    emctl status agent
    states that the agent works.

    Can you please tell how to solve the problem?

    Translated by Google Translate.
     
  2. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    You need to be sure that DBSNMP account is not expired/locked.

    Code (SQL):
    $ sqlplus / AS sysdba
    SQL> SELECT username, account_status FROM dba_users ORDER BY account_status;
    To unlock

    Code (SQL):
    SQL> ALTER USER dbsnmp account UNLOCK;

    To set password

    Code (SQL):
    SQL> ALTER USER dbsnmp IDENTIFIED BY password;

    Best Regards,
    Prashant
     
  3. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    You should also check for expired/locked for SYSTEM user.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The message does not report an inability to connect, it reports that the database is down. Is the database running? You should check with sqlplus, first, before trying to connect to the db console. Since 11gR2 requires a local EM repository for local management there must be a database created and the DBSNMP and SYSMAN accounts are valid and unlocked.
     
  5. dadbm

    dadbm Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Make sure your DB and DB listener are running.