Tuesday, July 22, 2008

ORA-01994

SQL> grant SYSDBA to STDING;
grant SYSDBA to STDING
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
ORA-27037: unable to obtain file status
HP IPF VMS Error: 2: no such file or directory
Additional information: 3
Solution:
Try renaming your password file to orapwSID (SID=instance name) and move it to $ORACLE_HOME/dbs. This is default name and location.
For 1 of my databases:
oracle@xyz127(rp3440):/mnt/app/oracle/10gR2_db/dbs
=>ls
afiedt.buf           file_rfile_size.lst  hc_orcl10g.dat       init.ora             initdw.ora           lkORCL10G            orapworcl10g       spfileorcl10g.ora
Where my SID is orcl10g

Command for creating new orapwd file:
> orapwd file=filename password=password entries=max_users

Usage: orapwd file= password= entries= force=

  where
    file - name of password file (mand),
    password - password for SYS (mand),
    entries - maximum number of distinct DBA and     force - whether to overwrite existing file (opt),
OPERs (opt),
  There are no spaces around the equal-to (=) character.
 

Check the following anyway:
1.
In your init.ora are you using anything like
remote_login_passwordfile = exclusive
or
remote_login_passwordfile = shared

2.
SQL> select * from v$pwfile_users;
USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE
SQL> show parameter remote_login_passwordfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE
SQL>

No comments:

Post a Comment