Unified auditing özelliği nasıl kapatılır ?
Oracle veritabanı 12c (12.1) ile gelen yeni audit mekanızmasının kapatılması için relink işlemi gerekmektedir. Bu işlemi aşağıdaki şekilde yapabilirsiniz.
Öncelikle ilgili Oracle Home dizininden çalışan tüm veritabanı varsa listener servislerinin kapatılması gerekmektedir.
Sonrasında aşağıdaki şekilde kapatabilirsiniz.
[oracle@orcldb01 ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@orcldb01 lib]$ pwd
/u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib
[oracle@orcldb01 lib]$ make -f ins_rdbms.mk uniaud_off ioracle
/usr/bin/ar d /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/libknlopt.a kzaiang.o
/usr/bin/ar cr /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/kzanang.o
chmod 755 /u01/app/oracle/product/12.2.0.1/dbhome_1/bin
- Linking Oracle
rm -f /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/oracle
/u01/app/oracle/product/12.2.0.1/dbhome_1/bin/orald -o /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/ -L/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/ -L/u01/app/oracle/product/12.2.0.1/dbhome_1/lib/stubs/ -Wl,-E /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/opimai.o /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/ssoraed.o /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/nautab.o /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/naeet.o /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/naect.o /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/naedhs.o /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/config.o -ldmext -lserver12 -lodm12 -lofs -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.2.0.1/dbhome_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap12" ; fi` -lskjcx12 -lslax12 -lpls12 -lrt -lplp12 -ldmext -lserver12 -lclient12 -lvsn12 -lcommon12 -lgeneric12 `if [ -f /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12 -lrt -lplp12 -ljavavm12 -lserver12 -lwwg `cat /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -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.2.0.1/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -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.2.0.1/dbhome_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12 -lserver12"; fi` -L/u01/app/oracle/product/12.2.0.1/dbhome_1/ctx/lib/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -lgeneric12 -lorazip -loraz -llzopro5 -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 -lfthread12 `cat /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/12.2.0.1/dbhome_1/lib -lm `cat /u01/app/oracle/product/12.2.0.1/dbhome_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/12.2.0.1/dbhome_1/lib `test -x /usr/bin/hugeedit -a -r /usr/lib64/libhugetlbfs.so && test -r /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/shugetlbfs.o && echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`
test ! -f /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracle || (\
mv -f /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracle /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracleO &&\
chmod 600 /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracleO )
mv /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/lib/oracle /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracle
chmod 6751 /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/oracleSonrasında , ilgili Oracle Home’dan çalışan tüm servisleri başlatabilirsiniz.
Kapatıldığını aşağıdaki sordu ile görebilirsiniz.
SQL> SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';
VALUE
----------------------------------------------------------------
FALSE
