-
Title
Error: "Unable to activate config for 'iwu1' thread '2'."during activation for RAC. -
Description
During activation, the following errors occur on RAC:
"sp_ctrl (iwsplgbu:2602)> activate config splex45_gbprod.cfg
Error: Unable to activate config for 'iwu1' thread '2'."
If you run these queries on node1 where Shareplex is activated you may get these results:
SQL> select host_name from gv$instance where thread# = 2;
no rows selected
SQL> select host_name,thread# from gv$instance;
HOST_NAME THREAD#
---------------------------------------------------------------- ----------
iwdbnyu1 1 -
Cause
Oracle init.ora parameter parallel_max_servers is set to 0 which cause gv$instance to show only the primary thread and not both threads.
-
Resolution
Shareplex queries gv$instance, gv$log, gv$logfile during activation on RAC. It needs to see all threads for RAC to show up in these query results. If Oracle parameter parallel_max_servers is set to 0, then gv$ views will only show the current thread not all threads.
1. Change the parameter PARALLEL_MAX_SERVERS to at least 1 on each instance (default is 5).
2. Make sure PARALLEL_AUTOMATIC_TUNING is set to same value on all the instances. This is according to Oracle bugs 2804070 / 4136570. This could be set to FALSE according to the bugs, but it needs to be the same on each instance.
3. Bounce the database.
4. Run these two queries on node1:
SQL> select host_name from gv$instance where thread# = 2;
You should see the thread2.
SQL> select host_name,thread# from gv$instance;
You should see both threads.
5. Activate config again.