Tuesday, March 13, 2012

To re-create "enq: RO – fast object reuse" problem

create 3 sessions.

Session 1:

SQL> select count(*) from mchbas;


Friday, March 9, 2012

Drop asm disk after moving ocr



Task 1: Gather Files and Perform Back Up
1. On the primary node, create a staging directory. For example:
[testasm] /home/oracle >mkdir -p /u02/stage
2. Create the same exact path on one of the standby hosts: [testdb] /home/oracle >mkdir -p /u02/stage
3. On the primary node, connect to the primary database and create a PFILE from the
SPFILE in the staging directory. For example:
SQL> create pfile='/u02/stage/inittestasm.ora' from spfile;
File created.

Oracle 11gR2 RAC on Windows 2008 using VMWARE

Oracle 11gR2 RAC on Windows 2008 R2 using VMWARE
Network Configuration

Name the network connection as “public” and “private”

Amend the C:\windows\system32\drivers\etc\hosts file to contain the following information.       localhost.localdomain   localhost
# Public   rac1.localdomain        rac1   rac2.localdomain        rac2
#Private   rac1-priv.localdomain   rac1-priv   rac2-priv.localdomain   rac2-priv
#Virtual   rac1-vip.localdomain    rac1-vip   rac2-vip.localdomain    rac2-vip
# SCAN   rac-scan.localdomain rac-scan

Addition changes:First, ensure the public interface is first in the bind order:

Start and stop owb service

1. Stop:

     local_service_login.sh -closedown $OWB_ORACLE_HOME
(Case sensitive)

How to find Cluster name on RAC instance

Soemtimes you need to check your cluster name on your RAC  instance. Here is the steps:

Move index or table to another tablespace

A) Tip :- How to move index  from one tablespace to another ?
B) Tip :- How to move Table from one tablespace to another ?

Adding and removing disks in ASM

Adding and removing disks in ASM

A first for me. I had seen asm in the past but never had hands on experience with it. A client needed some disks moved from 1 diskgroup to the other and so started my journey into ASM. :)