Re: Changing dump destinations in init.ora

2002-02-25 Thread Joe Testa
i didnt think the info was stored in the database. I thought it was stored as a binary file in the $ORACLE_HOME/dbs directory. i thought the oracle startup code looked for a spfile first in the dbs directory. if its literally stored in the database, how is oracle able to read it during

Re: Changing dump destinations in init.ora

2002-02-25 Thread Christian Trassens
As you said it is a binary file. Therefore it is not saved in the database, it is outside in $OH/dbs. Regarding what our colleague said, he mentioned a solution to get the parameters of the spfile to a plain file. But this can de done after at least one startup. Regards. --- Joe Testa [EMAIL

RE: RE: Changing dump destinations in init.ora

2002-02-25 Thread Deshpande, Kirti
SPfile is not stored in the database. It is kept in the $ORACLE_HOME/dbs directory. Although it is considered to be a binary file, in reality it is just a text file. It has a hashed value stored at the beginning of the file. - Kirti -Original Message- Sent: Sunday, February 24, 2002

Re: RE: Changing dump destinations in init.ora

2002-02-25 Thread Helen J Mitchell
Rich, Hi there. This is Helen Mitchell. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 24, 2002 7:58 PM Yes, the SPFILE is stored in binary format in the database, but you can sort of work around it. To create a text file

RE: RE: Changing dump destinations in init.ora

2002-02-25 Thread Grabowy, Chris
Helen, Hi there. This is Chris Grabowy. -Original Message- Sent: Monday, February 25, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Rich, Hi there. This is Helen Mitchell. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: RE: Changing dump destinations in init.ora

2002-02-25 Thread Mercadante, Thomas F
Is this step 7 ? -Original Message- Sent: Monday, February 25, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Rich, Hi there. This is Helen Mitchell. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 24, 2002

RE: RE: Changing dump destinations in init.ora

2002-02-25 Thread Mike Killough
Chris, Hi there. This is Mike Killough. (this is such a friendly list!) From: Grabowy, Chris [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Changing dump destinations in init.ora Date: Mon, 25 Feb 2002 07:25:01 -0800

Re: Changing dump destinations in init.ora

2002-02-25 Thread Rachel Carmichael
oracle creates spfile.ora in binary and reads that if it exists NOT stored in the database... --- Joe Testa [EMAIL PROTECTED] wrote: i didnt think the info was stored in the database. I thought it was stored as a binary file in the $ORACLE_HOME/dbs directory. i thought the oracle

RE: RE: Changing dump destinations in init.ora

2002-02-24 Thread Rich Holland
Yes, the SPFILE is stored in binary format in the database, but you can sort of work around it. To create a text file from the SPFILE, you can issue: CREATE PFILE 'pfilename' FROM SPFILE 'filename'; And vice versa with: CREATE SPFILE = 'filename' FROM PFILE = 'pfilename';

Re: Changing dump destinations in init.ora

2002-02-17 Thread hemantchitale
No, you do not have to. Dump_File_Dest information is not stored in the control-file -- it is read afresh at every instance startup. You can change the destinations in the initSID.ora and restart the instance for the new destinations to take effect. Hemant K Chitale Principal DBA Chartered

RE: Changing dump destinations in init.ora

2002-02-13 Thread Magaliff, Bill
no, just restart the db -Original Message- Sent: Wed, February 13, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Do I have to rebuild the controlfiles if I change any of the dump destinations in my oracle init.ora files. Thanks Darren

RE: Changing dump destinations in init.ora

2002-02-13 Thread Mercadante, Thomas F
Nope. Create the new directory, change them in the file and bounce the instance. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 13, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Do I have to rebuild the controlfiles if I change any

RE: Changing dump destinations in init.ora

2002-02-13 Thread K Gopalakrishnan
No need to bounce the instance. You can dynamically chance the location using ALTER SYSTEM command. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Thomas F Sent: Wednesday, February 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Nope. Create the new

RE: RE: Changing dump destinations in init.ora

2002-02-13 Thread Jacques Kilchoer
Title: RE: RE: Changing dump destinations in init.ora Though you can always delete the SF file and go back to the init.ora. The SF file will be used if it's there, but if it's missing Oracle will look for an init.ora file for the database. -Original Message- From: [EMAIL PROTECTED

RE: Changing dump destinations in init.ora

2002-02-13 Thread Rajesh Dayal
That's true only for Oracle 8i onwards. For Oracle 8.0.x still you would need to bounce the DB. Here is an output from Oracle 8.0.5 NUM NAME -- TYPE -- VALUE

RE: Changing dump destinations in init.ora

2002-02-13 Thread DBarbour
PROTECTED]02/13/2002 01:14 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: RE: Changing dump destinations in init.ora No need to bounce the instance. You can dynamically chance the locationusing ALTER SYSTEM command.Best Regards,K