Spec:
Windows 2008 Server
Oracle 11g r2
I can successfully create a password file in my production Oracle 11g database on Windows 2008 server, but each time I tried to add / grant sysdba to an account, I get the following error.
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
Here was my unsuccessful solution:
1. set the remote_login_passwordfile to none
alter SYSTEM SET remote_login_passwordfile=none scope=spfile;
2. restart database to take changes in account
3. delete password file.
4. recreate the new password file :
ORAPWD FILE=F:\Oracle_Prod\product\11.2.0\dbhome_1\database\PWDahrPROD.ora ENTRIES=10
5.alter system set remote_login_passwordfile=exclusive scope=spfile;
6.restart database to take changes in account
SQL> show parameter password
NAME TYPE VALUE
------------------------------------ ----------- ----------
remote_login_passwordfile string EXCLUSIVE
grant sysdba to SYSMAN
Same error as above.
Any idea?