Re: Help: password file name

"charlie cs" <cs3526(no spam)@yahoo.com> said...
> I am using 9.2 on Linux 7.2
>
> I created password file like this
> $orapw file=/opt/oracle/product/9.2/dbs/orapwtest.ora password=xxx entries=5
>
> that went well
>
> but create database failed with:
> ORA-01501: CREATE DATABASE failed
> ORA-01990: error opening password file '/opt/oracle/product/9.2/dbs/orapw'
> ORA-27037: unable to obtain file status
>
> Oracle is looking for orapw, how could I tell oracle password file is what I
> defined, instead of looking for the default one?
> Does this have anything to do with my set
> remote_login_passwordfile=exclusive?
>
> Thanks for your help.
>
>

Two things:

1. You must make sure the ORACLE_SID environment variable is set correctly:

$ ORACLE_SID=test
$ export ORACLE_SID

2. Do NOT specify a file extension for the password file when you create it:

$ cd $ORACLE_HOME/dbs
$ orapw file=orapwtest password=xxx entries=5

-- 
/Karsten