Skip to content
February 11, 2013 / doganay

ora-600 [kspgip1] when setting parallel_servers_target without PARALLEL_MAX_SERVERS too.


Problem:

$ sqlplus / as sysdba
SQL> alter system set parallel_servers_target=16 scope=spfile;
SQL> shutdown immediate
SQL> startup

ora-600 [kspgip1] when setting parallel_servers_target without PARALLEL_MAX_SERVERS too.

ORA-1078: failure in processing system parameters
ORA-600: internal error code, arguments: [kspgip1], [101], [1773],
[1], [parallel_max_servers], [], [], [], [], [], [], []

Bug 13817347 ORA-1078/OERI:kspgip1 with parallel_servers_target [ID 13817347.8]

* This issue is usually seen in hpux itanium

Solution:

This issue is fixed in
12.1 (Future Release)
11.2.0.4 (Future Patch Set)

Workaround (does not exist in metalink note):

alter system set parallel_force_local=TRUE scope=spfile sid='*';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: