ODV有効化無効化_RAC環境

■無効化手順
Enterprise Managerの停止
$ORACLE_HOME/bin/emtcl status dbconsole
$ORACLE_HOME/bin/emtcl stop dbconsole
$ORACLE_HOME/bin/emtcl status dbconsole

Databaseの停止
srvctl stop database -n global_sid
srvctl stop nodeapps -n oracle01
srvctl stop nodeapps -n oracle02
cstat

Relink
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink oracle

ssh oracle02
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink oracle

Databaseの起動
srvctl start nodeapps -n oracle01
srvctl start nodeapps -n oracle02
srvctl start database -d global_sid
cstat

ODV無効化
$ORACLE_HOME/bin/dvca -debug -action disable \
-service sminveuc \
-sys_passwd password \
-owner_account smbcrlm -owner_passwd oracle10g_ \
-racnode oracle01 \
-silent \
-nodecrypt

Enterprise Managerの起動
emctl start dbconsole
emctl status dbconsole

トリガーの無効化とODV状態の確認
sqlplus / as sysdba
alter trigger dvsys.dv_before_ddl_trg disable;
alter trigger dvsys.dv_after_ddl_trg disable;
SET LINE 999
COLUMN INST_ID FORMAT 9
COLUMN PARAMETER FORMAT A30
COLUMN VALUE FORMAT A20
select * from gv$option where parameter like '%Vault%';

■有効化手順
トリガーの有効化
sqlplus / as sysdba
alter trigger dvsys.dv_before_ddl_trg enable;
alter trigger dvsys.dv_after_ddl_trg enable;
exit

ODVの有効化
$ORACLE_HOME/bin/dvca -debug -action enable \
-service sminveuc \
-sys_passwd password \
-owner_account smbcrlm -owner_passwd oracle10g_ \
-silent \
-racnode oracle01 \
-nodecrypt

Enterprise Managerの停止
emctl stop dbconsole
emctl status dbconsole

Databaseの停止
srvctl stop database -d sminveuc
srvctl stop nodeapps -n oracle01
srvctl stop nodeapps -n oracle02
cstat

Relink
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_on
cd $ORACLE_HOME/bin
relink oracle

ssh oracle02
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_on
cd $ORACLE_HOME/bin
relink oracle
exit

Databaseの起動
srvctl start nodeapps -n oracle01
srvctl start nodeapps -n oracle02
srvctl start database -d sminveuc
cstat

Enterprise Managerの起動
emctl start dbconsole
emctl status dbconsole

ODV状態の確認
sqlplus / as sysdba
SET LINE 999
COLUMN INST_ID FORMAT 9
COLUMN PARAMETER FORMAT A30
COLUMN VALUE FORMAT A20
select * from gv$option where parameter like '%Vault%';
exit