Introduction : The Technology Codelevel Checker (ETCC) utility provides two scripts to ensure all the necessary database and application tier patches are installed on a 12.2 system. Oracle strongly recommends…
Read MoreIntroduction : FNDCPASS is an utility to change passwords of database schemas within the Oracle E-Business Suite. For example, you can change the APPS password using FNDCPASS.You can also change…
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 : After configuring the dataguard, databases would be in primary role and standby database role. The above mentioned roles can be altered without the loss of data and…
Read MoreThe 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 More