Home » RDBMS Server » Security » LOST ORACLE 9I'S PASSWORD
LOST ORACLE 9I'S PASSWORD [message #266093] Sun, 09 September 2007 12:28 Go to next message
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...?
Re: LOST ORACLE 9I'S PASSWORD [message #266094 is a reply to message #266093] Sun, 09 September 2007 12:32 Go to previous messageGo to next message
BlackSwan
Messages: 23060
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
Re: LOST ORACLE 9I'S PASSWORD [message #266131 is a reply to message #266093] Sun, 09 September 2007 23:21 Go to previous messageGo to next message
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
Re: LOST ORACLE 9I'S PASSWORD [message #269353 is a reply to message #266093] Fri, 21 September 2007 15:35 Go to previous messageGo to next message
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
Re: LOST ORACLE 9I'S PASSWORD [message #269387 is a reply to message #266093] Fri, 21 September 2007 23:11 Go to previous messageGo to next message
BlackSwan
Messages: 23060
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
Re: LOST ORACLE 9I'S PASSWORD [message #545973 is a reply to message #269387] Sun, 04 March 2012 04:18 Go to previous messageGo to next message
sowmia
Messages: 1
Registered: March 2012
Location: pondicherry
Junior Member
hello friends i lost my user name password and host string .... how to retrieve it... PLS HELP ME!!!!!!!!!!!
Re: LOST ORACLE 9I'S PASSWORD [message #545975 is a reply to message #545973] Sun, 04 March 2012 04:25 Go to previous message
Michel Cadot
Messages: 59814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Call your DBA!!!!!!!!!!!!!!

Regards
Michel
Previous Topic: Create Passwordfile In Oracle 10g
Next Topic: password problem in new database
Goto Forum:
  


Current Time: Thu Nov 27 13:58:59 CST 2014

Total time taken to generate the page: 0.12666 seconds