Apps DBA Workshop

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...

 Oracle released its latest version of Operating System - Linux 9 and its introduced too many new features with this release.  As the demand for computing is growing there is a huge inclined in cyber attacks. Operating System is the first layer where application, Database, middleware's, virtualization and everything is hosted. If this layer is compromised then your complete system is compromised. Hence with this release Oracle advanced its security with Oracle Enterprise Linux 9. In this blogpost we will discuss one of the key improvement security area. The old network-scripts package has been removed in Oracle Linux 9. Hence, there are no files in  /etc/sysconfig/network-scripts directory. Also this package was deprecated in Oracle Linux 8. This is a big change from the Administration perspective, if we use to configure network using legacy scripts  then its a very big setback.  Now the network is managed using the nmcli command: nmcli Information is stored fil...