Transforming Ideas into Innovation with Cloud, AI, and Data

This blogpost will provide you detailed information about Oracle Audit Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a comprehensive Database Activity Monitoring (DAM) solution that integrates with native audit data. Environment Setup: [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avcli mkdir: created directory ‘/oradb/oracle/avcli’ [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avagent mkdir: created directory ‘/oradb/oracle/avagent’ [oracrp@ebs-dev2-db01 ~]$ - Add these variables to the environment file vi DEV2CDB.env # AVS export AVCLI_HOME="/oradb/oracle/avcli" export AV_HOME="/oradb/oracle/avagent" export PATH="$PATH:$AV_HOME/bin" Download the JAR files:   AVDF installation requires one network interface card on respective hosts. IP assigned to AV server NIC will communicate with target databases and IP assigned to DF server will connect to AV Download - Agent jar file:   Login to AV console as avadmin user   - Go t...

The following post will provide the list of steps that needs to be performed while performing a manual switchover to DR database when Data guard is configured between these database. These commands are helpful if we are not using broker for switchover operations: Primary DB -  ERPDB Standby DB  DERPDB*   STEP1:(ERPDB) srvctl status database -d ERPDB srvctl stop instance  -d ERPDB  -i ERPDB2 -o immediate srvctl status database -d ERPDB STEP2: (DERPDB) srvctl status database -d DERPDB srvctl stop instance  -d DERPDB  -i DERPDB1 -o immediate srvctl status database -d DERPDB STEP3:(ERPDB) SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE; STEP4:(DERPDB) SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE; STEP5:(ERPDB) - Convert ERPDB to Physical standby database ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN; SHUTDOWN IMMEDI...