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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: URGENT - create database

RE: URGENT - create database

From: Tirumala, Surendra HS <surendra.tirumala_at_hs.utc.com>
Date: Thu, 16 Nov 2000 11:26:57 -0500
Message-Id: <10682.122264@fatcity.com>


I faced the same problem(my other mail with subject "How to have a DB specific PASSWD file?"
I set the "remote_logon_passwordfile" to none and,it allowed me to create the db as expected.

Surendra Tirumala
Oracle DBA
860-654-1322 (work)
860-298-9141 (home)

> -----Original Message-----
> From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> Sent: Thursday, November 16, 2000 7:57 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: URGENT - create database
>
> This note is from MetaLink that may provide some troubleshooting hints.
>
> Rick
>
> Error: ORA 1990
> Text: error opening password file <name>
>
> --------------------------------------------------------------------------
> --
> ---
> Cause: An attempt to open the specified password file failed because of
> one
> of the following errors:
> An operating system error occurred.
> ORAPWD is already running, so the password file is locked.
> The environment variables ORA_<sid>_PWFILE and ORA_PWFILE are not
> set.
> Action: Check for the above causes and correct as necessary.
> .
>
> > -----Original Message-----
> > From: Suganya [SMTP:ukumsu02_at_shafika.vetri.com]
> > Sent: Thursday, November 16, 2000 7:21 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: URGENT - create database
> >
> > Hi all
> > I didn't get the error number also in the orafaq please any one help
> and
> > tel me a solution for it
> >
> > SVRMGR> startup nomount pfile =
> > /sora01/app/oracle8i/product/8.1.5/admin/ford/pf
> > ile/initgalaxydb.ora
> > ORACLE instance started.
> > Total System Global Area 36683152 bytes
> > Fixed Size 64912 bytes
> > Variable Size 19668992 bytes
> > Database Buffers 16777216 bytes
> > Redo Buffers 172032 bytes
> > SVRMGR> create database galaxydb
> > 2> controlfile reuse
> > 3> datafile '/sora01/oradata/galaxydb/gxysystem.dbf' size 128M
> > AUTOEXTEND O
> > FF
> > 4> maxdatafiles 400
> > 5> maxinstances 8
> > 6> maxlogfiles 32
> > 7> logfile group 1 ('/sora01/oradata/galaxydb/redo1_1.log',
> > 8> '/sora01/oradata/galaxydb/redo1_2.log') size 5M REUSE,
> > 9> group 2 ('/sora01/oradata/galaxydb/redo2_1.log',
> > 10> '/sora01/oradata/galaxydb/redo2_2.log') size 5M REUSE,
> > 11> group 3 ('/sora01/oradata/galaxydb/redo3_1.log',
> > 12> '/sora01/oradata/galaxydb/redo3_2.log') size 5M REUSE
> > 13> noarchivelog;
> > create database galaxydb
> > *
> > ORA-01501: CREATE DATABASE failed
> > ORA-01990: error opening password file
> > '/sora01/app/oracle8i/product/8.1.5/dbs/o
> > rapw'
> >
> > for this i separately created the orapwd file command and executed still
>
> > it is giving the
> > same problem .
> > Regards
> > suganya
> >
> > "Sackwitz, Antje" wrote:
> >
> > Hi,
> > we also got a Sybase database in our company and I never worked with
> > Sybase
> > before.
> > Can anyone recommend some documentation for someone who knows
> > Oracle?
> > Is there a Sybase mailing list as well?
> > I'm also seekin gfor a document on the differences between Oracle,
> > Sybase,
> > Informix, PostGres(, Access maybe) also and for what situation
> > which is
> > the best database.
> >
> > Regards,
> > Antje
> > --
> > Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
> > --
> > Author: Sackwitz, Antje
> > INET: Sackwitz_at_vst.vossloh.de
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Nov 16 2000 - 10:26:57 CST

Original text of this message

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