Sponsored Links
How to reset Sys password in oracle
How to reset Sys password in oracle?
i want to reset sys password ... how to do that in oracle ?
A:
Option 1:
Your
password file should be under
<orahome>\database\PWD<SID>.ora. Delete it and run the
Oracle password utility from the command prompt as:
c\:Oracle\ora92\database>ORAPWD file=3DPWD<SID>.ora password=3D<password> entries=3D<however many>.
The
<password> is your new sys password. After you log in as sys you
can change it and create new passwords for system etc.
Option 2:
see
if you can still connect as sqlplus "/as sysdba" at the dos prompt. If
successful, you can change the system or sys users password using the
'alter user system identified by new_password;'
SQL>who user
USER is "SYS"
SQL>alter user sys identified by new_pass;
User altered.
SQL>exit
Page 1
|
| 
