Setting up TDE (Transparent Data Encryption) in 19c is very easy and these are the steps needed. 1:- Create a backup of spfile/initfile (it is always a good practice to create a backup before any change on the DB): 2:- Create WALLET directory in both nodes: 3:- Update sqlnet.ora with wallet location (in all nodes):... » read more
In this activity we are going to assume we have GoldenGate software already installed, if not, you can follow these steps here: Oracle GoldenGate 19c: How to install We are are going to replicate schema HR from/to these server: SOURCE (PDB): TARGET (NON CDB): hostname: racnode1 hostname: standbyracnode IP: 192.168.24.1 IP: 192.168.24.3 RDBMS: 19c RDBMS:... » read more
This is going to be a guide for how to install GoldenGate on your source/target servers, just the installation of the software. For the configuration and setting up and running, please check this: Oracle GoldenGate 19c: How to configure Integrated EXTRACT/REPLICAT First of all make sure you have the GoldenGate version that matches your DB.... » read more
While trying to reinstall Oracle Grid Infrastructure 19c on my lab, I was facing this error: The hint here is the CRS-1705: Found 0 configured voting files In this environment I was replacing OCR dg for RECO dg so lets check what each node see: Somehow I did miss to do a scan on node... » read more
Cloud tools are not known to provide huge amount of details when you have an error.In this case we were running patching prechecks which were failing with: Checking log, se can see error was given while trying to execute “select status from pdb_plug_in_violations where type = ‘ERROR’ and status = ‘PENDING’ order by name, time;”... » read more
Starting from 12c, RMAN allows to perform a Table Point In Time Recovery (PITR).On earlier releases, this was only possible by manually creating a point in time clone of the database and extracting the data via datapump.With this “new” feature, life gets easier. SETUP:For this task we are assuming you have your DB/ARCHIVE log backups... » read more
This is a weird case we had for a Customer where DB/PDB’s were running fine and after a restart, one of the PDB’s went to restricted YES.We don’t know why it went to restricted mode because there hasn’t been a patching activity for a while and DB had few restarts in the past with no... » read more
This wait can have an impact to production and deteriorate performance on a DB, so lets investigate… Lets see the output from a AWR report where this event is 23% of the total wait time: As per “Analyzing ‘enq: HW – contention’ Wait Event (Doc ID 740075.1)”, this can be generated by multiple sessions fighting... » read more
This is an easy one that will save you going through alert logs.
Sometimes you might get an incident for high usage on a filesystem. You check and yes, filesystem usage is high, but ‘du’ (disk usage) if different. why? Some explanations might say: they don’t use the same methods or metrics to calculate what they are reporting.Yes, that’s true, but pretty much outputs should be the same.If... » read more