password file

[deswal_aja]

mine is 8.1.6.3 on hpux 11.o

while creating a database the instance is looking for the password file under $HOME/dbs

why?

even when i used orapwd to create a new password file the problem persisted.i had to change remote_login_passwordfile to none to be able to go ahead.

thanks

[julian]

The password file must be under $ORACLE_HOME/dbs
The file name MUST be "orapw" and you must use the SID for the database in which the password file is being created. Do not add an extension to the file name.

Do the following:

1. Shutdown immediate the database.

2. cd $ORACLE_HOME/dbs.

3. orapwd file=orapw password= entries=

4. In the init.ora file, add REMOTE_LOGIN_PASSWORDFILE=exclusive

5. Startup the database.

[deswal_aja]

thanks Julian

[julian]

Did it work?

[deswal_aja]

i can't bring the DB down so i haven't tried yet.

[julian]

OK, try it when you have the dowtime.