RE: ORA-1078 During a 9iR2 Install

Scott, you probably have an error in your parameters. Try "startup pfile=/oracle/product/9.2.0/dbs/init_MYSID.ora". That should work.

> -----Original Message-----
> From: Scott Stefick [mailto:sstefick_at_harper.cc.il.us]
> Sent: Thursday, October 31, 2002 7:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-1078 During a 9iR2 Install
>
>
> 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: 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).