Issue : Replicat Is Abending With OGG-00660 Could not find unique key column within table definition When FUNCTION BASED INDEX and BATCHSQL Is Used Note : The issue was on…
Read MoreIssue : Replicat Abends With ERROR OGG-01029 Extract Reposition err – CDR Info sequence 0, rba 0 Observation : Replicat Abending with Error “OGG-01029 Extract reposition err – CDR Info sequence 0, rba 0.” This happens in Oracle GoldenGate –…
Read MoreWe might face some scenarios for convert string data into rows. Here you can separate a string into rows by giving the string separator as input. Users can give any…
Read MoreEXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER In this blog, we are going to learn about how to do export/import data pump backup by using the tablespace parameter [oracle@oracle Desktop]$ cd [oracle@oracle ~]$ export ORACLE_SID=Trainee [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Feb 4 10:42:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.…
Read MoreSCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING In this tutorial, we going to learn about to find which database instance is running now. Mostly we use “/etc/oratab” to view…
Read MoreThere are many scenarios, DBA struggling to identify the sessions running in database on sudden adhoc request. To capture the session quickly with the information what we get is really…
Read MoreIssue: The Commvault issue is reporting saying that first node connection is fine and rest all the 2 nodes is not connecting. Solution: The following are the key points that…
Read MoreDatabase backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem If the database was started using SQL*Plus, and the ORACLE_UNIQUENAME environment…
Read MoreBelow sql script to check the Highest SQL Wait Time using Active Session History (ASH) col session_id for a10 col session_serial# for a10 col session_state for a20 SELECT h.session_id, h.session_serial#,…
Read MoreBelow sql script to check if any Debug or Trace profile options have been set to Y in Oracle ERP application, select distinct a.application_short_name app_short, user_profile_option_name optname, decode(level_id, 10001,’SITE’, 10002,’APP…
Read More