Posts Tagged ‘oracle’
Oracle Patch Set update (PSU 2) released for 10.2.0.4 and 11.1.0.7
Oracle has recently released Oracle Patch Set update (PSU 2) along with CPU October 2009. As informed earlier , PSU are released quarterly along with CPU patches. If you are running 10.2.0.4 RAC database, you need to apply following patches 1) Apply Patch 8833280 [Read More]
Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password
You have been asked to schedule a shell script which need to connect to a particular user and perform some action? How do you pass the password to script without hardcoding it in script. If password is written in a script, isn’t it a security threat? Well with 10gR2 [Read More]
11gR2 Database Installation with ASM on OEL5
I will be listing down steps for 11g Release 2 installation on Linux x86. There has been few changes incorporated in 11gR2 which must be given due consideration before starting installation. ASM instance now runs from new Oracle Home called Grid Infrastructure. If you wish [Read More]
11gR2:What if Oracle gives you Kernel parameter fixup script
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 generate fixup script option and then points you to script location which [Read More]
Oracle 11gR2 on linux is out
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 available on [Read More]
OCFS2 Configuration Issue
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 style="font-family: [Read More]
GATHER_STATS_JOB – Is it enabled?
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 check following links Automated statistics gathering silently fails [Read More]
Failed dependencies error: lib* needed by unixODBC-devel-2.2.11-7.1.i386
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 RPM from CD3, [Read More]
Mview Complete Refresh and Atomic_refresh parameter
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. Atomic_refresh parameter is to allow either all of the tasks of a [Read More]
CleanUp Temporary Segments Occupying Permanent Tablespace
There are situations when we see “temporary segments” in permanent tablespaces hanging around and not getting cleaned up. These temporary segments in permanent tablespace can be created by DDL operations like CTAS and “alter index..rebuild” because [Read More]
Link: Best practices for AIX RAC Database on OTN
A new whitepaper has been published on OTN which primarily discusses best practices for AIX 5.2,5.3 and 6.1 for RAC database for avoiding node eviction due to Oprocd. It also mentions recommended AIX VMO parameters and recommended patches for Oracle RAC. You can find the [Read More]
Cloning database..Just do some Post checks !!
Well I will be covering some points which I believe should be part of post checklist for any cloned database environment. This might not be complete list as it contains point which I have encountered or heard of. 1) Change database Name and Database Id You should try to [Read More]
Silent Install :OUI-10133:Invalid staging area Error
While using silent install for database software installation , you could encounter following errors SEVERE:OUI-10133:Invalid staging area. There are no top level components for IBM SP AIX available for installation in this staging area. This error is reported when OUI is [Read More]
You Don’t need SysDBA privilege to run Awrrpt..
Well I tried to Sensationalize this post by using such a heading Though I just wanted to point out that Awrrpt script can be run without sysdba privilege too. Actually if you open awrrpti.sql script , it contains following line Rem NOTES Rem Run as SYSDBA. Generally this [Read More]
Grid Control Fails to Start
The link for Grid Control was not Working and it failed to show the login page. In this situation checked the following things: 1. The repository database was up and running 2. The listener was up. 3. OMS server was down. Tried to stratup the OMS server using opmnctl [Read More]
