Oracle 12c 开启审计埋下的坑ORA-00205 ORA-15040

拼搏现实的明天。 2022-11-20 11:59 93阅读 0赞

`1、默认关闭统一审计`

`可以使用下面sql查询`

`SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';`

`2.如果是RAC 的话，每个节点都要去执行`

`首先停掉各节点数据库`

`然后执行进入`

cd $ORACLE\_HOME/rdbms/lib

执行：`make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME`

`以上的步骤都是网上百度下来的接下来就是实际情况的遇到的坑`

`执行完上述操作之后，启动数据库`

[oracle@wxrac01 dbhome_1]$cd $ORACLE_HOME/rdbms/lib
    [oracle@wxrac01 lib]$ll ins_rdbms.mk 
    -rw-r--r-- 1 oracle oinstall 50005 Jan 26  2017 ins_rdbms.mk
    [oracle@wxrac01 lib]$make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
    /usr/bin/ar d /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/libknlopt.a kzanang.o
    /usr/bin/ar cr /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/libknlopt.a /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/kzaiang.o 
    chmod 755 /data/oracle/app/product/12.2.0/dbhome_1/bin
    
     - Linking Oracle 
    rm -f /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/oracle
    /data/oracle/app/product/12.2.0/dbhome_1/bin/orald  -o /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L/data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/ -L/data/oracle/app/product/12.2.0/dbhome_1/lib/ -L/data/oracle/app/product/12.2.0/dbhome_1/lib/stubs/   -Wl,-E /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/opimai.o /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/ssoraed.o /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive /data/oracle/app/product/12.2.0/dbhome_1/lib/nautab.o /data/oracle/app/product/12.2.0/dbhome_1/lib/naeet.o /data/oracle/app/product/12.2.0/dbhome_1/lib/naect.o /data/oracle/app/product/12.2.0/dbhome_1/lib/naedhs.o /data/oracle/app/product/12.2.0/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 /data/oracle/app/product/12.2.0/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 /data/oracle/app/product/12.2.0/dbhome_1/lib/libavserver12.a ] ; then echo "-lavserver12" ; else echo "-lavstub12"; fi` `if [ -f /data/oracle/app/product/12.2.0/dbhome_1/lib/libavclient12.a ] ; then echo "-lavclient12" ; fi` -lknlopt -lslax12 -lpls12  -lrt -lplp12 -ljavavm12 -lserver12  -lwwg  `cat /data/oracle/app/product/12.2.0/dbhome_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /data/oracle/app/product/12.2.0/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 /data/oracle/app/product/12.2.0/dbhome_1/lib/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat /data/oracle/app/product/12.2.0/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 /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo12 -lserver12"; fi` -L/data/oracle/app/product/12.2.0/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 /data/oracle/app/product/12.2.0/dbhome_1/lib/sysliblist` -Wl,-rpath,/data/oracle/app/product/12.2.0/dbhome_1/lib -lm    `cat /data/oracle/app/product/12.2.0/dbhome_1/lib/sysliblist` -ldl -lm   -L/data/oracle/app/product/12.2.0/dbhome_1/lib `test -x /usr/bin/hugeedit -a -r /usr/lib64/libhugetlbfs.so && test -r /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/shugetlbfs.o && echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`
    test ! -f /data/oracle/app/product/12.2.0/dbhome_1/bin/oracle || (\
       mv -f /data/oracle/app/product/12.2.0/dbhome_1/bin/oracle /data/oracle/app/product/12.2.0/dbhome_1/bin/oracleO &&\
       chmod 600 /data/oracle/app/product/12.2.0/dbhome_1/bin/oracleO )
    mv /data/oracle/app/product/12.2.0/dbhome_1/rdbms/lib/oracle /data/oracle/app/product/12.2.0/dbhome_1/bin/oracle
    chmod 6751 /data/oracle/app/product/12.2.0/dbhome_1/bin/oracle
    [oracle@wxrac01 lib]$sqlplus / as sysdba
    
    SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 28 20:39:37 2020
    
    Copyright (c) 1982, 2016, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup
    ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
    ORACLE instance started.
    
    Total System Global Area 2.6844E+10 bytes
    Fixed Size                 26330584 bytes
    Variable Size            8053066280 bytes
    Database Buffers         1.8455E+10 bytes
    Redo Buffers              309211136 bytes
    ORA-00205: error in identifying control file, check alert log for more info

查看log日志如下：

NOTE: ASMB mounting group 1 (DATA)
    NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
    WARNING: group 1 (DATA) has missing disks
    ORA-15040: diskgroup is incomplete
    WARNING: group 1 is being dismounted.
    WARNING: ASMB force dismounting group 1 (DATA) due to missing disks
    SUCCESS: diskgroup DATA was dismounted
    2020-10-28T20:06:20.084566+08:00
    ORA-01565: Unable to open Spfile +DATA/weixin/spfileweixin.ora.
    2020-10-28T20:06:20.111252+08:00
    NOTE: ASMB mounting group 1 (DATA)
    NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
    WARNING: group 1 (DATA) has missing disks
    ORA-15040: diskgroup is incomplete
    WARNING: group 1 is being dismounted.
    WARNING: ASMB force dismounting group 1 (DATA) due to missing disks
    SUCCESS: diskgroup DATA was dismounted
    2020-10-28T20:06:20.143265+08:00
    ORA-01565: Unable to open Spfile +DATA/weixin/spfileweixin.ora.
    2020-10-28T20:06:20.759544+08:00
    NOTE: ASMB mounting group 1 (DATA)
    NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
    WARNING: group 1 (DATA) has missing disks
    ORA-15040: diskgroup is incomplete
    WARNING: group 1 is being dismounted.
    WARNING: ASMB force dismounting group 1 (DATA) due to missing disks
    SUCCESS: diskgroup DATA was dismounted
    2020-10-28T20:06:20.799395+08:00
    ORA-01565: Unable to open Spfile +DATA/weixin/spfileweixin.ora.

悲惨发生了！！！！！！

至于怎么解决，mos

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoaXl1MTE1Nzc1ODY1NQ_size_16_color_FFFFFF_t_70][]

原来是oracle 文件权限改变了，于是马上修改过来

[root@wxrac01 bin]#ll oracle
    -rwsr-s--x 1 oracle oinstall 407948928 Oct 28 20:39 oracle
    [root@wxrac01 bin]#chgrp asmadmin oracle
    [root@wxrac01 bin]#ll oracle
    -rwxr-x--x 1 oracle asmadmin 407948928 Oct 28 20:39 oracle
    [root@wxrac01 bin]#chmod 6751 oracle

然后重新启动数据库搞定

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoaXl1MTE1Nzc1ODY1NQ_size_16_color_FFFFFF_t_70]: /images/20221120/f8c759056fdd4bbbb2289e2590ffc84c.png