Hello all,
I am going crazy over this one. I am testing creating a new password file but I am always getting an ora-01994 error.
-------------------------------------------------------------------------------- ----------
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | 0 |
| PL/SQL Release 12.1.0.2.0 - Production | 0 |
| CORE | 12.1.0.2.0 | Production | 0 |
| TNS for Linux: Version 12.1.0.2.0 - Production | 0 |
| NLSRTL Version 12.1.0.2.0 - Production | 0 |
[ORACLE/-test_1]/u01/shared_data/oradata/test> orapwd file=/u01/shared_data/oradata/test/orapwtest password=password entries=16
[ORACLE/-test_1]/u01/shared_data/oradata/test> srvctl stop database -d test
[ORACLE/-test_1]/u01/shared_data/oradata/test> srvctl start database -d test
[ORACLE/-test_1]/u01/shared_data/oradata/test> ll
-rw-r-----. 1 oracle oinstall 10752 May 17 07:57 orapwtest
test_1 > show parameter name
------------------------------------ ----------- ------------------------------
| cell_offloadgroup_name | string |
| db_file_name_convert | string |
| db_name | string | test |
| db_unique_name | string | test |
| global_names | boolean | FALSE |
| instance_name | string | test_1 |
| lock_name_space | string |
| log_file_name_convert | string |
| pdb_file_name_convert | string |
| processor_group_name | string |
| service_names | string | test |
test_1 > show parameter pass
------------------------------------ ----------- ------------------------------
| remote_login_passwordfile | string | EXCLUSIVE |
test_1 > select * from v$pwfile_users;
no rows selected
test_1 > grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
This should be easy, but I am having a hard time figuring out why the new password file is not working. This is a three node RAC. Am I missing something?
Thanks!