Posts by Sakthi Sethuperumal S

OGG-00529 DDL Replication is enabled but table gguser.GGS_DDL_HIST is not found. Please check DDL installation in the database.

Introduction Solution to fix the error OGG-00529 DDL Replication is enabled but table gguser.GGS_DDL_HIST is not found Posted by Sunilkumar Configure Goldengate DDL Replication Prerequisite Setup 1. Navigate to the directory where the Oracle Goldengate software is installed. 2.Connect to the Oracle database as sysdba.    sqlplus sys/password as sysdba 3.For DDL synchronization setup, run the marker_setup.sql script. Provide OGG_USER    schema name, when prompted.…

Read More

Please move GGUSER to its own tablespace

Posted by sunil71093 Please move GGUSER to its own tablespace SQL> @ddl_setup.sql Oracle GoldenGate DDL Replication setup script Verifying that current user has privileges to install DDL Replication… You will be…

Read More

Configuring the JBoss ON Server as a Service on Red Hat Enterprise Linux

The rhq-server.sh script can be managed by the init process so that the server starts automatically when the system boots. This also allows the server process to be managed by…

Read More

Ansible: Install and Configure Ansible Tower On oracle linux 7

Introduction Steps to install Ansible: Install and Configure Ansible Tower On oracle linux 7 Posted by Sunilkumar Ansible: Install and Configure Ansible Tower On oracle linux 7 Ansible has two components: Ansible Core and Ansible Tower. Core provides the Ansible runtime that executes playbooks (yaml files defining tasks and roles) against inventories (group of hosts). Ansible Tower provides management, visibility, job scheduling credentials, RBAC, auditing / compliance. Install Ansible Tower Download latest Ansible Tower release. Configure Setup. Ansible Tower uses an Ansible playbook to deploy itself. As such configuration parameters or groupvars are stored in inventory file. Example Inventory file Example Inventory file for an external existing database    Run setup    …

Read More

Creating a Custom Application in Oracle E-Business Suite Release 12.2

Introduction: Steps to create Custom Application in Oracle E-Business Suite Release 12.2 Posted by Sakthi Sethu Perumal Step 1: Create A Custom Application Using AD Splice Download Patch 3636980 “Support…

Read More

AD Administration error:Connected to db edition other than RUN and PATCH

Introduction Solution to fix AD Administration error:Connected to db edition other than RUN and PATCH Posted by Sundaravel Ramasubbu Issue: When we try to compile apps schema through adadmin AD Administration…

Read More

RMAN duplicate database having multiple directories to assign to BACKUP LOCATION

Introduction Steps to assign Backup location in Rman duplicate database having multiple directories. Posted by Mahendran Applies To By default RMAN picks one backup location to do duplicate with clause…

Read More