Home » RDBMS Server » Server Administration » log_parallelism parameter is not setting (Oracle 10g 10.2.0.3.0, Linux 64 bit)
log_parallelism parameter is not setting [message #350159] Wed, 24 September 2008 04:44 Go to next message
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

Re: log_parallelism parameter is not setting [message #350161 is a reply to message #350159] Wed, 24 September 2008 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: log_parallelism parameter is not setting [message #350181 is a reply to message #350161] Wed, 24 September 2008 05:23 Go to previous messageGo to next message
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.
Re: log_parallelism parameter is not setting [message #350190 is a reply to message #350181] Wed, 24 September 2008 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: log_parallelism parameter is not setting [message #350239 is a reply to message #350190] Wed, 24 September 2008 08:26 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

Quote:

LOG_PARALLELISM initialization parameter has been made obsolete



Re: log_parallelism parameter is not setting [message #350257 is a reply to message #350239] Wed, 24 September 2008 09:10 Go to previous message
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:
  


Current Time: Sun Dec 04 12:36:01 CST 2016

Total time taken to generate the page: 0.06130 seconds