Writing About Our Experiences With Oracle Databases
Sunday February 5th 2012

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

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

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]

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 [Read More]

Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins

In one of my databases, one application query suddenly started to pick Nested-Loop joins instead of Hash-Joins and took [Read More]

Posts Tagged ‘ASM’

Automatic Storage Management (ASM) FAQ

We have tried to consolidate list of Frequently Asked Questions (FAQ) on ASM. Please feel free to ask any other question or contribute to this FAQ by using comment section Frequently Asked Question on ASM 1) What is ASM? Automatic storage Management (ASM) is a new type of [Read More]

11G:SYSASM role

Starting from Oracle 11g ASM, new privilege has been created for Administering Oracle ASM instances. This is called SYSASM role. You can continue using SYSDBA role to connect to ASM but it will generate following warning messages at time of startup/shutdown, create [Read More]

New ASM Background Processes in 11G

Few hours back I installed Oracle Database 11g(Though still DB is yet to be created), so I started playing with the ASM instance. First thing I did was to check ASM alert.log. I used ADRCI (11g) to see it adrci> show incident ADR Home = [Read More]

11.1.0.6 ASM installation on Solaris fails -II

Some time back, I had written about CSS service not starting in my post 11.1.0.6 ASM installation on Solaris fails -I After doing some research, I came across Metalink Document Note:397238.1 – How to Convert init.cssd as a SMF service for Solaris 10 This document [Read More]

Can ASM DiskGroup Be Renamed?

This was actually a question on Oracle forum which I had replied to. Basically the Poster, wanted to know if he could rename the ASM Diskgroup name by renaming/editing ASM Disk header. He had also mentioned that he had heard about this being done by Oracle for its few [Read More]

kfed in 11g

While carrying out Oracle Database 11g install, I noticed that kfed is automatically created. This is in contrast to 10.2 where you had to create it using “make” command. In case you are looking for 10.2 method, you can find it in my previous post ORA-15063 [Read More]

11.1.0.6 ASM installation on Solaris fails -I

Looks like that there is no easy way for me to install/configure Oracle components. And every install/configuration leads me to some or the other problems. Anyways I was trying to install Oracle Database 11g on a Solaris 10 but the CSS does not seems to come up. While [Read More]

Adding new ASM disk to RAC database fails

Many times i came across a common problem in RAC databases where trying to add an asm disk is not possible due to errors like ORA-15075 “disk(s) are not visible cluster-wide” ORA-15020 “discovered duplicate ASM disk “DISK1″ and ORA-15054 [Read More]

Allocation Unit and Extents In ASM

ASM was introduced with Oracle 10g and is used as a Volume Manager and a file system. It provides both mirroring and striping of the database files. To use ASM you need to create a Diskgroup and add disks/raw devices to the Diskgroup.Data is allocated in disks in terms of [Read More]

ORA-15063 – ASM Discovered Insufficient amount of Disks

Looking at the response generated by my earlier post on ASM, I thought of writing one more article. Many of us (Working on ASM) would have encountered following errors during startup of ASM instance ORA-15032: not all alterations performed ORA-15063: ASM discovered an [Read More]

ASM Disk Discovery

While creating ASM diskgroup or adding new disk to a existing diskgroup, Disk should be visible in V$ASM_DISK. ASM discovers and examines the contents of all of the disks that are in the paths that you designated with values in the ASM_DISKSTRING initialization parameter. [Read More]

 Page 2 of 2 « 1  2 

Recent Comments

Saurabh Sood had this to say

Hi Pawan, We cannot force the writes to a specific disk. At least I am not aware of any such thing. Oracle will Read the post

Amit had this to say

hi Pawan, ASM_PREFERRED_READ_FAILURE_GROUPS is mainly used for RAC instances and that too stretch clusters i.e when Read the post

PAWAN had this to say

HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance Read the post

PAWAN had this to say

HI, i am newbie.... please guide me! My manager asked me to configure ASM in 11g with single instance Read the post

Saurabh Sood had this to say

@Ganesh: The global stats were up-to-date for both the databases, though I did not check the col stats. But the Read the post