Sometimes, we may have done some mistakes and we are facing issues with TDE. If you have a good backup of the wallet then we can go back to the backup file.There are two files pertaining to the TDEewallet.p12 – This is the actual wallet filecwallet.sso – This is the autologin wallet To restore the …
How To Restore TDE Wallet Files From Backup in Oracle Database Read More »
TDE stands for Transparent Data Encryption. We can encrypt both the tablespace and individual table columns using TDE.This article, we will see the step by step process for TDE encryption in oracle 12c What is TDE (Transparent Data Encryption) How is TDE licensed? TDE is part of Oracle Advanced Security, which also includes Data Redaction. …
This post is about library cache lock and How to resolve library cache lock in oracle What is library cache lock This is used to control concurrency between clients of the library cache by acquiring a lock on the object handle. Uses are(a)One client can prevent other clients from accessing the same object(b)The client can …
In this post, we will see what is library cache pin and how to resolve library cache pin in oracle What is library cache Pin In the library cache, a database object is cached in 2 parts: “handle” and “object”. Library cache lock works on Handle and the Library cache pin is only held when …
We can have both Linux and Windows compute instances in the Oracle Cloud. Let’s learn about how to login to both the Linux and Window compute instance/how to access oracle cloud compute instance Linux Compute Instance We first need to make sure, we have the public IP associated with the Compute instance and security list …
How to access oracle cloud compute instance(Linux/Window) Read More »
We often need to find out what all patches are applied to the EBS instance. Now, this varies as per the EBS instance version. We have different queries for R12.1 and R12.2.Let’s find out the Query to check the patch applied in R12/R12.1 and Query to check patch applied in R12.2 Query for R12/R12.1 ad_bugs …
Query to check patch applied in R12.2 Read More »
