Steps to upgarde 11i Application database to 11gR1



Last updated on December 21st, 2015 at 07:03 am

Steps to upgarde 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


Leave a Reply