ORA-28001 the password has expired (DBD Error:OCISessionBegin
794962Aug 31 2010 — edited Apr 16 2013I received the above error when try to start Enterprise Manager, the reason I even looked at the databases is because they stopped sending me backup job messages.
I read in a post on this site to use SQLPlus and try to sign in as sysman. I did and it said the password expired I then closed that and tried again. Still same mesage. I tried to sign on again in SQLPlus as sysman and this time it said password locked.
I have two instances with this problem instance A above and this instance B which is in the state that follows. The 2nd instance (B) is is signed into SQLPlus as sysman after asking what the new password is I stayed logged in. To check to see if the sysman userid is indeed locked, I started another command shell and tried to log on and the error about locked account comes up. I need to unlock the user using SQLPlus before I sign out or close the command window. How do I do that in instance B? What do I do for instance A.
In case it doesn't show, I know little about Oracle Databases I took a beginner class on Oracle online.
The installation is 11.1.0.6.0
Thank you for your help,
Rick
Edited by: user10401961 on Aug 31, 2010 9:27 AM