Right now all the modern apps system are running on Modern R12.2.x version. R11i is fairly obsoleted. These steps will help DBA still working on these legacy system
Steps to upgrade 11i Application database to 11gR1
1) Oracle Application Prerequisites patches before upgrade : Interoperability notes for Oracle Applications 11i with 11gR1 – 452783.12) Install Oracle 11.1.0.x software
3) run pre upgrade tool
4) collect stats on database
5) Check for Connect Role and get user or role list which are having the connect role
SELECT grantee FROM dba_role_privs
WHERE granted_role = 'CONNECT' and
grantee NOT IN (
'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',
'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',
'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY',
'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS',
'WMSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',
'SI_INFORMTN_SCHEMA', 'XDB', 'ODM');
SELECT GRANTEE,PRIVILEGE FROM DBA_SYS_PRIVS
WHERE GRANTEE='CONNECT';
6) Take invalid objects
select owner,object_name,object_type from dba_objects where status='INVALID';
7) Complete Materialized View Refreshes
SELECT DISTINCT(TRUNC(last_refresh))
FROM dba_snapshot_refresh_times;
8) Ensure No Files Need Media Recovery
SELECT * FROM v$recover_file;
9) Ensure No Files Are in Backup Mode
SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';
10) Resolve Outstanding Distributed Transactions
SELECT * FROM dba_2pc_pending;
11) Turn off archive log mode
12) stop listener old database
13) Create nls/data/9idata directory
14)check 11g Oraclehome, tnsadmin, ld_library_path, path,ORA_nls10
15)change log_archive_format _%t_%s_%r.arc
16) change the oratab entry to new 11ghome and inventory location new oracle inventory
17)Start upgrade
cd $ORACLE_HOME/rdbms/admin
shutdown immediate
STARTUP UPGRADE
@catupgrd.sql
STARTUP
@utlu111s.sql
@rdbms/admin/catuppst.sql
@utlrp.sql
18) Fix Korean lexers (conditional)
19) Run adgrants.sql
20) Grant create procedure privilege on CTXSYS
21)Gather statistics for SYS schema
22) recreate grants and synonym
Related Articles
How to upgrade R12.1 Instance database to 12c
R12.2 Upgrade