Author Archive
Downloading Oracle Software directly to Server
This article is based on Pythian’s aricle DOWNLOADING FROM OTN DIRECTLY TO YOUR DATABASE SERVER. Article tell’s about using lynx (text based web browser available on linux) to generate the cookies file which can be then used with wget to download software. But [Read More]
11gR2 Silent Install errors with [SEVERE] – Invalid My Oracle Support credentials
While performing 11gR2 RAC Database Software installation with response file (silent mode), I got this error. - Invalid My Oracle Support credentials I was using default response files for performing this installation. Searching on MOS (My Oracle Support ), I got a note [Read More]
opmnctl start fails when ORA_NLS10 parameter is set
I got into this issue , where in while starting Grid Control components, opmnctl command failed with following errors ./opmnctl start globalInitNLS: NLS boot file not found or invalid -- default linked-in boot block used XML parser init: error 201. globalInitNLS: NLS boot [Read More]
Cluvfy Reports CRS not Installed on Nodes
Before I start my post, I would like to wish all our readers a “Happy New Year”. While reviewing a 10gR2 RAC configuration I faced following errors on invoking cluvfy utility $ ./cluvfy stage -post crsinst -n prod01,prod02 -verbose Performing post-checks for [Read More]
11gR2: Steps to Rename ASM Diskgroup with DB files
11gR2 introduced renamedg utility to rename diskgroups. I would discuss renaming a diskgroup on a Standalone Grid Infrastructure installation with Oracle Restart. Before you use the command, ensure that ASM diskgroup is dismounted. Below is syntax for the command. You can [Read More]
11gR2 – SysAsm vs SysDba
SYSASM role was introduced in 11gR1 and was designed to administer ASM instances. In 11gR1 , if you connected with SYSDBA role , you used to get a warning which was only recorded in alert log (Refer to my earlier post here). But things have changed in 11gR2. While trying to [Read More]
ORA-27146 Errors while starting up Database
Short post on a issue faced by me, while starting up a cloned database SQL> startup nomount ORA-24323: value not allowed ORA-27146: post/wait initialization failed This database environment was cloned and was being started for first time after cloning. Running hcve [Read More]
Don’t blindly implement Blog suggestions on your Production Servers
Don’t blindly implement Blog suggestions on your Production Servers. This post is prompted by a recent issue where in DBA had modified racgvip script based on suggestion on one of blog (won’t name it). Any such suggestions or similar to these which involve [Read More]
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]
Wishing all a hApPy DiWaLi
Wishing you all a Happy and Prosperous Diwali - Amit & Saurabh [Read More]
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]
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]
