Differences between data dictionary views and V$ views
Here are the differences between data dictionary views and V$ views, in Oracle. Data Dictionary Views : 1. Data will not be lost even after the instance is shutdown .…
Read MoreAdop Fails With Error: ssh is not enabled for the following nodes
Getting the following error applying a patch running Adop: adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context :…
Read MoreConcurrent manager become up after 3-4 hours after start Oracle Application
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 MoreAll RDF Reports Running Forever With No Completion
Problem: 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 MoreHow to change EBS R12 Database and Application Port Number
Execute 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 MoreOC4J Configuration issue… OC4J_DBConsole_ not found.
I 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 MoreAutoconfig Issues seen after a Clone
After 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 MoreCorrupt Block alert in Alert Log
Error : ======= 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 MoreWays To find whether the module is installed or not in Oracle Applications
We 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 More12C : Unified Audit Trial was not captured during successful Login and Failures
From 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 More