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 -- //www.freelists.org/webpage/oracle-l