Oracle Apps DBA has too often troubleshoot various issues. I am giving here the Top 30 Useful oracle apps queries for DBA how to find form session id in oracle The below query will provide the session details for all the forms opened in the applications set linesize 1000 column username format a8 heading “User|Name” […]
Oracle apps queries for APPS DBA Read More »
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.
TDE encryption in Oracle 12c step by step Read More »
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
How to resolve library cache lock in oracle Read More »
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
how to resolve library cache pin in oracle Read More »
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 »
