OraFAQ Forum: Server Administration » Regardin LOG

Home » RDBMS Server » Server Administration » Regardin LOG_BUFFER (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regardin LOG_BUFFER [message #333831]

Mon, 14 July 2008 09:26

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

Report message to a moderator

Re: Regardin LOG_BUFFER [message #333834 is a reply to message #333831]

Mon, 14 July 2008 09:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please post what you did (session, with complete error message).

Report message to a moderator

Re: Regardin LOG_BUFFER [message #333839 is a reply to message #333831]

Mon, 14 July 2008 09:38

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Regardin LOG_BUFFER [message #333862 is a reply to message #333834]

Mon, 14 July 2008 11:51

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

swamitvk wrote on Mon, 14 July 2008 09:51

If you do not want to get the error, then don't issue the command that generates it.

Report message to a moderator

Re: Regardin LOG_BUFFER [message #334104 is a reply to message #333863]

Tue, 15 July 2008 07:52

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.

Report message to a moderator

Re: Regardin LOG_BUFFER [message #350473 is a reply to message #334104]

Thu, 25 September 2008 03:17

mdvreddy
Messages: 17
Registered: November 2007
Location: x

Junior Member

Please tell me how to increase log_buffer in oracle.. help me out

Report message to a moderator

Re: Regardin LOG_BUFFER [message #350475 is a reply to message #350473]

Thu, 25 September 2008 03:22

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> alter system set log_buffer=2850816 scope=spfile;

System altered.

And restart.

Regards
Michel

Report message to a moderator

Re: Regardin LOG_BUFFER [message #350480 is a reply to message #350475]

Thu, 25 September 2008 03:32

mdvreddy
Messages: 17
Registered: November 2007
Location: x

Junior Member

can one tell me please how to specify NOLLOGING in imp utility??

Report message to a moderator

Re: Regardin LOG_BUFFER [message #350523 is a reply to message #350480]

Thu, 25 September 2008 05:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't.
And DON'T hijack other's topic for a question that is not related.

Regards
Michel

Report message to a moderator

Re: Regardin LOG_BUFFER [message #350686 is a reply to message #350480]

Thu, 25 September 2008 22:23

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for confirming what I said.

Regards
Michel

Report message to a moderator

Previous Topic:	ora-04030
Next Topic:	what is clod storage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 22:08:39 CST 2025