Then you are using a PFILE and not an SPFILE.
Do : select ' SPFILE in use :'||value from v$parameter
where name = 'spfile'
and value is not null
select ' PFILE in use '||value from v$parameter
where name = 'spfile'
and value is null
/
To confirm.
Edit $ORACLE_HOME/dbs/init<SID_name>.ora and place the parameter there.
It will be picked up once you do a bounce...
-----Original Message-----
From: sarojadevi
[mailto:oracledba-ezmlmshield-x54875840.[Email address protected]
Sent: 02 November 2006 15:10
To: LazyDBA Discussion
Subject: RE: ORA-02095: specified initialization parameter cannot be
modified
Hi david,
Thanks for your reply. when i tried this statement mentioning
scope=spfile, i get this error.
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
Thanks,
Saroja
"David Chiu " <oracledba-ezmlmshield-x10413030.[Email address protected]
11/02/2006 02:55 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: ORA-02095: specified initialization parameter cannot be modified
This parameter is not a dynamic parameter,
So you must bounce the instance for it to take effect.
As sys:
alter system set parallel_automatic_tuning = FALSE scope=spfile;
Create pfile from spfile;
Then bounce the instance
------------------------------------------------------------------------
----
David Chiu
-----Original Message-----
From: sarojadevi
[mailto:oracledba-ezmlmshield-x35336577.[Email address protected]
Sent: Thursday, November 02, 2006 9:45 AM
To: LazyDBA Discussion
Subject: ORA-02095: specified initialization parameter cannot be
modified
Hi gurus,
when i try to alter this parameter parallel_automatic_tuning = FALSE i
end up with this error. Is there any other way to change this parameter
without shutting down the db. Please help...
It's very urgent!!!
ORA-02095: specified initialization parameter cannot be modified
Thanks,
Saroja.
=====-----=====-----=====
Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
ForwardSourceID:NT0000FB76
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************************
****
IMPORTANT NOTICE
House of Fraser (Stores) Limited
Registered office: Granite House, 31 Stockwell Street, Glasgow G1 4RZ
Company Number: 10677
If you have received this e-mail in error, please notify the sender and
delete the e-mail and attachments immediately. This e-mail (including any
attachments) may contain confidential and/or privileged information. If you
are not the intended recipient, any reliance on, use, disclosure,
dissemination, distribution or copying of the e-mail or attachments is
strictly prohibited.
We have checked for viruses but the content of an attachment may still
contain software viruses, which could damage your computer system. We do not
accept liability for any damage you sustain as a result of a virus
introduced by this e-mail or attachment and you are advised to use
up-to-date virus checking software. E-mail transmission cannot be guaranteed
to be secure or error free.
This e-mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.
To view our latest in-store news click on: http://www.houseoffraser.co.uk
****************************************************************************
****
Oracle LazyDBA home page