Posts by Doyensys

Deconfig Oracle RAC Grid Installation

Steps to deconfig GRID Installation :- To cleanup the failed installation of GRID,run the script of failed node. [root@test ~]# cd /u01/app/grid/crs/install/rootcrs.pl  -deconfig -force [root@test ~]# rm –rf /etc/ora* [root@test…

Read More

Show the High Water Mark for Specific Table

SET LINESIZE 300 SET SERVEROUTPUT ON SET VERIFY OFF DECLARE   CURSOR cu_tables IS     SELECT a.owner,            a.table_name     FROM   all_tables a  …

Read More

Bursting Fails With File Is Not Accessible From Node/Machine

BI Publisher (formerly XML Publisher) – Version 12.0 to 12.2 [Release 12.0 to 12.2]Information in this document applies to any platform. Issue: Bursting program failing with the following message: null…

Read More

XML Publisher Bursting Failing with error: oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.getSystemTempDirectory

Issue: XML Publisher Bursting program – XDOBURSTREP errors with:Exception null java.lang.NullPointerException at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.getSystemTempDirectory(JCP4XDOBurstingEngine.java:413) at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:106) at oracle.apps.fnd.cp.request.Run.main(Run.java:161)———————————-+ Error: Error received getSystemTempDirectory due to the temporary directory not being defined. Solution:…

Read More

WSHPSGL: Pick Selection List Generation Errors Out : ORA-06508: PL/SQL: could not find program unit being called

Issue: WSHPSGL: Pick Selection List Generation Errors Out : ORA-06508: PL/SQL: could not find program unit being called Symptoms: On : 12.1.1 version, Pick Release Process When attempting to pick…

Read More

Script to Monitor Cost Manager and other Inventory Interface Managers

#!/bin/bash ############################################################################### # Script Name : MonInterfaceMgr.sh                                               …

Read More

Script to Monitor Long Running Concurrent Requests

#!/bin/bash ############################################################################################# # Script Name : LongRunningReq.sh # # # # Description: # # Script to check Concurrent requests which are running for more than given threshold (mins)# # to…

Read More

Script to check workflow mailer service components status and send notification if DOWN

#!/bin/bash ################################################################################### # Script Name : WorkflowStatusCheck.sh # # # # Description: # # Script to check workflow mailer service components status and # # to send alert notification if…

Read More

Script To Monitor "Gather Schema Statistics" concurrent request

#!/bin/bash ############################################################################################################# # Script Name : MonGSSRequest.sh                                               …

Read More

Script to Monitor Output Post Processor (OPP) Concurrent Manager

#!/bin/bash ########################################################################### # Script Name :  MonOPPMgr.sh                                               …

Read More