Newsletters Archive - All

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  August 2005 Update — (04-August-2005)

This newsletter includes the following topics:

  *) Removing a Node from an Oracle10g RAC Cluster - (RHEL 3)
  *) Manually Creating an ASM Instance
  *) How to use Files in place of Real Disk Devices for ASM in
     - Linux
     - Solaris
     - Windows
  *) Adding / Dropping Disks From a ASM Disk Group
  *) ASM SQL Scripts


-------------------------------------------------------------
Removing a Node from an Oracle10g RAC Cluster - (RHEL 3)
-------------------------------------------------------------

Any DBA working with Oracle Real Application Clusters (RAC) 
should know how to effectively add and remove nodes from a 
clustered database environment. In March 2005, I provided an 
article that details the steps required to add a node to an 
already running cluster. This month, I provide a follow up 
article that documents how to remove a node. The article is 
located at:

http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/CLUSTER_22.shtml


-------------------------------------------------------------
Manually Creating an ASM Instance
-------------------------------------------------------------

If you are a DBA working with ASM you may be familiar with 
how to use the Oracle Database Configuration Assistant (DBCA) 
to create an ASM instance. I provide an article that documents 
the steps to manually create and configure an ASM instance. 
This article is located at:

http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_10.shtml


-------------------------------------------------------------
How to use Files in place of Real Disk Devices for ASM
-------------------------------------------------------------

Are you a DBA who wants to become familiar with ASM but 
doesn't have the bank account for a fully equipped SCSI disk 
array? Well, in July I wrote several articles that offer an 
alternative to creating ASM disk groups on real RAW disks. 
These articles demonstrate how the DBA can use blank padded 
files in place of real disk devices for use by ASM. Although 
this will never be a supported configuration in production, 
it does give the DBA the ability to become familiar with 
this ASM features. I have articles that demonstrate how to 
configure this for Windows, Linux, and Solaris: 

Windows
-------
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_22.shtml

Linux
-----
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_20.shtml

Solaris
-------
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_21.shtml


-------------------------------------------------------------
Adding / Dropping Disks From a ASM Disk Group
-------------------------------------------------------------

As the title indicates, this article provides the steps the 
DBA would take to effectively add and remove disk from an 
ASM disk group. Naviage to: 

http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_12.shtml


-------------------------------------------------------------
ASM SQL Scripts
-------------------------------------------------------------

As always, I continue to update the Oracle DBA Scripts 
section of my website to include SQL scripts that enable the 
DBA to manage and monitor the Oracle database environment. 
Now available are a set of scripts that can be used to view 
all metadata available to manage ASM. From the topics menu 
of my website (http://www.idevelopment.info), navigate to 
Oracle | DBA Scripts.

----------------------------
Jeffrey M. Hunter
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------