APPS DBA

How To Setup Printers on Oracle Apps Defined Printer at Unix OS level First check the status of printer at unix level by issuing the following command: $lpstat –a Step …

A Brief Introduction to ADPatch AutoPatch (adpatch) “AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.”   Modes Of adpatch There …

How to Check Version of Apache in Oracle Apps? Step 1. Goto Oracle Application Home  $ cd $IAS_ORACLE_HOME/Apache/Apache/bin/ $ pwd /apps/ebs/apps/tech_st/10.1.3/Apache/Apache/bin Step 2. Write httpd -v to fetch the Version …

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, …