Can somebody review/correct my steps for adding an entry to the orapwd file.
Is there an environment variable I need to set to tell it the name of the password file. In addition, how do I get a "user" in the password file when
orapwd accepts file, password and entries as paramaters. Does this mean
I need to give user "sys" sysdba privs?
SQL> grant sysdba to pbh;
grant sysdba to pbh
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
SQL> show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
Bookmarks