After 12.2.5 upgrade , adapcctl not able to start

After R12.2.5 upgrade, we started application services but adapcctl failed to start.

The below error , we were getting

adapcctl.sh version 120.0.12020000.6 
adapcctl.sh: starting OPMN if it is not running 

line 161: /a01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_ORION_OHS1/bin/opmnctl: No such file or directory


The problem was resolved after recreate the domain using perl txkEBSDomainConfig.pl.

After upgrade R12.1.3 to R12.2.5 with 12C db - other managers were not coming up although Internal manager was up

After successful upgrade from R12.1.3 with 11.2.0.3 database to R12.2.5 with 12c database. Internal manager is started but other managers failed to start.

We run the recovery wizard as MOS note id 134007.1 . But it also not helped to resolve this issue.
In one of the note we found  to recreate the     FNDSM libraries and create managers. 

By running the script afdcm037.sql , the remaining managers started  .

ORA-00700 in 12C Database alert log

This is  a warning message in 12C , which shows the heavy swapping is happening . Need to monitor the Database server memory utilization , O/S memory utilization. 

After Upgrade WebTier of eBS 12.2 to the 11.1.1.9 got - fs_clone failed

Running fs_clone failed with below error

START: Precloning the OHS Config.

Running /a01/TEST/fs2/FMW_Home/webtier/perl/bin/perl /a01/TEST/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetOHSConfig.pl preCloneInstance -ctxfile=/a01/TEST/fs2/inst/apps/TEST_orion001/appl/admin/TEST_orion001.xml -t2plogloc=/a01/TEST/fs2/inst/apps/TEST_orion001/admin/log/clone/ohsT2PStage -logdir=/a01/TEST/fs2/inst/apps/TEST_orion001/admin/log/clone -console=off

Script Executed in 501 milliseconds, returning status 1

ERROR: Script failed, exit code 1

Solution :

1. Revert cipher configuration from opmn.xml  file    $IAS_ORACLE_HOME/instances/EBS_web_<sid>_ohs#/config/OPMN/opmn/opmn.xml

2. Revert cipher configuration from admin.conf file   $IAS_ORACLE_HOME/instances/EBS_web_<sid>_ohs#/config/OHS/EBS_web_<sid>

Upgrade eBS R12.2.4 Oracle Database from 11.2.0.3 to 11.2.0.4

It involves number of steps to upgrade eBS R12.2.4 running on version 11.2.0.3 to 11.2.0.4. 
Before upgrade one should go thru the Oracle notes as there may be new patches released , which make the upgrade more smooth. 
I have upgraded this in the month of Oct'2016 , which contains all patches released that time. 
There will be more patches after Oct'2016. Refer the Oracle docs and CPU patches released quarterly.

In my case OLD ORACLE HOME : /d01/database/11.2.0.3
           NEW ORACLE HOME : /d01/database/11.2.0.4 

Preparation Steps

1. Download  the Oracle Database 11.2.0.4 using the valid CSI and unzip the file (/d01/software/)


2. Create one directory (created /d01/database/11.2.0.4) in the   
   ORACLE_BASE directory , where the old oracle home (/d01/database/11.2.0.3 ) exist

3. Goto the unzip location (/d01/software/database) and run the   
 below to install 11.2.0.4 software in (/d01/database/11.2.0.4)  location , which you have created in step 1.


   [/d01/software/database]$ ./runInstaller


 

  

If you wish to receive security updates provide information  like CSI /email  address Uncheck this,if you donot want to receive the updates

                           Note: Select “Install database software only”

                           Note: Select “Single instance database installation”

                     Keep the ORACLE BASE and Software Location information

      Click Next and then Install to start Oracle Software installation

       At the end of the installation, open new session and login as root  user . 

4. Install Oracle Database 11g Products from the 11g Examples CD)

5.  Apply additional 11.2.0.4 RDBMS patches – NEW ORACLE HOME

    Note :Do not run any of the post install instructions as those  will be done after the upgrade 

  The list of patches which were applied at the time of my upgrade 

  13417321,16075609,18604144,18708921,18966843,19835133,19949371

20488666,20523280,20678391,21249127,21286665,21321429,21864513

1904072 22180766,22307372,22496904,22731026,22876444,234778496

6. Create nls/data/9idata directory  - New home

  perl $ORACLE_HOME/nls/data/old/cr9idata.pl

  Verify the $ORACLE_HOME/nls/data/9idata directory  created successfully

7.Install JRE 6 or 7  - New Home

    Create the appsutil directory if it does not exist      

    

8.Database Upgrade

Ensure  Applications patching cycle is complete

Shut down Applications server processes and old database listener

9. Drop SYS.ENABLED$INDEXES from OLD Database

10. Run the Pre-Upgrade Information Tool (utlu112i) from OLD ORACLE HOME

Take necessary action based on the report generated after running utlu112i script

to be continue

Change APPLSYSPUB password in eBS R12.2

1.  Shutdown Application Server

2. Change APPLSYSPUB Password using FNDCPASS utility

3. Change the APPLYSYPUB password in $CONTEXT_FILE in two places

     grep s_gwyuid $CONTEXT_FILE

     grep s_gwyuid_pass $CONTEXT_FILE

4.  Run Autoconfig