Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help please with create database error
I take it you are using a flavour of Unix!
It might be because you did not set your oracle_sid;
try this and see it works.
ORACLE_SID=DATABASENAME
export ORACLE_SID
now try to run creation script.
Robert
"stevek" <stefano1_at_att.net> wrote in message
news:3C06E1C0.DAB5FA22_at_att.net...
>
> Trying to create a new database and continue to get the below error.
>
> ORA-01501: CREATE DATABASE failed
> ORA-01990: error opening password file '/u01/oracle/OraHome1/dbs/orapw'
>
> looked up in Oracle manual which states
>
> ORA-01990 error opening password file 'string'
> Cause: An attempt to open the specified password file failed because of
> one of
> the following errors:
> n An operating system error occurred.
> n ORAPWD is already running, so the password file is locked.
> The environment variables ORA_sid_PWFILE and ORA_PWFILE are not set.
>
> Set both variables without any success. How do I tell oracle that I
> would like
> orapw or oradev1pw placed someplace other than Oracle_Home/dbs/?
>
> Thanks in advance
Received on Fri Nov 30 2001 - 07:00:53 CST