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

listener running?

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

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

Yes, standalone enterprise manager.

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

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.

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!