Newsletters Archive - 2007

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


  Oracle RAC 10g Release 2 / RHEL4 U5 / iSCSI — (08-September-2007)

This newly updated article builds on previous guides on how to build an 
inexpensive Oracle RAC 10g using commodity hardware.

This updated guide provides the following new features:

  - Installing and configuring the latest CentOS 4 Update 5 operating system
  - Installing the newest Openfiler 2.2 x86 (respin 2)
  - improved troubleshooting section
  - Enabling Archive Logs (ARCHIVELOG MODE) in a RAC Environment
  - Creating a shared Oracle password file
  - Installing the latest version of OCFS2 (Release 1.2.5-6)
  - Downloading and installing a collection of advanced Oracle DBA scripts

This most recent guide provides detailed instructions on how to build a two 
node Oracle10g R2 RAC using iSCSI (powered by Openfiler) for the shared storage 
device.

Powered by rPath Linux, Openfiler is a free browser-based network storage 
management utility that delivers file-based Network Attached Storage (NAS) and 
block-based Storage Area Networking (SAN) in a single framework. Openfiler 
supports CIFS, NFS, HTTP/DAV, FTP, however, I will only be making use of its 
iSCSI capabilities to implement an inexpensive SAN for the shared storage 
component required by Oracle10g RAC.

The newly updated Oracle RAC 10g / iSCSI article can be found at:

Building an Inexpensive Oracle RAC 10g Release 2 on Linux - (RHEL 4.5 / iSCSI)

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


  VMware Workstation 6.0 — (17-July-2007)

VMware Workstation 6.0 has been out for several months now and enjoying great 
success - (released on 09-MAY-2007). Some of the new feature to VMware 
Workstation 6.0 include:

  - Support for Windows Vista
  - Support for Red Hat Enterprise Linux 5
  - Support for High-Speed USB 2.0 Devices
  - Multiple Monitor Support
  - Increased RAM Support

For a full list of features included in this newest release, see the "VMware 
Workstation 6.0 Release Notes" at:

http://www.vmware.com/support/ws6/doc/releasenotes_ws6.html

Over the past week, I put together several new articles that provide detailed 
instructions for installing the VMware Workstation 6.0 software as well as 
creating virtual machines for Solaris 10 (x86) and CentOS Enterprise Linux 5 
(which can also be used for installing Red Hat Enterprise Linux 5).

Installing VMware Workstation 6.0 - (Windows XP)

Creating a New Virtual Machine - (CentOS Enterprise Linux 5.0)

Creating a New Virtual Machine - (Solaris 10)


VMware Workstation 6.0 provides me with a virtual machine that can run the 
Windows, Linux, or Solaris x86 operating system simultaneously with Windows XP 
on my laptop. This allows me the flexibility to perform new installs or test 
new features of the Oracle database while not interrupting my "somewhat" stable 
Oracle install on the laptop.

VMware Workstation 6.0 and a 30 day evaluation key can be obtained directly 
from the company's website:

http://www.vmware.com/

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



  Enabling Archive Logs in Oracle RAC 10g — (13-July-2007)

Whether a single instance or clustered database, Oracle writes to its online 
redolog files in a circular manner. When the current online redolog fills, 
Oracle will switch to the next one. To facilitate media recovery, Oracle allows 
the DBA to put the database into "Archive Log Mode" which makes a copy of the 
online redolog after it fills (and before it gets reused). This is a process 
known as archiving.

While the Database Creation Assistant (DBCA) allows users to configure a new 
database to be in archive log mode, most DBA's opt to bypass this option. In 
cases like this where the database is in no archive log mode, it is a simple 
task to put the database into archive log mode using the following guide:

Enabling Archive Logs in a RAC Environment - (Oracle10g)

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


  Free Computer Magazines! — (22-May-2007)

Computer professionals can now take advantage of receiving popular magazines 
online. Best of all, it's FREE! The revenue stream for magazine companies come 
from the ads placed inside the magazine as well as the subscription costs. As the 
subscriber base grows for a magazine so does the amount they can charge for ads 
which results in more money for the magazine company. In an effort to increase 
their subscriber base, magazine companies often give away subscriptions online. 
To take advantage of this exciting new opportunity, please visit 
http://idevelopment.tradepub.com to sign up for your free subscriptions today.

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


  Erratic Mouse Behavior with Mouse on Linux and Belkin KVM Switch — (12-March-2007)

When using a Belkin KVM switch (and several others), you may notice erratic 
behavior with the PS/2 mouse when switching back and forth to a Linux machine 
running Red Hat Linux (and Mandrake 10). The PS/2 mouse will simply go nuts; 
jumping all around the screen with random button clicks when you try to move it 
anywhere! Often times, switching to a USB mouse will resolve the problem.

The root cause for this erratic behavior with the mouse rests in the fact that 
the PS/2 specification was not designed to be hot-pluggable. So, why is this a 
problem? Read on.

All PS/2 mice can work in what we will call "Basic PS/2 Mouse Mode"  no scroll 
wheel and only 2 or three buttons work. This is the default mode when the mouse 
initially gets power. To activate the scroll wheel and/or any extra buttons, 
the mouse must receive a special reset code. This switches the mouse to 
"Advanced Mouse Mode" and changes the mouse data protocol a little.

Many KVM switches may stop feeding power to the mouse when switching from one 
system to another. This causes the mouse to reset to "Basic PS/2 Mouse Mode". 
The system has no way of detecting that the mouse was reverted back to the 
basic mode. If the system was in a state where it had detected the mouse with 
"Advanced" capabilities and had sent it the appropriate reset code, it will 
expect the mouse to still be in "Advanced" mode and will misinterpret the mouse 
data (remember the mouse data protocol is different between Advanced and Basic 
mouse mode).

The following article provides several solutions that I have used to resolve 
this problem.

Erratic Mouse Behavior with Mouse on Linux and Belkin KVM Switch

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


  Connecting Oracle to MySQL using Oracle's Heterogeneous Services — (28-February-2007)

I recently updated an article that provides step by step instructions for 
installing and configuring Oracle's Heterogeneous Services (Oracle9i Release 2) 
to connect from an Oracle9i database running on Sun Solaris to MySQL running on 
a remote Linux machine.

The connection will utilize Oracle's Heterogeneous Services ODBC - generic 
connectivity (HSODBC) on Sun Solaris. This article can be used for Oracle 8i, 
9.0.1, and 10g releases running on either Solaris 9 or Solaris 10. Also note 
that this article has been tested with MySQL 4.0.20-standard running on Red Hat 
Linux - (Fedora Core 1) as well as MySQL 4.1.20 running on Red Hat Linux 4 
Update 4 (actually CentOS 4.4).

The newly updated article can be found at:
How to Setup HSODBC (Oracle9i on Solaris) to MySQL on Linux

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


  Update! Oracle RAC 10g Release 2 / VMware 5 / RHEL4 U4 — (20-February-2007)

This newly updated article builds on previous guides on how to build an 
inexpensive Oracle RAC 10g using commodity hardware. This most recent guide 
provides detailed instructions on how to build a two node Oracle RAC 10g R2 
using the latest version of VMware 5 Workstation (release 5.5.3). The cluster 
will consist of two virtual machines named vmlinux1 and vmlinux2 - each running 
CentOS 4.4 Enterprise Linux.

Both of the virtual machines will "virtualize" all of the required hardware 
components as required for an Oracle10g two node RAC configuration. For 
example, each of the virtual machines will be configured with two network 
interfaces - one for the public network and a second (running on a separate 
subnet) for the interconnect. With VMware, the process of creating additional 
hardware components for it to virtualize (i.e. network interfaces) is 
effortless. For the shared storage component, VMware will be used to virtualize 
several hard disks to be used for Oracle's physical database files (data, 
online redo logs, control files, archived redo logs). The new hard drives will 
be created using VMware on the first virtual node (vmlinux1) while the second 
virtual node (vmlinux2) will be configured to share them.

The newly updated Oracle RAC 10g / VMware 5 article can be found at:

Create an Oracle RAC 10g Release 2 using VMware Workstation 5 - (RHEL 4.4)

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


  New! Oracle RAC 10g Release 2 / RHEL4 U5 / iSCSI — (15-February-2007)

This newly updated article builds on previous guides on how to build an 
inexpensive Oracle RAC 10g using commodity hardware. This most recent guide 
provides detailed instructions on how to build a two node Oracle RAC 10g R2 
using iSCSI (powered by Openfiler) for the shared storage device.

Powered by rPath Linux, Openfiler is a free browser-based network storage 
management utility that delivers file-based Network Attached Storage (NAS) and 
block-based Storage Area Networking (SAN) in a single framework. Openfiler 
supports CIFS, NFS, HTTP/DAV, FTP, however, I will only be making use of its 
iSCSI capabilities to implement an inexpensive SAN for the shared storage 
component required by Oracle RAC 10g.

The Oracle RAC 10g / iSCSI article can be found at:

Building an Inexpensive Oracle RAC 10g Release 2 on Linux - (RHEL 4.5 / iSCSI)

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