We are working with an oracle database in which the person that set it up is "long gone" and thus do not know the sysdba password, but need it. We have root access to the box (its on linux). Is there any way to recover or change the sys passwords?
+13
A:
Have you tried logging into Linux as your installed Oracle user then
sqlplus "/ as sysdba"
When you log in you'll be able to change your password.
alter user sys identified by <new password>;
Good luck :)
Paul Hargreaves
2008-09-09 16:05:00
an addition... if you have root access but not the oracle user, login as root then "su - oracle" and follow Paul's instructions. Also try all the default oracle passwords. Last option is to look at OUTLN and DBSNMP accounts and Oracle hacks around that.
Mark Nold
2008-09-09 16:29:39
It helped me, the default passwords in oracle 11g didn't work out. Does this mean that oracle can be compromised easily.
Xolve
2009-04-11 14:09:29
+1
A:
Do you have any other login credentials (non-sysdba) for that database? If so, this link may be helpful.
JosephStyons
2008-09-09 16:05:28
A:
Thanks guys, I knew there was a way to do it as the oracle user but couldnt remember what it was. We got in and changed the sys password and are all set. Thanks for the quick responses!
Adam Lerman
2008-09-09 16:16:26