This post covers overview of Forms and Reports Upgrade in Oracle Apps R12 (12.0.X) to 10.1.2.3 Key Points for 10.1.2 upgrade in R12/12i (12.0.X) 1.There are two ORACLE_HOMEs on Application Tier 10.1.2.X for Forms & Reports 10.1.3.X for Web Server & J2EE application 2. By default, R12 uses Forms Servlet Architecturefor forms requests (to know more […]
Read MoreIf you follow Steven Chan’s blog you probably know that Oracle Apps Release 12.1.1 is available for download now. Last week I installed version 12.1.1 for Oracle Apps DBA training here ; error and fix below (oom-killer) Technology Stack changes in 12.1.1 1. Default database version is 11g (10g in 12.0.X ; 9i in 11i) 2. Default forms and report version is […]
Read MoreJVM Caching :- Cache is simply a copy or pre-fetched date stored away from the original data, there are few well known computing caches hits us as bellow # Oracle Database Buffer Cache of the SGA # Disk Cache # CPU Cache # Web Cache and in this scenario it is Java Cache. Similarly data […]
Read MoreIf you are upgrading your system (or planning to upgrade) to ATG roll up 4, 5 or 6 or using R12 (12.0.X to 12.1.X); beware of below common intermittent issues around Web Server (Apache/Jserv/OC4J/JVM) for 11.5.10 and R12 – Responsibility not visible to users –NoCalssDef found error in JVM logs –Intermittent hang in JVM (Jserv/Apache) –Intermittent page not found […]
Read MoreThis post covers broad level steps to introduce additional middle/application tier to accommodate more application users or for resilience. This document is based on Rapid Clone to add new Application Tier/Node. . Top Level Steps 1. Run Rapid Clone (preclone) on existing middle tier Node; perl adpreclone.pl appsTier 2. Copy middle tier file system from existing middle […]
Read MoreKey Points for Oracle Application Server 10.1.3 Upgrade in R12 1. There are two Oracle Homes under application tier in R12 (Total three , third one is database oracle home) a) 10.1.2 for forms & reports b) 10.1.3 for Web (Apache) and J2EE (OC4J for oacore, oafm and forms) Two Oracle Home (10.1.2 and 10.1.3) […]
Read MoreServices (new concept introduced in R12) define the set of processes that will be started on each application node. These services can be activated or deactivated on a specific application tier/node. . Type of Application Services Application tier processes are broadly classified in to five type of Services i) Root Service – Oracle Process Manager and […]
Read MoreOracle Apps 11i/R12 provides standard Concurrent Manager request “Signon Audit Unsuccessful Logins” to report all failed login attempts for 11i/R12 but if your Oracle E-Business Suite (11i/R12) is integrated with Oracle Single Sign-On (where 11i/R12 authentication is happening at SSO) then you need to look in to SSO table. Do not use “Signon Audit Unsuccessful Logins” for […]
Read MoreYour Oracle Apps 11i/R12/12i instance is currently integrated with Oracle Single Sign-On (SSO) & Oracle Internet Directory (OID) and you would like to remove integration (so that apps 11i/R12 instead of redirection to SSO, authentication happens at FND_USER). Broad level steps to deregister apps (11i/R12) from SSO 1. Deregister Oracle Apps (11i/R12) from OID and […]
Read MoreTurn on Logging In order to know, which listener commands were executing, one should enable the logging by the following: LSNRCTL> set log_directory …/log LSNRCTL> set log_file Listener_<sid name>.log LSNRCTL> set log_status on LSNRCTL> save_config Set the Listener Password Setting Listener Password is strongly recommended in order to prevent the distinct attacks. There are two […]
Read More