Last evening, Mukhtiar called me to assist in Demantra installation on Windows. By the time we got on screen share, he had already downloaded patch 2195481 and installed JDK 1.8.0_77. However, when he clicked setup.exe, nothing happened. We tried these :
1. Right click on setup.exe > Click Properties > Compatibility Tab > Run this program in compatibility mode for Windows XP 2. Run the program as Administrator 3. Tried changing registy settings as per some microsoft technotes
For an old 188.8.131.52 ERP, we are moving from the architecture of "EBS application server in DMZ" to the architecture of "Reverse Proxy in DMZ and EBS application server in intranet". After doing all configurations, we hit the classic issue where, you login through extranet url visible on public internet which redirects to intranet url.
So https://extranet.example.com asks for SSO details and after keying in SSO username and password goes to http://intranet.example.com.
At this time of the year during holidays, the Apps DBA community is busy doing upgrades as longer downtimes are possible. In case you are facing any issues, please feel free to write to me at my email: firstname.lastname@example.org . I will be glad to hear from you and help you.
We are currently upgrading one of our ERP instances from 184.108.40.206 to R12.2.5. One of the pre-upgrade steps is to execute the data fix script ap_wrg_11i_chrg_alloc_fix.sql. However, this script has been running very very slow. After 4 weeks of monitoring, logging SRs with Oracle, escalating etc., we started a group chat today with our internal experts. We had Ali, Germaine, Aditya, Mukhtiar, Martha Gomez and Zoltan. I also invited our top notch EBS Techstack expert John Felix.
We have used OEL 6.6 image in our latest build. When we cloned an EBS R12.2 instance that was on OEL 5.7 to this new server that has OEL 6.6, During the clone, adcfgclone.pl was failing. On further checks, we discovered that sqlplus is crashing with segmentation fault error whenever we tried to connect to database:
sqlplus /nolog conn apps/apps Segmentation Fault
So, I suggested the DBAs to do strace sqlplus apps/apps. The strace revealed many missing libraries:
Today, during a cutover when we were moving one of our ERP instance on Cisco UCS VMware VMs to Exalogic and Exadata, I got a call from Bimal. The extranet iSupplier URL had been configured, but whenever any user logged in, they were seeing the following error instead of the iSupplier OAF Home page:
Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured
Recently I spent almost a full day struggling to make out, why an sftp connection would not work without password, after setting up ssh equivalence. The keys were correct, the permissions on the directories were correct. The authorized_keys file looked ok. I copied the authorized_keys file of another account that was working fine. When I replaced the authorized_keys after taking backup of original authorized_keys, it started working. So then I proceeded to check the contents in a hex editor
While doing a google search today I noticed that there is another blog that has copied all content from my blog and posted it as their own content and even kept a similar sounding name: http://oracleapps-technology.blogspot.com . I have made a DMCA complaint to google about this. I will update this article about how it goes.
With the release of AD and TXK Delta 6, Oracle has provided the feature of single file system on development instances for R12.2. Here's what they have mentioned in support.oracle.com article: Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)
I got this error while upgrading an R12.1.3 instance to R12.2.4, when I completed AD.C.Delta 5 patches with November 2014 bundle patches for AD.C and was in the process of applying TXK.C.Delta5 with November 2014 bundle patches for TXK.C :
Validation successful. All expected nodes are listed in ADOP_VALID_NODES table. [START 2015/03/01 04:53:16] Check if services are down [INFO] Run admin server is not down [WARNING] Hotpatch mode should only be used when directed by the patch readme.
Alok and Shoaib pinged me about this error. This error is reported in logs when adcfgclone.pl is run for a R12.2.4 appsTier where the source and target instances are on same physical server.
SEVERE : Jan 27, 2015 3:40:09 PM - ERROR - CLONE-20372 Server port validation failed. SEVERE : Jan 27, 2015 3:40:09 PM - CAUSE - CLONE-20372 Ports of following servers - oacore_server2(7256),forms_server2(7456),oafm_server2(7656),forms-c4ws_server2(7856),oaea_server1(6856) - are not available. 4:00 PM
Anil pinged me today when his adop phase=fs_clone failed with this error message:
----------------------------- ERROR: The following required ports are in use: ----------------------------- 6801 : WLS OAEA Application Port Corrective Action: Free the listed ports and retry the adop operation.
Sravan came across this error while using SSO enabled URL for R12.2
URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.
This occurs for any user that is newly created. The user_guid column is not populated. Here is the Solution:
ssoreg_r12_linux erppgai1 DEV appspassword cleanup ssoreg_r12_linux erppgai1 DEV appspassword dereg
This information is from page 75 of Oracle® E-Business Suite Maintenance Guide Release 12.2 Part No. E22954-13, published in July 2013 available here http://docs.oracle.com/cd/V39571_01/current/acrobat/122ebsmt.zip
During an R12.2 upgrade, the worker icxr12pd.sql takes very long time. This is document in My Oracle Support Article ICXR12PD.Sql Runs Slowly During Upgrade to 12.1.1 (Doc ID 864898.1) Cause: The pre-upgrade steps for iProcurement were not implemented as documented in the upgrade guide
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.
If there is an issue with the oacore managed server, meaning apache is not able to connect to the oacore managed server, you'll see this error.
It is possible that the managed server oacore is not yet started, and you try to access the EBS URL. It is possible that the managed server for oacore is not able to start up because of a port conflict.
Manoj pinged me about this issue last night. Whenever he was trying to do adpreclone.pl dbTier or AppsTier, when he entered the apps password, the process would crash with either segmentation fault, bus error or out of memory.
I tried executing top and it was also ending up with segmentation fault some of the time. At the times it would start, it would give a flashing
I checked the server memory and it had 73 GB free memory.
Shoaib pinged me today. He was getting this error duing AutoConfig on DB node:
* ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.FND_CORE_LOG", line 318 ORA-06512: at "APPS.FND_CORE_LOG", line 62 ORA-06512: at "APPS.FND_CORE_LOG", line 456 ORA-06512: at "APPS.FND_PROFILE", line 110 ORA-06512: at "APPS.ADX_PRF_PKG", line 203 ORA-06512: at line 7