Friday, January 27, 2012
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
Latest Topics
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 [Read More]
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c [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 [Read More]
Subscribe To Feed
10g
10gR2 Silent Install with 11gr2 CRS fails
I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following error Check complete: Failed <<<< Problem: The 'active' version of Oracle Clusterware is not 10g Release 2 (10.2). Recommendation: You must upgrade all nodes of the cluster to Oracle Clusterware 10g Release 2. If you have [Read More]
11g
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 [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 [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 [Read More]
GRID
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c (12.1.0.1.0). The Complete Upgrade process will be carried out under 3 different stages: 1. Patch existing 11g OMS to get the 12c upgrade console. 2. Deploy and Configure 12c agents. 3. Upgrade 11g OMS to 12c. The approach used [Read More]
Performance
Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins
In one of my databases, one application query suddenly started to pick Nested-Loop joins [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 [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 [Read More]
Featured
Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c
This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c (12.1.0.1.0). The Complete Upgrade process will be carried out under 3 different stages: 1. Patch existing 11g OMS to get the 12c upgrade console. 2. Deploy and [Read More]
Upgrading Grid Infrastructure 11.2.0.1 to 11.2.0.2 on RHEL4
11.2.0.2 Patchset was released few days back. I decided to upgrade a test RAC database to 11.2.0.2 yesterday and was able [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 [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 [Read More]
Recent Comments
{ Hi Pawan, We cannot force the writes to a specific disk. At least I am not aware of any such thing. Oracle will write the... } – Jan 30, 8:37 AM
{ hi Pawan, ASM_PREFERRED_READ_FAILURE_GROUPS is mainly used for RAC instances and that too stretch clusters i.e when RAC nodes are not sitting in same cluster. On... } – Jan 29, 6:36 PM
{ HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance database! with Normal redundancy with two... } – Jan 29, 4:41 PM
- Older »