APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later SYMPTOMS: Database Names: UAT RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171 : $ rman auxiliary /…
Read MoreAPPLIES TO: Oracle Applications Manager - Version 12.1.3 and later SYMPTOMS: E-Business Suite R12 Applications Manager, Rapidclone related issues java.lang.Exception: AC-50006: Could not assign any APPL_TOP name to this instance.…
Read MoreEnvironment Details Server Name : primegg.localdomain OS Version : Oracle Linux Server release 7 Database Version : 19.0.0.0 GoldenGate Version : 19.1.0.0.4 for oracle Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 GoldenGate…
Read MoreACFS concept was introduced in 11.2.0.1 it only manages the non-database files. Oracle ACFS (Automatic Storage Management Cluster File System) is the preferred file manager for non-database files. It is…
Read MorePlease use the below. CREATE TABLE DBA.STATS$TOTALUSERS ( MEASURED_DATE DATE, TOTAL_USERS NUMBER, ACTIVE_USERS NUMBER ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K…
Read MorePlease use the below query. set line size 750 pages 9999 col box for a30 col username for a30 col spid for a30 col program for a30 col os_user for…
Read MoreThere are so many commands we use while working with vi editors. Here I have shared some commands. i – for insert mode. I – inserts text at…
Read MoreThe following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this query and query…
Read MoreIntroduction: Beginning with Oracle APEX 20.2, the only supported Web listener is Oracle REST Data Services (ORDS). What is ORDS? Oracle REST Data Services (ORDS) is a data service which…
Read MoreHere is an easy way to put all the Pending Concurrent requests in hold, if we are going through any situation(Mostly any Production Cutover/Go live scenarios). 1. First create a…
Read More