If you are on E-Business Suite Release 12.1, apply:
————————————————–
11g Release 2 interoperability patch for Release 12.1 (9062910)

adpatch (u9062910.drv)


12.1 TXK Delta 3 patch (8919489) – Already applied.
Superseded by 9239090 – Already applied.
9868229
10163753
11071569

If you are using Demand Signal Repository (DSR), apply:
——————————————————
9182368 – Already applied.
Implement AutoConfig or upgrade to the latest version.
——————————————————
If you are on Oracle E-Business Suite Release 12.1, apply patches:
9738085 and 9852070.
Daylight Saving changes
———————–
Apply these patches once the upgrade is finished with:

7695070 (Pre-requisite)
10272702 (DST V15)
10406470 (OJVM)
SELECT version FROM v$timezone_file;
VERSION
----------
10
$ cd /backup/ALGPTH/db/tech_st/11.2.0/javavm/admin
$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production ON Mon Mar 21 11:21:30 2011
Copyright (c) 1982, 2010, Oracle. ALL rights reserved.
Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
@fixTZa.SQL

PL/SQL PROCEDURE successfully completed.

Bug is in fact present, so this patch is needed
Proceed by restarting the database and running script

@fixTZb
PL/SQL procedure successfully completed.

Step1: If needed, edit init.ora and set cluster_database=FALSE

show parameter cluster_database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1

Step2: As SYS shutdown database:

shutdown immediate

Step3: Start the database in migrate:

startup migrate

Step4: Execute the script SQL> $ORACLE_HOME/javavm/admin/fixTZb

@?/javavm/admin/fixTZb.SQL
@fixTZb.SQL
SESSION altered.
PL/SQL PROCEDURE successfully completed.
PL/SQL PROCEDURE successfully completed.
PL/SQL PROCEDURE successfully completed.
PL/SQL PROCEDURE successfully completed.
PL/SQL PROCEDURE successfully completed.
PL/SQL PROCEDURE successfully completed.
CALL completed.
Testing various timezone DST attributes
Bug IS no longer present. Patch succeeded.
PL/SQL PROCEDURE successfully completed.
DROP java SOURCE fixTZ
DROP package fixTZ
PL/SQL PROCEDURE successfully completed.

Apply patch 6400501 (conditional)
OPATCH – NOT APPLIED: iAS 10.1.2 ORACLE_HOME

Install ORACLE_HOME - 11.2.0.2 (Patch: 10098816)
ORACLE_BASE: /backup/ALGPTH/db - as ealier when 11.1.0.7 was installed it was with /backup/ALGPTH.
ORACLE_HOME: /backup/ALGPTH/db/tech_st/11.2.0
(Same location as 11.1.0 ORACLE_HOME)

Set Environment for ORAPTH user:

vi /home/orapth/.profile
PATH=$PATH:/backup/ALGPTH/db/tech_st/11.2.0/bin
export ORACLE_HOME=/backup/ALGPTH/db/tech_st/11.2.0
cd $ORACLE_HOME
<strong>Create nls/data/9idata directory</strong>
$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl
Creating directory /backup/ALGPTH/db/tech_st/11.2.0/nls/data/9idata ...
Copying files to /backup/ALGPTH/db/tech_st/11.2.0/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /backup/ALGPTH/db/tech_st/11.2.0/nls/data/9idata!
Set Environment for ORAPTH user:
ORA_NLS10 to /backup/ALGPTH/db/tech_st/11.2.0/nls/data/9idata!
export ORA_NLS10=/backup/ALGPTH/db/tech_st/11.2.0/nls/data/9idata!
$ PATH=$PATH:/backup/ALGPTH/db/tech_st/11.2.0/OPatch
$ which opatch

Apply additional 11.2.0.2 RDBMS patches
—————————————
4247037 –
$ cd 4247037
$ opatch apply
OPatch succeeded.
10149223
$ cd 10149223
$ opatch apply
OPatch succeeded.
10229719
$ cd 10229719
$ opatch apply
OPatch succeeded.
On the Source – 11.1.0.7 Database:

$ cp -r /backup/ALGPTH/db/tech_st/11.2.0/rdbms/admin/utlu112i.sql /backup/ALGPTH/db/tech_st/11.1.0/rdbms/admin/utlu112i.sql
$ cd /backup/ALGPTH/db/tech_st/11.1.0/rdbms/admin/utlu112i.sql
$ cd /backup/ALGPTH/db/tech_st/11.1.0
$ cd rdbms/admin
$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 17 13:17:35 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SPOOL upgrade_info.log
@utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 03-17-2011 13:18:44
Script Version: 11.2.0.2.0 Build: 001
**********************************************************************
Database:
**********************************************************************
--&gt; name: ALGPTH
--&gt; version: 11.1.0.7.0
--&gt; compatible: 11.1.0
--&gt; blocksize: 8192
--&gt; platform: HP-UX IA (64-bit)
--&gt; timezone file: V10
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--&gt; SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 11061 MB
--&gt; APPS_UNDOTS1 tablespace is adequate for the upgrade.
.... minimum required size: 1701 MB
--&gt; APPS_TS_QUEUES tablespace is adequate for the upgrade.
.... minimum required size: 92 MB
--&gt; APPS_TS_TX_DATA tablespace is adequate for the upgrade.
.... minimum required size: 5779 MB
--&gt; CTXD tablespace is adequate for the upgrade.
.... minimum required size: 21 MB
--&gt; ODM tablespace is adequate for the upgrade.
.... minimum required size: 15 MB
--&gt; OLAP tablespace is adequate for the upgrade.
.... minimum required size: 32 MB
--&gt; SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 707 MB
--&gt; TMP tablespace is adequate for the upgrade.
.... minimum required size: 61 MB
**********************************************************************
Flashback: OFF
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
--&gt; If Target Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
--&gt; If Target Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
--&gt; plsql_native_library_dir 11.2 OBSOLETE
--&gt; plsql_native_library_subdir_ 11.2 OBSOLETE
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--&gt; Oracle Catalog Views [upgrade] VALID
--&gt; Oracle Packages and Types [upgrade] VALID
--&gt; JServer JAVA Virtual Machine [upgrade] VALID
--&gt; Oracle XDK for Java [upgrade] VALID
--&gt; Real Application Clusters [upgrade] INVALID
--&gt; OLAP Analytic Workspace [upgrade] VALID
--&gt; OLAP Catalog [upgrade] VALID
--&gt; Oracle Text [upgrade] VALID
--&gt; Oracle XML Database [upgrade] VALID
--&gt; Oracle Java Packages [upgrade] VALID
--&gt; Oracle interMedia [upgrade] VALID
--&gt; Spatial [upgrade] VALID
--&gt; Data Mining [upgrade] VALID
--&gt; Oracle OLAP API [upgrade] VALID
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --&gt; Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 11.1.0.7.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --&gt; Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER APPS has 4 INVALID objects.
WARNING: --&gt; Your recycle bin contains 295 object(s).
.... It is REQUIRED that the recycle bin is empty prior to upgrading
.... your database. The command:
PURGE DBA_RECYCLEBIN
.... must be executed immediately prior to executing your upgrade.
WARNING: --&gt; Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APPS has dependent objects.
**********************************************************************
Recommendations
**********************************************************************

Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:

EXECUTE dbms_stats.gather_dictionary_stats;

**********************************************************************
Oracle recommends removing all hidden parameters prior to upgrading.
To view existing hidden parameters execute the following command
while connected AS SYSDBA:

SELECT name,description FROM SYS.V$PARAMETER WHERE name
LIKE '\_%' ESCAPE '\'

Changes will need to be made in the init.ora or spfile.
**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:

SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'
Trace Events:
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'

Changes will need to be made in the init.ora or spfile.
**********************************************************************
The DMSYS schema exists in the database. Prior to performing an upgrade Oracle recommends that the DMSYS schema, and its associated objects be removed from the database.

Refer to the Oracle Data Mining Administration Guide for the instructions on how to perform this task.
**********************************************************************
Solutions for pre-upgrade script:
================================

$ sqlplus "/as sysdba"
PURGE DBA_RECYCLEBIN
DBA Recyclebin purged.
EXECUTE dbms_stats.gather_dictionary_stats;
PL/SQL PROCEDURE successfully completed.
SELECT name,description FROM SYS.V$PARAMETER WHERE name LIKE '\_%' ESCAPE '\';
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_system_trig_enabled
are system triggers enabled
_sort_elimination_cost_ratio
cost ratio for sort eimination under first_rows mode
_b_tree_bitmap_plans
enable the use of bitmap plans for tables w. only B-tree indexes
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_fast_full_scan_enabled
enable/disable index fast full scan
_like_with_bind_as_equality
treat LIKE predicate with bind as an equality predicate
_optimizer_autostats_job
enable/disable auto stats collection job
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_trace_files_public
Create publicly accessible trace files
7 rows selected.
SELECT (translate(value,chr(13)||chr(10),'
')) FROM sys.v$parameter2 WHERE UPPER(name) ='EVENT' AND isdefault='FALSE';
no rows selected.
SELECT (translate(value,chr(13)||chr(10),'
')) from sys.v$parameter2 WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE';
no rows selected

Upgrade Start:
=============

# cp -r /backup/ALGPTH/db/tech_st/11.1.0/network/admin/ALGPTH_oraap03 /backup/ALGPTH/db/tech_st/11.2.0/network/admin
# cd /backup/ALGPTH/db/tech_st/11.2.0/network/admin
# ls -ltr
total 4
-rw-r--r-- 1 orapth dba 187 May 7 2007 shrept.lst
drwxr-xr-x 2 orapth dba 96 Mar 16 12:52 samples
drwxr-xr-x 2 root sys 1024 Mar 17 13:21 ALGPTH_oraap03
# chown -R orapth:dba ALGPTH_oraap03
$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 17 13:23:34 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
create spfile from pfile;
File created.
exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
# cd /backup/ALGPTH/db/tech_st/11.1.0/dbs
# cp initALGPTH.ora /backup/ALGPTH/db/tech_st/11.2.0/dbs/
# cp spfileALGPTH.ora /backup/ALGPTH/db/tech_st/11.2.0/dbs/
# cp ALGPTH_oraap03_ifile.ora /backup/ALGPTH/db/tech_st/11.2.0/dbs/
# cd /backup/ALGPTH/db/tech_st/11.2.0/dbs/
# chown -R orapth:dba *
Change 11.1.0 to 11.2.0 - sqlnet.ora, listener.ora, tnsnames.ora
$ cd /backup/ALGPTH/db/tech_st/11.2.0/dbs
Comment out these lines in the pfile:
# plsql_native_library_dir = /backup/ALGPTH/db/tech_st/11.1.0/plsql/nativelib
# plsql_native_library_subdir_count = 149
Change 11.1.0 to 11.2.0
$ cd /backup/ALGPTH/db/tech_st/11.2.0
$ mkdir admin
$ cd admin
$ mkdir ALGPTH_oraap03
$ cd ALGPTH_oraap03
$ mkdir bdump
$ mkdir cdump
$ mkdir diag
$ mkdir udump
PATH=$PATH:/backup/ALGPTH/db/tech_st/11.2.0/bin
export ORACLE_HOME=/backup/ALGPTH/db/tech_st/11.2.0
export ORA_NLS10=/backup/ALGPTH/db/tech_st/11.2.0/nls/data/9idata!
export TNS_ADMIN=/backup/ALGPTH/db/tech_st/11.2.0/network/admin/ALGPTH_oraap03
cd $ORACLE_HOME
export ORACLE_SID=ALGPTH
export ORA_NLS10=/backup/ALGPTH/db/tech_st/11.2.0/nls/data - added the following line.
startup upgrade
cd /backup/ALGPTH/db/tech_st/11.2.0/rbms/admin
@catupgrd.sql
shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
#######################################################################
#######################################################################
The above sql script is the final step of the upgrade. Please review any errors in the spool log file. If there are any errors in the spool file, consult the Oracle Database Upgrade Guide for
troubleshooting recommendations.
Next restart for normal operation, and then run utlrp.sql to recompile any invalid application objects.
#######################################################################
#######################################################################
Rem Set errorlogging off
SET ERRORLOGGING OFF;
Rem *********************************************************************
Rem END catupgrd.sql
Rem *********************************************************************
Run only the "catmgdidcode.sql" and "utlrp.sql" scripts for the post install instructions. The other scripts are run as part of the dbua upgrade.

$ cd 4247037/files/md/admin/
$ ls
catmgdidcode.sql mgdidcodetype.sql mgdiddeinstall.sql mgdidinstall.sql mgdidprivs.plb prvtmgdidcodeutlb.plb catnomgdidcode.sql mgdidcodeutl.plb mgdidepctype.plb mgdidmetadata.sql mgdsys.sql prvtmgdidepctypeb.plb mgdidcodetype.plb mgdidcodeutl.sql mgdidepctype.sql mgdidmetatable.sql prvtmgdidcodetypeb.plb

$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production ON Thu Mar 3 16:32:46 2011
Copyright (c) 1982, 2009, Oracle. ALL rights reserved.
Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
@catmgdidcode.SQL
SESSION altered.
USER altered.
$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production ON Thu Mar 3 16:36:03 2011
Copyright (c) 1982, 2009, Oracle. ALL rights reserved.
Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
SELECT COUNT(*) FROM all_objects WHERE STATUS='INVALID';
COUNT(*)
----------
60918
!pwd
/backup/ALGPTH/db/tech_st/11.2.0/rdbms/admin
@utlrp.SQL
PL/SQL PROCEDURE successfully completed.
COUNT(*)
----------
45
$ sqlplus "/as sysdba"
startup
exit

$ lsnrctl stop ALGPTH
$ lsnrctl start ALGPTH

$ sqlplus "/as sysdba"
CREATE spfile FROM pfile;
shutdown immediate
startup
SHOW parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /backup/ALGPTH/db/tech_st/11.2.0/dbs/spfileALGPTH.ora

# cd /backup/ALGPTH/apps/apps_st/appl/admin
# cp -r adgrants.sql /backup/ALGPTH/db/tech_st/11.2.0/admin/
# cd /backup/ALGPTH/db/tech_st/11.2.0/admin
# chown -R orapth:dba adgrants.sql

$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 3 17:05:11 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
@adgrants.sql
Enter value for 1:
APPLSYS
APPS

$ cd $AD_TOP/patch/115/sql/
$ ls -ltr adctxprv.sql
-rwxr-xr-x 1 applpth dba 1664 Feb 28 14:12 adctxprv.sql
# cd /backup/ALGPTH/apps/apps_st/appl/ad/12.0.0/patch/115/sql
# cp -r adctxprv.sql /backup/ALGPTH/db/tech_st/11.2.0/admin/
# cd /backup/ALGPTH/db/tech_st/11.2.0/admin
# chown -R orapth:dba adctxprv.sql

@adctxprv.SQL
Connecting TO SYSTEM
Enter VALUE FOR 1: manager
Connected.
Enter VALUE FOR 2: CTXSYS
$ sqlplus "/ as sysdba"
EXEC ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
PL/SQL PROCEDURE successfully completed.
Login TO the Application:
========================
# su - applpth
$ cd $FND_TOP/patch/115/SQL/
$ ls -ltr wfaqupfix.SQL
-rwxr-xr-x 1 applpth dba 4631 Feb 28 14:06 wfaqupfix.SQL
$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production ON Thu Mar 3 17:16:03 2011
Copyright (c) 1982, 2005, Oracle. ALL rights reserved.
Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
@wfaqupfix.SQL
Enter VALUE FOR 1: APPLSYS
Enter VALUE FOR 2: APPS
PL/SQL PROCEDURE successfully completed.

1. Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following steps:
1.1. On the Application Tier (as the APPLMGR user):
1.1.1. Source the environment file.
1.1.2. Create the appsutil.zip file by executing:

$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
(On Windows: %ADPERLPRG% %AD_TOP%\bin\admkappsutil.pl)
This will create appsutil.zip under $INST_TOP/admin/out
$ . ./APPSALGPTH_oraap03.env
$ $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /backup/ALGPTH/inst/apps/ALGPTH_oraap03/admin/log/MakeAppsUtil_03031726.log
output located at /backup/ALGPTH/inst/apps/ALGPTH_oraap03/admin/out/appsutil.zip
MakeAppsUtil completed successfully.

1.2. On the Database Tier (as the ORACLE user):
1.2.1. Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>
1.2.2. cd <RDBMS ORACLE_HOME>
1.2.3. unzip -o appsutil.zip
1.2.4. Run AutoConfig by executing:
<RDBMS_ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh
(On Windows use adautocfg.cmd)
# cd /backup/ALGPTH/inst/apps/ALGPTH_oraap03/admin/out/
# cp -r appsutil.zip /backup/ALGPTH/db/tech_st/11.2.0/
# cd /backup/ALGPTH/db/tech_st/11.2.0/
# chown -R orapth:dba appsutil.zip
$ pwd
/backup/ALGPTH/db/tech_st/11.2.0
$ unzip -o appsutil.zip
$ cd appsutil/bin

$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /backup/ALGPTH/db/tech_st/11.2.0/jdk/jre/bin/java to execute java programs..
APPS Password: apps
The log file for this adbldxml session is located at:
/backup/ALGPTH/db/tech_st/11.2.0/appsutil/log/adbldxml_03031733.log
UnsatisfiedLinkError exception loading native library: njni11
java.lang.UnsatisfiedLinkError: no njni11 in java.library.path
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server: oraap03
Enter Port of Database server: 1561
Enter SID of Database server: ALGPTH
Enter the value for Display Variable: oraap03:0.0
The context file has been created at:
/backup/ALGPTH/db/tech_st/11.2.0/appsutil/ALGPTH_oraap03.xml
$ adconfig.sh contextfile=/backup/ALGPTH/db/tech_st/11.2.0/appsutil/ALGPTH_oraap03.xml
Enter the APPS user password:
The log file for this session is located at: /backup/ALGPTH/db/tech_st/11.2.0/appsutil/log/ALGPTH_oraap03/03031736/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /backup/ALGPTH/db/tech_st/11.2.0
Classpath : :/backup/ALGPTH/db/tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/backup/ALGPTH/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/backup/ALGPTH/db/tech_st/11.2.0/appsutil/java:/backup/ALGPTH/db/tech_st/11.2.0/jlib/netcfg.jar:/backup/ALGPTH/db/tech_st/11.2.0/jlib/ldapjclnt11.jar
Using Context file : /backup/ALGPTH/db/tech_st/11.2.0/appsutil/ALGPTH_oraap03.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.

/backup/ALGPTH/apps/apps_st/appl/admin
# cp -r adstats.sql /backup/ALGPTH/db/tech_st/11.2.0/admin
# cd /backup/ALGPTH/db/tech_st/11.2.0/admin
# ls
ALGPTH_oraap03 adctxprv.sql adgrants.sql adstats.sql
# chown -R orapth:dba adstats.sql

$ sqlplus "/ as sysdba"
ALTER system enable restricted SESSION;
@adstats.SQL
$ sqlplus "/ as sysdba"
ALTER system disable restricted SESSION;
exit;

Appllication Server:
adadmin: Re-create grants and synonyms
Restart Applications server processes
Synchronize Workflow views
Log on to Oracle E-Business Suite with the “System Administrator” responsibility. Click Requests > Run > Single Request and the OK button. Enter the following parameters:
Request Name = Workflow Directory Services User/Role Validation
p_BatchSize = 10000
p_Check_Dangling = Yes
Add missing user/role assignments = Yes
Update WHO columns in WF tables = No
Click “OK” and “Submit”.
$ unzip p6880880_112000_HPUX-IA64.zip
$ cd /backup/ALGPTH/db/tech_st/11.2.0
$ mv OPatch OPatch.old
$ cp -r OPatch /backup/ALGPTH/db/tech_st/11.2.0/
$ cd /backup/ALGPTH/db/tech_st/11.2.0/

$ opatch version
Invoking OPatch 11.2.0.1.4
OPatch Version: 11.2.0.1.4
OPatch succeeded.
$ PATH=$PATH:/backup/ALGPTH/db/tech_st/11.2.0/OPatch
$ opatch version
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.
$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /backup/ALGPTH/db/tech_st/11.2.0
Central Inventory : /backup/ALGPTH/db/oraInventory from : /var/opt/oracle/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /backup/ALGPTH/db/tech_st/11.2.0/oui
Log file location : /backup/ALGPTH/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2011-03-08_11-14-56AM.log
Patch history file: /backup/ALGPTH/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '10272702' to OH '/backup/ALGPTH/db/tech_st/11.2.0'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '10272702' for restore. This might take a while...
Backing up files affected by the patch '10272702' for rollback. This might take a while...
Patching component oracle.oracore.rsf, 11.2.0.1.0...
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/timezlrg_15.dat"
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/timezone_15.dat"
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/readme_15.txt"
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/big/timezlrg_15.dat"
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/big/timezone_15.dat"
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/little/timezlrg_15.dat"
Copying file to "/backup/ALGPTH/db/tech_st/11.2.0/oracore/zoneinfo/little/timezone_15.dat"
ApplySession adding interim patch '10272702' to inventory
Verifying the update...
Inventory check OK: Patch ID 10272702 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 10272702 are present in Oracle Home.
OPatch succeeded.

$ p10406470_112010_Generic.zip
$ opatch apply
ApplySession adding interim patch ‘10406470’ to inventory
Verifying the update…
Inventory check OK: Patch ID 10406470 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 10406470 are present in Oracle Home.
OPatch succeeded.
$ cd $ORACLE_HOME/javavm/admin
$ ls -ltr fixTZa*
-rw-r–r– 1 orapth dba 391464 Feb 23 17:48 fixTZa.sql
Startup the Database and Database Listener.

$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 8 13:13:59 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
@fixTZa.sql
===
PL/SQL procedure successfully completed.
Bug is in fact present, so this patch is needed
Proceed by restarting the database and running script
@fixTZb
PL/SQL procedure successfully completed.
Tagged with →  
Share →
0 comments