Upgrade 11.5.10 to R 12.1.1 / DB 9.2.0.5.0 to 10.2.0.4.0
STEP1: Apply Patch 7429271 (Application side)
1.[oracle@track admin]$ pwd
/home/oracle/Desktop/11ipatch/7429271/admin
[oracle@track admin]$
2.Copy the adgrants.sql from patch path to ORACLE_HOME
[oracle@track admin]$ cp adgrants.sql /oracle/APPS11/prod11idb/9.2.0/appsutil/admin/
3.Run the adgrants.sql script in sqlplus
SQL> @/oracle/APPS11/prod11idb/9.2.0/appsutil/admin/adgrants.sql apps
STEP2: Apply Patch 7705743 (Application side)
DB Side
Upgrade database Steps:
STEP 1: Down the DB/APPS /Listener
STEP 2:Install the 10g software & companion & upgrade patch
Step2.1:Install 10g(10.2.0.1) software
[oracle@track oracle]$ cd /192.168.3.142/Database10g/database10g/
[oracle@track database10g]$ ls
doc install response runInstaller stage welcome.html
[oracle@track database10g]$ ./runInstaller
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-08_09-50-58AM. Please wait ...[oracle@track database10g]$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
You have new mail in /var/spool/mail/oracle
Step2.2:Install 10g companion(select the 2 option(oracle 10g database product))
[oracle@track database10g]$ cd ..
[oracle@track Database10g]$ ls
10204Patchset companion database10g
[oracle@track Database10g]$ cd companion/
[oracle@track companion]$ ls
doc install response runInstaller stage welcome.html
[oracle@track companion]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-08_10-08-00AM. Please wait ...[oracle@track companion]$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
[oracle@track companion]$
Step2.3:Install 10g Upgrade Patch(10.2.0.4).
[oracle@track Database10g]$ cd 10204Patchset/
[oracle@track 10204Patchset]$ ls
10204_buglist.htm install patch_note.htm response runInstaller stage
[oracle@track 10204Patchset]$
[oracle@track 10204Patchset]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-02-08_12-23-09PM. Please wait ...[oracle@track 10204Patchset]$ Oracle Universal Installer, Version 10.2.0.4.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.
You have new mail in /var/spool/mail/oracle
[oracle@track 10204Patchset]$
STEP 3: # Apply additional 10.2.0.4 RDBMS patches
Apply the following patches:
* 6880880 or the latest OPatch version.
* 6521934
* 6600051
* 7496636
* 7497678
STEP 4: Soure the 9i database environment file
[oracle@track 10.2.0]$ cd /oracle/APPS11/prod11idb/9.2.0/
[oracle@track 9.2.0]$ . PROD11i_track.env
[oracle@track 9.2.0]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Feb 8 10:34:46 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 581506616 bytes
Fixed Size 452152 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.
Database opened.
SQL> @/oracle/9ito10g/db/tech_st/10.2.0/rdbms/admin/utlu102i.sql ==> (This script takes from 10G home path)
Oracle Database 10.2 Upgrade Information Utility 02-08-2012 10:37:04
.
**********************************************************************
Database:
**********************************************************************
--> name: PROD11I
--> version: 9.2.0.5.0
--> compatible: 9.2.0
.
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
--> The existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 7674 MB
--> ODM tablespace is adequate for the upgrade.
.... minimum required size: 10 MB
--> APPS_TS_QUEUES tablespace is adequate for the upgrade.
.... minimum required size: 72 MB
--> OLAP tablespace is adequate for the upgrade.
.... minimum required size: 15 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: --> "streams_pool_size" is not currently defined and needs a value of
at least 50331648
WARNING: --> "large_pool_size" needs to be increased to at least 8388608
WARNING: --> "session_max_open_files" needs to be increased to at least 20
.
**********************************************************************
Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
-- No deprecated parameters found. No changes are required.
.
**********************************************************************
Obsolete Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
--> "optimizer_max_permutations"
--> "row_locking"
--> "undo_suppress_errors"
--> "max_enabled_roles"
--> "enqueue_resources"
--> "sql_trace"
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
...The 'JServer JAVA Virtual Machine' JAccelerator (NCOMP)
...is required to be installed from the 10g Companion CD.
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [install]
--> Real Application Clusters [upgrade] INVALID
--> Oracle Data Mining [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] LOADED
--> OLAP Catalog [upgrade] VALID
--> Oracle OLAP API [upgrade] LOADED
--> Oracle interMedia [upgrade] VALID
...The 'Oracle interMedia Image Accelerator' is
...required to be installed from the 10g Companion CD.
--> Spatial [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Passwords exist in some database links.
.... Passwords will be encrypted during the upgrade.
.... Downgrade of database links with passwords is not supported.
WARNING: --> Deprecated CONNECT role granted to some user/roles.
.... CONNECT role after upgrade has only CREATE SESSION privilege.
WARNING: --> Database contains stale optimizer statistics.
.... Refer to the 10g Upgrade Guide for instructions to update
.... statistics prior to upgrading the database.
.... Component Schemas with stale statistics:
.... SYS
.... ODM
.... OLAPSYS
.... MDSYS
WARNING: --> Database contains INVALID objects prior to upgrade.
.... USER APPLSYS has 1 INVALID objects.
.... USER APPS has 258 INVALID objects.
.... USER CTXSYS has 8 INVALID objects.
.... USER SYS has 261 INVALID objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
--> New "SYSAUX" tablespace
.... minimum required size for database upgrade: 500 MB
.
PL/SQL procedure successfully completed.
SQL>
Create SYSAUX tablespace
SQL> create tablespace SYSAUX datafile '/oracle/APPS11/prod11idata/sysaux001.dbf' size 600m reuse
2 extent management local
3 segment space management auto
4 online;
Tablespace created.
SQL>
SQL>
Check the INVALID Objects
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
275
SQL>
Compile the INVALID Objects
SQL> @?/rdbms/admin/utlrp.sql
STEP 5: Down the db
STEP 6: Move the 9i PFILE to 10G home/dbs
STEP 7: Source the 10G profile(environment)
[oracle@track admin]$ cd /oracle/9ito10g/db/tech_st/10.2.0/
You have new mail in /var/spool/mail/oracle
[oracle@track 10.2.0]$ vi profile
export ORACLE_HOME=/oracle/9ito10g/db/tech_st/10.2.0
export ORACLE_SID=PROD11i
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_TERM=xterm
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export LDPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
STEP 8: Startup the Database Upgrade mode
SQL> startup upgrade
STEP 9: Run the Script /oracle/9ito10g/db/tech_st/10.2.0/rdbms/admin/catupgrd.sql
Total Upgrade Time: 01:20:48
STEP 10: DOWN the DB and strtup the normal mode
STEP 11:Compile the INVALID Objects
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
111543
1 row selected.
SQL> @?/rdbms/admin/utlrp.sql
STEP 12: Create Listener
Copy the 9i listener/tns paste on 10g HOME/network/admin and change the path
[oracle@track PROD11i_track]$ pwd
/oracle/APPS11/prod11idb/9.2.0/network/admin/PROD11i_track
[oracle@track PROD11i_track]$
[oracle@track PROD11i_track]$ cp -pr *.ora /oracle/9ito10g/db/tech_st/10.2.0/network/admin/
STEP 13: Create appsutil folder using /AD_TOP/bin/admkappsutil.pl and paste in 10g HOME
STEP 14:Create XML file using /appsutil/bin/adbldxml.sh
[oracle@track 10.2.0]$ cd appsutil/bin/
[oracle@track bin]$ perl adbldxml.sh tier=db appsuser=apps appspass=apps jtop=/oracle/9ito10g/db/tech_st/10.2.0/jre/1.4.2
Using JVM from /oracle/9ito10g/db/tech_st/10.2.0/jre/1.4.2/bin/java ...
The context file has been created at:
/oracle/9ito10g/db/tech_st/10.2.0/appsutil/PROD11i_track.xml
The log file for this adbldxml session is located at:
/oracle/9ito10g/db/tech_st/10.2.0/appsutil/log/PROD11i_track/02101223.log
[oracle@track bin]$
STEP 15: Run the adconfig and give the newly created XML file
[oracle@track bin]$ perl adconfig.sh
Enter the full path to the Context file:
[oracle@track bin]$ perl adconfig.sh
Enter the full path to the Context file: /oracle/9ito10g/db/tech_st/10.2.0/appsutil/PROD11i_track.xml
Enter the APPS user password:
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracle/9ito10g/db/tech_st/10.2.0
Using java command : /oracle/9ito10g/db/tech_st/10.2.0/jre/1.4.2/bin/java
Java version : 1.4.2_14
Classpath : /oracle/9ito10g/db/tech_st/10.2.0/jre/1.4.2/lib/rt.jar:/oracle/9ito10g/db/tech_st/10.2.0/jdbc/lib/ojdbc14.jar:/oracle/9ito10g/db/tech_st/10.2.0/appsutil/java/xmlparserv2.zip:/oracle/9ito10g/db/tech_st/10.2.0/appsutil/java
Using Context file : /oracle/9ito10g/db/tech_st/10.2.0/appsutil/PROD11i_track.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db817
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
The log file for this session is located at: /oracle/9ito10g/db/tech_st/10.2.0/appsutil/log/PROD11i_track/02101235/adconfig.log
[oracle@track bin]$
DB Side is Finshed.
Application -Side Upgrade.
STEP1: Enable Multi Organization
==> Source the 11i environment file.
==> Run the adadmin and select 4th option(Maintain Applications Database Entities menu) and select 6th option(Convert to Multi-Org)
STEP2: Run the R12.1.1 stage in upgrade mode(select second option)
STEP3: db node configure on the page type the unknown Node name (only installing application)
Installation completed with out errors.
STEP4: Error
by mistake R12.1.1 installation on the time given the wrong DATABASE(PROD) name.
but my upgrade db name is PROD11i. so application is not connect to database.
Solution:
==>Run the COMM_TOP/clone/bin/adclonectx.pl
[oracle@track bin]$ perl adclonectx.pl contextfile=/oracle/9ito10g/inst/apps/PROD11i_track/appl/admin/PROD_track.xml
==> source the APPL_TOP environment file.
==>sqlplus apps/apps at the time no error means continue the next step.
STEP5: Apply the Patch of 7461070 (AD 12.1.1 upgrade driver)
STEP6: Apply the driver patch 6678700
==> Go to $AU_TOP/patch/115/driver
==> adpatch options=nocopyportion,nogenerateportion
No comments:
Post a Comment