------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@;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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
