OraFAQ Forum: Security » LOST ORACLE 9I'S PASSWORD

Home » RDBMS Server » Security » LOST ORACLE 9I'S PASSWORD

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

LOST ORACLE 9I'S PASSWORD [message #266093]

Sun, 09 September 2007 12:28

preetigupta15@rediffmail.
Messages: 1
Registered: September 2007
Location: pune

Junior Member

hi

i can not remember my oracle 9i's username,password and hoststring..
is there any way i can retrive it back or change it...?

Report message to a moderator

Re: LOST ORACLE 9I'S PASSWORD [message #266094 is a reply to message #266093]

Sun, 09 September 2007 12:32

BlackSwan
Messages: 20106
Registered: January 2009

Senior Member

>is there any way i can retrive it back or change it...?
Yes, if you know what you are doing.
Log onto the database server are the OS user which own the Oracle s/w; then:

sqlplus
/ as sysdba
alter user scott identified by tigger;
exit

Report message to a moderator

Re: LOST ORACLE 9I'S PASSWORD [message #266131 is a reply to message #266093]

Sun, 09 September 2007 23:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Which user ???
1. sys default password is "change_on_install"
2. system default password is "manager"
3. scott default password is "tiger"
4. for host_string check your tnsnames.ora file.
located: $ORACLE_HOME/network/admin

Regards
Taj

Report message to a moderator

Re: LOST ORACLE 9I'S PASSWORD [message #269353 is a reply to message #266093]

Fri, 21 September 2007 15:35

parthokonar
Messages: 17
Registered: September 2006
Location: india

Junior Member

If your Sys password is lost and it not os authenticated you may have to create passowrd file again

Report message to a moderator

Re: LOST ORACLE 9I'S PASSWORD [message #269387 is a reply to message #266093]

Fri, 21 September 2007 23:11

BlackSwan
Messages: 20106
Registered: January 2009

Senior Member

>If your Sys password is lost and it not os authenticated you may have to create passowrd file again
If you have OS permissions to "create password file",
then you are logged onto the OS as the owner of Oracle s/w & can logon by:
sqlplus
/ as sysdba
-- then do anything you desired to/with the database

Report message to a moderator