| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 9.2 changes in INIT
Thanks very much for the info. Oracle documentation sucks!
Ron
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, June 07, 2004 11:03 AM
To: oracle-l_at_freelists.org
Subject: Re: Oracle 9.2 changes in INIT
Welcome to the wonderful world of the SPFILE discussed here recently.
There is a nice explanation at http://www.dizwell.com but to answer your question
ALTER SYSTEM has acquired some new functionality. You can now issue
ALTER SYSTEM SET <parameter> = <value> SCOPE=<SCOPE>;
where parameter is the parameter for example OPEN_CURSORS, value is the new value you want for example 500 and scop takes one of MEMORY which means make the change just to the currently running instance , SPFILE which means make the change to the SPFILE making it persistent or BOTH which fairly obviously means do both of these.
It also takes COMMENT= and then a comment so that you can document your changes, but obviously this option is almost never used :( .
I don't like them much but they do have a bunch of advantages (principally as a mechanism for self tuning and for RAC) and get to be mandated for various new features. To back them up - which is wise as the error checking leaves something to be desired and can leave you with a non startable instance and a non editable init.ora if you do things stupidly (or you experiment with new things in a perverse manner) - then either backup the file using an os utility or use the new CREATE PFILE <FILENAME> FROM SPFILE <filename> syntax to create an old fashioned plain text init.ora
cheers
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
On Mon, 7 Jun 2004 10:53:15 -0500, Smith, Ron L. <rlsmith_at_kmg.com>
wrote:
>
>
> I am setting up my first new 9.2 database. When I looked at the
> init(sid).ora it looks like there is some binary code at the front and
> end of the file. How do you edit the file now?
>
> Thanks!
> Ron Smith
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org put
> 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Jun 07 2004 - 11:14:20 CDT
 |
 |