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

create 3 sessions.

Session 1：

SQL> select count(*) from mchbas;

  COUNT(*)
----------
   5943314

Drop asm disk after moving ocr

 

CREATING A PHYSICAL STANDBY ON ASM 11gR2

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.
SQL>

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.
127.0.0.1       localhost.localdomain   localhost
# Public
192.168.96.3   rac1.localdomain        rac1
192.168.96.4   rac2.localdomain        rac2
#Private
192.168.40.2   rac1-priv.localdomain   rac1-priv
192.168.40.3   rac2-priv.localdomain   rac2-priv
#Virtual
192.168.96.111   rac1-vip.localdomain    rac1-vip
192.168.96.112   rac2-vip.localdomain    rac2-vip
# SCAN
192.168.96.201   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. :)