Oracle Kernel RAC: ON and OFF
Oracle Kernel needs to switch with ORACLE RAC ON / OFF when you
convert from Standalone to RAC or vice versa.
In some cases, you may want to enable or disable the RAC options for testing purposes –
In some cases, you may want to enable or disable the RAC options for testing purposes –
Disabling
and enabling RAC options are available only for UNIX/LINUX platforms.
I
haven’t checked on Windows RAC Instances.
Use the following steps to disable RAC (known as RAC OFF):
1. Log in as the Oracle software owner in
my case (oracle) (which is typically the UNIX account oracle) in all nodes.
2. Shutdown normally all the instances on
each and every node.
3. Go to $ORACLE_HOME/rdbms/lib:
$ cd $ORACLE_HOME/rdbms/lib
$ cd $ORACLE_HOME/rdbms/lib
4. Execute below make command to relink
the Oracle binaries without the RAC option:
make
-f ins_rdbms.mk rac_off
rebuild oracle
rebuild oracle
This normally runs for few minutes and
should not pose any errors.
(if any error fixed it or immediate contact with oracle support)
(if any error fixed it or immediate contact with oracle support)
5. Now relink the Oracle binaries:
cd $ORACLE_HOME/bin
#make -f ins_rdbms.mk oracle
cd $ORACLE_HOME/bin
#make -f ins_rdbms.mk oracle
relink
oracle
6. Now the Oracle binaries are relinked
with the RAC OFF option.
You may have to edit the parameter file init.ora or SPFILE parameters accordingly (Cluster_Database, Undo, Threads) etc.
You may have to edit the parameter file init.ora or SPFILE parameters accordingly (Cluster_Database, Undo, Threads) etc.
Use the following steps to enable RAC (known as RAC ON):
1. Log in as the Oracle software owner in
my case (oracle) (which is typically the UNIX account oracle) in all nodes.
2. Shutdown normally all the instances on
each and every node.
3. Go to
$ORACLE_HOME/rdbms/lib:
$ cd $ORACLE_HOME/rdbms/lib
$ cd $ORACLE_HOME/rdbms/lib
4. Execute the following make command to
relink the Oracle binaries without the RAC option:
make -f ins_rdbms.mk rac_on
make -f ins_rdbms.mk rac_on
rebuild oracle
This normally runs for a few minutes and should not pose any errors.
(Get in touch with Oracle Support in case of any error)
This normally runs for a few minutes and should not pose any errors.
(Get in touch with Oracle Support in case of any error)
5. Now relink the Oracle binaries:
cd $ORACLE_HOME/bin
#make -f ins_rdbms.mk oracle
relink oracle
relink oracle
Now the Oracle binaries are relinked with the RAC ON option. You may need to edit the parameter file init.ora or SPFILE parameters accordingly like (Cluster_Database,Undo,Threads…etc).
Manual make commands
While the Oracle relink command will automatically run the make commands, you still may run them menually:
For
executables: oracle, exp, imp, sqlldr, tkprof, mig, dbv, orapwd, rman, svrmgrl,
ogms and ogmsctl
cd
$ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install
For sqlplus
make -f ins_rdbms.mk install
For sqlplus
cd
$ORACLE_HOME/sqlplus/lib
make -f ins_sqlplus.mk install
For executables: dbsnmp, oemevent, oratclsh
make -f ins_sqlplus.mk install
For executables: dbsnmp, oemevent, oratclsh
cd
$ORACLE_HOME/network/lib
make -f ins_oemagent.mk install
For executables: names, namesctl
make -f ins_oemagent.mk install
For executables: names, namesctl
cd
$ORACLE_HOME/network/lib
make -f ins_names.mk install
For executables: osslogin, trcasst, trcroute, onrsd, tnsping
make -f ins_names.mk install
For executables: osslogin, trcasst, trcroute, onrsd, tnsping
cd
$ORACLE_HOME/network/lib
make -f ins_net_client.mk install
For executables: tnslsnr, lsnrctl
make -f ins_net_client.mk install
For executables: tnslsnr, lsnrctl
cd
$ORACLE_HOME/network/lib
make -f ins_net_server.mk install
make -f ins_net_server.mk install
For more details on using the relink command, see MOSC Note: 131321.1 titled "Using Oracle relink on UNIX".
business analyst training
ReplyDeleteoracle adf training
oracle rac training
msbi training
osb online course
azure devops online course
scala online course
sccm online course
spark online course
windows admin online course