FAQ
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-l

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 1, '12 at 11:59p
activeMay 2, '12 at 6:42a
posts2
users2
websiteoracle.com

2 users in discussion

Norman Dunbar: 1 post Mandal, Ashoke: 1 post

People

Translate

site design / logo © 2022 Grokbase