Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help please with create database error
The default format of the filename is orapw<$ORACLE_SID>
orapw alone would point to a missing env var.
oradev1pw is never going to be correct unless you set the ORA_PWFILE env
var.
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "stevek" <stefano1_at_att.net> wrote in message news:3C077E41.713AD38B_at_att.net...Received on Fri Nov 30 2001 - 07:26:58 CST
> 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