How to Recreate the Passwordfile for Oracle Database?

If you are the system administrator with full privilege, you can Recreate the Passwordfile for Oracle Database. This is required at times, if you forget or do not know the SYS or SYSTEM password. For example, typically some vendor application, such is Equity Edge, does not provide or share the password. You are forced to login, for genuine reasons, to maintain the database.

For example: Nobody here knows any of the account passwords for this instance

You can recreate the password file using the ORAPWDxx command by which you can specify the password for internal. Before running this command to create the new password file, make sure to delete the old password file. Otherwise, the ORAPWDxx utility will give an error message.

You can try this method.

0) set environment variable as needed
1) shutdown the instance
2) delete or rename the existing password file
3) run the orapwd command to create the new password file
4) if on Windows, you may be required to run an ORADIM command to rebuild/reconfigure your service
5) connect to the (idle) database
6) startup the database
7) alter the password for the SYS and SYSTEM users

Windows Platform:

Unix/Linux Platform:

You can use this method to reset system password for equity edge. Test it first in some dummy platform before implementing it. It is your own risk, not supported by etrade and oracle.

Key sentences:

equity edge 8.0 system password
equity edge 7.0 system password
equity edge 6.0 system password