10g OEM.

[dba_dada]

After reboot can't login to OEM login page. It says " The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click 'Startup' to obtain the current status and open the database. If the database cannot be opened, click 'Perform Recovery' to perform an appropriate recovery operation."

I started the DB. Started the LISTENER and

emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://XXXXX:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ........................ started.

Any ideas?

[TimHall]

Hi.

Sounds to me like the OEM repository is out of sync with the real status of the DB.

When this has happened to me I've run the "emca -r" command to reconfigure OEM.

It asks you a few questions and then does the business. The "-r" option tells it that the repository is already present in the SYSMAN schema. Without this is fails becaue it can't create the repository tables.

Once this is complete you should be able to login as normal.

This has happened a number of times to me, without any definite set of circumstances leading up to it. I guess it's a bug

Cheers

Tim...

[dba_dada]

Tim,

Thanks!!! It worked

[TimHall]

My my, what big teeth you have.

[dba_dada]

Thanks

( no teeth this time )