The automatic indexing feature automates the indexing in an Oracle database. Automatic indexing automatically creates, rebuilds, and drops indexes in a database based on the changes in application workload, thus…
Read MoreIntroduction : The listener is a separate database server process that runs locally on the database server or remotely on the Oracle RAC environment. When a request from the client…
Read MoreIntroduction: The Goldengate Replicat process is also known as the apply process. It is a mandatory process in the Goldengate setup. This data delivery process is the last component to…
Read MoreIntroduction : The Oracle Goldengate Extract process captures transactions that have been committed from the Oracle Redo Logs or Archived Logs. The Extract process writes the captured source data…
Read MoreIntroduction : The Goldengate Manager is the first process that needs to be setup in the replication configuration. This process must be running on the source and the target system.…
Read MoreError while upgrading the database from 11.2.0.4 to 19.3.0.0:- REASON: ERRORS FOUND: During Upgrade FILENAME: /u01/app/oracle/product/19c/cfgtoollogs/test19C/upgrade20200127132925/catupgrd0.log AT LINE NUMBER: 801192 —————————————————— Identifier CATJAVA 20-01-27 02:09:14 SCRIPT = [/u01/app/oracle/product/19c/rdbms/admin/initjms.sql] ERROR =…
Read MoreTo view the database components:- col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; 1) Remove Oracle Application…
Read Morestep 1:- connect oem database as sysdba and change the password:- sqlplus “/as sysdba” alter user sysman identified by “oem13c_monitor”; step 2:- Stop all OMS processes:- cd /u01/app/oracle/middleware/bin/ ./emctl stop…
Read MoreThe most renowned enterprise database in the world, Oracle Database has made an eminent advancement in its history by introducing autonomous database. At the initial stages of its announcement before…
Read Moreset lines 288 col sample_time for a14 col CONFIGURATION head “CONFIG” for 99.99 col ADMINISTRATIVE head “ADMIN” for 99.99 col OTHER for 99.99 SELECT TO_CHAR(SAMPLE_TIME, ‘HH24:MI ‘) AS SAMPLE_TIME, ROUND(OTHER…
Read More