Upgradation from 11.5.10.2 to R12 steps

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
akumar.oracle
Posts: 195
Joined: Sat May 31, 2008 1:29 pm
Location: India

Upgradation from 11.5.10.2 to R12 steps

Post by akumar.oracle »

Hi,
I am trying to upgrade from 11.5.10.2 (on 9i) to R12 (on 10g)

Currently have

/u01 = Database Tier
/u02 = Application Tier

Below are the steps that i figured out can someone please correct the steps that are highlighted.

1. In maintainance mode install p4653225 patch

2. $ ORACLE_HOME=/u01/visdb/10.2.0
$ export ORACLE_HOME

3. set kernel parameter in sysctl.conf

4. Install oracle 10g

5. unzip p4547817
$ cd .../Disk1
$ ./runInstaller

6. create $ vi /u01/visdb/10.2.0/oracle10g.env
$ORACLE_HOME=/u01/visdb/10.2.0
$export ORACLE_HOME

$PATH=$ORACLE_HOME/bin:$PATH
$export path:$PATH

$LD_LIBRARY_PATH=$ORACLE_HOME/lib
$export LD_LIBRARY_PATH

$CLASS_PATH=$ORACLE_HOME/jlib
$export CLASS_PATH

$ORACLE_SID=VIS
$export ORACLE_SID


7. $. ./oracle10g.env

8. Shutdown 9i db and listener
SQL> shutdown immediate
$ lsnrctl stop LISTENER

9. $ dbua

10. a.) configure listener
b.) check database version
c.) mkdir $ORACLE_HOME/rdbms/10.2.0.2
d.) in apputil create xml <span id='hl' style='background-color: yellow'>(I AM CONFUSED HERE... WHAT TO WRITE IN THAT XML FILE??)</span id='hl'>
e.) run autoconfig in DB & apps tier
in COMMON_TOP run autoconfig

f.) start all app tier services
g.) install R12 in upgrade mode

11. su - applmgr
$AD_TOP/bin/admkapplutil.pl

12. su - oracle
cd $ORACLE_HOME
cp /u01/oracle/inst/apps/test_linux/admin/out/appsutil.zip .

13. cd $ORACLE_HOME/appsutil/adautoconfig
sh adautocfg.sh

14. Post R12 steps
In R12 rdbms home inside VIS_init.ora file
specify path of control file
apply R12 adi patch on R12 app tier <span id='hl' style='background-color: yellow'>(WHAT IS ADI PATCH NUMBER????)</span id='hl'>

su - oracle
cd $ORACLE_HOME/appsutil
mkdir admin

su - applmgr
cd $APPL_TOP/admin
cp adgrants.sql /u01/db/test_st/10.2.0/appsutil/admin

su - oracle
cd $ORACLE_HOME/appsutil/admin
sqlplus / as sysdba <span id='hl' style='background-color: yellow'>(IT DOESNT RECONIZE THIS sqlplus apps/apps WORKS THOUGH)</span id='hl'>
> @adgrant.sql APPLSYS
apply R12 ada patch (WHAT IS ada patch???)
apply maintainenance pack u4440000.drv from AD_TOP
adpatch options=nocopyportion,nogenerateportion



Please help

ta
Arvin
Post Reply

Who is online

Users browsing this forum: No registered users and 17 guests