Re: ORA-01994: GRANT failed: password file missing or disabled
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 02 May 2012 07:32:20 +0100
Message-ID: <4FA0D4F4.4070300_at_dunbar-it.co.uk>
Morning Ashoke,
> Password file:
> UNIX> ls -l /dmasdev1/u01/app/oracle/admin/dmasdev1/pfile/orapwdmasdev1
> -rwSr----- 1 oracle oinstall 5120 Apr 30 11:17 /dmasdev1/u01/app/oracle/admin/dmasdev1/pfile/orapwdmasdev1-rwSr----- 1 oracle oinstall 5120 Apr 30 11:17 orapwdmasdev1
Date: Wed, 02 May 2012 07:32:20 +0100
Message-ID: <4FA0D4F4.4070300_at_dunbar-it.co.uk>
Morning Ashoke,
On 02/05/12 00:58, Mandal, Ashoke wrote:
> ERROR at line 1:
> ORA-01994: GRANT failed: password file missing or disabled
>...
> Password file:
> UNIX> ls -l /dmasdev1/u01/app/oracle/admin/dmasdev1/pfile/orapwdmasdev1
> -rwSr----- 1 oracle oinstall 5120 Apr 30 11:17 /dmasdev1/u01/app/oracle/admin/dmasdev1/pfile/orapwdmasdev1-rwSr----- 1 oracle oinstall 5120 Apr 30 11:17 orapwdmasdev1
The password file, should be in the location $ORACLE_HOME/dbs and should by default be named orapw<SID>. So your database will be masdev1 given the above.
At work, I keep my init<SID>.ora, spfile<SID>.ora and orapw<SID> files in a standard location and sym-link them as follows:
cd /srv/<APP>/oradata/<SID>/pfile
ln -s `pwd`/orapw<SID> $ORACLE_HOME/dbs/orapw<SID>
Obviously replacing <SID> with the appropriate database SID.
HTH
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 02 2012 - 01:32:20 CDT