I am learning Oracle part two of the OCP exam and I am trying to create a step by step database via SQL*Plus. I know I can use OEM or other means to create it, but I want to know each steps. All the right parameters have been set in the init.ora file. I enter the command create database nancy, it seems to do all it needs to do with one exception. That exception is this error:
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01991: invalid password file 'C:\oracle8i\ora81\DATABASE\PWDrichard.ORA'
I tried to replace that pwdrichard.ora with another by using the orapwd.exe command in dos to create a new pwdfile but that did not work and I still get this error. How can I resolve this issue?