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.
wola , it connects.
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