ORA-00439 feature not enabled-Real Application Clusters solution error reported when the instance is started after the RAC Install patch

Source: Internet
Author: User

 

 

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.