My friend said that after Windows RAC is patched, a node instance cannot be started and other processes are normal.
ORA-00439: feature not enabled: Real Application Clusters
I searched on Metalink for the Linux platform. The solution to the window platform was not found. However, my friend solved the problem and re-installed the patch on the problematic node. OK.
The cause of this error is that RAC does not link to RDBMS home.
You can perform the following steps to check whether RAC is linked to the RDBMS home.
(1) Enter $ ORACLE_HOME/rdbms/lib
(2) execute the following command:
Nm-r libknlopt. A | grep-C kcsm. o
If the returned value is equal to 0, there is no link;
If the returned value is greater than 0, it is already linked.
This is one of my test environments:
[Oracle @ Rac1 ~] $ CD $ ORACLE_HOME/rdbms/lib
[Oracle @ Rac1 lib] $ nm-r libknlopt. A | grep-C kcsm. o
1
Solution:
1. Disable all instances on the corresponding RDBMS home. Generally, it is one.
2. Enter $ ORACLE_HOME/rdbms/lib
3. users using Oracle relink:
Make-F ins_rdbms.mk rac_on ioracle
You can perform the following two steps:
Make-F ins_rdbms.mk rac_on
Make-F ins_rdbms.mk ioracle
4. Restart the instance
Note: The value of cluster_database, which is false may also cause this error.
SQL> alter system set cluster_database = true scope = spfile SID = '*';
System altered.
Bytes ---------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Online Resources: http://tianlesoftware.download.csdn.net
Video: http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)
Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823
Chat group: 40132017 chat 2 group: 69087192
-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.