‘database’ Archives
DBMS_SCHEDULER jobs not running?
I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite old and many of you would have already seen it. But for others and also for my future reference I am mentioning it here [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]
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]
