This post talks about What is Flashback Database in Oracle, How a flashback database works,How to configure flashback database What is Flashback Database A new feature from 10.1 onwards, Uses past block images to back out changes to an oracle database During normal database operation, Oracle occasionally logs past block images in flashback logs Flashback …
Oracle Flashback Database explained and limitation Read More »
In this post, we will see the Script to check locks in oracle database, how to check locks in oracle, how to check lock on table in oracle Locks is a process in the Oracle database through which it maintains consistency and concurrency. So they keep coming and going. We generally don’t need to worry …
Oracle EBS users can be created from the front end through Oracle forms or using backend PLSQL Blocks as well. We will see how to create user in oracle apps from the backend in this post Application User can be created from sqlplus using PLSQL Block Set serveroutput on BEGIN fnd_user_pkg.CreateUser(x_user_name => ‘UserName’ ,x_owner => …
Create EBS user from backend & Assign Responsibility 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 »
In this post, we will be checking out the most commonly used oracle tde wallet queries. how to open a wallet in Oracle 12c or 19c Here is how to open a wallet in Oracle 12c or 19c for both CDB and Non-CDB Databases With 12c Non-CDB ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY …
how to open a wallet in Oracle : Status, Open, Close Read More »
TDE stands for Transparent Data Encryption. It was initially released in Oracle 10gR1 where it gave the capability to encrypt the column in the table. With 11gR1, we can now 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 …
TDE encryption oracle 11g step by step Read More »
