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@;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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing 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).