Long Term Release: Oracle Database Long Term Releases offers highest level of stability including lot of bug fixes developed over the period of years. It typically has highest premier…
Read MoreBelow 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 More