Re: help please with create database error

Nope, I don't think thats it, I believe I set the sid correctly. Did you come to your conclusion due to the fact the error listed orapw instead of oradev1pw?
ORA-01990: error opening password file u01/oracle/OraHome1/dbs/orapw

I set the new sid 'dev1' in both the environment and also listed in the initdev1.ora init file I used to startup nomount the instance.

Robert Malikian wrote:
>
> 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 - 06:45:36 CST