Enterprise Manager 10g database status unavailable--configuration issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Enterprise Manager 10g database status unavailable--configuration issue

  1. #1
    Join Date
    May 2005
    Posts
    5

    Enterprise Manager 10g database status unavailable--configuration issue

    I've been having a really tough time getting Enterprise Manager to work in 10g. I can get it to the hostname:5500/em screen at long last, but it says "The database status is currently unavailable. It is possible that the database is in mount or nomount state..." If I hit Startup from that page, I can successfully shutdown or startup the database from that page. If I try to Perform Recovery, I'm told "Unable to connect to the database. Io exception: The Network Adapter could not establish the connection."

    It's clearly connecting to some degree because I CAN startup and shutdown the database from this login. But clearly not enough because I can't actually access the database and there's that Network Adapter error...

    What am I doing wrong?

    I've been configuring Enterprise Manager using emca... Here's the output of the command.

    [oracle.oinstall@jon-oracle bin]$ ./emca -r

    STARTED EMCA at Fri May 27 12:47:36 EDT 2005
    Enter the following information about the database to be configured
    Listener port number: 1521
    Database SID: oraclej
    Service name: oraclej
    Email address for notification:
    Email gateway for notification:
    Password for dbsnmp:
    Password for sysman:
    Password for sys:

    -----------------------------------------------------------------

    You have specified the following settings

    Database ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/db_1
    Enterprise Manager ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/db_1

    Database host name ................ jon-oracle.oho.com
    Listener port number ................ 1521
    Database SID ................ oraclej
    Service name ................ oraclej
    Email address for notification ...............
    Email gateway for notification ...............

    -----------------------------------------------------------------
    Do you wish to continue? [yes/no]: yes
    May 27, 2005 12:47:49 PM oracle.sysman.emcp.EMConfig updateReposVars
    INFO: Updating file /u01/app/oracle/product/10.1.0/db_1/sysman/emdrep/config/repository.variables ...
    May 27, 2005 12:47:51 PM oracle.sysman.emcp.EMConfig addPortEntries
    INFO: Updating file /u01/app/oracle/product/10.1.0/db_1/install/portlist.ini ...May 27, 2005 12:47:51 PM oracle.sysman.emcp.EMConfig updateEmdProps
    INFO: Updating file /u01/app/oracle/product/10.1.0/db_1/sysman/config/emd.properties ...
    May 27, 2005 12:47:52 PM oracle.sysman.emcp.EMConfig updateConfigFiles
    INFO: targets.xml file is updated successfully
    May 27, 2005 12:47:52 PM oracle.sysman.emcp.EMConfig updateEmomsProps
    INFO: Updating file /u01/app/oracle/product/10.1.0/db_1/sysman/config/emoms.properties ...
    May 27, 2005 12:47:52 PM oracle.sysman.emcp.EMConfig updateConfigFiles
    INFO: emoms.properties file is updated successfully
    May 27, 2005 12:47:59 PM oracle.sysman.emcp.EMConfig startOMS
    INFO: Starting the DBConsole ...
    May 27, 2005 12:49:43 PM oracle.sysman.emcp.EMConfig perform
    INFO: DBConsole is started successfully
    May 27, 2005 12:49:43 PM oracle.sysman.emcp.EMConfig perform
    INFO: >>>>>>>>>>> The Enterprise Manager URL is http://jon-oracle.oho.com:5500/em <<<<<<<<<<<
    Enterprise Manager configuration is completed successfully
    FINISHED EMCA at Fri May 27 12:49:43 EDT 2005

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    listener running?

  3. #3
    Join Date
    May 2005
    Posts
    5
    Yes, Listener is running. Here are my listener.ora and tnsnames.ora files:

    listener.ora:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = oraclej)
    (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
    (GLOBAL_DBNAME = oraclej)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.0.50)(PORT = 1521))
    )
    )
    )

    tnsnames.ora:

    ORACLEJ =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.0.50)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = oraclej)
    )
    )

  4. #4
    Join Date
    Jul 2002
    Posts
    335
    Um, is that tnsnames.ora right?

    Can you try (from the box in question)

    $> sqlplus system@oraclej

    when the database is running just to confirm that tnsnames entry for me.

    I take it this is the standalone enterprise manager?

    Bazza

  5. #5
    Join Date
    May 2005
    Posts
    5
    Yes, standalone enterprise manager.

    tnsnames.ora seems correct... I can connect using sqlplus system@oraclej.

  6. #6
    Join Date
    May 2005
    Posts
    5
    Here's a little more info:

    I've looked through all the logs in jon-oracle.oho.com_oraclej/sysman/log.

    Some are quite surprising to me...

    In emdctl.trc I get things like:

    WARN http: snmehl_connect: connect failed to (jon-oracle.oho.com:1830): Connection refused (error = 111)

    and the same thing on port 5500. I can reach both of those ports, though, from a browser on that machine as well as a remote browser.

    In emagent.trc I get a listener error:

    2005-05-31 14:59:00 Thread-3001027504 WARN TargetManager: Exception in computing dynamic properties of {oraclej.oho.com, oracle_database },ComputeVC::Missing Properties : [Version]
    2005-05-31 14:59:00 Thread-3001027504 WARN vpxoci: OCI Error -- ErrorCode(12541): ORA-12541: TNS:no listener

    SQL = " OCIServerAttach"...
    LOGIN = dbsnmp/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jon-oracle.oho.com)(PORT=1521))(CONNECT_DATA=(SID=oraclej)))

    As noted previously, though, my listener entry is valid. I wonder, though, why it puts that whole string in instead of sayinig dbsnmp/@oraclej...

    Finally, emoms.log and emoms.trc fill up with ALL sorts of Java errors... Much too many to post. My guess is that these errors occur because of the errors that the other log files are capturing.

    Does that help at all? I thought it was going to help me, but I'm getting confused again.

  7. #7
    Join Date
    May 2005
    Posts
    5
    Well, I finally got it to work! I think the problem WAS with my listener after all. It was listening on 10.7.0.50 but NOT on 127.0.0.1. Is there a way to get it to listen on both interfaces?

    Anyway, my guess is that because it was not listening on the loopback, it didn't know how to communicate with itself to get the EM stuff working.

    I am running into a separate problem that emca works sporadically. It works okay, though, if I just set it up through dbca... If anyone has thoughts on why emca might freeze mid-process, I'd appreciate that. Other than that, thanks for your help, all!

Posting Permissions

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


Click Here to Expand Forum to Full Width