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

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

"nyphot" <jonathan_at_oho.com> wrote in message news:1117227990.168979.166220_at_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 Sat May 28 2005 - 10:29:38 CDT