Learn Oracle Apps DBA

Interesting story behind this: I have received a customer requirement for a DBA position, and the main criteria was: the DBA must know oracle key vault, for their security solution project. I have received around 25/30 resumes where everyone has written, they know Oracle key-vault. While interviewing, someone saying it's a security file 😆, someone saying it's a parameter that exists since 12c on-words 😀, others saying it's a tool like oracle wallet & TDE 😟. Everyone disappointed me, although it's just a matter of little more detail reading of  (https://docs.oracle.com/en/database/oracle/key-vault/21.4/).   So thought of writing this blog and share it across for quick understanding.  Note: I have done this installation/deployment of  appliance image in my VM ware server. Created a 300Gigs vm with 8 GB of RAM & 2 vCPUs, and deployed it. Very simple.  Oracle Kye-vault is a security solution soft appliance from Oracle . It comes as an ISO image from...

   1.     Pre-Requisites   1.       Backup the current Audit Vault console: If the Audit vault server is installed in a VM, it is recommended to take a VM snapshot before starting the upgrade process.   2.        Release Existing Tablespace that are retrieved manually : If existing tablespaces are not released that will fail the pre-upgrade procedure. To release the tablespaces follow this procedure:                                                                                    I.   ...