***********************************************************
Before patch,please reference Doc ID:  290807.1 Step 4
***********************************************************

$ cd 6863618
$ ls
README.html       ad                f6863618.ldt      j6863618_fnd.zip  marker1.txt
README.txt        b6863618.ldt      fnd               j6863618_jtf.zip  u6863618.drv
$ ls -l
total 10446
-rw-rw-r--   1 applmgr  dba         4180 Mar  5  2008 README.html
-rw-rw-r--   1 applmgr  dba         1739 Mar  5  2008 README.txt
drwxr-xr-x   3 applmgr  dba          512 Jul 10 08:22 ad
-rw-rw-r--   1 applmgr  dba      4943814 Mar  4  2008 b6863618.ldt
-rw-rw-r--   1 applmgr  dba       114683 Mar  4  2008 f6863618.ldt
drwxr-xr-x   8 applmgr  dba          512 Jul 10 08:22 fnd
-rw-rw-r--   1 applmgr  dba       151559 Mar  4  2008 j6863618_fnd.zip
-rw-rw-r--   1 applmgr  dba         1705 Mar  4  2008 j6863618_jtf.zip
-rw-rw-r--   1 applmgr  dba           37 Mar  4  2008 marker1.txt
-rw-rw-r--   1 applmgr  dba        93138 Mar  4  2008 u6863618.drv

---------Enable 'Maintenance Mode'
$ adadmin

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                     Oracle Applications AD Administration

                                 Version 11.5.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

Attention: AD Administration 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 '/disk1/ap/prodappl'.
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: 11.5.0
AD Administration started at: Fri Jul 10 2009 08:26:31

APPL_TOP is set to /disk1/ap/prodappl

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :

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 [PROD] : PROD *

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 [NO] ? NO *

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 [NO] ? NO *

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 [devserver03] : devserver03 *

 

You are about to use or modify Oracle Applications product tables
in your ORACLE database 'PROD'
using ORACLE executables in '/disk1/ap/prodora/8.0.6'.

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: system

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] : 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

 

Identifier for the current session is 1913

........

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 : [11i.AD.I.2]

            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/***** @/disk1/ap/prodappl/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE
Spawned Process 17517

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] :

            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] :

 

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
/disk1/ap/prodappl/admin/PROD/log/adadmin.log

and in other log files in the same directory.

$

---------Apply the JRE Interoperability Patch (UNIX Users only)
$ pwd
/disk1/ap/prodora/8.0.6/patch/6863618
$ adpatch

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                         Oracle Applications AutoPatch

                                 Version 11.5.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 '/disk1/ap/prodappl'.
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] :

.......

AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema: system

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] : apps

AutoPatch is verifying your username/password.

.......

 

  Was already instantiated. So no instantiation done this time.

     **************** S T A R T   O F   U P L O A D ****************

Start date: Fri Jul 10 2009 08:40:00

 

0 "left over" javaupdates.txt files uploaded to DB: Fri Jul 10 2009 08:40:00

0 patches uploaded from the ADPSV format patch history files: Fri Jul 10 2009 08:40:00

Uploading information about files copied during the previous runs ...

0 "left over" filescopied_<session_id>.txt files uploaded to DB: Fri Jul 10 2009 08:40:00

     ****************** E N D   O F   U P L O A D ******************

End date: Fri Jul 10 2009 08:40:00

Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/disk1/ap/prodora/8.0.6/patch/6863618] :

Please enter the name of your AutoPatch driver file : u6863618.drv

........
Context Value Management has found new variables that must be defined to update the context file and continue with system configuration

Variable : s_ohs_serveradmin
Details  : This parameter sets the e-mail address that the OHS
           includes in any error messages it returns to the client.
           It may be worth setting up a dedicated address for this purpose.
Enter the Oracle HTTP Server Administrator email address [applmgr@mitac-mkl.com.cn]:

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring ABM_TOP.......COMPLETED
        Configuring ECX_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring GL_TOP........COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring XNC_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring PA_TOP........COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring IMT_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
The log file for this session is located at: /disk1/ap/prodappl/admin/PROD_devserver03/log/07100850/adconfig.log

  Unable to find WFRESGEN.
  Please follow the manual instructions in the Upgrading JInitiator/J2SE
  MetaLink document, to upgrade j2se16014 with Oracle Workflow.

Done
$

 

----------------Disable 'Maintenance Mode'

$ adadmin

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                     Oracle Applications AD Administration

                                 Version 11.5.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

Attention: AD Administration 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 '/disk1/ap/prodappl'.
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: 11.5.0
AD Administration started at: Fri Jul 10 2009 08:59:01

APPL_TOP is set to /disk1/ap/prodappl

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :

........

You are about to use or modify Oracle Applications product tables
in your ORACLE database 'PROD'
using ORACLE executables in '/disk1/ap/prodora/8.0.6'.

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: system

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] : apps

AD Administration is verifying your username/password.

.........

Saving product information.

AD code level : [11i.AD.I.2]

            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/***** @/disk1/ap/prodappl/ad/11.5.0/patch/115/sql/adsetmmd.sql DISABLE
Spawned Process 23027

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] :

            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] :

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
/disk1/ap/prodappl/admin/PROD/log/adadmin.log

and in other log files in the same directory.

$