▼
Friday, 29 January 2016

Script for concurrent request details using Request Id

›
Below script for running concurrent request details using Request Id. Script: set head off set verify off set echo off set pages 150...

Script for scheduled concurrent programs on particular date and time

›
Below script for scheduled concurrent details on exact date and time. Script: SELECT   fcr.request_id,          DECODE (fcpt.user_conc...
Thursday, 28 January 2016

Adadmin Fails after schema password has been changed through AFPASSWD

›
We are facing with adadmin fails after changing the password using AFPASSWD. Below is the issue and fix for solving the issue. Issue: A...
Wednesday, 27 January 2016

adopmnctl.sh exit with status 206 in oracle apps R12

›
We are facing issue while restarting opmnctl services. Issue: -bash-3.2$ cd $ADMIN_SCRIPTS_HOME -bash-3.2$ sh adopmnctl.sh startall ...

How to create a schema with existing schema permissions in oracle database

›
In my case existing schema is APPS and need to create a schema like CMSRC. Step 1: SQL> Set long 100000000 SQL> select dbms_meta...
Tuesday, 26 January 2016

How to run Autoconfig in TEST mode

›
When we run Autoconfig, It will update the existing configuration file. To prevent any unwanted changes, we can run the Autoconfig in TEST ...

Invalid objects details in oracle database

›
Below script to know the invalid objects count and details including (creation date, modification date and user details). Script: set l...
Monday, 25 January 2016

Current running concurrent request details in oracle apps R12

›
Below script to know the current running concurrent request details in oracle apps R12. Script: set echo off pages 100 lines 202 colum...

Forgotten SYSADMIN password in oracle apps R12

›
Step 1:   Connect to apps user in application node  SQL> conn apps/APPS123; Connected. Step 2:   Create below package  SQL> C...
Sunday, 24 January 2016

Forgotten apps user password in oracle apps R12

›
Below steps to get the forgotten apps user password in oracle apps R12. Step 1:   Connect to sys user  SQL> show user USER is ...
Sunday, 10 January 2016

Script for RMAN restore current status

›
Below script to know RMAN restore current status and remaining time to complete the refresh. Script: set lines 199 select OPNAME...

How to disable all scheduled concurrent programs after refresh

›
Below script to disable scheduled concurrent programs after refresh. Script: update fnd_concurrent_requests set phase_code='C'...

Apache, Jserv, Forms, Jinitiator and Perl version in Oracle Ebiz R12

›
Below script to know the versions of Apache, Jserv, Forms, Jinitiator and Perl version in Oracle Ebiz R12. Apache Version: -bash-3.2$ $...

AD Jobs running more than 1 hour

›
Below script to know AD jobs running more than 1 hour. Script: select distinct t.job_name,        TRUNC(t.ELAPSED_TIME * 24 * 60) MINU...

How to check Gather schema stats run in last 30 days

›
How many times GSS run in last 30 days in oracle. Script: set linesize 200 select  r.request_id,r.actual_start_date,r.phase_code,r.sta...
Saturday, 9 January 2016

Health check of oracle Ebiz database and applications

›
The below script is very useful to get the health check of oracle ebiz database and application. Script: SQL>conn apps/*** SQL>s...
Thursday, 7 January 2016

Cocurrent managers details from backend in oracle application

›
Below script to get all the concurrent manager details in oracle apps. Script: set lines 199 ----set pagesize 9999 select decode (CO...

Tablespace growth report using sqlplus

›
Below script to find the growth of tablespace in oracle database: Script: set linesize 120 column name format a15 column variance for...

Oracle database growth

›
Below script to get the growth of the oracle database Script: select to_char(CREATION_TIME,'RRRR') year,to_char(CREATION_TIME,...
Monday, 7 December 2015

How to check product patch level or code level oracle apps

›
Below script to know the patch level or code level of oracle apps. Script: SELECT app_short_name, MAX(patch_level) FROM apps.ad_...