Category Archives: manual upgrade oracle database 11g2

Manually upgrade the Database 10g2 (10.2.0.4) to Oracle database 11g2 on Redhat Linux 5

1. Run utlrp.sql to recompile any remaining stored PL/SQL and Java code. SQL> @utlrp.sql 2. Check dba_registry column comp_name format a40 set pagesize 50 set line 2000 select trim(comp_name) comp_name , version , status from dba_registry; 3. Verify that all … Continue reading

Posted in manual upgrade oracle database 11g2 | Tagged , , | 1 Comment