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