Search This Blog

Tuesday, February 28, 2017

Maximo not starting , 28001 password expired maximo

Recently i faced this error.

 

I had to connect to database via command line

go to Db home /bin and execute a command prompt.

Hope you know the trick, go to any folder and in address bar type cmd ; wola it opens a command prompt in that directory. No more navigation is required.

 

sqlplus.exe  / as sysdba

it connected

select name from v$database;

 

 

In case you are not able to see your databases listed here

Please check the bottom section.

else

$ alter user maximo identified by “maximo” ;

User will be altered and new password will work.

 

To make the system stable and make the password lifetime, change the default profile.

 

image

image

 

image

 

wola , it connects.

image

 

Problem I faced

One problem i faced while doing this, i could not find my listed database and i was confused why i am not able to see my maximo database.

 

So i found out , i had to change the default instance i was trying to connect to .

By default oracle connects with the default instance.

so i had to export the ORACLE_SID to maxdb76 , as you see in net configuration assistant of oracle.

so in command prompt.

set oracle_sid=maxdb76

sqlplus.exe  / as sysdba

now i could see my database and altered it.

 

Keep reading !

No comments:

Post a Comment