| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
-- 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).Received on Thu Oct 31 2002 - 18:13:41 CST
 |
 |