Monthly Archives: August 2010

Environment setup at Oracle RAC Database Server on Linux o/s (oraenv)

I have a RAC database named “TEST”, with instances TEST1 and TEST2. The default entry in the oratab looks something like this: TEST:/u01/app/oracle/product/11.2.0/dbhome_1:N [oracle@oscqadb02 ~]$ . oraenv ORACLE_SID = [QAERIE1] ? TEST — sets the *home* correctly, but does not … Continue reading

Posted in Uncategorized | Tagged , , | 1 Comment

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

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 Oracle 11g2 | Tagged | Leave a comment

Recover Gaps in Standby Database from primary Using incremental backups

Recovering a Standby database from a missing archives log A Physical Standby database synchs with Primary by continuous apply of archivelogs from a Primary Database. In case of an archivelog gone missing or corrupt you have to rebuild the standby … Continue reading

Posted in Data Guard | Tagged | Leave a comment