How to Resync Tables and Schemas to re-instantiate OGG replicat process :- Stop the Replicat process in the target environment if it is running by using the following command: GGSCI>…
Read MoreSteps to decommission of PDBs : Connect to container database : oracle $ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 23 08:19:41 2020 Copyright (c) 1982,…
Read MoreA. Pre-Upgrade Tasks 1. Download the latest OGG software from support.oracle.com. In our demo we have downloaded Oracle_GoldenGate_19.1.0.0.4.zip for Linux 64 bit. 2. Copy the OGG software to the source…
Read MoreSELECT ‘Request id: ‘||request_id , ‘Trace id: ‘||oracle_Process_id, ‘Trace Flag: ‘||req.enable_trace, ‘Trace Name: ‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’, ‘Prog. Name: ‘||prog.user_concurrent_program_name, ‘File Name: ‘||execname.execution_file_name|| execname.subroutine_name , ‘Status : ‘||decode(phase_code,’R’,’Running’) ||’-‘||decode(status_code,’R’,’Normal’), ‘SID Serial: ‘||ses.sid||’,’|| ses.serial#,…
Read MoreUse the below Link to create the Cerfiticate using Amazon SMTP address. https://whatsmychaincert.com/?email-smtp.us-east-1.amazonaws.com Creating Oracle Wallet : mkdir -p /u01/app/oracle/wallet/TEST orapki wallet create -wallet /u01/app/oracle/wallet/TEST orapki wallet add -wallet /u01/app/oracle/wallet/TEST…
Read MoreGot the below error during cloning. To fix this issue, need to “clear unarchived logfile group” Solution : SQL> alter database open resetlogs; alter database open resetlogs * ERROR…
Read MoreWhen considering the security, it is important to ensure the availability. Data High availability ensured by achieving below key architecture to preventing downtime. Data Availability: Ensure that we are not…
Read MoreData Safe is a control center for your Oracle Databases which helps understand the sensitivity of data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess…
Read MoreNetwork security was improved by using client, listener, and network guidelines to ensure protection. Using SSL is an essential element in these lists, enabling top security for authentication and communications.…
Read MoreOracle Secure Backup is a centralized tape backup management solution providing heterogeneous data protection in distributed UNIX, Linux, Windows, and Network Attached Storage (NAS) Environments. By protecting the file system and…
Read More