OraFAQ Forum: Server Administration » log_parallelism parameter is not setting

Home » RDBMS Server » Server Administration » log_parallelism parameter is not setting (Oracle 10g 10.2.0.3.0, Linux 64 bit)

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

log_parallelism parameter is not setting [message #350159]

Wed, 24 September 2008 04:44

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

when i am trying to set following parameter, oracle 10g is giving me error.

As i am trying to setup Standby database and in Production database, it is required to set this parameter

SQL> ALTER SYSTEM SET LOG_PARALLELISM=1 SCOPE=BOTH;
ALTER SYSTEM SET LOG_PARALLELISM=1 SCOPE=BOTH
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

SQL> ALTER SYSTEM SET LOG_PARALLELISM=1;
ALTER SYSTEM SET LOG_PARALLELISM=1
*
ERROR at line 1:
ORA-25138: LOG_PARALLELISM initialization parameter has been made obsolete

Report message to a moderator

Re: log_parallelism parameter is not setting [message #350161 is a reply to message #350159]

Wed, 24 September 2008 04:47

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This parameter does not exist in 10g.

Why do you want to change it?

Regards
Michel

Report message to a moderator

Re: log_parallelism parameter is not setting [message #350181 is a reply to message #350161]

Wed, 24 September 2008 05:23

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

I was setting up Logical standby database, in document it is written that this parameter needs to be set in Production database.

Report message to a moderator

Re: log_parallelism parameter is not setting [message #350190 is a reply to message #350181]

Wed, 24 September 2008 05:48

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

in document

Which one?
I recommend to use a document that is for your release.

Regards
Michel

Report message to a moderator

Re: log_parallelism parameter is not setting [message #350239 is a reply to message #350190]

Wed, 24 September 2008 08:26

ora110
Messages: 42
Registered: September 2007
Location: China

Member

Quote:

LOG_PARALLELISM initialization parameter has been made obsolete

Report message to a moderator

Re: log_parallelism parameter is not setting [message #350257 is a reply to message #350239]

Wed, 24 September 2008 09:10

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

This is better one Smile

with ORA-ERROR number.

ERROR at line 1:
ORA-25138: LOG_PARALLELISM initialization parameter has been made obsolete

[Updated on: Wed, 24 September 2008 09:10]

Report message to a moderator

Previous Topic:	One stop server status/health survey script.
Next Topic:	Oracle 9i/10g installation Window Vista Home Premium SP 1 ???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 00:50:31 CDT 2024