| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Summary ORA-1078 During a 9iR2 Install
List,
First of all, I want to thank Mladen Gogala and Bing Wong for their suggestions in helping me resolve my Install problem.
The problem seemed to be not related to Oracle or HPUX, It seemed to be caused by CA's Unicenter TNG Workload Agent. I shutdown all of the Unicenter components and tried the Install again and this time it finished and I was able to open the database.
Thanks again for your help!
-Scott Stefick
At 06:55 AM 11/1/02 -0800, you wrote:
>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).
-- 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 Fri Nov 01 2002 - 14:15:06 CST
 |
 |