Posts by Karthick Kannappan

Script to identify ASM diskgroup space

set serveroutput on declare v_diskgroup_name varchar2(50); v_total_space number(12); v_free_space number(12); v_pct_free number(6,3); begin for diskgroup_rec in (select name from v$asm_diskgroup) loop — — Get the total space for the current…

Read More

Upgrade database 19c registry components invalid

The below CATJAVA and JAVAVM components are invalid during 19c database upgrade. The below steps are needs to run to fix the corrupted database components. Steps :- 1)  Check DBA_REGISTRY_COMPONENTS…

Read More

Script to get metadata for schema creation and grants

select ‘create user ‘ ||username|| ‘ identified by values ”’ ||password|| ”’ default tablespace ‘ ||default_tablespace|| ‘ temporary tablespace ‘ ||temporary_tablespace|| ‘ profile ‘ ||profile||’;’ as sample from dba_users where…

Read More

How to Resync Tables & Schemas on Different SCN in Replicat OGG process

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 More

Decommission of pluggable databases

Steps 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 More

Oracle GoldenGate upgrade 19c

A. 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 More