Home » RDBMS Server » Server Administration » Regardin LOG_BUFFER (oracle 9i)
icon7.gif  Regardin LOG_BUFFER [message #333831] Mon, 14 July 2008 09:26 Go to next message
swamitvk
Messages: 14
Registered: November 2007
Junior Member
Hi

when i was trying to change the value of LOG_BUFFER parameter, i got the following error
ORA-02095: specified initialization parameter cannot be modified.
I do not know the reason of this error. Can you please help regarding this?

regards
swaminathan .r





Re: Regardin LOG_BUFFER [message #333834 is a reply to message #333831] Mon, 14 July 2008 09:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post what you did (session, with complete error message).
Re: Regardin LOG_BUFFER [message #333839 is a reply to message #333831] Mon, 14 July 2008 09:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LOG_BUFFER is a static parameter you can't modify it dynamically, you can just modify its value in spfile or pfile and wait the next startup.

Regards
Michel
Re: Regardin LOG_BUFFER [message #333862 is a reply to message #333834] Mon, 14 July 2008 11:51 Go to previous messageGo to next message
swamitvk
Messages: 14
Registered: November 2007
Junior Member
Hi

what i did is

Alter system set log_buffer=value scope=spfile

Then, the system displayed the error which is given below

ORA-02095: specified initialization parameter cannot be
modified.

Regards

swaminathan .r

[Updated on: Mon, 14 July 2008 11:52]

Report message to a moderator

Re: Regardin LOG_BUFFER [message #333863 is a reply to message #333862] Mon, 14 July 2008 11:55 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
swamitvk wrote on Mon, 14 July 2008 09:51
Hi

what i did is

Alter system set log_buffer=value scope=spfile

Then, the system displayed the error which is given below

ORA-02095: specified initialization parameter cannot be
modified.

Regards

swaminathan .r


If you do not want to get the error, then don't issue the command that generates it.
Re: Regardin LOG_BUFFER [message #334104 is a reply to message #333863] Tue, 15 July 2008 07:52 Go to previous messageGo to next message
rgopani
Messages: 15
Registered: June 2005
Location: rupesh_gopani@yahoo.com
Junior Member

You may not be using spfile otherwise it should work
execute:
SQL> show parameter spfile to know whether spfile is in use or not.
Re: Regardin LOG_BUFFER [message #350473 is a reply to message #334104] Thu, 25 September 2008 03:17 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
Please tell me how to increase log_buffer in oracle.. help me out
Re: Regardin LOG_BUFFER [message #350475 is a reply to message #350473] Thu, 25 September 2008 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> alter system set log_buffer=2850816 scope=spfile;

System altered.

And restart.

Regards
Michel
Re: Regardin LOG_BUFFER [message #350480 is a reply to message #350475] Thu, 25 September 2008 03:32 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
can one tell me please how to specify NOLLOGING in imp utility??
Re: Regardin LOG_BUFFER [message #350523 is a reply to message #350480] Thu, 25 September 2008 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
And DON'T hijack other's topic for a question that is not related.

Regards
Michel
Re: Regardin LOG_BUFFER [message #350686 is a reply to message #350480] Thu, 25 September 2008 22:23 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

mdvreddy wrote on Thu, 25 September 2008 16:32
can one tell me please how to specify NOLLOGING in imp utility??

google "direct path insert" "nolloging"
imp utility can't do that.
------

[Updated on: Thu, 25 September 2008 22:24]

Report message to a moderator

Re: Regardin LOG_BUFFER [message #350726 is a reply to message #350686] Fri, 26 September 2008 00:59 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for confirming what I said.

Regards
Michel
Previous Topic: ora-04030
Next Topic: what is clod storage
Goto Forum:
  


Current Time: Fri Dec 02 12:09:50 CST 2016

Total time taken to generate the page: 0.11196 seconds