Enterprise Manager 10g database status unavailable--configuration issue

From: nyphot <jonathan_at_oho.com>
Date: 27 May 2005 14:06:30 -0700
Message-ID: <1117227990.168979.166220@o13g2000cwo.googlegroups.com>

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_at_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 Received on Fri May 27 2005 - 16:06:30 CDT