Description: These two tables FND_ENV_CONTEXT FND_CONCURRENT_REQUESTS grown to 4 GB size . To speed up. Solution: 1. First Purge and then De-fragmentation to improve the performance of the DML fired…
Read MoreProblem: Concurrent program are running from long time and are not getting completed. $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132×66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace Get error: Environment:Environment java.lang.UnsatisfiedLinkError: Can’t…
Read MoreExecute the below in Application Tier: Run adpreclone on Application Tier $ perl ./adpreclone.pl appsTier Execute the following on the Database Tier: Logon as oracle database user and set envirnoment…
Read MoreI am trying to start EM on my newly created database, while starting EM, getting failed with OC4J Configuration issue… while diagnosed there is no OC4J_DBConsole_localhost directory exist in ORACLE_HOME.…
Read MoreAfter Completion of oracle clone , faced issue while running autoconfig. ERROR : ——– ERROR at line 1: ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it ORA-06512: at…
Read MoreError : ======= Bad header found during buffer read Data in bad block: type: 2 format: 2 rdba: 0x21008dd0 last change scn: 0x0006.12114f8e seq: 0x37 flg: 0x04 spare1: 0x0 spare2:…
Read MoreWe have 3 ways to find out if a module is installed in oracle apps 1 We can run the following script cd $AD_TOP/sql/adutconf.sql In this script, there is a…
Read MoreFrom oracle 12.1, unified audit trail has been introduced. To enable this audit_trail parameter should be set to none. However we observed that even though ORA_LOGON_FAILURES was available in AUDIT_UNIFIED_ENABLED_POLICIES…
Read MoreRecently I faced a new issue in 12C. In automated maintenance task, sql tuning advisor was already enabled. but its still showing not running. Even I have validated dba_autotask_operation, it…
Read MoreE-Business Suite R12 Concurrent Processing, Output Post Processing related issues Requests fail during Post Processing with the following errors: ‘Unable to find an Output Post Processor service to post-process request…
Read More