Steps to configure a BATCHSQL mode in Oracle GoldenGate
Steps to configure a BATCHSQL mode in Oracle GoldenGate How to do it… The BATCHSQL mode can be configured by adding the following parameters in the replicat configuration file: …
Read Moreadapcctl.sh: exiting with status 204 in oracle apps
Error: You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance … adapcctl.sh: exiting with status 204 Cause: .apachectl has permission denied to run the apache…
Read MoreHow to change passwords to include special characters using FNDCPASS
Note that the term ‘Special Characters’ is used in this article to refer to those characters who are shown in the table below. Use of the FNDCPASS utility to change…
Read MoreError while running the autoconfig on the apps Node
Error: Autoconfig could not process the following files: Directory: /u01/app/oracle/inst/apps/SVRPRD_svrprdebsal1/ora/10.1.3/Apache/Apache/bin .apachectl BINCPY .apachectl BINCPY AutoConfig is exiting with status 2 Solution : The workaround for this is…
Read MoreIDENTIFYING CORRUPTION SEGMENTS
set linesize 140col owner format a10col segment_type format a10col segment_name format a30col partition_name format a15col file# format 999SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# …
Read MoreTop 10 – Biggest Tables and Indexes
set lines 170set pages 20col owner format a20col object format a30col type format a6col tablespace format a20col size_in_gb format 999,999.9select * from (select…
Read More11gR2 RAC ASM using RMAN Multiplexing the control file
STEP 1. Check the current control file status SQL> select name from v$controlfile; NAME ——————————————————————————– +DATA/orcl/controlfile/current.263.800282297 STEP 2. Change the control_files parameter by adding the new disk group Alter system…
Read MoreORA-28000 “the account is locked” in the standby database
Scenario: ======= The user attempts to logon and gets an error ORA-28000 “the account is locked” in the primary database which is configure with Dataguard. The database administrator unlock this user’s…
Read MoreASM Diskgroup free space check script
#!/bin/bash ############################################################################### # File Name : asmdiskgroup_free_space.sh # Author : Vimal Raju # Date : 27/11/2014 # Description : asmdiskgroup size check # ###############################################################################…
Read More