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
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
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
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
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:
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
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
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
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';
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
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
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
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
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
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
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
16 matches
Mail list logo