Tips to Maximize performance and scalability of Oracle E-business Suite 11i

Application Tier: Forms Forms performance issues may arise when dead connection persists on the server and consuming the server resources. Enable the forms dead client connection can eliminate the dead connection. FORMS60_TIMEOUT=10 (recommended value and value specified in minutes) Do $ ps –ef| grep f60webmx and terminates f60webmx processes for dead clients. Enable Forms Abnormal […]

Read the rest of this entry »

DB Console issue after cloning 11.5.10.2 environment

DB Console issue after cloning 11.5.10.2 environment Issue: – 1 — On Applications 11.5.10.2 with RDBMS 11.1.0.7: After cloning dbconsole cannot start. When Checking the $ORACLE_HOME/bin directory and the following emagent, emdctl programs are missing. Step by Step Solution to start and discover DB target to DB Console in Stat and elabs Environments: 1)     Source […]

Read the rest of this entry »

Oracle E-Business Suite 11i to R12 Quick Transition

Here are some capsules for Oracle E-Business Suite 11i to R12 knowledge transition. Tech Stack Client Sun 1.5 Plug-in Middle Tier Application Server 10.1.3 Application Server 10.1.2 $ORACLE_HOME version (prev 8.0.6): /orachat/product/tech_st/10.1.2 $ORACLE_HOME version (prev 8.1.7): /orachat/product/tech_st/10.1.3 RDBMS Tier Oracle 10g R2 XDK XDB Scripts Also you can refer my previous post @ onlineappsdba …….. […]

Read the rest of this entry »

adpatch options

adpatch options Few of our dbas are still not clear about the helpful features of adpatch utility with command line options.If you are in a production downtime to do some patching activity, especially for some rollup upgrade, your downtime will end up with series of pre and post patches. In Such a scenario, it is […]

Read the rest of this entry »

Gather Schema Statistics with LASTRUN Option does not Clean FND_STATS_HIST Table

After running Gather Schema Statistics concurrent request with (LASTRUN) option to save only the history for last run, then run the concurrent request again for 2 times after that found that (FND_STATS_HIST) tables contains the history for all the 3 requests and it is not cleaned up to keep only last run. Sample steps to […]

Read the rest of this entry »

Notice to Oracle E-Business Suite Customers: Correction to Export/Import Notes (Doc ID 1055539.1)

If you conducted an import or export of an Oracle10g Release 2 or 11g Release 1 database prior to September 11, 2009, you should follow the instructions in My Oracle Support Knowledge Document 1055539.1 to verify the privileges in your database. This is because a missing step in several OracleMetaLink notes published before 11 September […]

Read the rest of this entry »

R12 RAC Cloning

RAC Cloning Details Note  : 559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems Patch : 5767290  : RAC-TO-RAC SUPPORT WITH RAPIDCLONE Supported Scenarios R12 Autoconfig Enabled on the dbTier and appsTier RAC conversion performed using on Note 388577.1. (This is the only RAC conversion method supported with Rapid Clone) […]

Read the rest of this entry »

FNDLOAD – Some live experiences

FNDLOAD – One of handy apps utility, especially when we are working in oracle application implementation projects. A good companion for data migration, code migration across various implementations. FNDLOAD assists us to download data from application entity to an editable text file, we can do the necessary changes and upload to another database. Say for […]

Read the rest of this entry »
|