PREPARING THE UPGRADE
***********************************
Review Upgrade Tasks and Apply 11i.AD.I.6
1. Apply 11i.AD.I.6 (conditional)
Both these patches are applied
Patch 6502079 – ‘AD.I.6 Delta’
Patch 6502082 – ‘AD.I.6′
2. Run TUMS utility (recommended) — The Upgrade Manual Script
/orastage/software/12i/12i_upg_patches/7705743
Apply 7705743 in hotpatch mode
cd $AD_TOP/patch/115/sql
sqlplus apps/apps @adtums.sql /u02/oracle/XXATD/11.5.0/comn/tmp
This will generate a report “tumsr12.html”
review the output “tumsr12.html”
Database and System Administration Tasks
_____________________________________________
1. Back up database, Applications, and customizations (recommended)
Will plan for backup
2. Prepare an upgrade plan for customizations (conditional)
Customizations will be tested before the upgrade.
Save customizations and modify them if necessary
3. Convert to Multiple Organizations architecture (required)
Already on multi-org
4. Drop event alert triggers in custom schemas (conditional)
No Custom Triggers
select * from all_triggers
where trigger_name like ‘ALR%’
$ALR_TOP/admin/sql/alrdtrig.sql
5. Review sizes of old and new tablespaces (required) ( 399362.1 )
From Metalink Note 399362.1
Database Size:
Years of Data Migrated Before Upgrade DB Size(GB) After Upgrade DB Size(GB) Delta(GB) %Growth
3 Years 6609.97 6808.44 198.47 3%
12 Years 6609.97 7161.61 551.64 8.3%
6. Run AD preparation scripts (required)
Download patch 7197489 and unzip the patch
Patch unzip under /orastage/software/12i/12i_upg_patches/7197489
CREATE USER XXATDFND
IDENTIFIED BY xxatd
DEFAULT TABLESPACE XXATDD
TEMPORARY TABLESPACE TEMP2
PROFILE DEFAULT
ACCOUNT UNLOCK;
– 2 Roles for XXATDFND
GRANT CONNECT TO XXATDFND;
GRANT RESOURCE TO XXATDFND;
ALTER USER XXATDFND DEFAULT ROLE ALL;
– 1 System Privilege for XXATDFND
GRANT UNLIMITED TABLESPACE TO XXATDFND;
– 4 Object Privileges for XXATDFND
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON XXATDSCM.SCM_SCHEMA_CHANGE_LOG TO XXATDFND;
GRANT ALTER, SELECT ON XXATDSCM.SCM_SCHEMA_CHANGE_LOG_S TO XXATDFND;
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON XXATDSCM.SCM_SCHEMA_STATE TO XXATDFND;
GRANT ALTER, SELECT ON XXATDSCM.SCM_SCHEMA_STATE_S TO XXATDFND;
CREATE TABLESPACE INTERIM
DATAFILE ‘+DATA’
SIZE 10G REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
SEGMENT SPACE MANAGEMENT AUTO ;
cd /orastage/software/12i/12i_upg_patches/7197489
sqlplus <APPS username>/<APPS password> @adgncons.sql apps apps
creates adcrtbsp.sql
Modify adcrtbsp.sql generated from above to reflect the ASM data group
sqlplus system/manager @adcrtbsp.sql
>> Extend tablespace APPS_TS_CUSTOM_INV_DATA
extend the current datafiles which are 2g in size to 30 g, probably 2 of them
select file_name,sum(bytes)/(1024*1024) from dba_datA_files
where tablespace_name = ‘APPS_TS_CUSTOM_INV_DATA’
group by file_name;
FILE_NAME SUM(BYTES)/(1024*1024)
——————————————— ———————-
+DATA/r12d/apps_cust_inv_data01.dbf 4096
+DATA/r12d/apps_cust_inv_data02.dbf 2048
+DATA/r12d/apps_cust_inv_data03.dbf 2048
+DATA/r12d/apps_cust_inv_data04.dbf 4096
+DATA/r12d/apps_cust_inv_data05.dbf 2048
+DATA/r12d/apps_cust_inv_data06.dbf 2048
+DATA/r12d/apps_cust_inv_data07.dbf 5120
alter database datafile ‘+DATA/r12d/apps_cust_inv_data01.dbf’ resize 30g;
alter database datafile ‘+DATA/r12d/apps_cust_inv_data02.dbf’ resize 30g;
Run adgrants.sql
Create $ORACLE_HOME/appsutil/admin on the database server
Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPLSYS schema name>
Applications Technology Tasks
______________________________
1. Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
5903765 – Patch already applied in PRD
Currently using workflow notification mailer for Alert
Customer Relationship Management Tasks
_______________________________________
Marketing, Sales, or Trade Management
_______________________________________
1. Create new product catalog (conditional)
TUMS step key: AMS_OSO_PLM_CHK
From the TUMS report this can be ignored
Incentive Compensation
__________________________
1. Verify completion of Sales Compensation processes
TUMS step key: CN_PAYRN_REP_CHK
From the TUMS report this can be ignored
TeleService
______________________
1. Set up profile option for TeleService (required)
Not Required, Not using TeleService
Mobile Field Service
________________________
1. Synchronize data for Mobile Field Service (conditional)
Not Required, Not using Mobile Field Service
Financials and Procurement Tasks
____________________________________
Financials for India
______________________
1. Set minimum patch levels (conditional)
Not Required. Not using Financials for India
General Ledger
____________________________
1. Run Accounting Setup Manager Diagnosis for MRC (optional)
Apply patch 5259121
cd /orastage/software/12i/12i_upg_patches/5259121
Apply u5259121.drv using hotpatch mode
Run the report
Accounting Setup Manager Pre-Update Diagnosis report
from General Ledger responsibility
output in “Accounting Setup Manager Pre-Update Diagnosis Report.html”
report came out with “No issues found” for all the steps
iPayments
___________
1. Prepare data for credit card encryption upgrade (conditional)
Not Required
( TUMS step key: IBY_SEC_UPGRADE )
Internet Expenses
___________________
1. Import expense reports into Accounts Payable (conditional)
Not Required
( TUMS step key: OIE_IMPORT_INTERCOMPANY_CHECK )
Payables
____________________
1. Import all invoices from Payables Open Interface (required)
TUMS step key: AP_IMPORT_INVOICES_CHECK
In this release, global descriptive flex fields (GDFs) are obsolete and are moved into tax
and payment columns. Several validations are performed based on the country the
invoice is imported from on these GDFs. They are not upgraded in the open interface
tables.
Import all invoices that have not yet been imported by running the Open Interface
Import program on the 11i APPL_TOP. Resolve any rejections and resubmit the
program until all invoices are imported.
select count(*) from ap_invoices_interface
1560
select count(*) from AP_INVOICE_LINES_INTERFACE
983
for this test upgrade
delete from ap_invoices_interface;
delete from AP_INVOICE_LINES_INTERFACE;
commit;
2. Confirm or cancel all Un-confirmed Payment Batches (required)
TUMS step key: AP__CNFM_PAY_BATCH_CHECK
Payables Manager -> Payments -> Inquiry
Search for status != Confirmed
No batches found
Subledger Accounting
___________________________
1. Set range of periods (optional)
Patch 5233248 can be applied to select the number of periods to be upgraded
cd /orastage/software/12i/12i_upg_patches/5233248
apply u5233248.drv in hotpatch mode
Run “SLA Pre-Upgrade program” to select the number of periods of data to be upgraded
Leasing and Finance Management Tasks
________________________________________
Not Required ( TUMS Step Key: OKL_LIC_CHK )
Projects Tasks
_________________
1. Complete distribution, transfer, and tieback of expense reports (conditional)
Not Required ( ATD does not use Projects — TUMS step key: PA_COMPLETE_DIST_TIEBACK_EXP )
2. Complete transfer and tieback of cost, cross charge, and revenue (conditional)
Not Required ( ATD does not use Projects — TUMS step key: PA_COMPLETE_DIST_TIEBACK_EXP )
Public Sector/University Tasks
_________________________________
Student Systems
_______________________
Not Required ( ATD does not use Oracle Student Systems )
Supply Chain Management Tasks
__________________________________________
Depot Repair
_________________
1. Identify and resolve problem data (conditional)
Not Required ( ATD does not use Depot Repair )
Process Manufacturing
_______________________
1. Prepare to migrate OPM data (conditional)
Not Required ( ATD does not use Process Manufacturing — TUMS step key: GMA_PREP_MIGRATE )
2. Finish migration preparations for OPM (conditional)
Not Required ( ATD does not use Process Manufacturing — TUMS step key: GMA_PREP_MIGRATE_FINISH )
Service Contracts
___________________________
1. Update Currency Code setup in Global Contracts defaults (conditional)
Not Required ( ATD does not use Service contracts — TUMS step key: OKS_VALIDATE_GCD )
2. Validate data for Rules and Time values migration (recommended)
Not Required ( ATD does not use Service contracts — TUMS step key: OKS_VALIDATE_GCD )
Prepare for the Upgrade
**************************************
ATD Specific Steps
ATD.1 Compile flexfield PRODUCT_CATEGORIES
Error: invctcat.ldt erroring out during upgrade
Solution
To implement the solution, please execute the following steps:
a. Go into the responsibility: Inventory
b. Navigate to Setup / Flexfields / Key / Segments / query Inventory, Item Categories.
c. Find PRODUCT_CATEGORIES flexfield structure, make sure that it is defined, enabled, and compiled.
Check other common category structures to ensure that they are defined, enabled and compiled.
ATD.2 Truncate ENI tables as we are not using business intelligence
MLOG$_ENI_OLTP_ITEM_STAR is Growing too Large, can it be Truncated? [ID 367693.1]
TRUNCATE TABLE ENI.MLOG$_ENI_OLTP_ITEM_STAR;
TRUNCATE TABLE ENI.ENI_OLTP_ITEM_STAR;
ATD.3 permission on olapsys objects
run the following connected as system
grant execute on OLAPSYS.CWM2_OLAP_METADATA_REFRESH to apps;
grant execute on OLAPSYS.CWM2_OLAP_CATALOG to apps;
grant execute on OLAPSYS.CWM2_OLAP_DIMENSION to apps;
grant execute on OLAPSYS.CWM2_OLAP_CUBE to apps;
ATD.4 db link SOLIX ( Only required for Test upgrades )
Make sure the db link SOLIX is valid
SQL> select name from v$database@solix;
NAME
—————————
SARCD
ATD.5 Unlock stats on mlog tables
on orar12.dev.icd
cd /orastage/software/12i/scripts
sqlplus ‘/ as sysdba’
@unlock_stats_gen.sql
@un_lock_stats.txt
1. Gather schema statistics for CBO (required)
This step should be done prior to the upgrade to reduce downtime. we gather stats weekly on a rotational basis, we can discuss the option of skipping this if required.
2. Back up the database (recommended)
Evaluate cold backup options or Take a backup of the system using netbackup
3. Run Rapid Install (required)
This step can be done ahead of time
a. Follow instructions in Chapter 1 of Oracle Applications Installation Guide: Using
Rapid Install to prepare your environment for the new system
Then, start Rapid
Install by typing rapidwiz on the command line.
b. On the Wizard Operation screen, select Upgrade to Oracle Applications Release 12.1.1. Click Next.
cd /orastage/software/12i/12.1.1/startCD/Disk1/rapidwiz
./rapidwiz
c. On the Select Upgrade Action screen, select Create Upgrade File System.
d. In the associated screen flow, enter the parameters required to set up your new
environment. Then, run Rapid Install.
select port pool : 0
Enter Database configuration info
Database Host : orar12
Database Port : 1521
Database SID : R12D
Domain Name : dev.icd
Database OS User : oracle
Database OS group : dba
Base Directory : /u01/oracle
Application User Information
Apps Username : apps
Apps Password : apps
GWYUID Username : APPLSYSPUB
GWYUID Password : PUB
Guest Username : GUEST
Guest Password : ORACLE
Primary Applications Node Configuration
Host Name : appr12
Domain Name : dev.icd
Apps OS User : oracle
Apps OS Group : dba
Base Dir : /u02/oracle/R12D
Instance Dir : /u02/oracle/R12D/inst
Config File Location
/u02/oracle/R12D/inst/apps/R12D_appr12/conf_R12D.txt
rapidwiz will do the following checks
Port Uniqueness
File Space
File Systems
Host / Domain
/u02/oracle/R12D/inst/apps/R12D_appr12/logs/06131106.log
Following error can be safely ignored as the DB is not configured for R12
Attempting upload of Context file and templates to database…ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; The element reports_port is missing from the context file /u02/oracle/R12D/inst/apps/R12D_appr12/appl/admin/R12D_appr12.xml. The context file upload will not continue.
Note: Rapid Install (as it runs AutoConfig) records errors in the
AutoConfig log file. These errors occur because the database has
not yet been upgraded. They can be safely ignored. The errors will
be resolved when you run Rapid Install (and AutoConfig) in Step 2
of the Finish the Upgrade, page 3-8 section of Chapter 3, page 3-
1.
Run Rapid Install again after the upgrade to configure and start the servers and
services. Rapid Install also delivers the unified upgrade driver that you will use later to
perform the upgrade.
4. Migrate or upgrade your database to at least Oracle 10g Release 2 (conditional)
Our database is at version 11GR1, this step can be ignored.
*****************************************
Upgrading to Release 12.1.1
*****************************************
Perform the Upgrade
____________________
1. Disable AOL Audit Trail (conditional)
Navigation : System Administrator
Security > Audit Trail > Groups
There are five groups set to “Disable – Purge Table” –> set this to “Disable – Prepare for Archive”
Run program “AuditTrail Update Tables”
2. Shut down application tier listeners and concurrent managers (required)
adstpall.sh apps/apps
3. Migrate database to at least Oracle10g Release 2 (conditional)
We are on 11.1.0.7.4 – Skipping this step
4. Update init.ora with upgrade parameters (required)
396009.1 – Database Initialization Parameters for Oracle Applications Release 12
Page 1-11
https://support.oracle.com/CSP/main/article?cmd=show&id=396009.1&type=NOT
alter system set “_sqlexec_progression_cost”=2147483647 scope=both;
alter system set “_optimizer_autostats_job”=false scope=both;
alter system set “_disable_fast_validate”=TRUE scope=both;
5. Disable custom triggers, constraints, and indexes (conditional)
Follow instructions in suspend_jaros.txt to disable Noetix triggers
cd /orastage/software/12i/scripts
sqlplus jarosconnect/jarosconnect
@disable_jaros_trig_run.sql
@truncate_jcd_run.sql
@truncate_jel_run.sql
@truncate_jelh_run.sql
6. Drop MRC schema (conditional)
Not Applicable — MRC_APPS does not exist
7. Back up the database (recommended)
Applies to 11i release level: All
TUMS step key: N/A
Make a cold backup of the Oracle Applications database. If you encounter problems
during the upgrade process, you can use this backup to restore your system to the
same state as before you began the upgrade.
Note: Shut down with the NORMAL option. You may not be able
to restore the database from the backup if you use the IMMEDIATE
or ABORT option.
8. Ensure that Maintenance Mode is enabled (required)
run adadmin and enable maintenance mode
*****
CUSTOM/PRE-UPGRADE STEPS BEFORE RUNNING THE UPGRADE DRIVER
*****
Source 11i Environment file
Apply patch 8845395
ATD.6 Source R12 Environment file
. ./R12.env
cat R12.env
. /u02/oracle/R12D/apps/apps_st/appl/APPSR12D_appr12.env
Apply patch 7461070 in normal mode
on the DB server
cd $ORACLE_HOME/appsutil/admin
scp oracle@appr12.dev.icd:/orastage/software/12i/12i_upg_patches/pre_upg/7461070/admin/adgrants.sql .
sqlplus /nolog
@adgrants.sql APPS
run adadmin to recreate grants and synonyms
ATD.7 Apply Following patches in pre-install mode
/orastage/software/12i/12i_upg_patches/pre_upg
adpatch preinstall=y
# Following not required
# cd $AD_TOP/patch/115/sql
# sqlplus apps/apps
# @adpamiss.pls
# @adpamisb.pls
********** Following will be merged into one patch driver ( 1211_preinstall.drv )*********
adpatch preinstall=y
8601033
>> 8218945 — Failed ( Skipped in creating a merge patch )
This patch is compatible with: entity ‘per’ – codeline ‘R12.PER.A’.
Your current on-site codeline for the entity ‘per’ is: ‘R12.PER.B’.
10096115 — ( apilnupg.sql runs for a long time )
7303029 — CUP 1
7648869 — AP patch
8615142 — AP Patch
8712047 — AP Patch
8865466 — AP Patch
9257954 — AP Patch
9586498 — AP Patch
9799876 — AP Patch
9918101 — AP Patch
10096191 — AP Patch
10144929 — AP Patch
10170555 — AP Patch
10358280 — AP Patch
11071399 — AP Patch
12344218 — AP Patch
8517880 — AR Patch
8509517 — GL Patch
10235226 — GL Patch ( only if upgrading to 12.1.3 )
8752951 — EB Tax Patch
9504903 — EB Tax Patch
9947835 — EB Tax Patch
10029457 — EB Tax Patch
10221534 — EB Tax Patch
8942413 — iPayments
10393730 — Cash Management, consolidated preupgrade fixes
12347791 — Project Costing
admrgpch -s /orastage/software/12i/12i_upg_patches/pre_upg/pre_upg_src -d /orastage/software/12i/12i_upg_patches/pre_upg/pre_upg_merge -merge_name 1211_preinstall
adpatch preinstall=y u_1211_preinstall.drv
ATD.8 adsstats.sql failing with duplicate value error
delete from FND_HISTOGRAM_COLS
where table_name = ‘FII_FIN_ITEM_HIERARCHIES’
and column_name = ‘PARENT_FLEX_VALUE’
ATD.9 Upgrade to GMF failing
drop synonym APPS.GMF_BATCH_REQUIREMENTS_GTMP;
drop table GMF.GMF_BATCH_REQUIREMENTS_GTMP;
DROP INDEX INV.XXATD_MTL_TRANS_INTERF_N6;
drop table APPS.FII_CURR_CONV_RATES_GT; — this is a table in APPS
drop view APPS.CST_ACCRUAL_ACCOUNTS; — This is a view
drop index PO.PO_VENDORS_F1; — Upgrade creates PO_VENDORS_OBS_F1 on the same set of columns
drop index APPS.MTL_MATERIAL_TRANSACTIONS_N26; — for 12.1.3 upgrade
– Clear OPP Queue table ( will save around 1 hour 45 mins )
exec dbms_aqadm.purge_queue_table(‘FND_CP_GSM_OPP_AQTBL’, null, null);
ATD.10 : Apply database patches
Shutdown database
Apply database patches
/u01/oracle/product/11.1.0/DB/patches/12i_upg_patches/
/orastage/software/12i/12i_upg_patches/db_patches
6460304
7111245
7211965
7684818
$ORACLE_HOME/OPatch/opatch napply /u01/oracle/product/11.1.0/DB/patches/12i_upg_patches/7684818 -id 4247037,6263237,6815733,7243270,7277741,7319922,7327166,7684818 -skip_duplicate
8639653
Startup database
cd /orastage/software/12i/12i_upg_patches/db_patches/7684818
sqlplus ‘/ as sysdba’
SQL> @?/md/admin/catmgdidcode
ATD.11 Recompile all objects to prevent timestamp issues
Running utlirp.sql ( total around 15 mins )
Login to sqlplus as sys as sysdba.
SQL>shutdown
SQL>startup upgrade
SQL>@?/rdbms/admin/utlirp.sql ( 15 mins )
SQL>shutdown
SQL>startup
SQL>@?/rdbms/admin/utlrp.sql ( 45 mins )
ATD.12 — delete MSC_APPS_INSTANCES
create table MSC_APPS_INSTANCES_1 as select * from MSC_APPS_INSTANCES;
delete from MSC_APPS_INSTANCES;
commit;
ATD.13 Extend Tablespace
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_DATA
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_IDX
add datafile ‘+DATA’ size 30g;
alter tablespace APPS_TS_TX_IDX
add datafile ‘+DATA’ size 30g;
**************** Tablespace Info after AP index creation ****************
select df.tablespace_name “Tablespace”,
totalusedspace “Used MB”,
(df.totalspace – tu.totalusedspace) “Free MB”,
df.totalspace “Total MB”,
round(100 * ( (tu.totalusedspace)/ df.totalspace))
“Pct. Used”
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
and tu.tablespace_name not in (‘UNDO1′,’UNDO2′,’UNDO3′,’UNDO4′)
order by 2 desc
TABLESPACE USED_MB FREE_MB TOTAL_MB PCT_USED
APPS_TS_TX_DATA 818616 229689 1048305 78
APPS_TS_TX_IDX 576909 189037 765946 75
SABRIX_DATA 299696 34126 333822 90
XXATDD 215383 265895 481278 45
XXATDX 53865 13719 67584 80
APPS_TS_SUMMARY 52774 24018 76792 69
APPS_TS_MEDIA 41340 7812 49152 84
UNDO5 26352 14608 40960 64
APPS_TS_INTERFACE 26076 4644 30720 85
APPS_TS_CUSTOM_INV_DATA 16585 60215 76800 22
APPS_TS_NOLOGGING 14068 27972 42040 33
SYSTEM 13801 6679 20480 67
TOOLS 13677 2707 16384 83
APPS_TS_ARCHIVE 11907 3189 15096 79
APPS_TS_CUSTOM_INV_IDX 10212 3100 13312 77
SYSAUX 9813 5547 15360 64
APPS_TS_SEED 7758 3534 11292 69
APPS_TS_QUEUES 3369 18191 21560 16
JAROSCHTRKDAT 1888 120992 122880 2
XXATD_STD_EUL 1099 949 2048 54
JAROSCHTRKIDX 1009 50191 51200 2
DISCOVERER 168 856 1024 16
PORTAL 34 266 300 11
9. Apply AD 12.1.1 upgrade driver (required)
cd $AU_TOP/patch/115/driver
adpatch options=nocopyportion,nogenerateportion
u6678700.drv
Following SQL running for more than 2 hours now, Might have to open a SR for performance
SQL.1
, following SQL is running. Might have to raise a SR
/* Formatted on 7/8/2011 4:07:49 PM (QP5 v5.163.1008.3004) */
SELECT COUNT (1)
FROM MTL_SYSTEM_ITEMS_B
WHERE STYLE_ITEM_FLAG = ‘Y’
AND ITEM_CATALOG_GROUP_ID IN
( SELECT ITEM_CATALOG_GROUP_ID
FROM MTL_ITEM_CATALOG_GROUPS_B
CONNECT BY PRIOR ITEM_CATALOG_GROUP_ID =
PARENT_CATALOG_GROUP_ID
START WITH ITEM_CATALOG_GROUP_ID = :B1)
******* Upgrade Observations *****************
07/11/2011 21:17
czhist.sql failed with “APPLSYS.FND_STATTAB is too old.”
Worker 8 was still running
Ran the script below and restarted worker 2
exec dbms_stats.upgrade_stat_table(‘APPLSYS’,'FND_STATTAB’);
adsstats.sql took 4 hours to complete
Continue with the next set of tasks
11. Run the NLS upgrade patch driver (conditional)
Skipped as English is the only language installed.
12. Apply latest product patches (required)
will apply 12.1.3 patchset later
13. Synchronize NLS and American English product patches (conditional)
N/A English is the only language
14. Disable Maintenance Mode (required)
run adadmin to disable maintenance mode
15. Reset init.ora parameters (required)
follow note 396009.1
alter system set “_disable_fast_validate”=FALSE scope=both;
16. Back up Oracle Applications (recommended)
FINISH THE UPGRADE
**********************************
1. Reset ORACLE schema passwords (recommended)
Might not be required if we are using the same passwords
2. Configure and start server processes (required)
a. Update the RDBMS ORACLE_HOME file system with AutoConfig files.
on apptier
cd $INST_TOP
perl $AD_TOP/bin/admkappsutil.pl
will generate /u02/oracle/R12D/inst/apps/R12D_appr12/admin/out/appsutil.zip
copy appsutil.zip to database ORACLE_HOME
cd $ORACLE_HOME
unzip -o appsutil.zip
b. Install/Upgrade JRE on apptier
cd /orastage/software/patches/jre
cp j2se16022.exe $COMMON_TOP/webapps/oacore/util/jinitiator
Apply the Interoperability Patch
Stop app tier services
enable maintenance mode using adadmin
apply patch 4377566 using adpatch
Patch Location
/orastage/software/patches/jre/4377566
Run the txkSetPlugin.sh Script on all webtiers
cd $FND_TOP/bin
./txkSetPlugin.sh 16022
copy jre to $ORACLE_HOME/appsutil on db tier
scp -r oracle@appr12.dev.icd:/u02/oracle/R12D/apps/tech_st/10.1.3/appsutil/jdk/jre $ORACLE_HOME/appsutil
Generate a new Database context file as follows:
cd $ORACLE_HOME/appsutil/bin
perl adbldxml.pl
will generate /u01/oracle/product/11.1.0/DB/appsutil/R12D_orar12.xml
Run AutoConfig on the database tier nodes
cd $ORACLE_HOME/appsutil/bin
adconfig.sh contextfile=/u01/oracle/product/11.1.0/DB/appsutil/R12D_orar12.xml
3. Configure Applications client software for forms applet (required)
Above steps will enable this ( Client side java is installed already )
4. Reapply customizations (conditional)
*** CUSTOM_DEV Will analyze later
5. Integrate custom objects and schemas (conditional)
*** CUSTOM_DEV Will analyze later
6. Re-enable custom triggers, constraints, and indexes (conditional)
sqlplus jarosconnect/jarosconnect
run enable_jaros_trig_run.sql
Finish System Administration Tasks
_____________________________________
System Administration
________________________
1. Configure SSL for Web Services (conditional)
Not required here
2. Complete Workflow Notification Mailer configuration (required)
Probably not required — but need to check in PRD
3. Complete Transport Agent setup (conditional)
Not required
4. Complete setup for Oracle XML Gateway (required)
Not required
Oracle XML Publisher
______________________
1. Enable PDF printing (required)
Copy pasta configuration file
Not required if PDF printing does not work
then cp $11i_FND_TOP/resource to 12i_FND_TOP/resource
2. Specify a temporary directory for XML Publisher (required)
Use XML publisher administrator to setup the temp directory
POST-UPGRADE TASKS
********************************
Review Post-upgrade Tasks
_____________________________
Will perform these steps after 12.1.3 Upgrade
12.1.3 UPGRADE
***************************************
12.1.3 pre upgrade steps
drop index APPS.MTL_MATERIAL_TRANSACTIONS_N26
/
12.1.3 Upgrade
cd /orastage/software/12i/1213_patchset
*** Apply RUP 3 ****
Steps
Apply prereq – R12.AD.B.DELTA.3 ( 9239089 ) — ( 15 mins )
copy adgrants.sql and run on database node
cd /u01/oracle/product/11.1.0/DB/appsutil/admin
scp oracle@appr12.dev.icd:/orastage/software/12i/1213_patchset/9239089/admin/adgrants.sql .
sqlplus /nolog @adgrants.sql APPS
on APPTIER
apply the patch driver u9239089.drv
Apply 12.1.3 ( 9239090 )
cd /orastage/software/12i/1213_patchset/9239090
Apply u9239090.drv
The following Oracle Forms objects did not generate successfully:
au resource OKSAUDET.pll
au resource CSCUTILS.pll
au resource OKCEXPOR.pll
au resource OKCKSRCH.pll
We will continue as if it were successful
APPLY ONLINE HELP
****************************
Apply 12.1.1 Help already applied as part of 12.1.1
Apply 12.1.3 Help
9239095
cd /orastage/software/12i/1213_patchset/9239095
apply u9239095.drv
Apply Post 12.1.3 Patches
cd /orastage/software/12i/1213_patchset
Patch 9817770 — POST-R12.ATG_PF.B.DELTA.3
Patch 9966055 — 1OFF:12.1.3:TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED
Apply HRMS Legislative data patch ( Metalink note : 145837.1 )
We have HR installed — but only used with purchasing.
HRMS RUP 4 can be applied ( 10281212 )
cd /orastage/software/12i/12i_upg_patches/post_upg
a. Apply u10281212.drv — 30 mins
b. run data install :
java oracle.apps.per.DataInstall apps apps thin orar12.dev.icd:1521:R12D
c. apply hrglobal.drv ( 15 mins )
cd $PER_TOP/patch/115/driver
apply hrglobal.drv
skip the worker if it fails
******** PUT JOBS ON HOLD ********
Create table apps.atd_upgrade_jobs_on_hold as select * from fnd_Concurrent_requests where PHASE_CODE=’P’ and hold_flag=’N';
select count(*) from apps.atd_upgrade_jobs_on_hold ;
update fnd_Concurrent_requests set hold_flag=’Y’ where PHASE_CODE=’P’ and hold_flag=’N’ and request_id in
(select request_id from apps.atd_upgrade_jobs_on_hold) ;
Commit;
********* BEFORE Starting Services ************
cd $ADMIN_SCRIPTS_HOME
run autoconfig
./adautocfg.sh
cp /home/oracle/work/config_files_r12/adovars_R12D_appr12.env /u02/oracle/R12D/inst/apps/R12D_appr12/appl/admin/adovars_R12D_appr12.env
Before you start the applications — put the jobs on hold
./adstrtal.sh apps/apps
URL
http://appr12.dev.icd:8000/
POST-UPGRADE TASKS
******************************
Application Technology Tasks
___________________________________
System Administration
__________________________
1. Verify Completion of concurrent Programs
Will run programs after starting services
2. Install online help (recommended)
Already installed
3. Update/verify custom responsibilities (conditional)
Custom Step to be done later
4. Migrate custom development to new technologies (recommended)
Custom Step to be done later
5. Migrate the CUSTOM library (conditional)
Custom step to be done later
6. Copy and re-customize modified scripts or reports (conditional)
Modify .prog files
7. Copy existing custom start scripts (conditional)
Modify custom startup and shutdown scripts including MWA
8. Review user responsibility assignments (recommended)
Review user and responsibility assignments
Alerts
_________________
1. Associate organization names with custom Alert definitions (conditional)
N/A single org
Multiple Organizations
_____________________________
1. Set operating unit mode for customizations (conditional)
Analyze custom programs and set the following
UPDATE FIND_CONCURRENT PROGRAMS
SET MULTI_ORG_CATEGORY=’S’
WHERE CONCURRENT_PROGRAM_NAME = ‘<your program name>’\
Report Manager
__________________
1. Assign the Report Manager Data Migration Program to a request group (required)
Add the concurrent program “Data Migration Program” to ATDI Custom Reports request group
2. Run the Data Migration Program
This program moves to new schema
Program failed with an error — will check as part of testing
Web ADI
________________________
1. Recreate existing spreadsheets (conditional)
existing spreadsheets do not work with the new tech stack, recreate the spreadsheets
Will be done as part of testing
Workflow
__________________________________
1. Update Status Monitor URLs (required)
run the program “Workflow Plsql Cartridge Dependency Removal From Data” to update urls, there is also a data fix script in the clone documents
2. Synchronize Product License and Workflow BES license status (conditional)
Run program “Synchronize Product License and Workflow BES License”
Assign the program to request group “System Administrator Reports”
Oracle E-Business Suite Integrated SOA Gateway
_________________________________________________
Will apply SOA patches later
Customer Relationship Management Tasks
_________________________________________________
Email Center
__________________
1. Migrate Email Center data (recommended)
N/A do not use Email Center
Sales and Telesales
_____________________________
1. Run concurrent programs (required)
Do not use Sales and Telesales – Skipping
2. Migrate Sales methodologies for opportunities (required – application specialist)
Do not use Sales and Telesales – Skipping
3. Migrate Sales credits (required – application specialist)
Do not use Sales and Telesales – Skipping
Sales Upgrade From ASN.B to Release 12
_________________________________________
1. Run ASN Migrate Duplicate Salesrep Main Program.
Do not use Sales — Skipping
2. Run ASN Post Upgrade Log and Customer Update.
Do not use Sales — Skipping
Mobile Field Service
_______________________________
1. Migrate to the New Mobile Field Service Application (conditional)
Not using Mobile Field Service — Skipping
Financials and Procurement Tasks
___________________________________
Financials for India
_______________________
1. Apply custom logic for Projects functionality (conditional)
N/A for ATD — Skipping
Internet Expenses
___________________________
1. Ensure that document categories have valid sequences (conditional)
N/A for ATD — Skipping
Payments
______________________
1. Enter encryption key for Payments (conditional)
N/A for ATD — Skipping
2. Complete payment profile options for Netherlands (conditional)
N/A for ATD — Skipping
3. Complete Danish payment means and channels (conditional)
N/A for ATD — Skipping
4. Complete remittance advice controls for Italy (conditional)
N/A for ATD — Skipping
Human Resources Tasks
______________________
Human Resources
_________________
1. Apply latest HRMS Legislative Updates (required)
Complete as part of post patch application
2. Verify Labor Distribution tables (conditional)
N/A for ATD — Skipping
3. Re-seed custom salary components (conditional)
N/A for ATD — Skipping
4. Migrate Training Administration to Learning Management (conditional)
N/A for ATD — Skipping
5. Complete HRMS Configuration Workbench Setup (conditional)
N/A for ATD — Skipping
6. Verify Time Zone conversion for Learning Management (required)
N/A for ATD — Skipping
7. Check downtime reduction report (recommended)
N/A for ATD — Skipping
8. Migrate stored names to new and revised formats (required)
N/A for ATD — Skipping
Approvals Management
_______________________
1. Attach new responsibilities to existing users for AME (conditional)
N/A for ATD — Skipping
Payroll
___________________
1. Install or update Vertex for Payroll (conditional)
N/A for ATD — Skipping
2. Run the QuickPay Exclusions Data Upgrade process (recommended)
N/A for ATD — Skipping
3. Create translated Database Item names for Japanese Localizations (conditional)
N/A for ATD — Skipping
4. Compile Japanese flexfields after generating messages (required)
N/A for ATD — Skipping
5. Enable Subledger Accounting (SLA) (conditional)
N/A for ATD — Skipping
Intelligence Tasks
____________________
Intelligence
______________
1. Perform additional steps for Embedded Data Warehouse (required)
N/A for ATD — Skipping
2. Perform additional steps for End User Layer (conditional)
N/A — Already on latest release
3. Perform additional Daily Business Intelligence steps (required)
N/A for ATD — Skipping
4. Perform additional Balanced Scorecard steps (required)
N/A for ATD — Skipping
Daily Business Intelligence – Marketing
____________________________________________
1. Verify Initial Load, Incremental, and Dashboard reports (recommended)
N/A for ATD — Skipping
Daily Business Intelligence – Sales
______________________________________
1. Run Initial Request Set (required)
N/A for ATD — Skipping
2. Verify Initial Load, Incremental, and Dashboard reports (recommended)
N/A for ATD — Skipping
Projects Tasks
______________________
Property Manager
______________________
1. Create accounts distribution for leases (conditional)
N/A for ATD — Skipping
Supply Chain Management Tasks
___________________________________
Mobile Applications
______________________
1. Review MWA Server Administration Task Changes (required)
Edit scripts to use new location of config files
See 394495.1
Process Manufacturing
_________________________
1. Complete Inventory Convergence for OPM (conditional)
N/A for ATD — Skipping
Service Contracts
___________________________
1. Monitor Deferred Upgrade Tasks (conditional)
N/A for ATD — Skipping
Oracle Profitability Manager
______________________________
N/A for ATD — Skipping
Oracle Enterprise Performance Foundation
__________________________________________
System Maintenance Tasks
__________________________________
System Maintenance
______________________
1. Delete obsolete product files (recommended)
Skipping this and retaining 11i appl_top for reference
2. Drop obsolete columns (recommended)
Skipping this — Will check later
Check : Oracle Database Administrator’s Guide 11g Release 1 (11.1) for details.
3. Register new products (conditional)
N/A for ATD — Skipping
4. Update Java Color Scheme profile option for selected users (conditional)
Check the user profile settings before the upgrade and set the same
ATD Specific tasks
__________________________
ATD.1 Copy custom tops to R12 APPL_TOP
ATD.2 Edit adovars.env for PRD
ATD.3 Create common top
ATD.4 Recreate links — run recreate_links_all.sh
ATD.5 Reset utl_file_dir change the first value to point to the new tmp directory
alter system set utl_file_dir = ‘/u02/oracle/R12D/XXATD/12.0.0/comn/tmp’,'/usr/tmp’,'/u02/oracle/R12D/XXATD/12.0.0/comn/edi/outbound’,'/u02/oracle/R12D/XXATD/12.0.0/comn/edi/inbound’ scope=spfile;
ATD.6 Relink libraries
ATD.7 Apply Post Upgrade Patches See list post_upgrade_patches.txt
ATD.8 Define new managers for Post upgrade jobs See post_upgrade_jobs.txt
ATD.9 Tune database Tune Database using “11g-upgrade-best-practices-ebusiness_suite.pdf”
ATD.10 SQL Plan baselines Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE
Release jobs from hold
update fnd_Concurrent_requests
set hold_flag=’N’ where hold_flag = ‘Y’
and requesT_id in (select request_id from apps.atd_upgrade_jobs_on_hold)
********** Tablespace After Upgrade ******************
select df.tablespace_name “Tablespace”,
totalusedspace “Used MB”,
(df.totalspace – tu.totalusedspace) “Free MB”,
df.totalspace “Total MB”,
round(100 * ( (tu.totalusedspace)/ df.totalspace))
“Pct. Used”
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
and tu.tablespace_name not in (‘UNDO1′,’UNDO2′,’UNDO3′,’UNDO4′)
order by 2 desc
TABLESPACE USED_MB FREE_MB TOTAL_MB PCT_USED
APPS_TS_TX_DATA 928373 119932 1048305 89
APPS_TS_TX_IDX 688250 77696 765946 90
SABRIX_DATA 302276 31546 333822 91
XXATDD 217218 264060 481278 45
XXATDX 53982 13602 67584 80
APPS_TS_SUMMARY 51623 25169 76792 67
APPS_TS_MEDIA 42126 7026 49152 86
UNDO5 31582 9378 40960 77
APPS_TS_INTERFACE 26399 4321 30720 86
APPS_TS_CUSTOM_INV_DATA 22101 54699 76800 29
SYSTEM 17739 2741 20480 87
APPS_TS_NOLOGGING 14159 27881 42040 34
TOOLS 13801 2583 16384 84
APPS_TS_ARCHIVE 11860 3236 15096 79
SYSAUX 9394 5966 15360 61
APPS_TS_CUSTOM_INV_IDX 9071 4241 13312 68
APPS_TS_SEED 8226 3066 11292 73
APPS_TS_QUEUES 3349 18211 21560 16
JAROSCHTRKDAT 2182 120698 122880 2
XXATD_STD_EUL 1103 945 2048 54
JAROSCHTRKIDX 1009 50191 51200 2
DISCOVERER 168 856 1024 16
PORTAL 34 266 300 11
