APPS DBA

Application Names in Oracle E-Business Suite R12   Application ID Application Name Application Short Name Basepath 1 0 Application Object Library FND FND_TOP 2 1 System Administration SYSADMIN FND_TOP 3 …

How to find the Oracle E-Business Suite R12 application URL? $ sqlplus apps/appsdrdg SQL*Plus: Release 10.2.0.4.0 – Production on Fri Oct 20 16:55:32 2017 Copyright (c) 1982, 2007, Oracle. All …

How to rename a Datafile with Extension .dbf? For example we have  added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …

How To Move Table to Different TableSpace   SYNTAX ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);   EXAMPLE ALTER TABLE hr.employee_details move TABLESPACE hr; OR ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);  

How To Trace Concurrent Programs CASE 1 : Concurrent Program Tracing without bind variables 1)   Follow the following navigation to enable logging for Concurrent Program Goto Sysadmin > Concurrent > …

Fixing a “Failed” worker  Whenever  a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker. …

RapidWiz log files for Oracle Applications Release 12   During installation of Release 12 using RapidWiz, the following log files are created. In case of any errors during the installation, …

Oracle AD Controller ADCTRL is used to manage worker processes that perform a pivotal role in the function of batch processing for patching and many other Applications activities. ADCTRL is …

List of All active Transactions