Enterprise Manager 10g database status unavailable--configuration issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nyphot - 27 May 2005 22:06 GMT

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

Reply to this Message

Dave - 27 May 2005 22:22 GMT

> 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
[quoted text clipped - 11 lines]
>
> What am I doing wrong?

is your listener running?

Reply to this Message

Valentin Minzatu - 28 May 2005 16:29 GMT

Is your database dynamically registering with the listener? If so, you may
want to add the database to the listener.ora - it worked in some cases, but
not always.

Cheers,
Valentin

> 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
[quoted text clipped - 72 lines]
> Enterprise Manager configuration is completed successfully
> FINISHED EMCA at Fri May 27 12:49:43 EDT 2005

Reply to this Message

nyphot - 31 May 2005 15:55 GMT

Dave, yes, my listener is running. Valentin, I'm not sure--I don't
know what the options for registering with the listener are. My guess
is that it's not a dynamic registration though. I put an entry in my
listener.ora file and then used lsnrctl start.

Do I need to use a hostname instead of an IP in my listener or
something like that? Specify my SID or my db_name? These entries work
if I want to connect via SQL*Plus so I thought they were generally
okay, but...

Here are my listener.ora and tnsnames.ora files if that helps any:

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

Reply to this Message