Database Blog

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

18c Oracle Database Installation(On-Premise)

Posted by : AnilKumar Kandepu You have three options to install database; Starting with Oracle Database 18c release. 1) Image-based Oracle Database Installation 2) RPM-Based Oracle Database Installation 3) Read-Only…

Read More

Query to find audit information about dropped users

Find audit information about dropped users NOTE : “DROP USER” is audited by default from Oracle 12c onwards. Use the below query to take information if you have not turned…

Read More

ORA-01270: RENAME operation is not allowed if STANDBY_FILE_MANAGEMENT is auto

INTRODUCTION :  This post describes renaming a datafile in standby. NOTE : In Primary database renaming a Datafile will not be reflected in Standby database even the STANDBY_FILE_MANAGEMENT=auto , So…

Read More

Extract a particular file from an zipped archive file to a given directory.

Unzip particular file from an zip file NOTE : Sometimes we would know the archive file present in zip folder and would like to unzip only that particular file.  The…

Read More