Upgrade excel4wands apps from 5 to 21.1
Follow these steps to perform an upgrade. 1. Confirm that both the Excel4apps and Excel4apps Reports Wand applications have been registered on you system. a. Log on to the Oracle…
Read MoreKill inactive apex sessions in amazon RDS
set serveroutput on; begin for i in ( select sid, serial# from gv$session where status=’INACTIVE’ and type=’USER’ and program=’APEX Listener’ and last_call_et/60 > 5) loop dbms_output.put_line(‘begin’); dbms_output.put_line(‘rdsadmin.rdsadmin_util.kill(‘); dbms_output.put_line(‘sid =>’||i.sid||’,’); dbms_output.put_line(‘serial…
Read MoreQuery to find to Soft Parse and Hard Parse Ratio
select ‘Soft Parses ‘ “Ratio” ,round( ((select sum(value) from v$sysstat where name = ‘parse count (total)’) – (select sum(value) from v$sysstat where name = ‘parse count (hard)’)) /(select sum(value) from…
Read MoreAutoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2
Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2 /u01/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status…
Read MoreQuery to check if DMZ is enabled
Query to check if DMZ is enabled select p.user_profile_option_name “Profile Name”, decode(v.profile_option_value, 1, ‘Admin’, 2, ‘Normal’, 3, ‘External’, ‘Unknown’) Value, decode(v.level_id, 10001, ‘SITE’, 10002, (select ‘App:’||a.application_short_name from fnd_application a where…
Read MoreQuery To Get Archive Log Apply Rate Speed of a Standby Database
Query To Get Archive Log Apply Rate Speed of a Standby Database set linesize 180 col Values for a70 col Recovery_start for a21 select to_char(START_TIME,’dd.mm.yyyy hh24:mi:ss’) “Recovery_start”, to_char(item)||’ =…
Read MoreQuery to check user session statistics
Query to check user session statistics col pid format 9999 heading ‘PID’ col spid format a6 heading ‘SERVER|PID’ col sid format 9999 heading ‘SID’ col serial# format 99999 heading ‘SERIAL’…
Read Moreadpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9”
Error: adpatch Fails After Restart With Error: “Unable to read file format id from file adainit.rf9” Solution: cd <$APPL_TOP>/admin/AXMD/restart/ Rename the file adainit.rf9 mv adainit.rf9 adainit.rf9.org
Read MoreOPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:
ERROR: $opatch lsinventory OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred: Can not get a list of inventory on this home. ERROR: OPatch failed because of Inventory problem. Solution:…
Read Moreadcfgclone issue – ORA-28040: No matching authentication protocol
ERROR: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database 12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database CloneContext_***.log Shows the Message: Exception occurred: java.sql.SQLException:…
Read More