R12.2 Apps DBA. Powered by Blogger.

High Level Step Of Upgrade R12.2

No comments :
1.Pre-requites steps for upgrade
a. pre-install rpm,lib,gcc packages on both application and database operating system.
b. Take backup of whole application file system and database as a cold backup.
c. Take Backup of oracle software binaries.
d. Disk Space Requirements.
e. Add following parameter to initialize parameter file
1.        *.service_names=SID, ebs_patch
2.       *.sec_case_sensitive_logon=FALSE
3.       *.local_listener='SID_LOCAL'
4.       *.plsql_optimize_level=2
5.       *.job_queue_process=4 (number of CPU).
6.        *. recyclebin=off
f. Gather schema statistics login as sysdba user.
SQL>FND_STATS.GATHER_SCHEMA_STATISTICS ('ALL', 10, :parallel_degree, 'NOBACKUP', NULL, 'LASTRUN', 'GATHER AUTO', 10, 'N');
g. Download software for upgrade from edeliver.oracle.com
h. Run buildStage.sh (Make sure run this script as root user)
i. Run buildStage.sh (Make sure run this script as root user)
A. Start installation of Application of R12.2.0 as a root user.
   $ cd /u02/apdba/ebs_upgrade_12_2/R12.2_Source/startCD/Disk1/rapidwiz
   $./ rapidwiz
1. choose Upgrade to Oracle E-Business suite Release R12.2.0 and press Next button to continue.
2. deselect check box to avoid any updates from My Oracle support.  Click next.
3. First select "Create Upgrade File System" to configuring and creating an upgrade file system or upgraded database.
4. Specify the port pool values for port pooling and press on Edit ports for specify DB port.
5. Database node configuration wizard.
   Fill all details about database host, SID, Port, Domain Name, DB OS User, Base Directory and RDBMS ORACLE_HOME.
   Dont forget to select "User Existing Oracle Home (No New Database Home Install).
6. Provide APPS user password details and review APPLSYSPUB and GUEST user details.
7. Select your database character set and press Next.
8. Fill all details in below wizard for application node and verify the apps base directory ,
   instance home directory and click on Edit Services, enabled all services as Application and db are running on single server.
9. Enter weblogic handy password and application OS user password.
10. It will display all node information. Press Next to continue.
11. This is pre-install validation steps. all must be completed with green yes mark.
    If its failed any of area of the prerequisites checks, then we have to fix the issue first and press retry button.
12. list of component will be installed after rapiz wizard is completed successfully.
    Press Next to continue.
13. list of component will be installed after rapiz wizard is completed successfully.
Press Next to continue.
C. Configure Release R12.2 E-Business Suite Instance.
a. Update the RDBMS ORACLE_HOME file system with Auto Config and Clone files.
1) Run environment file of application file system.
2) $perl <AD_TOP>/bin/admkappsutil.pl
3) Copy to RDMBS_HOME (DATABASE HOME)
4) unzip -o appsutil.zip
•    Generate a new database context file
1) $cd <RDBMS ORACLE_HOME>/appsutil/bin
2) $perl adbldxml.pl
•    Run AutoConfig on the database tier nodes
1) $Cd <RDBMS ORACLE_HOME>
2) $cd appsutil/bin/
3) $adconfig.sh contextfile
•    Run AutoConfig on the Apps Tier.
1) Run environment file on apps Tier.
2) Login to as apps/apps user
3) Prior to running AutoConfig check if table - ADX_PRE_AUTOCONFIG is existing in APPS schema:
    Select object_name, object_type, owner, status from dba_objects where    upper(object_name) = 'ADX_PRE_AUTOCONFIG' and object_type='TABLE' and upper(owner)='APPS';
4)
    Cd $AD_TOP/patch/115/sql
    Sqlplus apps/appson
    Sql> @txkDropAdxPreAutoConfig.sql
7) Run Autoconfig: go to $ADMIN_SCRIPT_HOME/
8) $sh adautocfg.sh
D. Run Rapid Install to configure Release 12.2 E-Business Suite instance.
1. You must run Rapid Install a second time to complete the configuration using Run File System context file.
2. Select “upgrade to oracle E-business suite release 12.2.0” and press “next” to continue.
3. Select an existing application context file from newly installed file system.
4. Review Application user information
D. DONT FORGET TO PERFORM POST INSTALL STEPS FROM PATCH README’s

No comments :

Post a Comment

Note: only a member of this blog may post a comment.