With the launch of Oracle Applications R12.2 Upgrade training by Oracle ACE & Author, Atul Kumar and Oracle R12 Upgrade specialist, Amit Sharma, we saw amazing response from Oracle Apps DBAs who wanted to learn R12.2 upgrade training. Unfortunately, We had to close the registration for Oracle E-Business Upgrade to R12.2 training early as we were fully booked (We limit the number of trainees in a batch to ensure Quality of the training and individual attention we provide to each trainee for Hands-On).
After few days of the Oracle E-Business Suite 12.2 Upgrade Training, Atul & Team K21Academy thought why not share what we cover in our training and kind of questions Apps DBAs have with everyone (specially those couldn’t join our training as we closed registration for R12.2 Upgrade course early) . In this blog series you will get insight of what we are covering in our training, things you should be learning , kind of questions you should have and try to answer others questions related to R12.2 Upgrade .
Today we are going to talk about key points that we covered in Day 1 session of Oracle R12.2 Upgrade Training for Apps DBAs. Day 1 of the workshop started with Module covering – 12.2 Architecture , Technology Stack and key changes in R12.2 with an explanation of the components like Oracle Fusion Middleware , WebLogic Console in Oracle R 12.2, managed servers like oacore, oafm etc
And here is one of the slide from the session
Covering five categories of the R12.2 Upgrade from Day 1
- R12.2 Architecture
- Files System Changes
- Online Patching – ADOP
- Comparison 12.1 and 12.2
- R12.2 Features – Apps DBA perspective
We covered high level overview of R12.2 architecture with emphasis on the new Fusion Middleware Components and also discussed on File system changes (DUAL File System).
We are supposed to cover Online Patching (ADOP) and compare key differences between R12.1 and R12.2 but because of lots of questions (We encourage to ask lot of questions in live sessions), We only covered about Architecture and File system changes in Day1 (Remaining things to come in Day 2 of Oracle Apps DBA Training for R12.2 Upgrade from 12.1/12.0 and 11i).
Here are just some of the questions along with the answers that we discussed and worth sharing :
Q1) Is Gridlink supported in R12.2 to connect from WebLogic to Database ?
A1) As per My Oracle Support # 2017419.1 Can Be The EBSDataSource in 12.2 Be Replaced By A MultiDataSource Or GridLink Datasource , this is not supported in
Q2) Is Oracle Database 12c in-Memory Option Suported in R12.2
A2) Yes it is supported
Q3) Limitations on upgrading database to Oracle 12c1
A3) Key features like Database Vault and Transportable Tablespace/Database is not yet supported
Q4) Can Admin server be in Oracle Apps 12.2 clustered?
A4) No, Admin Server is a singleton service that means it will always run in Active-Passive mode
Q5) What is forms-c4ws managed server used for in R12.2 ?
A5) Forms client end point for SOA, should be used only if SOA is integrated and if it needs forms as an end point.
Q6) Can application deployed on Admin Server of WebLogic in R12.2 ?
A6) Technically you can deploy application on Admin Server but this is Not Recommended
Q7) Does Admin server use the JDBC connection pool ?
A7) If you look at JDBC deployment (We cover this in theory and practical part of Oracle EBS/Financial/HRMS upgrade training from 11i/12.0/12.1 to 12.2.4 or 12.2.5 ) JDBC is targeted to only oacore and forms managed server in WebLogic Domain for R12.2 . This means as of 12.2.5 Admin Server doesn’t uses JDBC connection to EBS database.
Q8) Can we expose entire Appplications (Forms & Self Service) to the Web?
A8) Technically you can but No, it is not recommended to expose entire application to the net, only specific modules which are hardened for internet access like iexpenses/irecruitment should be exposed to internet.
Q9) How to debug oacore in R12.2 when compared with R12.1 ?
A9) In R12.2 $EBS_DOMAIN_HOME/servers/<servername>/logs contains the oacore managed server logs which is different compared to $INST_TOP/logs/ora/10.1.3/j2ee/oacore/<oacore jvm> in R12.1
Q10) Will FS1 & FS2 contain the same directory structure ?
A10) FS1 and FS2 are dual file system introduced in EBS R12.2 . Yes it will contain same directory structure and updated or sync’d (We cover this in patching section using ADOP)
Q11) Do we have situations where managed server fails due to heap size issues ?
A11) Yes, it does fail, either due to incorrect configuration or known bugs which are covered as part of this course but it can be monitored easily through the weblogic console.
Q12) Will each OHS/Apache instance have its own instance home ?
A12) Yes it will have, one for each of the node.
Q13) Is SSL supported for R12.2
A13) Yes, it is supported. We also refer My Oracle Support notes for configure SSL in R12.2
I am interested How can I learn the more ??
If you want to learn Oracle EBS Upgrade R12.2 (Financials, HRMS, SCM, Techincal) Upgrade to R12.2 at a faster pace with tons of features like Dedicated Machine to Practice, Live Sessions, Support, Retaking Sessions for next 1 Year and much more. Then you can also check out our paid workshop by visiting https://k21academy.com/oracle-ebs-upgrade or on blog here or
Did you download FREE 7 Docs every Oracle Apps DBA must read before Upgrading to Oracle R12.2 ?
Having a question related to your Oracle E-Business Suite Upgrade to 12.2 or Training for Oracle ACE , Atul Kumar then post under comments below for instant reply.