Author Archive
Using current_scn for RMAN incremental ? Think again..
I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby database which lagged by considerable time and we decided to use rman incremental database to make it current. We have done this in past and used normal [Read More]
Poll on Sql Plan Management
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to fix plans for queries and believe me its very easy and quick way of fixing problems in production [Read More]
Oracle Direct connector for HDFS
Some time back oracle had announced Oracle Big Data appliance. Along with this Oracle released Big Data Connectors to facilitate data access between data stored in a Hadoop cluster and Oracle Database. I tried installing Oracle Direct Connector for HDFS (Hadoop distributed [Read More]
Copying Oracle Scheduler jobs with Arguments
Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due to following scenarios 1)Runaway jobs – When Scheduler job is running [Read More]
EM12c:Automated discovery of Targets
In this post we will discuss the Automated discovery of Targets in Enterprise Manager Cloud Control(EM 12c). Once you have installed agents, you can schedule automatic discovery of new targets. Let’s get started 1)Click on Add Target>Configure Auto Discovery from [Read More]
Em12c:Silent Oracle Management agent Installation
This Post would describe how to install Oracle Management Agent 12c in silent mode. We need to download the agent software which can be done using emcli utility which is present on OMS host.Login to OMS host and execute emcli utility as mentioned below [Read More]
11gR2:Listener Startup Issues
In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this post based on my experiences or any comments on this blog post. Let’s get started.You will experience following errors while starting listener using [Read More]
Cluster SSH tool Utility
Many times you come across scenario’s when you wish to open multiple ssh windows and execute same commands.e.g You wish to see alert log for multi-node RAC simultaneously or edit sysctl.conf files for multiple machines. Cluster SSH utility helps solve this problem as [Read More]
11g: Multiple failed login attempt can block New Application connections
In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per Bug 7715339 – Logon failures causes “row cache lock” waits – Allow disable of logon [Read More]
Oracle Critical Patch Update January 2012
I guess most of us having My Oracle Support have got email from Oracle mentioning that Critical Patch Update January 2012 has been released. Main reason behind this is Security bug found by Infoworld which can make database run out of SCN. You can read the article here [Read More]
User Sessions stuck on resmgr:cpu quantum wait event
We were experiencing lot of session getting stuck on resmgr:cpu quantum in our database. In fact at a time we had 70 sessions which were stuck on this wait event and our cpu load average was touching 60 Checking active resource plan, we found that DEFAULT_MAINTENANCE_PLAN [Read More]
Plan Stability using Sql Profiles and SQL Plan Management
PLAN STABILITY How many times you have noticed a query using Index X when you wanted it to use index Y or query performing Nested Loop join when Hash Join would have completed the query much faster.Or take a scenario when the application suddenly starts using wrong plan [Read More]
V$SQL_SHARED_CURSOR in 11.2.0.2
Oracle 11.2.0.2 has introduced new column “REASON” to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which can cause multiple child cursors). As per documentation [Read More]
11gR1 CRS start failing with ORA-29702
This post was actually a comment from Sasi which came on previous article 10.2 CRS startup issue . I am converting it to a post so that we can get some feedback on this issue from other users. I suspect this to be caused by RHEL5 bug (fixed in RHEL5u6) related to NIC going [Read More]
AIOUG 2011 – I am Attending :)
All India Oracle User Group(AIOUG) is organizing the annual Oracle Conference in Bangalore on Friday, December 9th and Saturday December 10th, 2011.Arup Nanda is key speaker this year. I will be attending this conference for first time and I am looking forward to meeting [Read More]
