It is important to recover your lost password on the Oracle database, as not having it would hamper your productivity and block your access to the database, resulting in security issues.
To recover or change a password in Oracle, simply connect under command line mode on the server:
#sqlplus /nolog
SQL>conn / as sysdba
SQL>alter user Username identified by PASSWORD;
To reset your password from the Oracle database, the process is a bit different. Your password file should be under <orahome>\database\PWD<SID>.ora.
Delete it and run the Oracle password utility from the command prompt:
c\:Oracle\ora92\database>ORAPWD file=PWD<SID>.ora password={password} entries={however many}.
The <password> is your new sys password. After you log in as sys, you can change it and create new passwords for the system.
Need more password help? Check out our forum!
Subject
Replies
Databases
- Forgot oracle database password
- Oracle forgot password
- How to recover oracle database password
- Forgot hotmail email password > Guide
- Forgot lenovo laptop password > Guide
- I forgot my facebook password and i lost my sim card [solved] > Forum - Facebook
- I lost my sim and forgot my facebook password [solved] > Forum - Facebook
- Forgot call barring password [solved] > Forum - Android
- What is the equivalent of DATEDIFF in Oracle?
- How to avoid duplicate records in SQL: select query
- How to reset a sequence in Oracle?
- How to list Oracle tables