Sunday, November 30, 2008
Oracle RAC Installation & Configuration Resources
Real Application Clusters Installation Guidehttp://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/install.111/b28264/racinstl.htmReal Application Clusters Administration and Deployment Guidehttp://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/rac.111/b28254/toc.htm...
Friday, November 14, 2008
Oracle Import Utility
Import extracts data from an export file and puts it back into an Oracle database. Import is command line not SQL command.Table objects are imported from the export file in the following order:1. Table definitions2. Table data3. Table indexes4. Integrity constraints and triggers...
Unable to mount ASMlib driver filesystem
While doing # /etc/init.d/oracleasm configureand you have the following error messageMounting ASMlib driver filesystem: mount: block device oracleasmfs is write-protected, mounting read-onlymount: cannot mount block device oracleasmfs read-onlyUnable to mount ASMlib driver filesystemyou...
Tuesday, November 11, 2008
Recompile oracle invalid object from script
Login to oracle using sqlplus command lineprompt>sqlplus login@ora_serviceenter password then copy the following text after the ---------- line to sqlplus prompt---------script start ------------------------set heading off;set feedback off;set echo off;Set lines 999; Spool compile_ora_invalid_obj.sql...