Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help please with create database error

Re: help please with create database error

From: Robert Malikian <robertmalikian_at_hotmail.com>
Date: Fri, 30 Nov 2001 05:00:53 -0800
Message-ID: <3c071225$1@news1.homechoice.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US