Apps DBA Workshop

In the last blog post we have seen how we can install the ZFS rpm packages on Oracle Linux 8 Operating System and now in this blog post, we will see how to configure and create the zpool on Oracle Linux 8 operating system.  Check the ZFS services: [root@localhost ~]# systemctl -a | grep zfs zfs-import-cache.service loaded inactive dead Import ZFS pools by cache file zfs-mount.service loaded inactive dead Mount ZFS filesystems zfs-share.service loaded inactive dead ZFS file system shares ...

This blog post will guide you on how we can pull the Docker images on Oracle Linux Server. The following link provides the available docker images: https://hub.docker.com/_/oraclelinux/ Check the available docker images: [root@localhost ~]# docker images REPOSITORY TAG IMAGE ID CREATED SIZE [root@localhost ~]# To pull the docker images server should be connected to the internet  Pulling the docker images: [root@localhost ~]# docker pull oraclelinux:7-slim 7-slim: Pulling from library/oraclelinux e83e8f2e82cc: Pull complete Digest: sha256:8a1041ef1238165425de696fae910aa36a16ba370cd1d47b04ad8dd00d3ea655 Status: Downloaded newer image for oraclelinux:7-slim docker.io/library/oraclelinux:7-slim [root@localhost ~]# [root@localhost ~]# docker pull oraclelinux:8-slim 8-slim: Pulling from library/oraclelinux 90e2fb2facff: Pull complete Digest: sha256:c911d89784e56a150d14030091b9fbf7875efb8c4ed190f39313f90691d81fbb Status: Downloaded newer image for oraclelinux:8...

In this blog post, we will see how we can install the ZFS rpm packages on Oracle Linux 8 operating system. Install pre-requiste package: [root@localhost ~]# dnf install -y yum-utils Last metadata expiration check: 1:16:13 ago on 25 May 2023 03:34:37 AM EDT. Package yum-utils-4.0.21-19.0.1.el8_8.noarch is already installed. Dependencies resolved. Nothing to do. Complete! [root@localhost ~]# Install the EPEL repository: [root@localhost ~]# dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm Last metadata expiration check: 1:17:42 ago on Wed 31 May 2023 03:34:37 AM EDT. epel-release-latest-8.noarch.rpm 33 kB/s | 25 kB 00:00 Dependencies resolved. ==========================================================================================================================================================...

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