Tag Archives: installation

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

Encountered file error when copying listeners from home

If you encountered same or similar error message during of Oracle database creation on RAC Environment: “Encountered file error when copying listeners from home=/u01/app/11.2.0/grid” Follow below steps to fix the problem $ echo $TNS_ADMIN If set, unset and run dbua … Continue reading

Posted in RAC DBCA oracle 11g oracle 10g | Tagged , , | Leave a comment