Newsletters Archive - All

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


  November 2004 Update — (19-November-2004)

This newsletter includes the following topics:

  *) New Oracle DBA Scripts
  *) Oracle9i Data Guard White Paper, by Michael New
  *) New Features in Oracle9i E-Book, by Howard J. Rogers
  *) Why Fedora Core 1 and not Fedora Core 2 for Oracle9i 
     RAC on Linux / FireWire White Paper?
  *) Windows VBS and Jscript Examples - Coming Soon


---------------------------------------------------
New Oracle DBA Scripts
---------------------------------------------------

Many new scripts have been added to the Oracle DBA Scripts section of the site. 
Included are scripts that allow the DBA to compare schemas, report on jobs, and 
better manage Statspack. Expect many more scripts in the next several weeks 
that allow the DBA to report on security and tuning as well as UNIX shell and 
Windows batch scripts.

To reach to the Oracle Database Scripts page, to go 
http://www.idevelopment.info/ and from the Topics menu, navigate to
"Oracle" -> "DBA Scripts". Follow the directions in the README.txt for 
configuring your system.


---------------------------------------------------
Oracle9i Data Guard White Paper, by Michael New
---------------------------------------------------

While researching for information on setting the FAL_CLIENT and FAL_SERVER 
initialization parameters for Oracle9i Data Guard, I was very fortunate to run 
across a white paper by Michael New entitled "Implementing Oracle9i Data 
Guard". I quickly found the answer I was looking for in this article, and was 
pleased to find other fine points that could not be found in any of Oracle's 
official documentation. Mr. New's white paper goes far beyond a simple overview 
of Oracle's Data Guard features, but rather provides thorough examples, best 
practices, and recommended configurations. 

The white paper is organized with well-constructed examples that allow the 
reader to follow along on their own Oracle database to help further clarify 
features. 

A link to Mr. New's article can be found by navigating to 
http://www.idevelopment.info/ and from the Topics menu, navigate to 
"Oracle" -> "DBA Tips" -> "Data Guard - (Oracle9i)" -> 
"Implementing Oracle9i Data Guard - (by Michael New)". 


---------------------------------------------------
New Features in Oracle9i E-Book by Howard J. Rogers
---------------------------------------------------

For those of you familiar with Howard Rogers' earlier Oracle9i New Features 
document, you will be happy to know that he has completely re-written his 
popular e-book to include many of the enhancements and new features available 
in Oracle9i Release 2. 

The book is organized with well-constructed examples that allow the reader to 
follow along on their own database to help further clarify new features. 

The New Features in Oracle9i E-Book is available from O'Reilly using the link 
below: 

http://www.oreilly.com/catalog/oracle9ipdf/


---------------------------------------------------
Why Fedora Core 1 and not Fedora Core 2 for Oracle9i
RAC on Linux / FireWire White Paper?
---------------------------------------------------

By far, one of most popular articles this year on my website is a step-by-step 
white paper on how to install and configure Oracle9i RAC on Linux using 
FireWire technology. A common question I receive regarding this white paper is 
why I didn't use Fedora Core 2 or Core 3 as opposed the legacy Fedora Core 1.

I made a significant effort to get this configuration to work with Red Hat 
Linux - Fedora Core 2 with no success. The primary reason this configuration 
did not work was due to incompatibilities with the modified 2.4 Linux kernel 
that needs to be downloaded and applied (provided by Oracle's Linux Projects 
development group) and the way kernel modules are handled in Fedora Core 2. 

Fedora Core 2 includes the 2.6 kernel and makes use of the 
file /etc/modprobe.conf to exclusively control administrating kernel modules. 
This is unlike how kernel modules were handled in the 2.4 kernel where 
configuration information was contained in both the /etc/modprobe.conf 
and /etc/modules.conf configuration files. Starting with the 2.6 kernel, 
the /etc/modules.conf file has been phased out and only /etc/modprobe.conf is 
used. 

The format and syntax for these two files are similar, but not exact. When the 
2.4 Linux kernel boots, it will look for a file called /etc/modules.conf. I 
tried to copy the /etc/modprobe.conf file to /etc/modules.conf and take out 
everything but the bare essentials for the server to work (i.e. Network 
settings). No matter how I tried to configure the /etc/modules.conf for the 
Linux 2.4 kernel, I could not get it to accept the settings for networking and 
the ieee1394-controller. After several attempts in getting this configuration 
to work, I decided to use Fedora Core 1 since it uses the 2.4 kernel and made 
applying the modified 2.4 kernel an easy task.


---------------------------------------------------
Windows VBS and JScript Examples - Coming Soon
---------------------------------------------------

Within the month of December, I will be putting together a set of VBS and 
JScript Windows scripts that support the Windows Scripting Host. My initial 
task will be to introduce the Windows Scripting Host environment along with 
reasons for using the VBS and JScript engines. Once this is complete, I 
will start to introduce Windows scripts (using both VBS and JScript) that 
provide support for accessing databases, namely Oracle, SQL Server, and MySQL.

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