ASM – ORA-00020: maximum number of processes
The Oracle parameter PROCESSES has been exceeded as a result of multiple database instances connecting to the ASM instance. The default value (often 40) is insufficient to support more than…
Read MoreQuery to check Table Full Scan
Query: spool large_table_scans.txt –Find Large Table Scans set linesize 132 SELECT substr(table_owner,1,10) Owner, substr(table_name,1,15) Table_Name, size_kb, statement_count, reference_count, substr(executions,1,4) Exec, …
Read MoreSize need to check as DBAs
How to find database size? SQL> select sum(bytes)/1024/1024 from dba_data_files; (OR) SQL>select sum(result) from (…
Read MoreDeconfig 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 MoreShow 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 MoreBursting 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 MoreXML 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 MoreWSHPSGL: 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 MoreScript to Monitor Cost Manager and other Inventory Interface Managers
#!/bin/bash ############################################################################### # Script Name : MonInterfaceMgr.sh …
Read MoreScript 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