Below are the major Golden gate files and their locations. Reports (.rpt) /u01/doyen/goldengate/ogg/dirrpt Parameters (.prm) /u01/doyen/goldengate/ogg/dirprm Replicat Checkpoints (.cpr) /u01/doyen/goldengate/ogg/dirchk Extract Checkpoints (.cpe) /u01/doyen/goldengate/ogg/dirchk Process Status (.pcs) /u01/doyen/goldengate/ogg/dirpcs SQL Scripts…
Read MoreHere are the differences between data dictionary views and V$ views, in Oracle. Data Dictionary Views : 1. Data will not be lost even after the instance is shutdown .…
Read More1. Remove Oracle OLAP API: *************************** @?/olap/admin/olapidrp.plb @?/olap/admin/catnoxoq.sql @?/rdbms/admin/utlrp.sql select comp_id, comp_name, version, status from dba_registry where COMP_ID=’XOQ’; SELECT object_name,object_type,owner FROM dba_objects WHERE status = ‘INVALID’; alter public synonym DBMS_CUBE_ADVISE…
Read More1. Remove Oracle Text: *********************** @?/ctx/admin/catnoctx.sql drop procedure sys.validate_context; select comp_id, comp_name, version, status from dba_registry where COMP_ID=’CONTEXT’; SELECT object_name FROM dba_objects WHERE status = ‘INVALID’; 2. Remove OLAP Analytic…
Read MoreWorking wit ORADEBUG utility for uploading SR to check on slowness:- ************************************************************************ connect / as sysdba Find OSPID using the below query:- select p.PID,p.SPID,s.SID, s.SQL_EXEC_START, s.SQL_EXEC_ID, a.sql_text from v$process p,v$session…
Read MoreGetting the following error applying a patch running Adop: adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context :…
Read MoreIssue : GoldenGate Error Queue For Apply Process “OGG$RNDDEV_A” Contains New Transaction With ORA-904 Observation : *** ACTION NAME:(OGG$RNDDEV_A – Apply Server) 2016-06-01 15:50:47.102 dbkedDefDump(): Starting a non-incident diagnostic dump…
Read MoreCause: The current session has exceeded the INIT.ORA open_links maximum. To find: ——— SQL> show parameter open_links; NAME …
Read MoreRMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLFILE; rman> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE SBT; or…
Read MoreDescription: These two tables FND_ENV_CONTEXT FND_CONCURRENT_REQUESTS grown to 4 GB size . To speed up. Solution: 1. First Purge and then De-fragmentation to improve the performance of the DML fired…
Read More