| OEM 10g DB Unavailable Error [message #204291] |
Mon, 20 November 2006 00:16  |
arish_zishan
Messages: 4
Registered: November 2005
Location: Muscat
|
Junior Member |
|
|
My database is already openand working fine with other tools, all the services are also started, but when i try to connect through OEM
http:\\mymachine:5500/em
I recieve following message
"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 already tried startup option at this page and database restarted successfully and is opened, but the same page come when i tried to access OEM.
Kindly reply at arish@shanfari.com also.
Thanks
|
|
|
|
|
|
| Re: OEM 10g DB Unavailable Error [message #204307 is a reply to message #204294] |
Mon, 20 November 2006 01:55  |
arish_zishan
Messages: 4
Registered: November 2005
Location: Muscat
|
Junior Member |
|
|
Hi Taj,
Thankx for the reply. The solution given below seems to be similar to my case as i also changed the password of sysman from sqlplus.
Can you give example or clarify how to perform step 1,2 and 4.There is no OMS service in windows Administrative tools services section like it was there in 9i. I think my DB should be having only one OMS as i am using the deauflt setting for OEM which installs with Oracle DB installation.
Thankx
You cannot just change the SYSMAN password from SQL*Plus, You need to do this (as per Metalink):
To reset the SYSMAN password -
1. Stop all Oracle Management Servers (OMS) currently connected to the EM Repository.
2. From one of the OMS systems, use SQLPLUS to connect to the EM Repository Database. The connection attempt must be made using the EM Repository schema user's account.
3. Execute the SQL script: %Oracle_home%\sysman\admin\vduresetsysman.sql
4. Restart each OMS.
5. Launch the EM Console. Logon as sysman with a password of oem_temp and change the password when prompted. Make sure the sysman and oem_temp are all lower case.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
