Thursday, February 20, 2014

ORA-00205: error in identifying control file, check alert log for more info

›
  As part of moving the control file from current ASM Diskgroup to new Diskgroup, I did the following; 1. Backup the current controlfile a...
Monday, February 10, 2014

How to open GUI on Unix using Exceed XServer

›
  1. Find out the IP address of Host Windows machine    PING hostname 2. start the X server... Example C:\Program Files (x86)\Hummingbir...
Wednesday, January 29, 2014

Life Cycle of SQL Tuning - SQL Profile

›
     
Wednesday, October 16, 2013

Oracle Database Patching Procedure

›
 

Oracle Enterprise Manager 11g - OEM 11g Log file location

›
  $ORACLE_HOME/sysman/config/emInstanceMapping.properties This file will tell you the internal ID (OMS name) of the OMS, and a pointer ...
Wednesday, October 09, 2013

How to change password of SYS user on ASM

›
  For changing the SYS password on ASM: In 11.2 we can use asmcmd to change the password as follows · In single instance environmen...
Tuesday, October 08, 2013

How to exclude disk on Linux ASMLib

›
  Requirement: We need the 2 asm disk groups (DG_UAT_DATA_01, DG_UAT_FLASH_01) to be mounted only on +ASM that runs on ServerB. I see that...
Thursday, September 26, 2013

Analogy: Restore & Recovery to bone fracture

›
  Restore and recovery are analogous to the healing process when you break a bone. Restoring is similar to the process of setting the bro...

Traffic analogy: Unix – CPU metric Run queue length

›
  The traffic analogy A single-core CPU is like a single lane of traffic. Imagine you are a bridge operator ... sometimes your bridge is ...