Up Gradation Doc

Upgradation from 10.7 to 11.5.10.2 Step 1 Install the file system: Initially I install the oracle application file system like Create two useraccounts like applmgr and oramgr as a root user Useradd -g dba -md /u01/appsumo appsumo Useradd -g dba –md /u01/orasumo orasumo Initially I install the oracle application file system like Run the. /rapidwiz (Then we will get the wizard like below).

This screen lists the components that are included in, or supported by, this release of Oracle Applications.

Step 2 Select a wizard operation: Use the Select Wizard Operation screen to indicate the action you want Rapid Install toperform. The available actions are as follows:  

Install Oracle Applications E-Business 11i Upgrade to Oracle Applications E-Business 11i

Here we need to select Upgrade to Oracle Applications E-Business 11i for installing the file system.

Step 3: identification of configuration file:

We will be indicate whether we are using an existing config.txt or new config file

Step 4: Choose the installation type identification of configuration file:

Step 5: Define the database type In this we have to give which database we are installing whether it is demodatabase or fresh database.

Step 6: Set up database installation directory

On a Unix (or Linux) operating system, the screen would look like this.

Step 7: Save the configuration file:

Step 8: Review pre-install checks

Step 9: Begin the installation

During an installation, Rapid Install displays a main progress bar and an individual progress bar.

I created manual database By using creat database command: Edit init pfile parameters Change control file locations Change undo tablespace name Create database script logfile group 1 ('/u01/oraupgrade/upgradedata/log01.rdo') size 15m, group 2 ('/u01/oraupgrade/upgradedata/log02.rdo') size 15m, group 3 ('/u01/oraupgrade/upgradedata/log03.rdo') size 15m datafile '/u01/oraupgrade/upgradedata/system01. dbf' size 100m autoextend on next 512k maxsize 120m

default temporary tablespace temp tempfile '/u01/oraupgrade/upgradedata/temp01.dbf' size 15m autoextend on next 5m maxsize 20m undo tablespace UNDOTBS1 datafile '/u01/oraupgrade/upgradedata/undo01.dbf' size 15m autoextend on next 5m maxsize 60m character set WE8ISO8859P1 national character set AL16UTF16; Run this creat database script like below: SQL > srartup nomount; SQL > @/u01/oraupgrade/manualscript.sql

Run postscripts after creation of empty database Create a directory named admin in /u01/orasumo/9.2.0/appsutil Copy the following four scripts from APPL_TOP/admin to /u01/orasumo/9.2.0/appsutil/admin. --addb920.sql---adjv920.sql---admsc920.sql---adsy920.sql--Result: -The above scripts create objects required by RDBMS and other technology stack components on the database server

Create tablespaces along with sizes required AKD AKX APD APX ARD ARX AXD AXX BOMD

BOMX EAOD EAOX FNDD FNDX GLD GLD GLX ICXD

ICXX INVD INVX MRPD MRPX OED OEX PANGEA POD

POX RBS RBS_TUNE RGD RGX SHD SHX SYSTEM TEMP

TOOLS WIPD USERS WIPX

Take Cold backup Perform the following steps to take whole database backup:1. 2. 3. 4.

Sqlplus ‘/as sysdba’ Shut immediate Cp all datafiles to respective backup loccation Startup the database.

Import given exported 10.7 dump to existing database [imp system/manager

full=y log=/u01/oraupgrd/9.2.0/imp01.log]

After completing the importing we need to chech whether we are able to connecting Sqlplus apps/apps (It is the mandatory, if not then there is some problem with importing. So need to import the data again).

Perform pre upgrade steps Database upgrade tasks:Before doing this tasks, better take advantage of The Upgrade Manual Script(TUMS). This creates script that lists the upgrade steps that do not apply to your system To generate TUMS report I follow the doc:-230538.1 Download the patch 3422686 as follows:$ftp updates.oracle.com ftp> bin ftp>cd 3422686 ftp>get P3422686_solaris.zip ftp>bye When you apply the patch, it loads objects into your APPS schema that TUMS uses to examine your Applications configuration. Your current Applications environment is not affected. Unzip the patch as follows:$unzip P3422686_solaris.zip

In the patch directory there will be adtums.sql To generate tums.html run adtums.sql as follows:$cd $AD_TOP/patch/110/sql $sqlplus APPS /appspassword @adtums.sql

Applications Technology: Oracle Alert Tasks (To drop all event alert database triggers in custom schemas, run alrdtrig.sql from the new APPL_TOP. Re-create the triggers in Step 2 of the Oracle Alert Tasks in Chapter 6 (Rerun alrdtrig.sql, which is located in the preupg subdirectory of the admin directory under APPL_TOP, for each custom schema. If alrdtrig.sql has been run for all custom schemas, then open each [schema]. sql (created by this script), which can be found in the current directory, and manually delete the drop trigger Statements, which do not belong.) $ cd $APPL_TOP/admin/preupg SQL > <APPS username>/<APPS password> @alrdtrig.sql SQL > @/u01/applupgrade/upgradeappl/admin/preupg/apps.sql Trigger dropped. Trigger dropped. SQL > @/u01/applupgrade/upgradeappl/admin/preupg/alrdtrig.sql Enter username for custom schema. Username: applsys Enter password for custom schema. Password: apps Connected. SQL > @/u01/applupgrade/upgradeappl/admin/preupg/applsys.sql SQL > @/u01/applupgrade/upgradeappl/admin/preupg/alrdtrig.sql Enter username for custom schema. Username: applsyspub Enter password for custom schema. Password: pub. Connec SQL > @/u01/applupgrade/upgradeappl/admin/preupg/applsyspub.sql

Oracle Common Modules Tasks: Review the output (akchkp16.rpt) for invalid data. If the report indicates a problem, use the appropriate Oracle Application forms to correct the problem. (You can run scripts akfxmrp1.sql and akfxmrp2.sql to correct specific problems as described in OracleMetaLink Doc 184261.1). Continue to run the scripts (from the new APPL_TOP) and make corrections until there is no invalid data.

Check the output (akchkr11.rpt) for invalid data. Use the appropriate Oracle Applications forms to make corrections. Continue to run the script (from the new APPL_TOP) and make corrections until there is no invalid data. $ cd $APPL_TOP/admin/preupg SQL > <APPS username>/<APPS password> @akchkp16.sql

Oracle Workflow Tasks: If you customized seeded item types in prior versions of Oracle Workflow, the new seed data may not load properly when you use the Workflow Definitions Loader. To see a list of item types, type the following at any prompt: First query the itemtypes like SQL> select ITEM_TYPE from WF_LOOKUP_TYPES It will give the some item_types like ECO_APP WFMAIL APEXP HRSTAND HREKIOSK CSSTAND HRAPPRVL $ cd $APPL_TOP/admin/preupg $ SQL <APPS username>/<APPS password> @wfprotrst

Database and System Administration: System Administration Tasks: If you originally installed Oracle Applications with Release 9.3 or earlier, ensure that the IDs for existing ORACLE schemas do not conflict with ones necessary for new schemas created by AutoUpgrade. To identify potential conflicts, run the following script from the new APPL_TOP: $ cd $APPL_TOP/admin/preupg

$ SQL / @adpuver.sql Set up tablespaces : Convert existing tablespaces to local extent management We recommend using local extent management to increase performance. To convert all non-SYSTEM tablespaces from Data Dictionary extent management to local extent management, run the following script: $ cd $APPL_TOP/admin/preupg $ SQL <SYSTEM username>/<SYSTEM password> @adtbscnv.pls <SYSTEM password> Create new product tablespaces and resize existing product tables In this task, you determine your system’s tablespace requirements, and create (and resize) the product tablespace. You can choose to begin the conversion to the new Oracle Applications tablespace model, or continue to use the existing model. $ cd $AD_TOP/patch/115/sql $ sqlplus <APPS username>/<APPS password> @adgnofa.sql <MODE> By running the above script generates adcrtbsp.sql   Review the information in adcrtbsp.sql and specify the location of the data files. Then, run it from the database server as the SYSTEM user to add new product tablespaces and resize the existing product tablespaces Apply database patch:

Before you continue with the upgrade, apply patch 3835781 to update/create necessary OWS packages. Create subdirectory $ORACLE_HOME/appsutil/admin/OWS Download patch 3835781 to any patch directory and unzip it. Copy the following files from the directory where you downloaded the patch the subdirectory you created in Step 1: patch.sql, modplsql/owa/pubmat.sql, modplsql/owa/privmat.sql. From the directory $ORACLE_HOME/appsutil/admin/OWS, execute the Following commands: $ Sqlplus / nolog SQL> connect / as sysdba SQL> @patch.sql Run preparatory script – administration node :

Run this script from the admin directory under the new APPL_TOP. Make sure you have permission to write to that directory.

Sqlplus <SYSTEM username>/<SYSTEM password> @adsysapp2.sql <SYSTEM password> Check the spool file for errors. Invalid packages in the database are acceptable. They are validated when you run AutoUpgrade. Gather database statistics for CBO:

$ Cd $FND_TOP/patchsc/107/sql $ Sqlplus <APPS username>/<APPS password> @afstatrn.sql FALSE Gather database information:

The adupinfo.sql script generates a file called adupinfo.lst, which contains information You will need later in the upgrade. Run adupinfo.sql from the new APPL_TOP. $ Cd $APPL_TOP/admin/preupg $ Sqlplus <APPS username>/<APPS password> @adupinfo.sql Install XML Parser for PL/SQL :

Create ORACLE_HOME/appsutil/admin/xmlparser directory on the node where you have installed the database, if they do not already exist. Copy plxmlparser_v1_0_2.zip from COMMON_TOP/util to ORACLE_HOME/appsutil/admin/xmlparser and unzip it. This file creates several subdirectories in the current location CopyXSU12_ver1_2_1.zipfromCOMMON_TOP/utiltoORACLE_HOME/appsutil/admin and unzip it. This file creates a single subdirectory (OracleXSU12) and places everything under that directory. Follow the installation instructions in the readme file for each product (xmlparser/lib/README for the XML Parser for PL/SQL, and OracleXSU12/lib/README for the XML SQL Utility. Use the following procedure to load the Oracle XML Parser for PL/SQLinto Oracle Applications 11i database: o Log onto the OS as the owner of the Oracle Applications database node. o Set your environment to point to the ORACLE_HOME on your Applications database server. o Create an ORACLE_HOME/appsutil/admin/xmlparser directory on your database server: $ mkdir ORACLE_HOME/appsutil/admin/xmlparser

o Copy "plxmlparser_v1_0_2.zip" from $COMMON_TOP/util to ORACLE_HOME/appsutil/admin/xmlparser. o Uncompress the "plxmlparser_v1_0_2.zip" file using unzip: $ cd ORACLE_HOME/appsutil/admin/xmlparser $ unzip plxmlparser_v1_0_2.zip o Change directory to: $ cd lib/java o Load the following jar files into database: $ loadjava -user <APPS user/APPS password> -r -v xmlparserv2.jar $ loadjava -user <APPS user/APPS password> -r -v xmlplsql.jar o Change directory to the sql subdirectory: $ cd ../sql o Load the XML Parser for PL/SQL packages into the APPS schema using SQL*Plus: $ cat load.sql | sqlplus <APPS user/APPS password> This will load all the sql files needed by the PLSQL XML parser. o Update XML Parser for Java version to ensure consistency between the application tier and the database. If the database server and the Applications servers are on the same node, change to the location of the JAVA_TOP and run the loadjava command. If they are not on the same node, copy xmlparserv2.zip from $JAVA_TOP on any Applications server node to a temporary location on the node where the database server is installed. Load it into the APPS schema using the following syntax: @ loadjava -user <APPS username>/<APPS password> -r -v xmlparserv2.zip Install all packages in the APPS schema.

Run Autoupgrade

To continue to use the OFA-compliant (old) tablespace model: $ adaimgr consolidated_tablespace=N