Re: Where is Oracle 9.2 init.ora?
Kirti, I am using Red Hat 7.1, I will test it in W2K - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 3:53 PM > Ramon, > I can not explain that. What platform are you on? > May be this is another bug with SPFILE. > > - Kirti > > > > -Original Message- > > From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, July 15, 2002 2:58 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Where is Oracle 9.2 init.ora? > > > > Hi Kirti > > > > I have something to add to the topic. > > > > I "could" edit the spfile with VI and add a parameter with a value of 20, > > later add the same parameter to the init file with a value of 30, bounce > > the > > DB and it worked very fine. > > > > SQL> shutdown immediate; > > Database closed. > > Database dismounted. > > ORACLE instance shut down. > > SQL> startup > > > > ORACLE instance started. > > > > Total System Global Area 235693104 bytes > > Fixed Size 279600 bytes > > Variable Size 167772160 bytes > > Database Buffers 67108864 bytes > > Redo Buffers 532480 bytes > > Database mounted. > > Database opened. > > SQL> SHOW PARAMETER JOB > > > > NAME TYPEVALUE > > --- > > --- > > --- > > job_queue_processes integer 20 <-- spfile > > > > > > SQL> shutdown immediate; > > Database closed. > > Database dismounted. > > ORACLE instance shut down. > > SQL> startup > > ORACLE instance started. > > > > Total System Global Area 235693104 bytes > > Fixed Size 279600 bytes > > Variable Size 167772160 bytes > > Database Buffers 67108864 bytes > > Redo Buffers 532480 bytes > > Database mounted. > > Database opened. > > SQL> show parameter job > > > > NAME TYPEVALUE > > --- > > --- > > --- > > job_queue_processes integer 30 <-- init > > SQL> > > SQL> > > > > Could you explain me that ??? > > > > Ramon > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Sunday, July 14, 2002 5:58 PM > > > > > > > All Right, Larry. Since we have the test servers and databases; and my > > > Company still pays for 'doing Oracle' the 'scary' way, here is another > > > 'scary thing' I did with SPFILE :) > > > (9iR1 on HP) > > > > > > SQL> conn / as sysdba > > > Connected to an idle instance. > > > SQL> startup< using spfile > > > > > > ORACLE instance started. > > > Total System Global Area 72273416 bytes > > > Fixed Size 437768 bytes > > > Variable Size 37748736 bytes > > > Database Buffers 33554432 bytes > > > Redo Buffers 532480 bytes > > > Database mounted. > > > Database opened. > > > SQL> show parameter db_cache_size > > > NAME TYPEVALUE > > > --- > > > -- > > > db_cache_sizebig integer 33554432 > > > > > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > > > > > SQL> !ls -l *.ora > > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a > > new > > > value > > > > > > System altered. <--- No problem? > > > > > > SQL> show parameter db_cache_size > > > > > > NAME TYPEVALUE > > > --- > > > -- > > > db_cache_sizebig integer 12582912 > > > > > > --> New value in effect. > > > > > > SQL> !ls -l *.ora > > > -rw-r--r--
RE: SPFILE Bug [RE: Where is Oracle 9.2 init.ora?]
Work around: Yes do not use spfile Hire a DBA :) -Original Message- Sent: Monday, July 15, 2002 5:02 PM To: Multiple recipients of list ORACLE-L Okay.. Oracle Support just informed me that Bug # 2462605 has been filed regarding this issue with SPFILE not visible to public yet, but following text is in my TAR: --- Called customer lms on vm please call when avail SME did see this.. but did not file a bug on this. 15-JUL-02 17:08:16 GMT talked with custoemr.. about this.. he would like me to file a bug filing bug 15-JUL-02 17:19:47 GMT bug was filed 2462605 15-JUL-02 17:29:37 GMT Associated bug 2462605 has been updated and has changed status to 10. - - Kirti > -Original Message- > From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > Thanks, Tony. > > If that were the case, the second test (scope=spfile) should not have > failed. > > Oracle Support left a v-mail to me stating that they are considering this > a > bug. And wanted to talk to me about more testing. I will get with them > later today (or tomorrow). > > Regards. > > - Kirti > > > -Original Message- > > From: Aponte, Tony [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, July 15, 2002 9:37 AM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject:RE: Where is Oracle 9.2 init.ora? > > > > On my version of UNIX (Solaris) moving/removing a file that is in use > only > > affects the directory entry and not the actual payload on disk. I > suspect > > that the spfile was held open by your sqlplus program and it executed > the > > I/O operation using the open file descriptor. I've participated in > > similar (and unplanned) tests with ufs-based file systems where all of > the > > underlying files where rm-ed and the database continued to run. It > > crashed when it tried to switch into the next and non-existent redo log > > files. A post-mortem on the incident taught us that removing an open > file > > only removed the entry from UNIX's directory file but the cleanup was > > postponed until the OS closed the last open handle for that i-node. > > > > HTH > > Tony Aponte > > > > -Original Message- > > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > > Sent: Sunday, July 14, 2002 6:58 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > > > All Right, Larry. Since we have the test servers and databases; and my > > Company still pays for 'doing Oracle' the 'scary' way, here is another > > 'scary thing' I did with SPFILE :) > > (9iR1 on HP) > > > > SQL> conn / as sysdba > > Connected to an idle instance. > > SQL> startup< using spfile > > > > ORACLE instance started. > > Total System Global Area 72273416 bytes > > Fixed Size 437768 bytes > > Variable Size 37748736 bytes > > Database Buffers 33554432 bytes > > Redo Buffers 532480 bytes > > Database mounted. > > Database opened. > > SQL> show parameter db_cache_size > > NAME TYPEVALUE > > --- > > -- > > db_cache_sizebig integer 33554432 > > > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > > > SQL> !ls -l *.ora > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a > new > > > > value > > > > System altered. <--- No problem? > > > > SQL> show parameter db_cache_size > > > > NAME TYPEVALUE > > --- > > -- > > db_cache_sizebig integer 12582912 > > > > --> New value in effect. > > > > SQL> !ls -l *.ora > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > --> Still no SFILE > > --> Now, why would not Oracle tell us that there was no spfile to > process > > SCOPE=BOTH ? > > > > SQL> c/both/spfile
RE: Where is Oracle 9.2 init.ora?
Ramon, I can not explain that. What platform are you on? May be this is another bug with SPFILE. - Kirti > -Original Message- > From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 2:58 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Where is Oracle 9.2 init.ora? > > Hi Kirti > > I have something to add to the topic. > > I "could" edit the spfile with VI and add a parameter with a value of 20, > later add the same parameter to the init file with a value of 30, bounce > the > DB and it worked very fine. > > SQL> shutdown immediate; > Database closed. > Database dismounted. > ORACLE instance shut down. > SQL> startup > > ORACLE instance started. > > Total System Global Area 235693104 bytes > Fixed Size 279600 bytes > Variable Size 167772160 bytes > Database Buffers 67108864 bytes > Redo Buffers 532480 bytes > Database mounted. > Database opened. > SQL> SHOW PARAMETER JOB > > NAME TYPEVALUE > --- > --- > --- > job_queue_processes integer 20 <-- spfile > > > SQL> shutdown immediate; > Database closed. > Database dismounted. > ORACLE instance shut down. > SQL> startup > ORACLE instance started. > > Total System Global Area 235693104 bytes > Fixed Size 279600 bytes > Variable Size 167772160 bytes > Database Buffers 67108864 bytes > Redo Buffers 532480 bytes > Database mounted. > Database opened. > SQL> show parameter job > > NAME TYPEVALUE > --- > --- > --- > job_queue_processes integer 30 <-- init > SQL> > SQL> > > Could you explain me that ??? > > Ramon > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, July 14, 2002 5:58 PM > > > > All Right, Larry. Since we have the test servers and databases; and my > > Company still pays for 'doing Oracle' the 'scary' way, here is another > > 'scary thing' I did with SPFILE :) > > (9iR1 on HP) > > > > SQL> conn / as sysdba > > Connected to an idle instance. > > SQL> startup< using spfile > > > > ORACLE instance started. > > Total System Global Area 72273416 bytes > > Fixed Size 437768 bytes > > Variable Size 37748736 bytes > > Database Buffers 33554432 bytes > > Redo Buffers 532480 bytes > > Database mounted. > > Database opened. > > SQL> show parameter db_cache_size > > NAME TYPEVALUE > > --- > > -- > > db_cache_sizebig integer 33554432 > > > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > > > SQL> !ls -l *.ora > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a > new > > value > > > > System altered. <--- No problem? > > > > SQL> show parameter db_cache_size > > > > NAME TYPEVALUE > > --- > > -- > > db_cache_sizebig integer 12582912 > > > > --> New value in effect. > > > > SQL> !ls -l *.ora > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > --> Still no SFILE > > --> Now, why would not Oracle tell us that there was no spfile to > process > > SCOPE=BOTH ? > > > > SQL> c/both/spfile > > 1* alter system set db_cache_size=10M scope=spfile > > SQL> / > > alter system set db_cache_size=10M scope=spfile > > * > > ERROR at line 1: > > ORA-27037: unable to obtain file status > > HP-UX Error: 2: No such file or directory > > Additional information: 3 > > > > -->This is what should have happened with SCOPE=BOTH as well, or at > least > a > > warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no > > SPFILE available. I would
SPFILE Bug [RE: Where is Oracle 9.2 init.ora?]
Okay.. Oracle Support just informed me that Bug # 2462605 has been filed regarding this issue with SPFILE not visible to public yet, but following text is in my TAR: --- Called customer lms on vm please call when avail SME did see this.. but did not file a bug on this. 15-JUL-02 17:08:16 GMT talked with custoemr.. about this.. he would like me to file a bug filing bug 15-JUL-02 17:19:47 GMT bug was filed 2462605 15-JUL-02 17:29:37 GMT Associated bug 2462605 has been updated and has changed status to 10. - - Kirti > -Original Message- > From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > Thanks, Tony. > > If that were the case, the second test (scope=spfile) should not have > failed. > > Oracle Support left a v-mail to me stating that they are considering this > a > bug. And wanted to talk to me about more testing. I will get with them > later today (or tomorrow). > > Regards. > > - Kirti > > > -Original Message- > > From: Aponte, Tony [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, July 15, 2002 9:37 AM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject:RE: Where is Oracle 9.2 init.ora? > > > > On my version of UNIX (Solaris) moving/removing a file that is in use > only > > affects the directory entry and not the actual payload on disk. I > suspect > > that the spfile was held open by your sqlplus program and it executed > the > > I/O operation using the open file descriptor. I've participated in > > similar (and unplanned) tests with ufs-based file systems where all of > the > > underlying files where rm-ed and the database continued to run. It > > crashed when it tried to switch into the next and non-existent redo log > > files. A post-mortem on the incident taught us that removing an open > file > > only removed the entry from UNIX's directory file but the cleanup was > > postponed until the OS closed the last open handle for that i-node. > > > > HTH > > Tony Aponte > > > > -Original Message- > > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > > Sent: Sunday, July 14, 2002 6:58 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > > > All Right, Larry. Since we have the test servers and databases; and my > > Company still pays for 'doing Oracle' the 'scary' way, here is another > > 'scary thing' I did with SPFILE :) > > (9iR1 on HP) > > > > SQL> conn / as sysdba > > Connected to an idle instance. > > SQL> startup< using spfile > > > > ORACLE instance started. > > Total System Global Area 72273416 bytes > > Fixed Size 437768 bytes > > Variable Size 37748736 bytes > > Database Buffers 33554432 bytes > > Redo Buffers 532480 bytes > > Database mounted. > > Database opened. > > SQL> show parameter db_cache_size > > NAME TYPEVALUE > > --- > > -- > > db_cache_sizebig integer 33554432 > > > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > > > SQL> !ls -l *.ora > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a > new > > > > value > > > > System altered. <--- No problem? > > > > SQL> show parameter db_cache_size > > > > NAME TYPEVALUE > > --- > > -- > > db_cache_sizebig integer 12582912 > > > > --> New value in effect. > > > > SQL> !ls -l *.ora > > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > > > --> Still no SFILE > > --> Now, why would not Oracle tell us that there was no spfile to > process > > SCOPE=BOTH ? > > > > SQL> c/both/spfile > > 1* alter system set db_cache_size=10M scope=spfile > > SQL> / > > alter system set db_cache_size=10M scope=spfile > >
Re: Where is Oracle 9.2 init.ora?
Hi Kirti I have something to add to the topic. I "could" edit the spfile with VI and add a parameter with a value of 20, later add the same parameter to the init file with a value of 30, bounce the DB and it worked very fine. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 235693104 bytes Fixed Size 279600 bytes Variable Size 167772160 bytes Database Buffers 67108864 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL> SHOW PARAMETER JOB NAME TYPEVALUE --- --- --- job_queue_processes integer 20 <-- spfile SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 235693104 bytes Fixed Size 279600 bytes Variable Size 167772160 bytes Database Buffers 67108864 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL> show parameter job NAME TYPEVALUE --- --- --- job_queue_processes integer 30 <-- init SQL> SQL> Could you explain me that ??? Ramon - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 14, 2002 5:58 PM > All Right, Larry. Since we have the test servers and databases; and my > Company still pays for 'doing Oracle' the 'scary' way, here is another > 'scary thing' I did with SPFILE :) > (9iR1 on HP) > > SQL> conn / as sysdba > Connected to an idle instance. > SQL> startup< using spfile > > ORACLE instance started. > Total System Global Area 72273416 bytes > Fixed Size 437768 bytes > Variable Size 37748736 bytes > Database Buffers 33554432 bytes > Redo Buffers 532480 bytes > Database mounted. > Database opened. > SQL> show parameter db_cache_size > NAME TYPEVALUE > --- > -- > db_cache_sizebig integer 33554432 > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > SQL> !ls -l *.ora > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a new > value > > System altered. <--- No problem? > > SQL> show parameter db_cache_size > > NAME TYPEVALUE > --- > -- > db_cache_sizebig integer 12582912 > > --> New value in effect. > > SQL> !ls -l *.ora > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > --> Still no SFILE > --> Now, why would not Oracle tell us that there was no spfile to process > SCOPE=BOTH ? > > SQL> c/both/spfile > 1* alter system set db_cache_size=10M scope=spfile > SQL> / > alter system set db_cache_size=10M scope=spfile > * > ERROR at line 1: > ORA-27037: unable to obtain file status > HP-UX Error: 2: No such file or directory > Additional information: 3 > > -->This is what should have happened with SCOPE=BOTH as well, or at least a > warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no > SPFILE available. I would not have objected if Oracle re-recreated SPFILE in > the default location and told me so! > > If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I > would like to know the source of that information. I have searched Metalink, > Google but have not come across any. I have created an iTar with OWS. > Thanks. > > As I said before, SPFILE has some things that need to be made fool proof. > > This time I did not drink prior to doing this 'scary' stuff !!;-) > > Regards, > > - Kirti > > > -Original Message- > > From: Larry Elkins [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, July 12, 2002 9:03 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > Man, it scares the heck out of me too that Jared and Kirti are actually > > "doing Oracle" -- I can't believe companies actually pay them ;-) > > &g
RE: Where is Oracle 9.2 init.ora?
Thanks, Tony. If that were the case, the second test (scope=spfile) should not have failed. Oracle Support left a v-mail to me stating that they are considering this a bug. And wanted to talk to me about more testing. I will get with them later today (or tomorrow). Regards. - Kirti > -Original Message- > From: Aponte, Tony [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 9:37 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Where is Oracle 9.2 init.ora? > > On my version of UNIX (Solaris) moving/removing a file that is in use only > affects the directory entry and not the actual payload on disk. I suspect > that the spfile was held open by your sqlplus program and it executed the > I/O operation using the open file descriptor. I've participated in > similar (and unplanned) tests with ufs-based file systems where all of the > underlying files where rm-ed and the database continued to run. It > crashed when it tried to switch into the next and non-existent redo log > files. A post-mortem on the incident taught us that removing an open file > only removed the entry from UNIX's directory file but the cleanup was > postponed until the OS closed the last open handle for that i-node. > > HTH > Tony Aponte > > -Original Message- > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > Sent: Sunday, July 14, 2002 6:58 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > > All Right, Larry. Since we have the test servers and databases; and my > Company still pays for 'doing Oracle' the 'scary' way, here is another > 'scary thing' I did with SPFILE :) > (9iR1 on HP) > > SQL> conn / as sysdba > Connected to an idle instance. > SQL> startup< using spfile > > ORACLE instance started. > Total System Global Area 72273416 bytes > Fixed Size 437768 bytes > Variable Size 37748736 bytes > Database Buffers 33554432 bytes > Redo Buffers 532480 bytes > Database mounted. > Database opened. > SQL> show parameter db_cache_size > NAME TYPEVALUE > --- > -- > db_cache_sizebig integer 33554432 > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > SQL> !ls -l *.ora > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a new > > value > > System altered. <--- No problem? > > SQL> show parameter db_cache_size > > NAME TYPEVALUE > --- > -- > db_cache_sizebig integer 12582912 > > --> New value in effect. > > SQL> !ls -l *.ora > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > --> Still no SFILE > --> Now, why would not Oracle tell us that there was no spfile to process > SCOPE=BOTH ? > > SQL> c/both/spfile > 1* alter system set db_cache_size=10M scope=spfile > SQL> / > alter system set db_cache_size=10M scope=spfile > * > ERROR at line 1: > ORA-27037: unable to obtain file status > HP-UX Error: 2: No such file or directory > Additional information: 3 > > -->This is what should have happened with SCOPE=BOTH as well, or at least > a > warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no > SPFILE available. I would not have objected if Oracle re-recreated SPFILE > in > the default location and told me so! > > If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, > I > would like to know the source of that information. I have searched > Metalink, > Google but have not come across any. I have created an iTar with OWS. > Thanks. > > As I said before, SPFILE has some things that need to be made fool proof. > > This time I did not drink prior to doing this 'scary' stuff !!;-) > > Regards, > > - Kirti > > > -Original Message- > > From: Larry Elkins [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, July 12, 2002 9:03 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > Man, it scares the heck out of me too that Jared and Kirti are actually > > "doing Oracle" --
RE: Where is Oracle 9.2 init.ora?
Title: RE: Where is Oracle 9.2 init.ora? On my version of UNIX (Solaris) moving/removing a file that is in use only affects the directory entry and not the actual payload on disk. I suspect that the spfile was held open by your sqlplus program and it executed the I/O operation using the open file descriptor. I've participated in similar (and unplanned) tests with ufs-based file systems where all of the underlying files where rm-ed and the database continued to run. It crashed when it tried to switch into the next and non-existent redo log files. A post-mortem on the incident taught us that removing an open file only removed the entry from UNIX's directory file but the cleanup was postponed until the OS closed the last open handle for that i-node. HTH Tony Aponte -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 6:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Where is Oracle 9.2 init.ora? All Right, Larry. Since we have the test servers and databases; and my Company still pays for 'doing Oracle' the 'scary' way, here is another 'scary thing' I did with SPFILE :) (9iR1 on HP) SQL> conn / as sysdba Connected to an idle instance. SQL> startup < using spfile ORACLE instance started. Total System Global Area 72273416 bytes Fixed Size 437768 bytes Variable Size 37748736 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL> show parameter db_cache_size NAME TYPE VALUE --- -- db_cache_size big integer 33554432 SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile SQL> !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora SQL> alter system set db_cache_size=10M scope=both; <-- try to set a new value System altered. <--- No problem? SQL> show parameter db_cache_size NAME TYPE VALUE --- -- db_cache_size big integer 12582912 --> New value in effect. SQL> !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora --> Still no SFILE --> Now, why would not Oracle tell us that there was no spfile to process SCOPE=BOTH ? SQL> c/both/spfile 1* alter system set db_cache_size=10M scope=spfile SQL> / alter system set db_cache_size=10M scope=spfile * ERROR at line 1: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 3 -->This is what should have happened with SCOPE=BOTH as well, or at least a warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no SPFILE available. I would not have objected if Oracle re-recreated SPFILE in the default location and told me so! If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I would like to know the source of that information. I have searched Metalink, Google but have not come across any. I have created an iTar with OWS. Thanks. As I said before, SPFILE has some things that need to be made fool proof. This time I did not drink prior to doing this 'scary' stuff !! ;-) Regards, - Kirti > -Original Message- > From: Larry Elkins [SMTP:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 9:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > Man, it scares the heck out of me too that Jared and Kirti are actually > "doing Oracle" -- I can't believe companies actually pay them ;-) > > And you two guys, and I'm talking to you Kirti and Jared, probably dig in > and do things you shouldn't on test boxes just to see how things work and > to > learn. FWIW, I've heard rumors about other people doing similar things. > You've probably even intentionally crashed a DB or pulled the plug just to > see if you could recover. Shame on you two. You should both be banished > from > the list for doing such unconventional things ;-) > > And neither of you will ever be allowed close to a DB I deal with -- I'll > call ltiu from now on ;-) > > Larry > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > [EMAIL PROTECTED] > > Sent: Friday, July 12, 2002 8:08 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > > > Some of us have bee
RE: Where is Oracle 9.2 init.ora?
All Right, Larry. Since we have the test servers and databases; and my Company still pays for 'doing Oracle' the 'scary' way, here is another 'scary thing' I did with SPFILE :) (9iR1 on HP) SQL> conn / as sysdba Connected to an idle instance. SQL> startup< using spfile ORACLE instance started. Total System Global Area 72273416 bytes Fixed Size 437768 bytes Variable Size 37748736 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL> show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 33554432 SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile SQL> !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora SQL> alter system set db_cache_size=10M scope=both; <-- try to set a new value System altered. <--- No problem? SQL> show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 12582912 --> New value in effect. SQL> !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora --> Still no SFILE --> Now, why would not Oracle tell us that there was no spfile to process SCOPE=BOTH ? SQL> c/both/spfile 1* alter system set db_cache_size=10M scope=spfile SQL> / alter system set db_cache_size=10M scope=spfile * ERROR at line 1: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 3 -->This is what should have happened with SCOPE=BOTH as well, or at least a warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no SPFILE available. I would not have objected if Oracle re-recreated SPFILE in the default location and told me so! If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I would like to know the source of that information. I have searched Metalink, Google but have not come across any. I have created an iTar with OWS. Thanks. As I said before, SPFILE has some things that need to be made fool proof. This time I did not drink prior to doing this 'scary' stuff !!;-) Regards, - Kirti > -Original Message- > From: Larry Elkins [SMTP:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 9:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > Man, it scares the heck out of me too that Jared and Kirti are actually > "doing Oracle" -- I can't believe companies actually pay them ;-) > > And you two guys, and I'm talking to you Kirti and Jared, probably dig in > and do things you shouldn't on test boxes just to see how things work and > to > learn. FWIW, I've heard rumors about other people doing similar things. > You've probably even intentionally crashed a DB or pulled the plug just to > see if you could recover. Shame on you two. You should both be banished > from > the list for doing such unconventional things ;-) > > And neither of you will ever be allowed close to a DB I deal with -- I'll > call ltiu from now on ;-) > > Larry > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > [EMAIL PROTECTED] > > Sent: Friday, July 12, 2002 8:08 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > > > Some of us have been around the block a few times. :) > > > > Editing binary files is no big deal. > > > > You neophytes are all the same. > > > > Jared > > > > ltiu <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/12/2002 04:28 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Where is Oracle 9.2 init.ora? > > > > > > You DBA's must be drunk. > > > > Spfiles are in binary format and if you open it in a text editor, all > you > > see > > are weird characters. > > > > Man. You guys are actually doing Oracle? Scares me. > > > > ltiu > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
Kirti, That's interesting. I guess anyone would have *expected* scope=both to report a problem regarding spfile just as it did when specifying just scope=spfile. I wonder if they are going to say in your TAR that this is the expected behavior ;-) Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Deshpande, > Kirti > Sent: Saturday, July 13, 2002 6:23 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > > All Right, Larry. Since we have the test servers and databases; and my > Company still pays for 'doing Oracle' the 'scary' way, here is another > 'scary thing' I did with SPFILE :) > (9iR1 on HP) > > SQL> conn / as sysdba > Connected to an idle instance. > SQL> startup< using spfile > > ORACLE instance started. > Total System Global Area 72273416 bytes > Fixed Size 437768 bytes > Variable Size 37748736 bytes > Database Buffers 33554432 bytes > Redo Buffers 532480 bytes > Database mounted. > Database opened. > SQL> show parameter db_cache_size > NAME TYPEVALUE > --- > -- > db_cache_sizebig integer 33554432 > > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile > > SQL> !ls -l *.ora > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a new > value > > System altered. <--- No problem? > > SQL> show parameter db_cache_size > > NAME TYPEVALUE > --- > -- > db_cache_sizebig integer 12582912 > > --> New value in effect. > > SQL> !ls -l *.ora > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora > > --> Still no SFILE > --> Now, why would not Oracle tell us that there was no spfile to process > SCOPE=BOTH ? > > SQL> c/both/spfile > 1* alter system set db_cache_size=10M scope=spfile > SQL> / > alter system set db_cache_size=10M scope=spfile > * > ERROR at line 1: > ORA-27037: unable to obtain file status > HP-UX Error: 2: No such file or directory > Additional information: 3 > > -->This is what should have happened with SCOPE=BOTH as well, or > at least a > warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no > SPFILE available. I would not have objected if Oracle > re-recreated SPFILE in > the default location and told me so! > > If anyone has seen any mention of this particular behaviour of > SCOPE=BOTH, I > would like to know the source of that information. I have > searched Metalink, > Google but have not come across any. I have created an iTar with OWS. > Thanks. > > As I said before, SPFILE has some things that need to be made fool proof. > > This time I did not drink prior to doing this 'scary' stuff !!;-) > > Regards, > > - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
All Right, Larry. Since we have the test servers and databases; and my Company still pays for 'doing Oracle' the 'scary' way, here is another 'scary thing' I did with SPFILE :) (9iR1 on HP) SQL> conn / as sysdba Connected to an idle instance. SQL> startup< using spfile ORACLE instance started. Total System Global Area 72273416 bytes Fixed Size 437768 bytes Variable Size 37748736 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes Database mounted. Database opened. SQL> show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 33554432 SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile SQL> !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora SQL> alter system set db_cache_size=10M scope=both; <-- try to set a new value System altered. <--- No problem? SQL> show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 12582912 --> New value in effect. SQL> !ls -l *.ora -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora --> Still no SFILE --> Now, why would not Oracle tell us that there was no spfile to process SCOPE=BOTH ? SQL> c/both/spfile 1* alter system set db_cache_size=10M scope=spfile SQL> / alter system set db_cache_size=10M scope=spfile * ERROR at line 1: ORA-27037: unable to obtain file status HP-UX Error: 2: No such file or directory Additional information: 3 -->This is what should have happened with SCOPE=BOTH as well, or at least a warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no SPFILE available. I would not have objected if Oracle re-recreated SPFILE in the default location and told me so! If anyone has seen any mention of this particular behaviour of SCOPE=BOTH, I would like to know the source of that information. I have searched Metalink, Google but have not come across any. I have created an iTar with OWS. Thanks. As I said before, SPFILE has some things that need to be made fool proof. This time I did not drink prior to doing this 'scary' stuff !!;-) Regards, - Kirti > -Original Message- > From: Larry Elkins [SMTP:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 9:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > Man, it scares the heck out of me too that Jared and Kirti are actually > "doing Oracle" -- I can't believe companies actually pay them ;-) > > And you two guys, and I'm talking to you Kirti and Jared, probably dig in > and do things you shouldn't on test boxes just to see how things work and > to > learn. FWIW, I've heard rumors about other people doing similar things. > You've probably even intentionally crashed a DB or pulled the plug just to > see if you could recover. Shame on you two. You should both be banished > from > the list for doing such unconventional things ;-) > > And neither of you will ever be allowed close to a DB I deal with -- I'll > call ltiu from now on ;-) > > Larry > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > [EMAIL PROTECTED] > > Sent: Friday, July 12, 2002 8:08 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Where is Oracle 9.2 init.ora? > > > > > > Some of us have been around the block a few times. :) > > > > Editing binary files is no big deal. > > > > You neophytes are all the same. > > > > Jared > > > > ltiu <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/12/2002 04:28 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Where is Oracle 9.2 init.ora? > > > > > > You DBA's must be drunk. > > > > Spfiles are in binary format and if you open it in a text editor, all > you > > see > > are weird characters. > > > > Man. You guys are actually doing Oracle? Scares me. > > > > ltiu > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
After reading this, I ran to verify what happens when I edited the spfile. Surprisingly I had the same situation (9.0.1 Solaris). Edited the file and started the database without a single error and nothing reported in the alert or bdump. But Oracle used init.ora since non of the settings in spfile were in effect. I can not believe that Oracle starts without any complaints or errors. Probably it's a punishment for editing the holy file! Regards, Waleed -Original Message- Sent: Friday, July 12, 2002 8:53 PM To: Multiple recipients of list ORACLE-L I guess your are right.. I am sincerely sorry about my earlier post. I must be drunk at that time as I could not replicate my test. I was mistaken (happens as I get old... ;) However, let me state the following: SPFILE is in ASCII format (on AIX and HP that I checked) And can be edited via 'the Six Editor' (that is the other name for VI editor per Dave Ensor ;) There is some hashed information maintained in the 1st line based on the contents of the file when it was originally created. I edited the file for a few parameters and bounced the DB. It started fine without any warnings, BUT it silently used the available init.ora file. My changes did not take effect. There was no ORA error or warning. Nothing in alert.log either. When I renamed the init.ora file, and tried to bounce the database, it did not start. But now, following ORA errors were reported... SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/home/oracle/product/9.0.1/dbs/initKED9.ora' So, the lesson learned is not to edit the SPFILE. And if there is an init.ora file, Oracle will simply use it, if it the SPFILE does not pass the checks based in the hashed information in the 1st line of SPFILE. And hence, there is still some work to be done by Oracle with how SPFILE is implemented. I would like to see an error telling me that "available SPFILE is useless" before using the available init.ora file. Then I used the "corrupted" SPFILE to build a new init.ora file and started the database without any problems. I like to 'play' around with throw away databases to see how these new features work and how we can break them, there is nothing wrong in doing so. This is how I 'do oracle' :) Cheers! - Kirti > -Original Message- > From: ltiu [SMTP:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 5:27 PM > To: [EMAIL PROTECTED]; Deshpande, Kirti > Cc: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > You DBA's must be drunk. > > Spfiles are in binary format and if you open it in a text editor, all you > see > are weird characters. > > Man. You guys are actually doing Oracle? Scares me. > > ltiu > > Quoting "Deshpande, Kirti" <[EMAIL PROTECTED]>: > > > I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 > :) > > > > - Kirti > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
I could have SWORN there were problems when manually editing the spfile
file.. if not, why bother creating it when you can just as easily use
the init.ora file?
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0
> :)
>
> - Kirti
>
> > -Original Message-
> > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, July 12, 2002 3:18 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Where is Oracle 9.2 init.ora?
> >
> > It should NOT however, be edited!
> >
> >
> > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > > >> Oracle created the SPFILE which is not humanly readable.
> > >
> > > Mine is pretty easy to read! Maybe you need to check your
> character
> > > set???
> > > :-))
> > >
> > > RF
> > >
> > > Robert G. Freeman - Oracle OCP
> > > Oracle Database Architect
> > > CSX Midtier Database Administration
> > > Author
> > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > > Oracle9i New Features (Oracle Press)
> > > Mastering Oracle8i (Sybex)
> > >
> > > Clark Griswold: Eddie, has anyone ever told you that you're bad
> luck?
> > > Cousin Eddie: Those were my mother's dying words. But I
> > > guess if your body's covered in third degree burns, and
> > > your foot's caught in a bear trap, you tend to start talkin'
> > > crazy.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Thursday, July 11, 2002 12:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dennis,
> > >
> > > Oracle created the SPFILE which is not humanly readable.
> There
> > > should
> > > be an
> > > alter database/system command that does the change for you.
> > > According to
> > > what I
> > > heard at Oratechs 2000 editing the init.ora file is now longer
> > > effective.
> > >
> > > Dick Goulet
> > >
> > > Reply Separator
> > > Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > > Date: 7/11/2002 7:43 AM
> > >
> > > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > > expecting the
> > > init.ora file?
> > >
> > > I created the database using dbca. It created an init.ora in
> > > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and
> renamed
> > > the
> > > original init.ora file. Then I discovered that Oracle is not
> reading
> > > the new
> > > init.ora. The database starts fine, with no errors. I tried
> moving
> > > the
> > > init.ora file back to the original pfile location, but it is
> still
> > > not
> > > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > > true, but I
> > > have made other changes and they are not taking effect either.
> > >
> > > I have searched the documentation, and while there is the new
> SPFILE,
> > > there
> > > is no indication how this might affect my problem.
> > >
> > > Any insights from someone that has turned archiving on with 9.2
> would
> > > be
> > > appreciated.
> > >
> > > Dennis Williams
> > > DBA, 20% OCP
> > > Lifetouch, Inc.
> > > [EMAIL PROTECTED]
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
>
> > > 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).
> > > --
> > > Pl
RE: Where is Oracle 9.2 init.ora?
Man, it scares the heck out of me too that Jared and Kirti are actually "doing Oracle" -- I can't believe companies actually pay them ;-) And you two guys, and I'm talking to you Kirti and Jared, probably dig in and do things you shouldn't on test boxes just to see how things work and to learn. FWIW, I've heard rumors about other people doing similar things. You've probably even intentionally crashed a DB or pulled the plug just to see if you could recover. Shame on you two. You should both be banished from the list for doing such unconventional things ;-) And neither of you will ever be allowed close to a DB I deal with -- I'll call ltiu from now on ;-) Larry > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, July 12, 2002 8:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > > Some of us have been around the block a few times. :) > > Editing binary files is no big deal. > > You neophytes are all the same. > > Jared > > > > > > ltiu <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/12/2002 04:28 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Where is Oracle 9.2 init.ora? > > > You DBA's must be drunk. > > Spfiles are in binary format and if you open it in a text editor, all you > see > are weird characters. > > Man. You guys are actually doing Oracle? Scares me. > > ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
Some of us have been around the block a few times. :)
Editing binary files is no big deal.
You neophytes are all the same.
Jared
ltiu <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/12/2002 04:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Where is Oracle 9.2 init.ora?
You DBA's must be drunk.
Spfiles are in binary format and if you open it in a text editor, all you
see
are weird characters.
Man. You guys are actually doing Oracle? Scares me.
ltiu
Quoting "Deshpande, Kirti" <[EMAIL PROTECTED]>:
> I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
>
> - Kirti
>
> > -Original Message-
> > From:Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent:Friday, July 12, 2002 3:18 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Where is Oracle 9.2 init.ora?
> >
> > It should NOT however, be edited!
> >
> >
> > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > > >> Oracle created the SPFILE which is not humanly readable.
> > >
> > > Mine is pretty easy to read! Maybe you need to check your character
> > > set???
> > > :-))
> > >
> > > RF
> > >
> > > Robert G. Freeman - Oracle OCP
> > > Oracle Database Architect
> > > CSX Midtier Database Administration
> > > Author
> > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > > Oracle9i New Features (Oracle Press)
> > > Mastering Oracle8i (Sybex)
> > >
> > > Clark Griswold: Eddie, has anyone ever told you that you're bad
luck?
> > > Cousin Eddie: Those were my mother's dying words. But I
> > > guess if your body's covered in third degree burns, and
> > > your foot's caught in a bear trap, you tend to start talkin'
> > > crazy.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Thursday, July 11, 2002 12:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dennis,
> > >
> > > Oracle created the SPFILE which is not humanly readable. There
> > > should
> > > be an
> > > alter database/system command that does the change for you.
> > > According to
> > > what I
> > > heard at Oratechs 2000 editing the init.ora file is now longer
> > > effective.
> > >
> > > Dick Goulet
> > >
> > > Reply Separator
> > > Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > > Date: 7/11/2002 7:43 AM
> > >
> > > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > > expecting the
> > > init.ora file?
> > >
> > > I created the database using dbca. It created an init.ora in
> > > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> > > the
> > > original init.ora file. Then I discovered that Oracle is not reading
> > > the new
> > > init.ora. The database starts fine, with no errors. I tried moving
> > > the
> > > init.ora file back to the original pfile location, but it is still
> > > not
> > > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > > true, but I
> > > have made other changes and they are not taking effect either.
> > >
> > > I have searched the documentation, and while there is the new
SPFILE,
> > > there
> > > is no indication how this might affect my problem.
> > >
> > > Any insights from someone that has turned archiving on with 9.2
would
> > > be
> > > appreciated.
> > >
> > > Dennis Williams
> > > DBA, 20% OCP
> > > Lifetouch, Inc.
> > > [EMAIL PROTECTED]
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spell
RE: Where is Oracle 9.2 init.ora?
I guess your are right.. I am sincerely sorry about my earlier post. I must be drunk at that time as I could not replicate my test. I was mistaken (happens as I get old... ;) However, let me state the following: SPFILE is in ASCII format (on AIX and HP that I checked) And can be edited via 'the Six Editor' (that is the other name for VI editor per Dave Ensor ;) There is some hashed information maintained in the 1st line based on the contents of the file when it was originally created. I edited the file for a few parameters and bounced the DB. It started fine without any warnings, BUT it silently used the available init.ora file. My changes did not take effect. There was no ORA error or warning. Nothing in alert.log either. When I renamed the init.ora file, and tried to bounce the database, it did not start. But now, following ORA errors were reported... SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/home/oracle/product/9.0.1/dbs/initKED9.ora' So, the lesson learned is not to edit the SPFILE. And if there is an init.ora file, Oracle will simply use it, if it the SPFILE does not pass the checks based in the hashed information in the 1st line of SPFILE. And hence, there is still some work to be done by Oracle with how SPFILE is implemented. I would like to see an error telling me that "available SPFILE is useless" before using the available init.ora file. Then I used the "corrupted" SPFILE to build a new init.ora file and started the database without any problems. I like to 'play' around with throw away databases to see how these new features work and how we can break them, there is nothing wrong in doing so. This is how I 'do oracle' :) Cheers! - Kirti > -Original Message- > From: ltiu [SMTP:[EMAIL PROTECTED]] > Sent: Friday, July 12, 2002 5:27 PM > To: [EMAIL PROTECTED]; Deshpande, Kirti > Cc: Multiple recipients of list ORACLE-L > Subject: RE: Where is Oracle 9.2 init.ora? > > You DBA's must be drunk. > > Spfiles are in binary format and if you open it in a text editor, all you > see > are weird characters. > > Man. You guys are actually doing Oracle? Scares me. > > ltiu > > Quoting "Deshpande, Kirti" <[EMAIL PROTECTED]>: > > > I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 > :) > > > > - Kirti > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
Yes I usually do Oracle after I'm done driving my cab :)
I did edit the spfile in 9iR1 on Solaris using vi and had no problem!
The header and tail were binaries but all the rest is text.
Regards,
Waleed
-Original Message-
Sent: Friday, July 12, 2002 7:28 PM
To: Multiple recipients of list ORACLE-L
You DBA's must be drunk.
Spfiles are in binary format and if you open it in a text editor, all you
see
are weird characters.
Man. You guys are actually doing Oracle? Scares me.
ltiu
Quoting "Deshpande, Kirti" <[EMAIL PROTECTED]>:
> I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
>
> - Kirti
>
> > -Original Message-
> > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, July 12, 2002 3:18 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Where is Oracle 9.2 init.ora?
> >
> > It should NOT however, be edited!
> >
> >
> > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > > >> Oracle created the SPFILE which is not humanly readable.
> > >
> > > Mine is pretty easy to read! Maybe you need to check your character
> > > set???
> > > :-))
> > >
> > > RF
> > >
> > > Robert G. Freeman - Oracle OCP
> > > Oracle Database Architect
> > > CSX Midtier Database Administration
> > > Author
> > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > > Oracle9i New Features (Oracle Press)
> > > Mastering Oracle8i (Sybex)
> > >
> > > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > > Cousin Eddie: Those were my mother's dying words. But I
> > > guess if your body's covered in third degree burns, and
> > > your foot's caught in a bear trap, you tend to start talkin'
> > > crazy.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Thursday, July 11, 2002 12:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dennis,
> > >
> > > Oracle created the SPFILE which is not humanly readable. There
> > > should
> > > be an
> > > alter database/system command that does the change for you.
> > > According to
> > > what I
> > > heard at Oratechs 2000 editing the init.ora file is now longer
> > > effective.
> > >
> > > Dick Goulet
> > >
> > > Reply Separator
> > > Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > > Date: 7/11/2002 7:43 AM
> > >
> > > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > > expecting the
> > > init.ora file?
> > >
> > > I created the database using dbca. It created an init.ora in
> > > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> > > the
> > > original init.ora file. Then I discovered that Oracle is not reading
> > > the new
> > > init.ora. The database starts fine, with no errors. I tried moving
> > > the
> > > init.ora file back to the original pfile location, but it is still
> > > not
> > > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > > true, but I
> > > have made other changes and they are not taking effect either.
> > >
> > > I have searched the documentation, and while there is the new SPFILE,
> > > there
> > > is no indication how this might affect my problem.
> > >
> > > Any insights from someone that has turned archiving on with 9.2 would
> > > be
> > > appreciated.
> > >
> > > Dennis Williams
> > > DBA, 20% OCP
> > > Lifetouch, Inc.
> > > [EMAIL PROTECTED]
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
> > > 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
> > >
RE: Where is Oracle 9.2 init.ora?
You DBA's must be drunk.
Spfiles are in binary format and if you open it in a text editor, all you see
are weird characters.
Man. You guys are actually doing Oracle? Scares me.
ltiu
Quoting "Deshpande, Kirti" <[EMAIL PROTECTED]>:
> I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
>
> - Kirti
>
> > -Original Message-
> > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, July 12, 2002 3:18 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: Where is Oracle 9.2 init.ora?
> >
> > It should NOT however, be edited!
> >
> >
> > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > > >> Oracle created the SPFILE which is not humanly readable.
> > >
> > > Mine is pretty easy to read! Maybe you need to check your character
> > > set???
> > > :-))
> > >
> > > RF
> > >
> > > Robert G. Freeman - Oracle OCP
> > > Oracle Database Architect
> > > CSX Midtier Database Administration
> > > Author
> > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > > Oracle9i New Features (Oracle Press)
> > > Mastering Oracle8i (Sybex)
> > >
> > > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > > Cousin Eddie: Those were my mother's dying words. But I
> > > guess if your body's covered in third degree burns, and
> > > your foot's caught in a bear trap, you tend to start talkin'
> > > crazy.
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: Thursday, July 11, 2002 12:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dennis,
> > >
> > > Oracle created the SPFILE which is not humanly readable. There
> > > should
> > > be an
> > > alter database/system command that does the change for you.
> > > According to
> > > what I
> > > heard at Oratechs 2000 editing the init.ora file is now longer
> > > effective.
> > >
> > > Dick Goulet
> > >
> > > Reply Separator
> > > Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > > Date: 7/11/2002 7:43 AM
> > >
> > > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > > expecting the
> > > init.ora file?
> > >
> > > I created the database using dbca. It created an init.ora in
> > > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> > > the
> > > original init.ora file. Then I discovered that Oracle is not reading
> > > the new
> > > init.ora. The database starts fine, with no errors. I tried moving
> > > the
> > > init.ora file back to the original pfile location, but it is still
> > > not
> > > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > > true, but I
> > > have made other changes and they are not taking effect either.
> > >
> > > I have searched the documentation, and while there is the new SPFILE,
> > > there
> > > is no indication how this might affect my problem.
> > >
> > > Any insights from someone that has turned archiving on with 9.2 would
> > > be
> > > appreciated.
> > >
> > > Dennis Williams
> > > DBA, 20% OCP
> > > Lifetouch, Inc.
> > > [EMAIL PROTECTED]
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
> > > 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:
> > > INET: [EMA
RE: Where is Oracle 9.2 init.ora?
I've also heard that it should not be edited. It can be more'd to see
contents. No need to edit it directly since SCOPE can be used.
Gerardo
-Original Message-
Sent: Friday, July 12, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, July 12, 2002 3:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Where is Oracle 9.2 init.ora?
>
> It should NOT however, be edited!
>
>
> --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > >> Oracle created the SPFILE which is not humanly readable.
> >
> > Mine is pretty easy to read! Maybe you need to check your character
> > set???
> > :-))
> >
> > RF
> >
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i (Sybex)
> >
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and
> > your foot's caught in a bear trap, you tend to start talkin'
> > crazy.
> >
> >
> >
> > -Original Message-
> > Sent: Thursday, July 11, 2002 12:09 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Dennis,
> >
> > Oracle created the SPFILE which is not humanly readable. There
> > should
> > be an
> > alter database/system command that does the change for you.
> > According to
> > what I
> > heard at Oratechs 2000 editing the init.ora file is now longer
> > effective.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > Date: 7/11/2002 7:43 AM
> >
> > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > expecting the
> > init.ora file?
> >
> > I created the database using dbca. It created an init.ora in
> > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> > the
> > original init.ora file. Then I discovered that Oracle is not reading
> > the new
> > init.ora. The database starts fine, with no errors. I tried moving
> > the
> > init.ora file back to the original pfile location, but it is still
> > not
> > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > true, but I
> > have made other changes and they are not taking effect either.
> >
> > I have searched the documentation, and while there is the new SPFILE,
> > there
> > is no indication how this might affect my problem.
> >
> > Any insights from someone that has turned archiving on with 9.2 would
> > be
> > appreciated.
> >
> > Dennis Williams
> > DBA, 20% OCP
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> > 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:
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> > 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
RE: Where is Oracle 9.2 init.ora?
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, July 12, 2002 3:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Where is Oracle 9.2 init.ora?
>
> It should NOT however, be edited!
>
>
> --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > >> Oracle created the SPFILE which is not humanly readable.
> >
> > Mine is pretty easy to read! Maybe you need to check your character
> > set???
> > :-))
> >
> > RF
> >
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i (Sybex)
> >
> > Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> > Cousin Eddie: Those were my mother's dying words. But I
> > guess if your body's covered in third degree burns, and
> > your foot's caught in a bear trap, you tend to start talkin'
> > crazy.
> >
> >
> >
> > -Original Message-
> > Sent: Thursday, July 11, 2002 12:09 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Dennis,
> >
> > Oracle created the SPFILE which is not humanly readable. There
> > should
> > be an
> > alter database/system command that does the change for you.
> > According to
> > what I
> > heard at Oratechs 2000 editing the init.ora file is now longer
> > effective.
> >
> > Dick Goulet
> >
> > Reply Separator
> > Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > Date: 7/11/2002 7:43 AM
> >
> > For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> > expecting the
> > init.ora file?
> >
> > I created the database using dbca. It created an init.ora in
> > admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> > the
> > original init.ora file. Then I discovered that Oracle is not reading
> > the new
> > init.ora. The database starts fine, with no errors. I tried moving
> > the
> > init.ora file back to the original pfile location, but it is still
> > not
> > reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> > true, but I
> > have made other changes and they are not taking effect either.
> >
> > I have searched the documentation, and while there is the new SPFILE,
> > there
> > is no indication how this might affect my problem.
> >
> > Any insights from someone that has turned archiving on with 9.2 would
> > be
> > appreciated.
> >
> > Dennis Williams
> > DBA, 20% OCP
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> > 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:
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> > 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: Freeman, Robert
> > INET: [EMAI
RE: Where is Oracle 9.2 init.ora?
I suppose that depends on how you look at it. If you needed to for some
reason,
you could pull the header and footer records out and make it into just a
plain
init.ora But you are correct, of course that the SPFILE itself should
not
be edited if you wish it to remain a usable SPFILE.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Friday, July 12, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
It should NOT however, be edited!
--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> >> Oracle created the SPFILE which is not humanly readable.
>
> Mine is pretty easy to read! Maybe you need to check your character
> set???
> :-))
>
> RF
>
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i (Sybex)
>
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and
> your foot's caught in a bear trap, you tend to start talkin'
> crazy.
>
>
>
> -Original Message-
> Sent: Thursday, July 11, 2002 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dennis,
>
> Oracle created the SPFILE which is not humanly readable. There
> should
> be an
> alter database/system command that does the change for you.
> According to
> what I
> heard at Oratechs 2000 editing the init.ora file is now longer
> effective.
>
> Dick Goulet
>
> Reply Separator
> Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 7/11/2002 7:43 AM
>
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> the
> original init.ora file. Then I discovered that Oracle is not reading
> the new
> init.ora. The database starts fine, with no errors. I tried moving
> the
> init.ora file back to the original pfile location, but it is still
> not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
> there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would
> be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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: Freeman, Robert
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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 OR
RE: Where is Oracle 9.2 init.ora?
always someone to spoil the fun!
-Original Message-
Sent: Friday, July 12, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
It should NOT however, be edited!
--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> >> Oracle created the SPFILE which is not humanly readable.
>
> Mine is pretty easy to read! Maybe you need to check your character
> set???
> :-))
>
> RF
>
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i (Sybex)
>
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and
> your foot's caught in a bear trap, you tend to start talkin'
> crazy.
>
>
>
> -Original Message-
> Sent: Thursday, July 11, 2002 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dennis,
>
> Oracle created the SPFILE which is not humanly readable. There
> should
> be an
> alter database/system command that does the change for you.
> According to
> what I
> heard at Oratechs 2000 editing the init.ora file is now longer
> effective.
>
> Dick Goulet
>
> Reply Separator
> Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 7/11/2002 7:43 AM
>
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> the
> original init.ora file. Then I discovered that Oracle is not reading
> the new
> init.ora. The database starts fine, with no errors. I tried moving
> the
> init.ora file back to the original pfile location, but it is still
> not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
> there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would
> be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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: Freeman, Robert
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> >> Oracle created the SPFILE which is not humanly readable.
>
> Mine is pretty easy to read! Maybe you need to check your character
> set???
> :-))
>
> RF
>
> Robert G. Freeman - Oracle OCP
> Oracle Database Architect
> CSX Midtier Database Administration
> Author
> Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> Oracle9i New Features (Oracle Press)
> Mastering Oracle8i (Sybex)
>
> Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
> Cousin Eddie: Those were my mother's dying words. But I
> guess if your body's covered in third degree burns, and
> your foot's caught in a bear trap, you tend to start talkin'
> crazy.
>
>
>
> -Original Message-
> Sent: Thursday, July 11, 2002 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dennis,
>
> Oracle created the SPFILE which is not humanly readable. There
> should
> be an
> alter database/system command that does the change for you.
> According to
> what I
> heard at Oratechs 2000 editing the init.ora file is now longer
> effective.
>
> Dick Goulet
>
> Reply Separator
> Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 7/11/2002 7:43 AM
>
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> the
> original init.ora file. Then I discovered that Oracle is not reading
> the new
> init.ora. The database starts fine, with no errors. I tried moving
> the
> init.ora file back to the original pfile location, but it is still
> not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
> there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would
> be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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: Freeman, Robert
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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
RE: Where is Oracle 9.2 init.ora?
>> Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There should
be an
alter database/system command that does the change for you. According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
The creation of the spfile by the DBCA is optional, BTW, in 9iR1 and 9iR2.
There is a checkbox where you can disable the use of the SPFILE.
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Dennis,
the info you are looking for can be found in the IOUG "Select Nov
2001" magazine.
" Spfile is a new form of the INIT.ORA file, which is a binary file.
the default location is in $ORACLE_HOME/dbs/spfileSID.ora. The spfile
contains all of the initialization parameters that are currently set in
the online database. When setting a dynamic initialization parameter,
you have the option of setting it's scope, i.e. Memory memory only,
spfile only, or both.
The spfile can be recreated from the pfile and vice versa.
=== ALTER SYSTEM SET parameter
===COMMENT='This is the reason for setting it'
===SCOPE=[MEMORY,SPFILE,BOTH];
The default behavior is to use the SPFILE instead of the pfile.
===CREATE SPFILE[=''] FROM PFILE[='...']
===CREATE PFILE[='...'] FROM SPFILE[='']
additional information can be found in
V$SPFILE
V$SPPARAMETER
V$PARAMETER &
V$PARAMETER2"
From what I have read and understand you have to "activate" the
changes in the pfile by creating the spfile and then bouonce the DB to
activate it.
HTH
ROR mª¿ªm
>>> [EMAIL PROTECTED] 07/11/02 12:09PM >>>
GOTCHA!
The dbca also created an "SP" file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.
HTH & YMV!
DENNIS WILLIAMS wrote:
>
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
> original init.ora file. Then I discovered that Oracle is not reading
the new
> init.ora. The database starts fine, with no errors. I tried moving
the
> init.ora file back to the original pfile location, but it is still
not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would
be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
Lists
>
> 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).
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit
Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my
part!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail m
RE: Where is Oracle 9.2 init.ora?
Oracle will use the spfile by default, only if there is one. If there isn't and there is an init.ora, Oracle will use it. In many cases, you can even start Oracle without an init file at all (for example in a disaster recovery and you want to recover your spfile from an RMAN control file backup), if your system can handle the parameter default settings. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 11, 2002 12:40 PM To: Multiple recipients of list ORACLE-L On Thu, 11 Jul 2002 07:43:27 -0800, you wrote: >For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the >init.ora file? By default, Oracle reads init parms from the new SPFILE. You need to use new ALTER DATABASE (or is it ALTER SYSTEM?) syntax now in order to change parameter settings. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
I checked this on my 9.2 Oracle on win2k:
1- Database is up and running
2- There is no init.ora
3- show parameters indicate a parameter called spfile
4- checked v$parameter and found spfile is defined by default to
spfile.ora
5- renamed the file spfile.
6- shutdown the database.
7- try to restart the database.
8- It failed saying can not find init.ora
9- Copied spfile to init.ora
10- restart the database.
11- Failed. It complains about the file format (it's binary).
12- Let's rename spfile file back to its original name.
12- Now we have a wrong init.ora and correct spfile.
13- restart the database.
14- Database is up and no errors. It never complains about the format of
init.ora which indicates that it checks first for spfile
if it's there it restarts the database without reading init.ora. If
there is no spfile then Oracle tries to use init.ora.
15- I used to edit spfile in 9.01 on Solaris using vi and it worked.
Regards,
Waleed
-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
On Thu, 11 Jul 2002 07:43:27 -0800, you wrote: >For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the >init.ora file? By default, Oracle reads init parms from the new SPFILE. You need to use new ALTER DATABASE (or is it ALTER SYSTEM?) syntax now in order to change parameter settings. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Where is Oracle 9.2 init.ora?
Dennis,
the info you are looking for can be found in the IOUG "Select Nov
2001" magazine.
" Spfile is a new form of the INIT.ORA file, which is a binary file.
the default location is in $ORACLE_HOME/dbs/spfileSID.ora. The spfile
contains all of the initialization parameters that are currently set in
the online database. When setting a dynamic initialization parameter,
you have the option of setting it's scope, i.e. Memory memory only,
spfile only, or both.
The spfile can be recreated from the pfile and vice versa.
=== ALTER SYSTEM SET parameter
===COMMENT='This is the reason for setting it'
===SCOPE=[MEMORY,SPFILE,BOTH];
The default behavior is to use the SPFILE instead of the pfile.
===CREATE SPFILE[=''] FROM PFILE[='...']
===CREATE PFILE[='...'] FROM SPFILE[='']
additional information can be found in
V$SPFILE
V$SPPARAMETER
V$PARAMETER &
V$PARAMETER2"
From what I have read and understand you have to "activate" the
changes in the pfile by creating the spfile and then bouonce the DB to
activate it.
HTH
ROR mª¿ªm
>>> [EMAIL PROTECTED] 07/11/02 12:09PM >>>
GOTCHA!
The dbca also created an "SP" file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.
HTH & YMV!
DENNIS WILLIAMS wrote:
>
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
> original init.ora file. Then I discovered that Oracle is not reading
the new
> init.ora. The database starts fine, with no errors. I tried moving
the
> init.ora file back to the original pfile location, but it is still
not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would
be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
Lists
>
> 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).
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit
Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my
part!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
Not sure about default pfile location, so I'm specifying it explicitly on db
startup.
As for SPFILE, the default location on Unix is $ORACLE_HOME/dbs (while on NT
it is $ORACLE_HOME/database).
So, if you create SPFILE in this default directory, than you don't have to
specify it on startup.
To create SPFILE in default directory, use: "create spfile from pfile=.'
(notice, there is no spfile specification, so Oracle will create it in
default folder using default file name).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 11:43 AM
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
> original init.ora file. Then I discovered that Oracle is not reading the
new
> init.ora. The database starts fine, with no errors. I tried moving the
> init.ora file back to the original pfile location, but it is still not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but
I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> 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: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
Dennis-
With 9i you have the option of using init.ora or the spfile. DBs created with the
assistant I think use spfile by default. To make the change you want, issue the ALTER
SYSTEM blah blah SCOPE BOTH to make the change both immediate and permanent. SCOPE
MEMORY changes it immediately but only until reboot, SCOPE SPFILE changes the
initialization file but won't take effect until reboot.
Jim
-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Conboy, Jim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
Dennis, IIRC, the dbca creates an spfile in $ORACLE_HOME/dbs, and
startup reads that by default. If you make changes in init.ora, you'd
have to create a new spfile for them to be recognized. With 9.x, the
preferred way to change parameters is via ALTER SYSTEM...SCOPE...,
which makes the change directly to the spfile.
HTH,
Paul Baumgartel
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
> the
> original init.ora file. Then I discovered that Oracle is not reading
> the new
> init.ora. The database starts fine, with no errors. I tried moving
> the
> init.ora file back to the original pfile location, but it is still
> not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
> true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE,
> there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would
> be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> 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).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
Dennis,
Do you see a spfile? Are you starting the database via a tool like OEM? If
the spfile is out there, Oracle gives it preferance. Try recreating it from
the pfile and see if your change "takes" or just get rid of it and start
things on the server and see how that does.
HtH,
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Where is Oracle 9.2 init.ora?
GOTCHA!
The dbca also created an "SP" file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.
HTH & YMV!
DENNIS WILLIAMS wrote:
>
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
> original init.ora file. Then I discovered that Oracle is not reading the new
> init.ora. The database starts fine, with no errors. I tried moving the
> init.ora file back to the original pfile location, but it is still not
> reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
> have made other changes and they are not taking effect either.
>
> I have searched the documentation, and while there is the new SPFILE, there
> is no indication how this might affect my problem.
>
> Any insights from someone that has turned archiving on with 9.2 would be
> appreciated.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> 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).
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my part!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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).
