Archive for September, 2009
Sqlplus connection on AIX taking too long
Recently we faced a performance issue, where in sqlplus connection from application server A (AIX 5.3) to Database server DB (different physical server,10gR2 on AIX 5.3) was taking nearly 1-2 minutes. We did some quick check’s to narrow down the problematic area.i.e [Read More]
Link:11gR2 RAC installation steps on OEL4
If you are looking for steps for 11gR2 RAC installation, you can refer to this article by Rajeev Ramdas at Dbastreet.com. Article lists down steps for installing 11gR2 RAC on 64 bit Oracle Enterprise Linux 4 (OEL4) using ASM for storage. As Raw devices are no longer [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: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
Ever since 11gR2 has been released, it has created a lot of buzz in Oracle Blogosphere with various posts on 11g Release 2 (11gR2 ) New Features primarily ASM New features. I would like to introduce you all to a feature which has been incorporated in 11gR2 Oracle [Read More]
Get Upgrading: Steps To Upgrade To 11gR2
As 11gR2 is out for Linux, I decided to upgrade one of my existing 10.2.0.3 database to 11.2.0.1 to get the look and feel of 11gR2. Direct upgrade to 11gR2 is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher and 11.1.0.6 or higher. If you have a [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]
