Lost Oracle administrator username and password that run on Unix system

[Jacky Wong_1]

I lost Oracle administrator username and password but have Unix root administrator username and password. What can I do to get back the data inside the oracle? The oracle is 8.0.5 and run on Unix 10.0 Thnaks for your help.

[Thierry Poels_1 · Accepted solution]

Hi,

- login as root
- su - oracle
- svrmgrl
- connect interal
- and change password

(if you have a password file which disallows connect internal, you can recreate the password file when logged on as oracle)

regards,
Thierry.

[Jacky Wong_1]

Dear Thierry Poels ,

Thanks for your reply.But when I logon oracle by su username, do I need to provide password at the same time? Thanks for your help.

[Printaporn_1]

from root can su to any user without supply password.

su - oracle
(don't need password)
export ORACLE_SID=
svrmgrl
connect internal
alter user system identified by

[T G Manikandan]

Hello,
That is what Thierry is explaining.
Login as root.
issue
#passwd oracle
to change the password
or
#su - oracle
to change to oracle.
As this is super user you do not need permissions.

10 points to Thierry
Thanks

[Jacky Wong_1]

And, how can I know that I succeed to change oracle administrator password?

[Steven Sim Kok Leong]

Hi,

Try using the changed password to connect either using sqldba or sqlplus.

I suppose you realised you had forgotten your password only after attempting an oracle connection right?

Hope this helps. Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com

[T G Manikandan]

Hello,
login into oracle user.

echo $ORACLE_SID(test your ORACLE_SID)
$svrmgrl
SVRMGR>connect internal
The oracle administrator users are sys and system

to find the usernames
SVRMGR>select username from dba_users;

SVRMGR>alter user system identified by "";
The ouput will be "statement processed"

Then you can connect using the user 'system'.


Thanks

[Jacky Wong_1]

Excuse me, Anyone know the backup or export oracle database method that can use simple command to backup and restore whole database. Where can I find some information for it? Many Thanks!

[Steven Sim Kok Leong]

Hi,

Here is the Oracle export/import FAQ:

http://www.orafaq.com/faqiexp.htm

For purpose of backup and restoration of Oracle databases, personally I prefer omniback which is more secure (encryption) and fast (software compression).

Hope this helps. Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com