Tuesday, January 12, 2016

ORA-27303 and ORA-27302 on instance startup (RAC to Single Clone)

If you need to clone a RAC database to a single node and if you copy an Oracle Home from one of the RAC nodes to the target single node for building an Oracle home in the target, then you may encounter the following error.

SQL> startup nomount;
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:bind_fail failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpvifconf
ORA-27303: additional information: requested interface 192.168.7.246 failed bind. Check output from ifconfig command

Strange error right? We are on a single node, but still Oracle tries to bind to the interfaces like we are on a Oracle Cluster?
This error is actually an expected one. As we copy the Oracle Home Software from a RAC environment, the executables are linked with the RAC option.
In order to solve this, we relink the rdbms executable. Note that it is also good to check the environment, remove the unnecessary RAC related environments and relink the ioracle as well.

So the action plan is;

unset ORA_CRS_HOME and remove it from .bash_profile if it is there
unset cluster_interconnects db parameter

Relink;
  • cd $ORACLE_HOME/rdbms/lib
  • make -f ins_rdbms.mk rac_off
  • make ins_rdbms.mk ioracle

No comments :

Post a Comment