‘Metric execution timed out’ error reported by Grid

We use 10.2 Enterprise Manager Grid control  to monitor our oracle database environments . Apart from the normal metrics provided by oracle we also use host based and sql user defined metrics which allows you to monitor almost anything . Coming back to the main issue, following error was reported from one of the monitored…

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 file not found or invalid — default linked-in boot block used XML…

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 cluster services setup Checking node reachability… Check: Node reachability from node "prod01-fe" Destination…

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 scripts on system indicated that OS kernel parameters were adequately sized. SHMMNI set to…

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 (10.2.0.4.2 PSU 2) on Oracle Database 10.2.0.4 2) Apply Patch 8436582…

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 Is it network or database server or some issue with application server? 1)Vmstat…