I am an IT professional with 10 years of professional experience,I have good proficiency on Oracle technologies, and at last 2 years of my career to study Real Application Clusters,data guard and participate actively on Oracle community ,If you want to hire me on Contract or to quote on project basis contact me at khurrampc@hotmail.com.

Tuesday, January 27, 2009

Sysman Password Lock

Whenever I start the service for DBConsole through command line, the account sysman get locks .It happens even though after unlocking the sysman user again and again.When i try to open the OEM console page it shows up the database is currently unavailable why?Although it connets from SQL and show me status of database open but dont know why it shows unavailable at OEM console page,It happens always whenever i try to open my OEM dbconsole it opens the page like
It happens due to changes of sysman password via sql , whenever you try to start emctl dbconsole it will lock that user why cause Oracle associate the Oracle Management Service with a repository which are defined within emoms.properties configuration file, the password within emoms.properties file conflict the password with data dictionary object password which cause to lock that sysman user and will always show up the above page whenever I start em console page
To get rid from this page you have to also edit emomos.properties (OMS repositry) whenever you change sysman or dbnsmp user password. Here couple of steps to achieve it
Stop the Management Service. Open the emoms.properties file.
ORACLE_HOME/localhostname_SIDname/sysman/config/emoms.properties (UNIX) ORACLE_HOME\localhostname_SIDname\sysman\config\emoms.properties (Windows)
Change the emdRepPwdEncrypted property to FALSE. Change the emdRepPwd property to the new password. Save the changes and close the emoms.properties file. Start the dbconsole Note : When the Management Service starts, it opens the emoms.properties file, encrypts the password, and changes the emdRepPwdEncrypted property to TRUE. Open the EM console


nayyares said...

nice tip.


Anonymous said...

Oh thanks a lot !!!

That works !

daspeac said...

I have heard about another repair tool to repair the master database in sql. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.


About Me

My photo
Melbourne, Victoria, Australia