Oracle OTM/GTM 6.3.6 application don't support RAC database environment without SCAN listener although we had the Load balancer. Finally, I ended up converting the two node RAC environment to Non-RAC.
Note: My client did not have SCAN listener in the RAC environment due to certain reasons.
Steps to disable the RAC setup in two node RAC configuration
SQL> select name from v$DATABASE;
NAME
---------
gtmotm
SQL> alter system set cluster_database=false scope=spfile;
System altered.
SQL> alter system set cluster_database_instances=1 scope=spfile;
System altered.
SQL> alter database disable thread 2;
Database altered.
SQL> select thread#, group# from v$log;
THREAD# GROUP#
---------- ----------
1 1
1 2
2 3
2 4
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database drop logfile group 4;
Database altered.
SQL> select TABLESPACE_NAME from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
UNDOTBS2
DATA
ARCHIVE
REPORT
REPORTINDX
INDX
TABLESPACE_NAME
------------------------------
BPL_DAY1
BPL_DAY2
BPL_DAY3
BPL_DAY4
BPL_DAY5
BPL_DAY6
BPL_DAY7
PART_1
PART_2
PART_3
PART_4
TABLESPACE_NAME
------------------------------
PART_5
MSG_PART_TBS1
LOB1
LOB2
LOB3
LOB4
LOB5
LOB6
LOB7
MSG_LOB_TBS1
32 rows selected.
SQL> drop tablespace UNDOTBS2 including contents and datafiles;
Tablespace dropped.
SQL> create pfile from spfile;
File created.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
2. Comment the parameters related to second node in the pfile.
3. Change the SID in tnsnames .ora and listener.ora
4.Relink the Oracle binaries
[oracle@test01 lib]$ export ORACLE_SID=gtmotm
[oracle@test01 lib]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.1.0.2/gtmotm
[oracle@test01 lib]$ echo $ORACLE_SID
gtmotm
[oracle@test01 lib]$ cd $ORACLE_HOME/rdbms/lib
[oracle@test01 lib]$ make -f ins_rdbms.mk rac_off
rm -f /u01/app/oracle/product/12.1.0.2/gtmotm/lib/libskgxp12.so
cp /u01/app/oracle/product/12.1.0.2/gtmotm/lib//libskgxpg.so /u01/app/oracle/product/12.1.0.2/gtmotm/lib/libskgxp12.so
rm -f /u01/app/oracle/product/12.1.0.2/gtmotm/lib/libskgxn2.so
cp /u01/app/oracle/product/12.1.0.2/gtmotm/lib//libskgxns.so \
/u01/app/oracle/product/12.1.0.2/gtmotm/lib/libskgxn2.so
/usr/bin/ar d /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/libknlopt.a kcsm.o
/usr/bin/ar cr /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/libknlopt.a /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/ksnkcs.o
[oracle@test01 lib]$ make -f ins_rdbms.mk ioracle
chmod 755 /u01/app/oracle/product/12.1.0.2/gtmotm/bin
- Linking Oracle
rm -f /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/oracle
/u01/app/oracle/product/12.1.0.2/gtmotm/bin/orald -o /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/ -L/u01/app/oracle/product/12.1.0.2/gtmotm/lib/ -L/u01/app/oracle/product/12.1.0.2/gtmotm/lib/stubs/ -Wl,-E /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/opimai.o /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/ssoraed.o /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /u01/app/oracle/product/12.1.0.2/gtmotm/lib/nautab.o /u01/app/oracle/product/12.1.0.2/gtmotm/lib/naeet.o /u01/app/oracle/product/12.1.0.2/gtmotm/lib/naect.o /u01/app/oracle/product/12.1.0.2/gtmotm/lib/naedhs.o /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/config.o -lserver12 -lodm12 -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12 -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12 -lrt -lplp12 -lserver12 -lclient12 -lvsn12 -lcommon12 -lgeneric12 `if [ -f /u01/app/oracle/product/12.1.0.2/gtmotm/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /u01/app/oracle/product/12.1.0.2/gtmotm/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12 -lrt -lplp12 -ljavavm12 -lserver12 -lwwg `cat /u01/app/oracle/product/12.1.0.2/gtmotm/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/product/12.1.0.2/gtmotm/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat /u01/app/oracle/product/12.1.0.2/gtmotm/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /u01/app/oracle/product/12.1.0.2/gtmotm/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnzst12 -lzt12 -lztkg12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if /usr/bin/ar tv /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12 -lserver12"; fi` -L/u01/app/oracle/product/12.1.0.2/gtmotm/ctx/lib/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -loraz -llzopro -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged -lippsmerged -lippcore -lippcpemerged -lippcpmerged -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12 -laio -lons `cat /u01/app/oracle/product/12.1.0.2/gtmotm/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/12.1.0.2/gtmotm/lib -lm `cat /u01/app/oracle/product/12.1.0.2/gtmotm/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/12.1.0.2/gtmotm/lib
test ! -f /u01/app/oracle/product/12.1.0.2/gtmotm/bin/oracle ||\
mv -f /u01/app/oracle/product/12.1.0.2/gtmotm/bin/oracle /u01/app/oracle/product/12.1.0.2/gtmotm/bin/oracleO
mv /u01/app/oracle/product/12.1.0.2/gtmotm/rdbms/lib/oracle /u01/app/oracle/product/12.1.0.2/gtmotm/bin/oracle
chmod 6751 /u01/app/oracle/product/12.1.0.2/gtmotm/bin/oracle
SQL> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 3731384 bytes
Variable Size 3221225544 bytes
Database Buffers 5335154688 bytes
Redo Buffers 29822976 bytes
Database mounted.
Database opened.
SQL> select instance_name from V$INSTANCE;
INSTANCE_NAME
----------------
gtmotm
SQL> select name from V$DATABASE;
NAME
---------
gtmotm
Happy Learning!
No comments:
Post a Comment