Modern Oracle DBA

Encountering configuration issues post-cutover. However, here's a straightforward solution to resolve these errors efficiently. Follow these steps to modify the config.xml file and get your system back on track. Solution:  Go to config.xml locatation and take backup for the "config.xml" file cd /apps/applmgr/r12/fs1/FMW_Home/user_projects/domains/EBS_domain/config/ ls -ltr config.xml cp config.xml config.xml_bkp Search the config.xml file in " connection-filter-rule " Change the value " deny "  to " allow " [applmgr@vtebstest config]$diff config.xml_bkp config.xml 33d32 <     <OTM >vtebstest.appl.com * * allow </connection-filter-rule> 35d33 <     <connection-filter-rule>0.0.0.0/0 * * deny </connection-filter-rule> [applmgr@vtebstest config]$ Save the config.xml file and bounce the adadminsrvctl.sh Login weblogic page and retest the issue

 Login to the DB Server and execute below commands Copy SQL> select count(*) from WRH$_ACTIVE_SESSION_HISTORY; COUNT(*) ------------------ 0           Copy SQL> alter system set "_ash_enable"=false; System altered.   Copy SQL> alter system set "_ash_enable"=true; System altered.   Login in to OEM and Retest the issue Reference:- OEM Top Activity Graphs Are Not Displayed (Doc ID 2229483.1)

Here I have collected the List of good Oracle Apps DBA interview Questions/Answers. How Many Oracle homes there in R12.2? Oracle 10.1.2 home and Oracle fusion middleware home oracle application is running on top of the FMW home. What is EBR? Edition based redefinition is R12.2 online patching new fecture. EBR has been introduced in 11g R12 database EBR is allows multiple version of plsql objects views and synonyms in single schema. EBR is enabled via database users and all EBS users including custon schemas. While running adadmin What is batchsize parameter in EBS? It means number of rows to commit at one time to the Database.  What is multi ligual tables in ebs? EBS applications allow users to create their programs in a variety of languages.   Ex:-   If table name ending with "_TL" those tables are corresponding to another table with same name minus the _TL those tables provide the multiple language support.   FND_PROFILE_OPTIONS_TL FND_PROFILE_OPTIONS