We’re going live ina few weeks and and my performance tests showed me a distrubing trend. The oacore processes would consume about 40% CPU between them and were churning out 8 GB’s of stdout files for each managed servers in a few hours.
Opening an SR gave me a method to create a filter that would filterout these message but I had to use the EBS scritps to start and stop these managed servers then. And I liked the WL control console 🙂
After a bit of further digging, I chanced upon Oracle Doc ID 1981206.1, which points to bug 18345006.
JBO DEBUG LOGGING ON WITHOUT -D FLAG, NOTICE LEVEL AND PROD MODE=TRUE
After applying the patch jbo messages are no longer being thrown into teh std out, and the CPU and I/O are very normal now
While applying an online patch today, ADOP failed during the apply phase with the error
AutoPatch error: You must be in Maintenance Mode to apply patches.
You can use the AD Administration Utility to set Maintenance Mode.
Now, this message should never come in an online patch as oracle did away with the Maintenance mode feature with 12.2.4. So what could be the problem?
Several hours and 100’s of log files later, it was found that the tnsnames.ora did not have the proper entry for <SID>_PATCH tns entry. It should have the EBS_PATCH service name in it. The fix was quick – my entry went from
ORCL = (DESCRIPTION=
ORCL_PATCH = (DESCRIPTION=
Lo & behold – APPLY phase went through without any issues. Now, if only Oracle had more meaningful error messages 🙂
To access forms directly in 12.2.4, we need to go to URL
If you have out of the box configuration, you will get the error
APP-FND-01542: This Applications Server is not authorized to access this database
To get this working, you need to modify your current run context file, and chnage the “s_appserverid_authentication” value from SECURE to OFF. Then run Autoconfig on RUN FS.
In Oracle EBS 12.2.4, Rapidclone automatically runs adaddnode.pl. In My case, the adcfgclone.pl appsTier errored out with the below error
sqlplus /nolog @/<serverlocation>/ad/11.5.0/patch/115/sql/adadmdat.sql APPS apps apps
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 159
Going though the adadmdat.sql, I see that it is trying to update the current view snapshot entries. Going through the requirements for Rapidclone on 12.2, I saw that running a full maintin current view snapshow was required.
So on the sourcenode, I ran adadmin and updated the current view snapshot. It takes about 1 hours. After this, remove the entry for the new appltop frmo ad_appl_top and re-run adaddnode.pl
perl adaddnode.pl -appsuser=apps -appspass=apps
We were applying a pre req patch before upgrade from 12.1.1 to 12.1.3. After sourcing the environment , I did OPATCH lsinventory and it gave expected output. After that when we applied OPATCH apply, it errored out with the message
OPATCH_JAVA_ERROR=OPatch Exception While Trying to Check for Mini Patchset
Looking in My Oracle Support did not give much clue. The Note ID 971783.1 OPATCH_JAVA_ERROR=OPatch Exception While Trying to Check for Mini Patchset’ while applying patch using opatch 126.96.36.199.x. This note suggested removing the ‘&’ and ‘<‘ character from the bug description section in the /etc/config/inventory file. However, my inventory file did not have any such characters except the XML tags, which I couldn’t remove.
It was then that I noticed that the patch was unzipped into a path which had a space in the folder name. We renamed the folder to a simpler name, without spaces and the patch proceeded normally.
I read around for strategies on platform migration of EBS R12 and 11g DB. There are paths defined by Oracle which guides such migrations. Given below is a high level description of an oracle endorsed approach of App-Tier migration process. DB migration is a separate topic and should be dealt as such.
- Most of the application tier migration can be done in advance and a very minimal downtime is required. However DB tier migration will require downtime (you have to move the 2 TB data from one place to other!)
- The below steps are explained in detailed in the note (438086.1) which was my reference.
- OS system requirements in the new platform target machine.
- Software requirements on source and target machine (zip, JDK, perl etc)
- Apply the latest AD Patch (R12.AD.B.DELTA.3 for 12.1)
- Upgrade to EBS 12.0.4 or higher
- Apply the latest Autoconfig template patches
- Apply the latest Rapidclone Patches
- Apply Platform Migration Patches & Additional Patches (No Patched advised for 12.1.x at this point of time)
- Run Autoconfig on Source system
- Run adpreclone in source system
- Run maintain snapshot (And this must complete successfully)
- Identify Tech Stack Updates to be done to the Target machine after the migration. This is done by using technology Stack Inventory utility
- Generate and upload the manifest of customer-specific files. This is used to generate a custom migration patch. The custom migration patch created is specific to specific upgrade only and contains all the files contained in the APPL_TOP that are binary specific to the new target platform. This patch is therefore applied in the new environment.
- Copy the Source System to the Target System
- Install JDK and InfoZip utilities on the Target System
- Copy the Source System Context File to the Target System
- Clone the Applications Context File on the Target System
- Install the Application Tier Technology Stack
- Run AutoConfig setup phase on the Target System
- Download and apply the customer-specific update with AutoPatch
- Review Component Versions and Technology Stack patch level
- Regenerate File System Objects
- Clean Nodes
- Run AutoConfig to complete the Target System configuration
- Update Third Party Extensions.
- Review and update Target System Application Tier Settings and Customizations
- Update printer settings
- Update Oracle Workflow configuration settings
- Verify the APPLCSF variable setting
- Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
- Start all services on the Target System
Application Tier Platform Migration with Oracle E-Business Suite Release 12 ID : 438086.1
PROBLEM: Identify a method to update the existing usernames in FND_USER to a value matching the Active Directory username. This is required for implementing stuff like Single Sign On (SSO). The process works fine when done from ERP Application front end, however a simple update of the FND_USER table from back-end does not work.
CAUSE: The reason why a simple update of FND_USER doesn’t work is that Oracle uses Workflows (WF) to maintain this information and when we update the FND_USER the foreign key references in the Workflow are not updated automatically.
SOLUTION:We can use the oracle provided procedure APPS.FND_USER_PKG.CHANGE_USER_NAME () to change the username as well as update the related WF tables.
I tested this on my username SARATHJ and changed it to SARATHJ1. All the responsibilities that existed for the user SARATHJ still exists for the changes user SARATHJ1. I validated this from both back-end and front-end. I could also login to the Application with my old password and work. A script can be written using this API and we can use SQL Loader to import data from a spreadsheet (.xls file) into a table in the Database. Then the API can be called in a loop to update the records. A pseudo code for the same is given below:
1. Place the usernames.xls in the interface directory
2. Run SQL Loader and import data into a loading table in the Database.
3. SQL Script
a. For each row in loading table, call the API.
b. COMMIT every 500 rows