2014년 11월 6일 목요일

[EBS] Insalling Oracle E-Business Suite 12.1.3 for Solaris SPARC

**************************************************************
* Insalling Oracle E-Business Suite 12.1.3 for Solaris SPARC *
**************************************************************


12.1.1
======

Note 761568.1 - Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Oracle Solaris on SPARC (64-bit)
Note 788053.1 - Oracle Applications NLS Release Notes, Release 12.1


Install 12.1.1
--------------

1. edelivery에서 12.1.1 Media download (startCD 제외, NLS 포함)
2. download latest startCD (Patch 11072566)
   http://blogs.oracle.com/stevenChan/entry/new_rapid_install_startcd_12
3. unzip above all
4. run rapidwiz
5. Completed Component version
   - DB : 11gR1 11.1.0.7.0
   - OC4J : 10.1.3.4 -> 10.1.3.5
   - Forms : 10.1.2.3
   - Dev10g : 10.1.2.2
   - Java Plug-in : 1.6.0_07 -> 1.6.0_29



Add to NLS(KO)
--------------

1. Apply Patch 8576725 (12.1.1 NLS PATCHING PERFORMANCE FIX)

2. Enable KO Language License
   Oracle Application Manager > License Manager > Languages
   Check Korean > Submit > Submit

3. Maintain Multi-lingual table
   $ adadmin
     4.  Maintain Applications Database Entities menu > 3. Maintain multi-lingual tables

4. Create NLS Patch Stage
   unzip V16174-01.zip  => 6678700_KO

5. Apply NLS Stage
   $ cd 6678700_KO
   $ Apply patch using drive u6678700.drv
     FADTXD.xlf Error

adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
  -DB_USERNAME apps -DB_PASSWORD apps \
  -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ocskrebs)(PORT=1521)))(CONNECT_DATA=(SID=OCSKRVIS)))" \
  -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE 00 \
  -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME $FA_TOP/patch/115/publisher/defs/FADTXD.xml

adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
  -DB_USERNAME apps -DB_PASSWORD apps \
  -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ocskrebs)(PORT=1521)))(CONNECT_DATA=(SID=OCSKRVIS)))" \
  -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE en \
  -TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME $FA_TOP/patch/115/publisher/templates/US/FADTXD.rtf

위 command 수행 후 Patch Again


6. Apply Patch 6746000 (ONLINE HELP FOR ORACLE APPLICATIONS RELEASE 12.1.1 (12.1.1 iHelp Upgrade Driver))




12.1.3
======

Note 1080973.1 - Oracle E-Business Suite Release 12.1.3 Readme

Applying the Release Update Pack
--------------------------------

9239089 - Oracle Applications DBA 12.1.3 Product Release Update Pack (Patchset R12.AD.B.delta.3)
  * Pre-install Tasks
    1. Create $ORACLE_HOME/appsutil/admin on the database server.
    2. Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin.
    3. Set the environment to point to ORACLE_HOME on the database server.
    4. Use SQL*Plus to run the script:
       $ sqlplus /nolog
       SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>
  * Apply The Patch

9239090 - ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK
  * Pre-install Tasks
    1. Apply R12.AD.B.DELTA.3
  * Apply The Patch
    Forms pll Compile Error
    Forms Compile Error
csd forms/US CSDREPLN.fmx
wsh forms/US WSHSTREF.fmx
wsh forms/US WSHQSSUI.fmx
wsh forms/US WSHFSTRX.fmx

    Report pll Compile Error
au plsql FABAL.pll
au plsql FARSV.pll
au plsql fadolif.pll

    Report Compile Error
  * Post-install Tasks
    1. Latest legislation data update (Hrglobal installation) : Note 145837.1

9239095 - Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack




Post-Update Steps
-----------------

Note 9817770 - R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH]
Note 9966055 - R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED]

Update database tier nodes with the Oracle E-Business Suite Release 12.1.3 code level
  perl $AD_TOP/bin/admkappsutil.pl
  unzip -o appsutil.zip
  perl adpreclone.pl dbTier
  perl adpreclone.pl appsTier




Upgrade OracleAS 10g 10.1.3.5
=============================

Note 454811.1 - Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12

  Patch 8971404 (R12.TXK.B) <= already applied (include 12.1.3)
  Patch 7359933 (Template patch) <= already applied (include 12.1.3)
  Patch 8920270 (Environment Preparation Patch) : Must merge to Patch 8626084 before 10.1.3.5.0
  Patch 8626084 (OracleAS 10g 10.1.3.5.0)
  Patch 8999551 (REQEUST TO EVALUATE TO REV UP THE JAVA MAILER APIS TO LATEST TO SUPPORT SSL)

  AutoConfig




Upgrade Java Plug-in
====================

Note 393931.1 - Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

  Patch 4377566 (JRE Plug-in Interoperability Patch)
  Download Latest JRE (1.6.0_29), rename to j2se16029.exe, copy to $COMMON_TOP/webapps/oacore/util/jinitiator

  txkSetPlugin.sh 16029




--------------------------------------------------------------------------------------------------------------------------


Upgrade Java
============

Using Latest Java 6.0 Update With Oracle E-Business Suite Release 12 (Doc ID 455492.1)



Database Upgrade
================

Note 1058763.1 - Interoperability Notes Oracle E-Business Suite Release 12 with Oracle Database 11g Release 2 (11.2.0)
Note 456347.1  - Using Oracle E-Business Suite Release 12 with a Database Tier Only Platform on Oracle 11g Release 2

Section 1: Upgrading an R12 Database to Oracle Database 11g Release 2 (11.2.0)
------------------------------------------------------------------------------
  11g Release 2 interoperability patch for Release 12.1 (9062910)
  12.1 TXK Delta 3 patch (8919489) <= already applied (include 12.1.3)
  9868229
  10163753
  11071569
  9182368 <= already applied (include 12.1.3)
  9403153
  9738085
  9852070

댓글 없음:

댓글 쓰기