RE: ORA-1078 During a 9iR2 Install

I tried it and I got the following error:

ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS Thanks,
-Scott

>===== Original Message From ORACLE-L_at_fatcity.com =====
>try to startup the database in nomount and then do it.
>
>
>
>-----Original Message-----
>Sent: Thursday, October 31, 2002 4:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I've never been able to get into the DB yet to open it.
>
>-Scott
>
>
>At 03:48 PM 10/31/02 -0800, you wrote:
>>Was your database in mount,nomount,open or IDLE state?
>>
>>
>>
>>
>>-----Original Message-----
>>Sent: Thursday, October 31, 2002 3:30 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>I'm really new to 9i and I vaguely heard about the spfile, so I looked in
>>the Oracle9i New Features book (thanks RF!) to read up on the spfile. I
>>noticed that it said that if an spfile was not created, it would default to
>>look for the initSID.ora file. Well, I opened a SQLPLUS session and tried
>>to use the syntax in the book to create an spfile anyway and I got the
>>following message:
>>
>>------snip-----------------------------------------------
>>SQL> CREATE
>SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
>> FROM
>>PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora';
>>
>>CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora'
>>*
>>ERROR at line 1:
>>ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS
>>ORA-27037: unable to obtain file status
>>HP-UX Error: 14 Bad address
>>Additional information: 1
>>
>>SQL>
>>------snip-----------------------------------------------
>>
>>I think my whole problem is that the DBCA is supposed to create one for you
>>and it never got to that point. I got the ORA-01078 error before it was
>>ever created.
>>
>>Thanks so much,
>>-Scott
>>
>>
>>
>>At 07:03 AM 10/31/02 -0800, you wrote:
>> >You should recreate your spfile. Oracle9i starts from an spfile, if it
>> >exists
>> >and some installations do put a ghost one in $ORACLE_HOME/dbs.
>> >
>> > > -----Original Message-----
>> > > From: Scott Stefick [mailto:sstefick_at_harper.cc.il.us]
>> > > Sent: Wednesday, October 30, 2002 5:04 PM
>> > > To: Multiple recipients of list ORACLE-L
>> > > Subject: ORA-1078 During a 9iR2 Install
>> > >
>> > >
>> > > Hi Gurus,
>> > >
>> > > Hardware: HP rp5470
>> > > OS: HP-UX 11i (11.11)
>> > > Oracle Version: Enterprise Edition 9.2.0.1.0
>> > >
>> > > I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is
>> > > trying to create and start the database, I'm getting an
>> > > "ORA-1078: failure
>> > > in processing system parameters" error. Then when I tried
>> > > startup nomount
>> > > I got that error again along with "LRM-00109: could not open
>> > > parameter file
>> > > '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message. I
>> > > opened up a TAR with Oracle and so far they just made sure that my
>> > > ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set
>> > > correctly. they
>> > > said they would get back to me on this one. Has anyone here
>> > > encountered
>> > > anything like this during a 9iR2 install, or does anyone have any
>> > > suggestions that I could try?
>> > >
>> > > Thanks in advance!
>> > > -Scott
>> > >
>> > > ******************************************
>> > > Scott Stefick
>> > > UNIX Systems Administrator
>> > > Oracle Certified Professional DBA
>> > > Wm. Rainey Harper College
>> > > 847.925.6130
>> > > ******************************************
>> > > --
>> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> > > --
>> > > Author: Scott Stefick
>> > > INET: sstefick_at_harper.cc.il.us
>> > >
>> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> > > San Diego, California -- Mailing list and web hosting services
>> > > ---------------------------------------------------------------------
>> > > 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: Gogala, Mladen
>> > INET: MGogala_at_oxhp.com
>> >
>> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> >San Diego, California -- Mailing list and web hosting services
>> >---------------------------------------------------------------------
>> >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).
>>
>>
>>******************************************
>>Scott Stefick
>>UNIX Systems Administrator
>>Oracle Certified Professional DBA
>>Wm. Rainey Harper College
>>847.925.6130
>>******************************************
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Scott Stefick
>> INET: sstefick_at_harper.cc.il.us
>>
>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>San Diego, California -- Mailing list and web hosting services
>>---------------------------------------------------------------------
>>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: Wong, Bing
>> INET: bing.wong_at_IngramMicro.com
>>
>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>San Diego, California -- Mailing list and web hosting services
>>---------------------------------------------------------------------
>>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).
>
>
>******************************************
>Scott Stefick
>UNIX Systems Administrator
>Oracle Certified Professional DBA
>Wm. Rainey Harper College
>847.925.6130
>******************************************
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Scott Stefick
> INET: sstefick_at_harper.cc.il.us
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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: Wong, Bing
> INET: bing.wong_at_IngramMicro.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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: sstefick
  INET: sstefick_at_harper.cc.il.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).