RE: ORA-1078 During a 9iR2 Install

2002-11-01 Thread Gogala, Mladen
ple 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? >

RE: ORA-1078 During a 9iR2 Install

2002-10-31 Thread sstefick
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

RE: ORA-1078 During a 9iR2 Install

2002-10-31 Thread Wong, Bing
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 mou

RE: ORA-1078 During a 9iR2 Install

2002-10-31 Thread Scott Stefick
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 an

RE: ORA-1078 During a 9iR2 Install

2002-10-31 Thread Wong, Bing
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

RE: ORA-1078 During a 9iR2 Install

2002-10-31 Thread Scott Stefick
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 trie

RE: ORA-1078 During a 9iR2 Install

2002-10-31 Thread Gogala, Mladen
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