Database Blog

Oracle Golden Gate files Location and extension

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 More

Differences between data dictionary views and V$ views

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

Steps to remove OLAP API and OLAP Catalog

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

Step to remove database componentes

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

ORADEBUG utility

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

Adop Fails With Error: ssh is not enabled for the following nodes

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

GoldenGate Error Queue For Apply Process “OGG$RNDDEV_A” Contains New Transaction With ORA-904

Issue : 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 More

ORA-02020: too many database links in use

Cause:  The current session has exceeded the INIT.ORA open_links maximum. To find: ——— SQL> show parameter open_links; NAME                         …

Read More

RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error

RMAN> 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

Concurrent manager become up after 3-4 hours after start Oracle Application

Description: 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