RE: ORA-1078 During a 9iR2 Install
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@;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@;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 >
RE: ORA-1078 During a 9iR2 Install
I tried it and I got the following error: ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS Thanks, -Scott >= Original Message From [EMAIL PROTECTED] = >try to startup the database in nomount and then do it. > > > >-Original Message- >Sent: Thursday, October 31, 2002 4:14 PM >To: Multiple recipients of list ORACLE-L > > >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). >> >> >>** >>S
RE: ORA-1078 During a 9iR2 Install
try to startup the database in nomount and then do it. -Original Message- Sent: Thursday, October 31, 2002 4:14 PM To: Multiple recipients of list ORACLE-L 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 Networ
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@;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: UNSU
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 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
RE: ORA-1078 During a 9iR2 Install
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).
RE: ORA-1078 During a 9iR2 Install
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).
