Database Administration (MOSC)

MOSC Banner

ora - 01994

edited Sep 11, 2012 8:50AM in Database Administration (MOSC) 7 commentsAnswered
I have created the password file using the orapwd utility.

orapwd file=orapwdfile entries=5

My database showed


SQL> show parameter remote_login_passwordfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

When I try to grant sysdba to a particular user, I am getting the ora - 01994 error

SQL> connect / as sysdba
Connected.
SQL> grant sysdba to rmanbk_admin;
grant sysdba to rmanbk_admin
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

I am not sure what step I missed. This is for oracle database version 11.2.0.3 on solaris 11. The only thing that worth mention is that this is an ebs instance. Please advice. Thank you very much.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center