Like many of us, we need to recreate the password file from time to time. Today I had to change the name of a database with the NID tool. As part of the process I needed to create a new password file.
The command is simple:
$ORACLE_HOME\bin\orapwd file= ‘<location/filename>’ password=<password>
I typed in the command at the command line and was getting the error: OPW-00001. I kept scratching my head, then it dawned on me; I needed to but single-quotes (‘) around the file location/name.
Always remember this and you’ll always be successful when trying to recreate a password file for oracle.
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.