NetApp - Databases

Oracle ASM - Automatic Storage Management - Part VI - Creating Oracle RAC Database

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle RAC (Oracle 10g) - PART VI - Creating Oracle RAC Database

1. Setting Oracle SID

On node 1...

On node 2...

2. Starting DBCA

3. Configuring datafiles and logs on NetApp

4. Finish Oracle RAC Database creation

5. Starting Oracle RAC instance (All nodes)

On node 1...

On node 2...

6. Checking connection to Oracle RAC Database

On node 1...

On node 2...

 

Neto Solutions

Net(App)O(racle) Solutions - The perfect solution!

All the best,

neto

NetApp - I love this company!

Oracle ASM - Automatic Storage Management - Part V - Inside ASM

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle RAC (Oracle 10g) - PART V - Inside ASM

1. Looking inside ASM

2. Adding disks to ASM Diskgroup

3. Useful script to check ASM disks

 

#!/bin/sh
#
# NetApp
#
# Authors:     Bob Smith, neto from Brazil
#                     Mike Doherty, Silviu Angelescu
#                     Greg Loughmiller, Dan Giannascoli
#
# Purpose:  Create an ASM disk report
# Generates report by combining outputs from kfod partition lookup
# ASM disk report - version 0.1

clear
echo "NetApp"
echo "Authors: Bob Smith, neto from Brazil"
echo "          Mike Doherty, Silviu Angelescu"
echo "          Greg Loughmiller, Dan Giannascoli"
echo -e "\n"
echo "Purpose:  Create an ASM disk report"
echo "Generate report by combining outputs from kfod partition lookup"
echo -e "\n"
echo "NetApp - ASM Disk Report - version 0.1"
echo -e "\n"
echo "Generating ASM Disk Report ..."
sleep 5
# Create ASM disk report
kfod disks=asm status=true > asm-disk-report.netapp.out
# Loop through all device names and update the ASM disk Report
echo "Updating ASM Disk Report with device names"
for asmlabel in `ls /dev/oracleasm/disks/`
do
   major=`ls -l /dev/oracleasm/disks/${asmlabel}|awk '{print $5}'|tr -d ','`
   minor=`ls -l /dev/oracleasm/disks/${asmlabel}|awk '{print $6}'|tr -s " "`
   partition=`cat /proc/partitions|tr -s " "|grep -we "${major} ${minor}"|awk '{print $4}'`
   /usr/bin/perl -pi -e "s|`echo $asmlabel`|`echo $asmlabel - ${partition}`|" asm-disk-report.netapp.out
done
echo "ASM Disk Report generated"
cat asm-disk-report.netapp.out

In my next post I will explain about Oracle RAC (Oracle 10g) - Creating Oracle RAC Database

All the best

neto

NetApp - I love this company!

Oracle ASM - Automatic Storage Management - Part IV - Using DBCA

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle RAC (Oracle 10g) - PART IV - Installing a Database using dbca

1. Starting DBCA

2. Configuring ASM instance (DBCA)

On node 1...

On node 2...

3. Configuring ASM instance (manually)

create the password file:

[oracle@mickey ~]$ orapwd file=$ORACLE_HOME/dbs/orapw+ASM password=netapp1 entries=5

[oracle@mickey ~]$ mkdir -p $ORACLE_BASE/admin/+ASM
[oracle@mickey ~]$ cd $ORACLE_BASE/admin/+ASM
[oracle@mickey +ASM]$ mkdir bdump
[oracle@mickey +ASM]$ mkdir udump
[oracle@mickey +ASM]$ mkdir cdump
[oracle@mickey +ASM]$ mkdir pfile

Create the init+ASM.ora file:

+ASM.__oracle_base='/oracle/app' #ORACLE_BASE set from environment
*.asm_diskgroups='DATA','TEMP'
+ASM.asm_diskgroups='DATA','TEMP'#Manual Mount
*.diagnostic_dest='/oracle/app'
*.instance_type='asm'
*.large_pool_size=12M

[oracle@mickey ~]$ cat $ORACLE_HOME/dbs/init+ASM.ora +ASM.__oracle_base='/oracle/app' #ORACLE_BASE set from environment
*.asm_diskgroups='DATA','TEMP'
+ASM.asm_diskgroups='DATA','TEMP'#Manual Mount
*.diagnostic_dest='/oracle/app'
*.instance_type='asm'
*.large_pool_size=12M

Create spfile+ASM.ora and start the instance using that file:

[oracle@mickey ~]$ export ORACLE_SID=+ASM
[oracle@mickey][+ASM][~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Oct 28 02:35:40 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> create spfile from pfile;

File created.

SQL> startup mount

ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted

Open the /etc/oratab file and add the following line at the end:

+ASM:/oracle/app/oracle/product/11g/db_1:Y

In my next post I will explain about Oracle RAC (Oracle 10g) - Inside ASM

All the best

neto

NetApp - I love this company!

Oracle ASM - Automatic Storage Management - Part III - Configuring ASM

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle RAC (Oracle 10g) - PART III - Configure ASM.

1. Configuring LUNs for ASM

2. LUNs with a partition (all Oracle RAC nodes)

Linux LUN partition alignment tool

nalunpart is designed to simplify creating partitions on NetApp LUNs, aligned to the underlying 4k WAFL file. Proper partition alignment is essential for maximum LUN performance. The alignment process is described in detail in NetApp Knowledge Base article 8190: http://now.netapp.com/Knowledgebase/solutionarea.asp?id=kb8190 nalunpart creates a partition table containing a single whole-disk partition and reloads the partition map correctly for both single and multipath LUN devices, and prints the new partition device. A LUN is limited to 2 TB. This is useful for scripting the creation of a large number of identical LUNs and identifying the correct partition, such as when setting up an Oracle ASM diskgroup.

3. Changing permissions (all Oracle RAC nodes)

On node 2...

4. Configuring ASMLib (all Oracle RAC nodes)

Please install RPM packages for ASMLib

On node 2...

5. Creating disks using ASMLib

On node 2...

In my next post I will explain about Oracle RAC (Oracle 10g) - Creating Database using DBCA

All the best

neto

NetApp - My Passion!

Oracle ASM - Automatic Storage Management - Part II - Oracle Binaries

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle RAC (Oracle 10g) - PART II - Install/Configure Oracle Binaries

1. Installing Oracle Binaries (Oracle 10g) - Silent Mode

2. Executing from CLI Oracle Binaries (Oracle 10g) - Silent Mode

On node 2...

In my next post I will explain about Oracle RAC (Oracle 10g) - Configure ASM Volumes for Database.

All the best

neto

NetApp - I love this company!

Oracle ASM - Automatic Storage Management - Part I - CRS

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle RAC (Oracle 10g) - PART I - Install/Configure CRS

1. Configure RAW Devices for CRS LUNs

iqn.1987-05.com.cisco:atlibm19 - node 1

iqn.1987-05.com.cisco:atlibm18 - node 2

2. Checking LUNs NetApp Storage Controller

3. Reloading iSCSI Driver (all Oracle RAC nodes)

/etc/rc.d/init.d/iscsi reload

4. fdisk LUNs with a partition (all Oracle RAC nodes)

for x in b c do fdisk /dev/sd$x << EOF; done

n

p

1

1

1011

w

EOF

5. Configuring RAW Devices (all Oracle RAC nodes)

6. Permissions RAW Devices (all Oracle RAC nodes)

On other host run partprobe to discover luns and permissions

7. Preparing Installation CRS Oracle Software (Oracle 10g) - Silent Mode

8. Installing CRS Oracle Software (Oracle 10g) - Silent Mode

On node 2...

9. Configuring VIPCA (Oracle 10g) - Silent Mode

10. Checking Oracle CRS (Oracle 10g) Installation

In my next post I will explain about Oracle RAC (Oracle 10g) - Install/Configure Oracle Binaries.

All the best

neto

NetApp - I love this company!

Oracle ASM - Automatic Storage Management - Introduction

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Automatic Storage Management (ASM).

ASM is a powerful and portable storage manager designed to manage Oracle® Database 10g and 11g database files. ASM simplifies storage management so that DBA's worry less about Oracle Database file layout and management . ASM delivers lower total cost of ownership while increasing storage utilization, all without compromising performance or availability. With ASM, a fraction of the time is needed to manage your database files.

Some important ASM key features are:

· Volume Management
· Database File System with performance of RAW I/O
· Supports clustering (RAC) and single instance
· Automatic data distribution
· Online add/drop/resize disk with automated data relocation
· Automatic file management
· Flexible mirror protection

Basically, ASM is a storage manager designed to manage Oracle Database files with Volume Manager (1MB/128KB striping, Flexible mirroring and Online disk reconfigurations and automatic rebalancing), File System (Even data distribution with optimal performance) and Automatic file management using Oracle Managed Files (OMF).

ASM views:

The combined capabilities of Oracle ASM and NetApp are a unique and powerful automated database management solution that simplifies and optimizes performance, utilization and data protection for Oracle Databases using a perfect combination between NetApp and Oracle - Net(App)O(racle) Technologies

In my next post I will explain about installation and configuration of ASM.

All the best

neto

NetApp - This is my LIFE!