Friday, February 7, 2014

How To Apply Patch In Oracle Application

Patching is one of the very basic task that DBA perform. Well I am not out here as DBA, though I like stuffs what they do. I believe many out there love to have there own Vision Demo instance to check out seeded functionality and explore new solutions. Vision Demo comes with basic setups and don’t carry latest patches and fixes. So we may end up having very basic functionality and not able to explore new features. That brings us here to understand how can we apply patch.
Lets get started…
There are steps involved in applying patch to Oracle Applications.
  • Validate Patch In Oracle Application :- Before proceeding any further first check if the patch is already applied to the instance or not. To check if the patch is already applied follow the this post - Check Patch in Oracle Application
  • Download Patch : Get the patch from Oracle Support (Best know as - Metalink) and go through the readme file. This will tell you if any pre-requisite is there and if you need to perform any activity after patching. Following screenshots will tell you how to down and go through readme file.
Image 013 Image 014Image 015 Image 017
  • Transfer File : You need to put the downloaded patch file to Oracle Application file system. You can use any FTP tool like WinSCP, I love light and handy plugin ‘FireFTP’ comes with Firefox. I have created a patch directory for all my patching activities.
Image 001
  • Unzip the file. Make sure you have the file path handy with you as you will be needing it later in the stage. Also take a note the “.drv” file. This is the patch driver file which drives the patching activities. There are possibility that a patch is updating multiple file including .pls, .fmb, .rdf etc… and driver file takes care which should be applied and how.
    • login as: oracle
      oracle@192.168.56.200's password:
      Last login: Wed Feb  5 23:38:44 2014 from 192.168.56.1
      [oracle@ebsapp ~]$ cd /u01/patch
      [oracle@ebsapp patch]$ ls *12976183*
      p12976183_R12.OKS.B_R12_GENERIC.zip
      [oracle@ebsapp patch]$ unzip p12976183_R12.OKS.B_R12_GENERIC.zip
      Archive:  p12976183_R12.OKS.B_R12_GENERIC.zip
        inflating: 12976183/README.html
        inflating: 12976183/u12976183.drv
        inflating: 12976183/f12976183.ldt
        inflating: 12976183/okc/patch/115/odf/OKCSHD1.odf
        inflating: 12976183/okc/patch/115/sql/OKCRSTSB.pls
        inflating: 12976183/marker1.txt
        inflating: 12976183/b12976183.ldt
        inflating: 12976183/README.txt
        inflating: 12976183/patch_metadata.xml
      [oracle@ebsapp patch]$ cd 12976183
      [oracle@ebsapp 12976183]$ ls
      b12976183.ldt  marker1.txt  patch_metadata.xml  README.txt
      f12976183.ldt  okc          README.html         u12976183.drv
      [oracle@ebsapp 12976183]$ pwd
      /u01/patch/12976183
      [oracle@ebsapp 12976183]$

Image 037
  • Stop Application Services : - Login to Application Tier (Unix Box) with Oracle/ApplMgr user and stop all the application tier services. This is really import. You don’t want any body using the application or services while patch modifies the application files.
    • If you have a script handy that calls the “adstpall.sh” then execute that. Other wise move to $ADMIN_SCRIPTS_HOME and run the script
  • login as: oracle
    oracle@192.168.56.200's password:
    Last login: Sun Feb  2 16:15:35 2014 from 192.168.56.1
    [oracle@ebsapp ~]$ . /u01/E-BIZ/apps/apps_st/appl/APPSVIS_ebsapp.env
    [oracle@ebsapp ~]$ cd $ADMIN_SCRIPTS_HOME
    [oracle@ebsapp scripts]$ pwd
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts
    [oracle@ebsapp scripts]$ ls
    adalnctl.sh   adforms-c4wsctl.sh  adopmnctl.sh   ieo          mwactlwrpr.sh
    adapcctl.sh   adformsctl.sh       adpreclone.pl  java.sh
    adautocfg.sh  adformsrvctl.sh     adstpall.sh    jtffmctl.sh
    adcmctl.sh    adoacorectl.sh      adstrtal.sh    msc
    adexecsql.pl  adoafmctl.sh        gsmstart.sh    mwactl.sh
    [oracle@ebsapp scripts]$ sh adstpall.sh
    
    You are running adstpall.sh version 120.10.12010000.4
    
    
    Enter the APPS username: apps
    
    Enter the APPS password:
    The logfile for this session is located at /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstpall.log
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/jtffmctl.sh stop
    script returned:
    ****************************************************
    
    You are running jtffmctl.sh version 120.3
    
    Shutting down Fulfillment Server for VIS on port 9302 ...
    
    jtffmctl.sh: exiting with status 0
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adcmctl.sh stop
    script returned:
    ****************************************************
    
    You are running adcmctl.sh version 120.17.12010000.5
    
    Shutting down concurrent managers for VIS ...
    ORACLE Password:
    Submitted request 5821431 for CONCURRENT FND SHUTDOWN
    
    
    adcmctl.sh: exiting with status 0
    
    
    adcmctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adcmctl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adoafmctl.sh stop
    script returned:
    ****************************************************
    
    You are running adoafmctl.sh version 120.8
    
    Stopping OPMN managed OAFM OC4J instance ...
    
    adoafmctl.sh: exiting with status 0
    
    adoafmctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adoafmctl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adformsctl.sh stop
    script returned:
    ****************************************************
    
    You are running adformsctl.sh  version 120.16.12010000.3
    
    Stopping OPMN managed FORMS OC4J instance  ...
    
    adformsctl.sh: exiting with status 0
    
    adformsctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adformsctl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adoacorectl.sh stop
    script returned:
    ****************************************************
    
    You are running adoacorectl.sh version 120.13
    
    Stopping OPMN managed OACORE OC4J instance ...
    
    adoacorectl.sh: exiting with status 0
    
    adoacorectl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adoacorectl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adapcctl.sh stop
    script returned:
    ****************************************************
    
    You are running adapcctl.sh version 120.7.12010000.2
    
    Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
    opmnctl: stopping opmn managed processes...
    
    adapcctl.sh: exiting with status 0
    
    adapcctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adapcctl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adalnctl.sh stop
    script returned:
    ****************************************************
    
    adalnctl.sh version 120.3
    
    Shutting down listener process APPS_VIS.
    
    adalnctl.sh: exiting with status 0
    
    
    adalnctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adalnctl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    Executing service control script:
    /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adopmnctl.sh stop
    script returned:
    ****************************************************
    
    You are running adopmnctl.sh version 120.6.12010000.5
    
    Stopping Oracle Process Manager (OPMN)  and the managed processes ...
    opmnctl: stopping opmn and all managed processes...
    
    adopmnctl.sh: exiting with status 0
    
    adopmnctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adopmnctl.txt for more information ...
    
    
    .end std out.
    
    .end err out.
    
    ****************************************************
    
    
    All enabled services on this node are stopped.
    
    adstpall.sh:Exiting with status 0
    
    adstpall.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstpall.log for more information ...
    
    [oracle@ebsapp scripts]$

Image 021 Image 022
  • Enable Maintenance Mode :- This is required to enable system where it can apply patches.
    • To enable maintenance mode please execute command “adadmin” and follow the steps.
    • Script will validate the details of the system. Please check the details and if default value seems correct you press ‘ENTER’. It will validate :-
      • Application Top
      • Log File Name
      • Batch Size
      • Database Name
      • SYSTEM schema password. In my case its default ‘manager’.
      • APPS schema password. In my case its default ‘apps’.
    • In the Administration console/menu choose ‘5’ to Change Maintenance Mode.
    • In the next screen choose ‘1’ to Enable Maintenance Mode
    • Return to main menu and then exit AD Administration console.
    • [oracle@ebsapp scripts]$ adadmin
      
                           Copyright (c) 2002 Oracle Corporation
                              Redwood Shores, California, USA
      
                           Oracle Applications AD Administration
      
                                       Version 12.0.0
      
      NOTE: You may not use this utility for custom development
            unless you have written permission from Oracle Corporation.
      
      Your default directory is '/u01/E-BIZ/apps/apps_st/appl'.
      Is this the correct APPL_TOP [Yes] ?
      
      AD Administration records your AD Administration session in a text file
      you specify.  Enter your AD Administration log file name or press [Return]
      to accept the default file name shown in brackets.
      
      Filename [adadmin.log] :
      
      ************* Start of AD Administration session *************
      AD Administration version: 12.0.0
      AD Administration started at: Wed Feb 05 2014 23:46:59
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      You can be notified by email if a failure occurs.
      Do you wish to activate this feature [No] ?
      
      Please enter the batchsize [1000] :1
      Please enter the name of the Oracle Applications System that this
      APPL_TOP belongs to.
      
      The Applications System name must be unique across all Oracle
      Applications Systems at your site, must be from 1 to 30 characters
      long, may only contain alphanumeric and underscore characters,
      and must start with a letter.
      
      Sample Applications System names are: "prod", "test", "demo" and
      "Development_2".
      
      Applications System Name [VIS] : VIS *
      
      
      NOTE: If you do not currently have certain types of files installed
      in this APPL_TOP, you may not be able to perform certain tasks.
      
      Example 1: If you don't have files used for installing or upgrading
      the database installed in this area, you cannot install or upgrade
      the database from this APPL_TOP.
      
      Example 2: If you don't have forms files installed in this area, you cannot
      generate them or run them from this APPL_TOP.
      
      Example 3: If you don't have concurrent program files installed in this area,
      you cannot relink concurrent programs or generate reports from this APPL_TOP.
      
      
      Do you currently have files used for installing or upgrading the database
      installed in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have Java and HTML files for HTML-based functionality
      installed in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have Oracle Applications forms files installed
      in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have concurrent program files installed
      in this APPL_TOP [YES] ? YES *
      
      
      Please enter the name Oracle Applications will use to identify this APPL_TOP.
      
      The APPL_TOP name you select must be unique within an Oracle Applications
      System, must be from 1 to 30 characters long, may only contain
      alphanumeric and underscore characters, and must start with a letter.
      
      Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
      
      APPL_TOP Name [ebsapp] : ebsapp *
      
      
      
      You are about to use or modify Oracle Applications product tables
      in your ORACLE database 'VIS'
      using ORACLE executables in '/u01/E-BIZ/apps/tech_st/10.1.2'.
      
      Is this the correct database [Yes] ?
      
      AD Administration needs the password for your 'SYSTEM' ORACLE schema
      in order to determine your installation configuration.
      
      Enter the password for your 'SYSTEM' ORACLE schema:
      
      
      The ORACLE username specified below for Application Object Library
      uniquely identifies your existing product group: APPLSYS
      
      Enter the ORACLE password of Application Object Library [APPS] :
      
      AD Administration is verifying your username/password.
      The status of various features in this run of AD Administration is:
      
                                                 <-Feature version in->
      Feature                          Active?   APPLTOP    Data model    Flags
      ------------------------------   -------   --------   -----------   -----------
      CHECKFILE                        Yes       1          1             Y N N Y N Y
      PREREQ                           Yes       6          6             Y N N Y N Y
      CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
      PATCH_TIMING                     Yes       2          2             Y N N Y N Y
      PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
      SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
      JAVA_WORKER                      Yes       1          1             Y N N Y N Y
      CODELEVEL                        Yes       1          1             Y N N Y N Y
      
      
      
      Identifier for the current session is 543213
      
      Reading product information from file...
      
      Reading language and territory information from file...
      
      Reading language information from applUS.txt ...
      
      AD Administration warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/zfaprod.txt
       does not exist for product "zfa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      AD Administration warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/zsaprod.txt
       does not exist for product "zsa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      AD Administration warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/jtsprod.txt
       does not exist for product "jts".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      Reading database to see what industry is currently installed.
      
      Reading FND_LANGUAGES to see what is currently installed.
      Currently, the following language is installed:
      
      Code   Language                                Status
      ----   --------------------------------------- ---------
      US     American English                        Base
      
      Your base language will be AMERICAN.
      
      Setting up module information.
      Reading database for information about the modules.
      Saving module information.
      Reading database for information about the products.
      Reading database for information about how products depend on each other.
      Reading topfile.txt ...
      
      Saving product information.
      
      AD code level : [B.3]
      
                  AD Administration Main Menu
         --------------------------------------------------
         1.    Generate Applications Files menu
      
         2.    Maintain Applications Files menu
      
         3.    Compile/Reload Applications Database Entities menu
      
         4.    Maintain Applications Database Entities menu
      
         5.    Change Maintenance Mode
      
         6.    Exit AD Administration
      
      
      
      
      
      
      
      
      
      Enter your choice [6] : 5
      
                   Change Maintenance Mode
         ----------------------------------------
      Maintenance Mode is currently: [Disabled].
      
      
      Maintenance mode should normally be enabled when patching
      Oracle Applications and disabled when users are logged on
      to the system.  See the Oracle Applications Maintenance
      Utilities manual for more information about maintenance mode.
      
      
      Please select an option:
      
         1.    Enable Maintenance Mode
      
         2.    Disable Maintenance Mode
      
         3.    Return to Main Menu
      
      
      
      Enter your choice [3] : 1
      
      sqlplus -s &un_apps/***** @/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql ENABLE
      
      Successfully enabled Maintenance Mode.
      
      Review the messages above, then press [Return] to continue.
      
      
      Backing up restart files, if any......Done.
      
                   Change Maintenance Mode
         ----------------------------------------
      Maintenance Mode is currently: [Enabled].
      
      
      Maintenance mode should normally be enabled when patching
      Oracle Applications and disabled when users are logged on
      to the system.  See the Oracle Applications Maintenance
      Utilities manual for more information about maintenance mode.
      
      
      Please select an option:
      
         1.    Enable Maintenance Mode
      
         2.    Disable Maintenance Mode
      
         3.    Return to Main Menu
      
      
      
      Enter your choice [3] : 3
      
                  AD Administration Main Menu
         --------------------------------------------------
         1.    Generate Applications Files menu
      
         2.    Maintain Applications Files menu
      
         3.    Compile/Reload Applications Database Entities menu
      
         4.    Maintain Applications Database Entities menu
      
         5.    Change Maintenance Mode
      
         6.    Exit AD Administration
      
      
      
      
      
      
      
      
      
      Enter your choice [6] : 6
      
      
      
      Backing up restart files, if any......Done.
      
      
      There is no timing information available for the current session.
      
      
      AD Administration is complete.
      
      Errors and warnings are listed in the log file
      /u01/E-BIZ/apps/apps_st/appl/admin/VIS/log/adadmin.log
      
      and in other log files in the same directory.
      
      You have new mail in /var/spool/mail/oracle
      [oracle@ebsapp scripts]$

Image 024 Image 028 Image 031 Image 032 Image 033 Image 034 Image 035 Image 036
  • Apply The Patch :- To apply the patch execute the command ‘adpatch’.
    • Script will ask a series of inputs same as it asked while you were running ‘adadmin’ command, including patch location and driver file that you have copied and kept aside.
    • Script will validate the details of the system. Please check the details and if default value seems correct you press ‘ENTER’. It will validate :-
      • Application Top
      • Log File Name
      • Batch Size
      • Database Name
      • SYSTEM schema password. In my case its default ‘manager’.
      • APPS schema password. In my case its default ‘apps’.
      • Provide script location. Make sure you enter the directory where your driver file exists.
      • Provide the driver file name.
    • [oracle@ebsapp scripts]$ adpatch
      
                           Copyright (c) 2002 Oracle Corporation
                              Redwood Shores, California, USA
      
                               Oracle Applications AutoPatch
      
                                       Version 12.0.0
      
      NOTE: You may not use this utility for custom development
            unless you have written permission from Oracle Corporation.
      
      
      Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
      You must use OAM Patch Wizard for this feature. Alternatively, you can
      review the README for pre-requisite information.
      
      
      Your default directory is '/u01/E-BIZ/apps/apps_st/appl'.
      Is this the correct APPL_TOP [Yes] ?
      
      AutoPatch records your AutoPatch session in a text file
      you specify.  Enter your AutoPatch log file name or press [Return]
      to accept the default file name shown in brackets.
      
      Filename [adpatch.log] :
      
      You can be notified by email if a failure occurs.
      Do you wish to activate this feature [No] ?
      
      Please enter the batchsize [1000] : 1
      
      
      Please enter the name of the Oracle Applications System that this
      APPL_TOP belongs to.
      
      The Applications System name must be unique across all Oracle
      Applications Systems at your site, must be from 1 to 30 characters
      long, may only contain alphanumeric and underscore characters,
      and must start with a letter.
      
      Sample Applications System names are: "prod", "test", "demo" and
      "Development_2".
      
      Applications System Name [VIS] : VIS *
      
      
      NOTE: If you do not currently have certain types of files installed
      in this APPL_TOP, you may not be able to perform certain tasks.
      
      Example 1: If you don't have files used for installing or upgrading
      the database installed in this area, you cannot install or upgrade
      the database from this APPL_TOP.
      
      Example 2: If you don't have forms files installed in this area, you cannot
      generate them or run them from this APPL_TOP.
      
      Example 3: If you don't have concurrent program files installed in this area,
      you cannot relink concurrent programs or generate reports from this APPL_TOP.
      
      
      Do you currently have files used for installing or upgrading the database
      installed in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have Java and HTML files for HTML-based functionality
      installed in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have Oracle Applications forms files installed
      in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have concurrent program files installed
      in this APPL_TOP [YES] ? YES *
      
      
      Please enter the name Oracle Applications will use to identify this APPL_TOP.
      
      The APPL_TOP name you select must be unique within an Oracle Applications
      System, must be from 1 to 30 characters long, may only contain
      alphanumeric and underscore characters, and must start with a letter.
      
      Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
      
      APPL_TOP Name [ebsapp] : ebsapp *
      
      
      
      You are about to apply a patch to the installation of Oracle Applications
      in your ORACLE database 'VIS'
      using ORACLE executables in '/u01/E-BIZ/apps/tech_st/10.1.2'.
      
      Is this the correct database [Yes] ?
      
      AutoPatch needs the password for your 'SYSTEM' ORACLE schema
      in order to determine your installation configuration.
      
      Enter the password for your 'SYSTEM' ORACLE schema:
      The ORACLE username specified below for Application Object Library
      uniquely identifies your existing product group: APPLSYS
      
      Enter the ORACLE password of Application Object Library [APPS] :
      
      AutoPatch is verifying your username/password.
      The status of various features in this run of AutoPatch is:
      
                                                 <-Feature version in->
      Feature                          Active?   APPLTOP    Data model    Flags
      ------------------------------   -------   --------   -----------   -----------
      CHECKFILE                        Yes       1          1             Y N N Y N Y
      PREREQ                           Yes       6          6             Y N N Y N Y
      CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
      PATCH_TIMING                     Yes       2          2             Y N N Y N Y
      PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
      SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
      JAVA_WORKER                      Yes       1          1             Y N N Y N Y
      CODELEVEL                        Yes       1          1             Y N N Y N Y
      
      
      
      Identifier for the current session is 543215
      
      Reading product information from file...
      
      Reading language and territory information from file...
      
      Reading language information from applUS.txt ...
      
      AutoPatch warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/zfaprod.txt
       does not exist for product "zfa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      AutoPatch warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/zsaprod.txt
       does not exist for product "zsa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      AutoPatch warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/jtsprod.txt
       does not exist for product "jts".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      Reading database to see what industry is currently installed.
      
      Reading FND_LANGUAGES to see what is currently installed.
      Currently, the following language is installed:
      
      Code   Language                                Status
      ----   --------------------------------------- ---------
      US     American English                        Base
      
      Your base language will be AMERICAN.
      
      Setting up module information.
      Reading database for information about the modules.
      Saving module information.
      Reading database for information about the products.
      Reading database for information about how products depend on each other.
      Reading topfile.txt ...
      
      Saving product information.
      
      AD code level : [B.3]
      
      
      
      Trying to obtain a lock...
      
      
        Attempting to instantiate the current-view snapshot...
      
        No baseline bug-fixes info available. Will attempt next time.
      
      
           **************** S T A R T   O F   U P L O A D ****************
      
      Start date: Wed Feb 05 2014 23:54:56
      
      
      
      0 "left over" javaupdates.txt files uploaded to DB: Wed Feb 05 2014 23:54:56
      
      0 patches uploaded from the ADPSV format patch history files: Wed Feb 05 2014 23:54:56
      
      
      Uploading information about files copied during the previous runs ...
      
      0 "left over" filescopied_<session_id>.txt files uploaded to DB: Wed Feb 05 2014 23:54:56
      
           ****************** E N D   O F   U P L O A D ******************
      
      
      
      
      End date: Wed Feb 05 2014 23:54:56
      
      
      
      
      Enter the directory where your Oracle Applications patch has been unloaded
      
      The default directory is [/u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts] : /u01/patch/12976183
      
      Please enter the name of your AutoPatch driver file : u12976183.drv
      
      Getting Oracle Applications Release...
      
      Current installed release is  12.1.3
      
      Reading patch driver file...
      
        Parsing and loading patch driver file...
               80 lines processed.
      
        Not checking patch integrity as integrity checking flag is turned off.
      
      Successfully read patch driver file.
      
      Determining target release...
      
      Current target    release is  12.1.3
      
      
      Determining which bug fixes to apply...
      
      Done determining which bug fixes to apply.
      
      
      Log and Info File sync point:
        Wed Feb 05 2014 23:56:20
      
      Turning off actions that reference unrecognized products.
      
      
      Log and Info File sync point:
        Wed Feb 05 2014 23:56:20
      
      End of unrecognized products checking.
      
      
      
      AD utilities can support a maximum of 999 workers. Your
      current database configuration supports a maximum of 71 workers.
      Oracle recommends that you use between 2 and 4 workers.
      
      
      Enter the number of parallel workers [2] :
      AutoPatch will run in parallel mode.
      
      
      Did not need to apply new applterr.txt.
      
      Applying new applprod.txt (if any)...
      
        Did not need to apply new applprod.txt.
      
      Performing version checking for driver files...
      
      Copying driver files into installation area...
      
        No driver files were selected for copying.
      
      Skipping...
       ForceCopy driver files into installation area for Specified driver
       since no such action is present for this driver file
      
      Screening out files not valid for this installation...
      
      Determining valid on-site files...
      
      Screening out files not valid for this installation...
      
      Determining valid on-site files...
      
      Skipping...
       Extract object modules from libraries for Specified driver
       since no such action is present for this driver file
      
      Performing version checking...
      
      Skipping...
       Determine directories to create for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Determine executables to link for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Determine forms to generate for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Determine Oracle Reports libraries to generate for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Determine reports to generate for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Determine if need to generate message files for Specified driver
       since no such action is present for this driver file
      
      Looking for active bug fixes with no active actions...
      
      
      Reading customized files list (if any)...
      
      Did not find customized files registration file
      "/u01/E-BIZ/apps/apps_st/appl/admin/applcust.txt"
      The file may have been uploaded to the database.
      
      
      This patch replaces the following customized files:
      
        No customized files are replaced by this patch.
      
      
      Copying files into installation area...
      
      **********************************************************
      You are running admvcode
      
      Header information is:
        $Header: aiopatch.lc 120.7 2007/12/03 08:27:09 nissubra ship $
      
      Start of admvcode session
      Date/Time is Wed Feb 05 2014 23:57:13
      
      Filelist file is: /u01/E-BIZ/apps/apps_st/appl/admin/VIS/out/copymast.txt
      Patch   Character Set is: us7ascii
      On-site Character Set is: AL32UTF8
      
      
      
      Log and Info File sync point:
        Wed Feb 05 2014 23:57:13
      
      Information about files copied to the APPL_TOP would be written to the
      informational message file.
      
      Character set 'US7ASCII' is a subset of character set 'AL32UTF8'.
      No character set conversion is required.
      
      
      Copying files to APPL_TOP...
      
         0 directories created.
         2 files copied without         character set conversion.
         0 files copied with successful character set conversion.
      
         2 files copied successfully.
         0 files had fatal errors.
      
      admvcode is exiting with status 0
      
      End of admvcode session
      Date/time is Wed Feb 05 2014 23:57:13
      **********************************************************
      
      Done copying files into installation area.
      
      Skipping...
       ForceCopy files into installation area for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Archive object modules into product libraries for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Create Directories for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Relink for Specified driver
       since no such action is present for this driver file
      
      Performing second half of mirrored copies...
      
        No mirrored copies were executed in this patch.
      
      Updating Oracle Applications Java files if necessary...
      
        No Oracle Applications Java files required updates.
      
        Checking to see if any files possibly included in the product JAR files
        were copied by this patch...
      
          No files possibly included in the product JAR files
          were copied by this patch.
      
      
      Skipping ...
        Running AutoConfig to instantiate templates which affect
        the generation of JAR files since none of these templates
        were patched during this run of adpatch.
      
      
      
      
         No product JAR files need to be re-generated.
      
      
        Checking to see if adjborg.txt or any files included in
        adjborg.txt were copied by this patch...
      
         Neither adjborg.txt nor any file included in
         adjborg.txt was copied by this patch.
      
        Checking to see if adjborg2.txt or any files included in
        adjborg2.txt were copied by this patch...
      
         Neither adjborg2.txt nor any file included in
         adjborg2.txt was copied by this patch.
      
      Compiling JSP files...
      
        Not compiling JSPs: no JSPs in patch.
      
        No JSP files were compiled.
      
      Number of invalid objects: 356
      
      Getting list of invalid objects in APPS schema.
      
      Invalid object reports are recorded in
      /u01/E-BIZ/apps/apps_st/appl/admin/VIS/log/543215_preenv.*
      
      Running SQL scripts and EXEC commands...
      
      Determining which SQL and EXEC commands to run...
      
      
      Validating PL/SQL direct execute exceptions file ...
      
      Done validating PL/SQL direct execute exceptions file.
      
      Done determining which SQL and EXEC commands to run.
      
      
      Running SQL and EXEC commands in parallel...
      
      
      
      Creating the AD_UTIL_PARAMS table...
      Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
      
      Creating FND_INSTALL_PROCESSES table...
      
      Writing dependencies of jobs to run to appldep.txt file...
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
      Reading completed jobs from restart file (if any).
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
      
      Determining which java executables are supported by adJavaWorker...
      
      Starting worker processes.
      
      Worker process 1 started.
      
      Worker process 2 started.
      
      Checking if all jobs have their actual and symbolic arguments in sync....
      
      Done.
      
      
      Reading jobs from FND_INSTALL_PROCESSES table ...
      
      
      Done reading jobs from FND_INSTALL_PROCESSES table ...
      
      Telling workers to read 'todo' restart file.
      Done.
      
      Starting phase 0 (A0): tab
      
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
       Assigned: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      ************* Start of AD Worker session *************
      AD Worker version: 12.0.0
      AD Worker started at: Wed Feb 05 2014 23:57:23
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      ************* Start of AD Worker session *************
      AD Worker version: 12.0.0
      AD Worker started at: Wed Feb 05 2014 23:57:23
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      Checking if all jobs have their actual and symbolic arguments in sync....
      
      Done.
      
      
      Reading jobs from FND_INSTALL_PROCESSES table ...
      
      
      Done reading jobs from FND_INSTALL_PROCESSES table ...
      
      Telling workers to read 'todo' restart file.
      Done.
      
      Starting phase 0 (A0): tab
      
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
       Assigned: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      ************* Start of AD Worker session *************
      AD Worker version: 12.0.0
      AD Worker started at: Wed Feb 05 2014 23:57:23
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      ************* Start of AD Worker session *************
      AD Worker version: 12.0.0
      AD Worker started at: Wed Feb 05 2014 23:57:23
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      Completed: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      
      Starting phase 1 (A1): tbm: Create Large Indexes
      
      
      There are now 5 jobs remaining (current phase=A1):
          0 running, 1 ready to run and 4 waiting.
      
       Assigned: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      Completed: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      
      Starting phase 2 (A2): vw
      
      
      There are now 4 jobs remaining (current phase=A2):
          0 running, 1 ready to run and 3 waiting.
      
       Assigned: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      Completed: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      
      Starting phase 3 (A3): plb
      
      
      There are now 3 jobs remaining (current phase=A3):
          0 running, 1 ready to run and 2 waiting.
      
       Assigned: file OKCRSTSB.pls on worker  1 for product okc username OKC.
      Completed: file OKCRSTSB.pls on worker  1 for product okc username OKC.
      
      Starting phase 4 (A4): dfr
      
      
      There are now 2 jobs remaining (current phase=A4):
          0 running, 1 ready to run and 1 waiting.
      
       Assigned: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      Completed: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      
      Starting phase 5 (A5): en: Create Large Indexes
      
      
      There are now 1 jobs remaining (current phase=A5):
          0 running, 1 ready to run and 0 waiting.
      
       Assigned: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      Completed: file OKCSHD1.odf  on worker  1 for product okc username OKC.
      
      Telling workers to quit...
      
      
      All workers have quit.
      
      
      Dropping FND_INSTALL_PROCESSES table...
      
      
      FND_INSTALL_PROCESSES table dropped.
      
      
      Dropping AD_DEFERRED_JOBS table...
      
      
      AD_DEFERRED_JOBS table dropped.
      
      
      Done running SQL and EXEC commands in parallel.
      
      
      Running Invoker's Rights Maintenance...
      
      
      
      Creating the AD_UTIL_PARAMS table...
      Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.
      
      Creating FND_INSTALL_PROCESSES table...
      
      Setting parallel context: Invoker's Rights processing at R120
      
      
      Need to perform Invoker's Rights processing
      
      Making job list for APPLSYS/*****
      
      Writing dependencies of jobs to run to appldep.txt file...
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
      Reading completed jobs from restart file (if any).
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
      
      Determining which java executables are supported by adJavaWorker...
      
      Starting worker processes.
      
      ************* Start of AD Worker session *************
      AD Worker version: 12.0.0
      AD Worker started at: Wed Feb 05 2014 23:57:48
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      Worker process 1 started.
      
      Worker process 2 started.
      
      Checking if all jobs have their actual and symbolic arguments in sync....
      
      Done.
      
      
      Reading jobs from FND_INSTALL_PROCESSES table ...
      
      ************* Start of AD Worker session *************
      AD Worker version: 12.0.0
      AD Worker started at: Wed Feb 05 2014 23:57:48
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      
      Done reading jobs from FND_INSTALL_PROCESSES table ...
      
      Telling workers to read 'todo' restart file.
      Done.
      
      Starting phase 0 (A0): invoker
      
      
      There are now 6 jobs remaining (current phase=A0):
          0 running, 1 ready to run and 5 waiting.
      
       Assigned: file adinvset.pls on worker  1 for product ad  username APPLSYS.
      Completed: file adinvset.pls on worker  1 for product ad  username APPLSYS.
      
      Starting phase 1 (A1): invoker+1
      
      
      There are now 5 jobs remaining (current phase=A1):
          0 running, 2 ready to run and 3 waiting.
      
       Assigned: file adinvrun.pls on worker  1 for product ad  username APPLSYS.
       Assigned: file adinvrun.pls on worker  2 for product ad  username APPLSYS.
      Completed: file adinvrun.pls on worker  1 for product ad  username APPLSYS.
      Completed: file adinvrun.pls on worker  2 for product ad  username APPLSYS.
      
      Starting phase 2 (A2): invoker+2
      
      
      There are now 3 jobs remaining (current phase=A2):
          0 running, 2 ready to run and 1 waiting.
      
       Assigned: file adinvrn2.pls on worker  1 for product ad  username APPLSYS.
       Assigned: file adinvrn2.pls on worker  2 for product ad  username APPLSYS.
      Completed: file adinvrn2.pls on worker  1 for product ad  username APPLSYS.
      Completed: file adinvrn2.pls on worker  2 for product ad  username APPLSYS.
      
      Starting phase 3 (A3): invoker+3
      
      
      There are now 1 jobs remaining (current phase=A3):
          0 running, 1 ready to run and 0 waiting.
      
       Assigned: file adinvcln.pls on worker  1 for product ad  username APPLSYS.
      Completed: file adinvcln.pls on worker  1 for product ad  username APPLSYS.
      
      Done with Invoker's Rights processing.
      
      
      Telling workers to quit...
      
      
      All workers have quit.
      
      
      Dropping FND_INSTALL_PROCESSES table...
      
      
      FND_INSTALL_PROCESSES table dropped.
      
      
      Dropping AD_DEFERRED_JOBS table...
      
      
      AD_DEFERRED_JOBS table dropped.
      
        Updating the checkfile repository if necessary...
      Processing the last batch...
        Done updating the checkfile repository...
      
      Done running SQL scripts and EXEC commands.
      
      Compiling invalid objects...
      
      
      sqlplus -s APPS/***** @/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 2  0 NONE FALSE
      
      sqlplus -s APPS/***** @/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 2  0 NONE FALSE
      
      Number of invalid objects: 257
      
      Getting list of invalid objects in APPS schema.
      
      Invalid object reports are recorded in
      /u01/E-BIZ/apps/apps_st/appl/admin/VIS/log/543215_postenv.*
      
      Skipping...
       Generate forms library files for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Generate forms menu files for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Generate forms for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Generate reports libraries for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Generate reports for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Generate Messages for Specified driver
       since no such action is present for this driver file
      
      Skipping...
       Generate Workflow resource files for Specified driver
       since no such action is present for this driver file
      
      Skipping ...
       Running AutoConfig since none of its templates were
       patched during this run of adpatch.
      
      Saving Patch History information to Database...
      
      Trying to obtain a lock...
      
      > Inserted 1 patch history records (total).
      
      Gathering Statistics for AD_PATCH_HIST_TEMP
      
      Done Gathering Statistics for AD_PATCH_HIST_TEMP
      
      >>> Inserted 1 bug history records for this patch (total).
      >>>>> Inserted 0 action history records for this bug (total).
      
      Gathering Statistics for AD_PATCH_HIST_TEMP
      
      Done Gathering Statistics for AD_PATCH_HIST_TEMP
      
      >>> Inserted 2 bug history records for this patch (total).
      >>>>> Inserted 0 action history records for this bug (total).
      
      
      
        Updating the current-view snapshot...
      
        Done saving Patch History information.
      
      
      About to do IREP processing...
      
        Attempting to process IREP files ...
      
        Successfully processed IREP files.
      
      Done IREP processing.
      
      
      Copying applprod.tmp to applprod.txt (if needed)...
      
        Did not need to copy applprod.tmp to applprod.txt.
      
      Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...
      
      Did not need to copy admin/VIS/applterr.txt to admin/applterr.txt.
      
      sqlplus -s APPS/***** @/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql 543215 adt543215
      
      A job timing report has been generated for the current session.
      You should check the file
          /u01/E-BIZ/apps/apps_st/appl/admin/VIS/out/adt543215.lst
      
      for details.
      
      
      Purging timing information for prior sessions.
      
      sqlplus -s APPS/***** @/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1
      
      Done purging timing information for prior sessions.
      
      AutoPatch is complete.
      
      AutoPatch may have written informational messages to the file
      /u01/E-BIZ/apps/apps_st/appl/admin/VIS/log/adpatch.lgi
      
      Errors and warnings are listed in the log file
      /u01/E-BIZ/apps/apps_st/appl/admin/VIS/log/adpatch.log
      
      and in other log files in the same directory.
      
      You have new mail in /var/spool/mail/oracle
      [oracle@ebsapp scripts]$

 Image 038 Image 040 Image 042 Image 043 Image 044  Image 047 Image 048  Image 050 Image 051 Image 052   Image 056
  • Disable Maintenance Mode :- To disable maintenance mode execute the the same ‘adadmin’ command. Only change will be you need to choose option ‘2’.
    • [oracle@ebsapp scripts]$ adadmin
      
                           Copyright (c) 2002 Oracle Corporation
                              Redwood Shores, California, USA
      
                           Oracle Applications AD Administration
      
                                       Version 12.0.0
      
      NOTE: You may not use this utility for custom development
            unless you have written permission from Oracle Corporation.
      
      Your default directory is '/u01/E-BIZ/apps/apps_st/appl'.
      Is this the correct APPL_TOP [Yes] ?
      
      AD Administration records your AD Administration session in a text file
      you specify.  Enter your AD Administration log file name or press [Return]
      to accept the default file name shown in brackets.
      
      Filename [adadmin.log] :
      
      ************* Start of AD Administration session *************
      AD Administration version: 12.0.0
      AD Administration started at: Wed Feb 05 2014 23:46:59
      
      APPL_TOP is set to /u01/E-BIZ/apps/apps_st/appl
      
      You can be notified by email if a failure occurs.
      Do you wish to activate this feature [No] ?
      
      Please enter the batchsize [1000] :1
      Please enter the name of the Oracle Applications System that this
      APPL_TOP belongs to.
      
      The Applications System name must be unique across all Oracle
      Applications Systems at your site, must be from 1 to 30 characters
      long, may only contain alphanumeric and underscore characters,
      and must start with a letter.
      
      Sample Applications System names are: "prod", "test", "demo" and
      "Development_2".
      
      Applications System Name [VIS] : VIS *
      
      
      NOTE: If you do not currently have certain types of files installed
      in this APPL_TOP, you may not be able to perform certain tasks.
      
      Example 1: If you don't have files used for installing or upgrading
      the database installed in this area, you cannot install or upgrade
      the database from this APPL_TOP.
      
      Example 2: If you don't have forms files installed in this area, you cannot
      generate them or run them from this APPL_TOP.
      
      Example 3: If you don't have concurrent program files installed in this area,
      you cannot relink concurrent programs or generate reports from this APPL_TOP.
      
      
      Do you currently have files used for installing or upgrading the database
      installed in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have Java and HTML files for HTML-based functionality
      installed in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have Oracle Applications forms files installed
      in this APPL_TOP [YES] ? YES *
      
      
      Do you currently have concurrent program files installed
      in this APPL_TOP [YES] ? YES *
      
      
      Please enter the name Oracle Applications will use to identify this APPL_TOP.
      
      The APPL_TOP name you select must be unique within an Oracle Applications
      System, must be from 1 to 30 characters long, may only contain
      alphanumeric and underscore characters, and must start with a letter.
      
      Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
      
      APPL_TOP Name [ebsapp] : ebsapp *
      
      
      
      You are about to use or modify Oracle Applications product tables
      in your ORACLE database 'VIS'
      using ORACLE executables in '/u01/E-BIZ/apps/tech_st/10.1.2'.
      
      Is this the correct database [Yes] ?
      
      AD Administration needs the password for your 'SYSTEM' ORACLE schema
      in order to determine your installation configuration.
      
      Enter the password for your 'SYSTEM' ORACLE schema:
      
      
      The ORACLE username specified below for Application Object Library
      uniquely identifies your existing product group: APPLSYS
      
      Enter the ORACLE password of Application Object Library [APPS] :
      
      AD Administration is verifying your username/password.
      The status of various features in this run of AD Administration is:
      
                                                 <-Feature version in->
      Feature                          Active?   APPLTOP    Data model    Flags
      ------------------------------   -------   --------   -----------   -----------
      CHECKFILE                        Yes       1          1             Y N N Y N Y
      PREREQ                           Yes       6          6             Y N N Y N Y
      CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
      PATCH_TIMING                     Yes       2          2             Y N N Y N Y
      PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
      SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
      JAVA_WORKER                      Yes       1          1             Y N N Y N Y
      CODELEVEL                        Yes       1          1             Y N N Y N Y
      
      
      
      Identifier for the current session is 543213
      
      Reading product information from file...
      
      Reading language and territory information from file...
      
      Reading language information from applUS.txt ...
      
      AD Administration warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/zfaprod.txt
       does not exist for product "zfa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      AD Administration warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/zsaprod.txt
       does not exist for product "zsa".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      AD Administration warning:
       Product Data File
       /u01/E-BIZ/apps/apps_st/appl/admin/jtsprod.txt
       does not exist for product "jts".
      This product is registered in the database but the
      above file does not exist in APPL_TOP.  The product
      will be ignored without error.
      
      
      Reading database to see what industry is currently installed.
      
      Reading FND_LANGUAGES to see what is currently installed.
      Currently, the following language is installed:
      
      Code   Language                                Status
      ----   --------------------------------------- ---------
      US     American English                        Base
      
      Your base language will be AMERICAN.
      
      Setting up module information.
      Reading database for information about the modules.
      Saving module information.
      Reading database for information about the products.
      Reading database for information about how products depend on each other.
      Reading topfile.txt ...
      
      Saving product information.
      
      AD code level : [B.3]
      
                  AD Administration Main Menu
         --------------------------------------------------
         1.    Generate Applications Files menu
      
         2.    Maintain Applications Files menu
      
         3.    Compile/Reload Applications Database Entities menu
      
         4.    Maintain Applications Database Entities menu
      
         5.    Change Maintenance Mode
      
         6.    Exit AD Administration
      
      
      
      
      
      
      
      
      
      Enter your choice [6] : 5
      
                   Change Maintenance Mode
         ----------------------------------------
      Maintenance Mode is currently: [Enabled].
      
      
      Maintenance mode should normally be enabled when patching
      Oracle Applications and disabled when users are logged on
      to the system.  See the Oracle Applications Maintenance
      Utilities manual for more information about maintenance mode.
      
      Please select an option:
      
         1.    Enable Maintenance Mode
      
         2.    Disable Maintenance Mode
      
         3.    Return to Main Menu
      
      
      
      Enter your choice [3] : 2
      
      sqlplus -s &un_apps/***** @/u01/E-BIZ/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE
      
      Successfully disabled Maintenance Mode.
      
      Review the messages above, then press [Return] to continue.
      
      
      Backing up restart files, if any......Done.
      
                   Change Maintenance Mode
         ----------------------------------------
      Maintenance Mode is currently: [Disabled].
      
      
      Maintenance mode should normally be enabled when patching
      Oracle Applications and disabled when users are logged on
      to the system.  See the Oracle Applications Maintenance
      Utilities manual for more information about maintenance mode.
      
      Please select an option:
      
         1.    Enable Maintenance Mode
      
         2.    Disable Maintenance Mode
      
         3.    Return to Main Menu
      
      
      
      Enter your choice [3] : 3
      
                  AD Administration Main Menu
         --------------------------------------------------
         1.    Generate Applications Files menu
      
         2.    Maintain Applications Files menu
      
         3.    Compile/Reload Applications Database Entities menu
      
         4.    Maintain Applications Database Entities menu
      
         5.    Change Maintenance Mode
      
         6.    Exit AD Administration
      
      
      
      
      
      
      
      
      
      Enter your choice [6] : 6
      
      
      
      Backing up restart files, if any......Done.
      
      
      There is no timing information available for the current session.
      
      
      AD Administration is complete.
      
      Errors and warnings are listed in the log file
      /u01/E-BIZ/apps/apps_st/appl/admin/VIS/log/adadmin.log
      
      and in other log files in the same directory.
      
      [oracle@ebsapp scripts]$

Image 024 Image 028 Image 031 Image 057 Image 059
  • Start Application Services :- To start the services execute the script ‘adstrtal.sh’. Enter apps schema password and you are done. Application services will be brought up and you can access system with new features that is applied by the patch.
    • [oracle@ebsapp scripts]$ sh adstrtal.sh
      
      You are running adstrtal.sh version 120.15.12010000.3
      
      
      Enter the APPS username: apps
      
      Enter the APPS password:
      The logfile for this session is located at /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstrtal.log
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adopmnctl.sh start
      script returned:
      ****************************************************
      
      You are running adopmnctl.sh version 120.6.12010000.5
      
      Starting Oracle Process Manager (OPMN) ...
      opmnctl: opmn started.
      
      adopmnctl.sh: exiting with status 0
      
      adopmnctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adopmnctl.txt for more information ...
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adalnctl.sh start
      script returned:
      ****************************************************
      
      adalnctl.sh version 120.3
      
      Checking for FNDFS executable.
      Starting listener process APPS_VIS.
      
      adalnctl.sh: exiting with status 0
      
      
      adalnctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adalnctl.txt for more information ...
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adapcctl.sh start
      script returned:
      ****************************************************
      
      You are running adapcctl.sh version 120.7.12010000.2
      
      Starting OPMN managed Oracle HTTP Server (OHS) instance ...
      opmnctl: opmn is already running.
      opmnctl: starting opmn managed processes...
      
      adapcctl.sh: exiting with status 0
      
      adapcctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adapcctl.txt for more information ...
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adoacorectl.sh start
      
      ****************************************************
      
      You are running adoacorectl.sh version 120.13
      
      Starting OPMN managed OACORE OC4J instance  ...
      
      adoacorectl.sh: exiting with status 0
      
      adoacorectl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adoacorectl.txt for more information ...
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adformsctl.sh start
      
      ****************************************************
      
      You are running adoafmctl.sh version 120.8
      
      Starting OPMN managed OAFM OC4J instance  ...
      
      adoafmctl.sh: exiting with status 0
      
      adoafmctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adoafmctl.txt for more information ...
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/adcmctl.sh start
      script returned:
      ****************************************************
      
      You are running adcmctl.sh version 120.17.12010000.5
      
      Starting concurrent manager for VIS ...
      Starting VIS_0206@VIS Internal Concurrent Manager
      Default printer is noprint
      
      adcmctl.sh: exiting with status 0
      
      
      adcmctl.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adcmctl.txt for more information ...
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      Executing service control script:
      /u01/E-BIZ/inst/apps/VIS_ebsapp/admin/scripts/jtffmctl.sh start
      script returned:
      ****************************************************
      
      You are running jtffmctl.sh version 120.3
      
      Validating Fulfillment patch level via /u01/E-BIZ/apps/apps_st/comn/java/classes
      Fulfillment patch level validated.
      Starting Fulfillment Server for VIS on port 9302 ...
      
      jtffmctl.sh: exiting with status 0
      
      
      .end std out.
      
      .end err out.
      
      ****************************************************
      
      
      All enabled services for this node are started.
      
      adstrtal.sh: Exiting with status 0
      
      adstrtal.sh: check the logfile /u01/E-BIZ/inst/apps/VIS_ebsapp/logs/appl/admin/log/adstrtal.log for more information ...
      
      [oracle@ebsapp scripts]$

Image 062
Image 063 

No comments :

Post a Comment

SeachBox