ORA-01994: GRANT failed: password file missing or disabled

I am attempting to add an entry to my orapwd file and I get this error:

SQL> grant sysdba to scott;

grant sysdba to scott

*

ERROR at line 1:

ORA-01994: GRANT failed: password file missing or disabled

Cause The operation failed either because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the password file was missing.

1) Check remote_login_passwordfile  value

SQL> show parameter REMOTE_LOGIN_PASSWORDFILE;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

remote_login_passwordfile            string      NONE

2) Change the exclusive remote_login_passwordfile  mode not to exclusive .This statics parameter

SQL> alter system set remote_login_passwordfile =exclusive scope=spfile;

System altered.

to implement the changes  you need to restart the database

SQL> shu immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area  603979776 bytes

Fixed Size                  1250380 bytes

Variable Size             184552372 bytes

Database Buffers          411041792 bytes

Redo Buffers                7135232 bytes

Database mounted.

Database opened.

 

SQL> show parameter REMOTE_LOGIN_PASSWORDFILE;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

remote_login_passwordfile            string      EXCLUSIVE

now grant the sysdba privelages to user

SQL> grant sysdba to scott;

Grant succeeded.

You can caheck which user have sysdba privelages  tou can find using query

SQL> SELECT USERNAME FROM V$PWFILE_USERS WHERE USERNAME != 'SYS' AND SYSDBA='TRUE';

USERNAME

------------------------------

SCOTT

2) if  password file is missing then you need to creaet new password file using blow command

C:\Documents and Settings\vanita.sharma>orapwd FILE=C:\ORACLE\product\10.2.0\db_1\database\pwdorcl.ora password=pass ENTRIES=50 FORCE=y