Author Archive
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]
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]
Installing 10.2.0.5 EM using software-only on 10.2.0.4/11g DB (GUI)
In this article , I will discuss how to install 10.2.0.5 EM Grid using 10.2.0.4 database. This method can also be used with 11g database.When you carry out 10.2.0.1 EM Grid control installation, it creates a 10.1.0.4 Database by default which is no longer supported and [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]
Use awk/sed in vi
Thought of sharing some useful info which can help you to do your work faster in vi.You can use awk/sed scripts in vi using following command in vi :%!scriptname Here the scriptname file should have execute privilges for user. I used this to create a useful script which I [Read More]
dbms_stats.copy_table_stats does not alter low/high value
I was working on a performance issue arising due to missing table stats on a new partition for large Partitioned table.This was a 10.2.0.4 database on IBM AIX 5L. So as to resolve the issue , I used dbms_stats.copy_table_stats to copy the stats to new parition from the [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]
WordPress 2.8 “Baker” Released
WordPress version 2.8 has been released. Following link contains video demo of changes in V2.8. I found option of installing theme directly from WordPress themes the coolest feature. It is not new for people using the free wordpress account’s but for people using [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]
ORA-1078 ORA-1565 Errors while starting database with SPFILE on ASM
I was getting following error’s while starting a database using spfile on ASM. Actually this was a cloned RAC environment. SQL> create SPFILE='+ASM_GROUP/PORTALDB/spfileportaldb.ora' from pfile; File created. SQL> shut immediate; ORA-01109: database [Read More]
OUI-67124 – Copy failed from ‘location 1′ to ‘location 2′
Just a short note to discuss a problem faced by me while applying CPU Jan patch to clusterware on AIX 5L. I was getting following errors UtilSession failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: Copy failed from [Read More]
