| 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
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
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).
-- 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).Received on Thu Oct 31 2002 - 17:48:34 CST
 |
 |