11gR2 database installation comes up with new feature known as Installation Fixup scripts which aids you during Installation phase. If a pre-requisite check fails, then it provides a click and…
Read Full Recipe
Oracle 11gR2 has been released for linux x86 and x86-64 platform. Software can be downloaded at http://www.oracle.com/technology/software/products/database/index.html Guys start downloading..:) .. Note: - As of now documentation link is not…
Read Full Recipe
While setting up ocfs2 for OCR and Voting disk storage with following commad: # ocfs2console After clicking on ==>cluster ==> configure nodes, I got a pop-up saying: <span style="font-size: small;"><span…
Read Full Recipe
Few days back , Martin had posted a series of post on a issue where GATHER_STATS_JOB was failing silently for a large object. If you have missed it, you can…
Read Full Recipe
While trying to install 11gR1 on Oracle Enterprise Linux (OEL5), runInstaller failed for unixODBC* packages. To solve the issue , I started following OTN article http://www.oracle.com/technology/pub/articles/smiley-11gr1-install.html When trying to install…
Read Full Recipe
This post discusses issue faced by me while working on Materialized view (mview) creation at new site(database). Starting Oracle 10g, how atomic_refresh works with complete refresh has undergone a change.…
Read Full Recipe