Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error occured processing parameter

user454189Apr 22 2008 — edited Apr 22 2008

Hi,

I need to set new value for log_buffer. so what I did was i issued the following command at sql command prompt

alter system set log_buffer=50M scope=spfile;

it throws
ORA-012095: specified initialization paramer cannot be modified

so i brought the DB down and I made an entry(log_buffer=50m) in the initfile
and saved. Then, when I try to create spfile from pfile;
it throws error

ORA-91978:failure in processing system parameters
ORA-32003:error occured processing parameter 'log_buffer'

Due to this I couldn't resize the log buffer.

can anyone help me in how to set log_buffer

Please help in this..... I will e grateful to you

OS:AIX
oracle:10.2.0.2.0

Thanks in advance

With Regards
Boo

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2008

Added on Apr 22 2008

#general-database-discussions

12 comments

1,594 views