-
Title
Activation : "Error: Unable to activate config for 'UNNAMED_INSTANCE_4' thread '4" -
Description
Activation on RAC unable to activate config due to "UNNAMED_INSTANCE_X' thread 'x'.
sp_ctrl (<host>:<port>)> activate config <name>.config
Error: Unable to activate config for 'UNNAMED_INSTANCE_4' thread '4'.
sp_ctrl (<host>:<port>)>
Event_log:
Notice 2011-02-18 14:33:38.740243 12833 4121745792 User command: oracle activate config <name>.config (from <hostname>)
Info 2011-02-18 14:33:38.745918 16266 4124837568 Activation launched, pid = 16266 (activating sid <SOURCE SID NAME>)
Notice 2011-02-18 14:33:38.983254 16266 4124837568 Activation: Oracle compatible parameter='11.2.0.0.0'. (activating sid I<SOURCE SID NAME>) [module ocf]
Error 2011-02-18 14:33:39.604649 16266 4124837568 Activation: Failed to find hostname for instance: 'UNNAMED_INSTANCE_4' thread: '4'. ORA-01403: no data found. (activating sid <SOURCE SID NAME>) [module ocf]
Error 2011-02-18 14:33:39.605048 16266 4124837568 Activation: Instance: 'UNNAMED_INSTANCE_4' thread: '4' might be down. (activating sid<SOURCE SID NAME> [module ocf]
Error 2011-02-18 14:33:39.605642 16266 4124837568 Compile of "<name>.config" for sid o.<SOURCE SID NAME> failed: Error: Unable to activate config for 'UNNAMED_INSTANCE_4' thread '4'.
-
Cause
RAC system has not dropped or removed instances not being used. Activation fails when it tries to get information for a node that is not up.
-
Resolution
Resolution :
Drop or remove the instances with STATUS= CLOSED and ENABLED=PRIVATE
Retry the activation
Additional Information:
Queries to find the UNNAMED INSTANCE.
1. Select * from gv$thread;
2. Look for any instances with STATUS= CLOSED and ENABLED=PRIVATE.
Example output:
1 1 OPEN PUBLIC 2 Node1 18-FEB-11 2 78 15517841 23-FEB-11 9855419 09-FEB-11 0 78 61030 15585574 23-FEB-11
1 2 OPEN PUBLIC 2 Node2 18-FEB-11 4 62 15527392 23-FEB-11 9855419 09-FEB-11 0 62 40959 15585574 23-FEB-11
1 3 CLOSED PRIVATE 2 Node3 13-FEB-11 0 27 13147392 16-FEB-11 9855419 09-FEB-11 0 26 13228 13127288 16-FEB-11
1 4 CLOSED PUBLIC 2 UNNAMED_INSTANCE_4 0 0 9855419 09-FEB-11 9855419 09-FEB-11 0 0 0 0
2 1 OPEN PUBLIC 2 Node1 18-FEB-11 2 78 15517841 23-FEB-11 9855419 09-FEB-11 0 78 61030 15585574 23-FEB-11
2 2 OPEN PUBLIC 2 Node2 18-FEB-11 4 62 15527392 23-FEB-11 9855419 09-FEB-11 0 62 40959 15585574 23-FEB-11
2 3 CLOSED PRIVATE 2 Node3 13-FEB-11 0 27 13147392 16-FEB-11 9855419 09-FEB-11 0 26 13228 13127288 16-FEB-11
2 4 CLOSED PUBLIC 2 UNNAMED_INSTANCE_4 0 0 9855419 09-FEB-11 9855419 09-FEB-11 0 0 0 0