adcfgclone return code = .16.17.18.19.20.21
Where I Faced this Issue? When I ran adcfgclone appsTier on EBS 12.2 I got this error, and it said got error while running autoconfig, but the actual error is…
Read MoreWhich type of Database release customer should follow? Long Term Release and Innovation Release?
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 MoreOracle 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 MoreDifferences 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 MoreSteps 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 MoreStep 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 MoreORADEBUG 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 MoreAdop 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 MoreGoldenGate 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 MoreORA-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