Newsletters Archive - 2004

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
----------------------------


  Improved Oracle Database Scripts Page and Free DDL Wizard Toolkit — (11-October-2004)

This newsletter includes the following topics:

  *) Improved Oracle Database Scripts Page
  *) Free DDL Wizard Toolkit
  *) Oracle9i Data Guard

--------------------------------------
Improved Oracle Database Scripts Page
--------------------------------------

During the last week, I was able to improve the Oracle Database Scripts page 
by providing an archived file of all scripts that can be downloaded at one 
time. This archived file can be unzipped (or un-tar'd for UNIX) to your 
$ORACLE_HOME directory. After setting a few environment variables, you are then 
ready to go.

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.

--------------------------------------
Free DDL Wizard Toolkit
--------------------------------------

DDL Wizard is a tool that can be used by Oracle DBAs and Developers to reverse 
engineer Oracle export files (dump files) to display and manipulate the DDL 
CREATE statements contained within them. The tool basically extracts the DDL 
structure from an export file and runs on a Windows PC. Simply download the 
self-extracting executable from the site http://www.ddlwizard.com/. At the time 
of this writing, the current version of the DDL Wizard is 04.01.01 and is 
around 2.2 MB in size.

After downloading the executable (ddlwizard_install040101.exe), simply 
double-click to start the installation processes. During the install, you will 
be asked to obtain a license key. This does require you to complete an online 
form that asks for your Name, Company, E-mail address, and Country. After 
submitting this information, you will then be given an activation key. At the 
end of the installation is a quick tutorial that walks you through the basics 
steps for extracting DDL.

--------------------------------------
Oracle9i Data Guard
--------------------------------------

A new section has been created within the DBA Tips page to include articles on 
creating and managing Oracle Data Guard. For now, I have a single article that 
introduces you to Oracle Data Guard 9i and provides the steps necessary to 
install and configure a two node configuration.

I have several more articles specific to Oracle9i Standby Database, but will 
soon be adding more about 10g soon after.

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


  Oracle RAC on Linux Installation Update — (31-August-2004)

Since the republication of my article "Building an Inexpensive Oracle9i RAC 
Configuration on Linux" on Oracle Technology Network (OTN), I have received 
several messages with suggestions and questions about the use of FireWire 
technology. I have attempted to answer these messages by updating the article 
both on OTN and on this website. To view the updated article from this website, 
use the Topics menu on the left frame and navigate to "Oracle" -> "DBA Tips" 
and then scroll to the "Linux" section where you will find the 
article "Building an Inexpensive Oracle9i RAC Configuration on Linux". You can 
also go to Oracle's OTN website at http://otn.oracle.com.

I also updated the installation guide on this website for installing Oracle9i 
(9.2.0.5.0) on Fedora Core 2. This article can be found in the same section as 
mentioned above.

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


  Oracle's Heterogeneous Services — (07-August-2004)

I recently started a new section and published an article within the Oracle DBA 
Tips section for Heterogeneous Services (HS). The article describes, 
step-by-step, how to configure Oracle's HS to connect from an Oracle database 
running on Solaris to a MySQL database running on Linux.

If you have never used HS in Oracle, it is an excellent technology built into 
Oracle for accessing and modifying data that may reside in a remote / foreign 
(non-Oracle) database. From a user's point of view, they can access and modify 
data in a remote (non-Oracle) database just as if it were a local set of Oracle 
tables.

As time permits, I will continue to expand this section with other 
configurations as well as advanced features and administration of Oracle's 
Heterogeneous Services.

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


  August 2004 Update — (01-August-2004)

Throughout July, I was able to concentrate on several articles dedicated to 
Unix Administration and Oracle running on Unix. All of these articles are 
available from the left frame topics menu under "Unix". Included are custom 
documents for installing Solaris 8 and Solaris 9 on SPARC as well as installing 
Oracle8i and Oracle9i on Solaris. 

In the August timeframe, I have several articles planned for configuring 
Heterogeneous Services, Oracle Streams, and continuing on Oracle9i New 
Features. 

On a personal note, I am proud to announce that I will be working for DBA Zone, 
Inc. (http://www.dbazone.com) starting on August 16, 2004. This is a great move 
and I look forward to building on the enormous success that the company has 
already developed.

As always, I welcome your comments and suggestions for the site.

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


  New Posted Publications — (08-June-2004)

This month I have had several re-publications centered on 
supporting Oracle on Linux:

OTN:
http://otn.oracle.com/pub/articles/hunter_rac.html

SearchOracle.com
http://searchoracle.techtarget.com/featuredTopic/0,290042,sid41_gci968437,00.html

If you are working with Oracle on Linux, I am hoping that any of these articles
provide useful information.

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


  Oracle9i RAC on Linux — (10-May-2004)

I was able to complete the long awaited article entitled "Building an 
Inexpensive Oracle9i RAC Configuration on Linux". This article provides a 
comprehensive overview to installing and configuring an Oracle9i RAC system 
using Red Hat Linux (Fedora Core 1) and using FireWire technology for the 
shared storage device. I ran into several complications last year when 
configuring the Linux kernel to recognize the shared storage device (the shared 
FireWire hard drive) in non-exclusive mode. The problem was with the FireWire 
drive that I purchased. It did not contain the Oxford 911 chipset, which is one 
of the requirements in order for the Linux kernel to obtain multiple logins to 
the disk. I then purchased a drive that I knew contained the proper chipset 
(Maxtor One Touch 200GB USB 2.0 / Firewire External Hard Drive). 

To access the article, visit the website site:

http://www.idevelopment.info

Navigate the topics menu (left frame) to:

"Oracle -> DBA Tips -> Oracle9i RAC ->
  Building an Inexpensive Oracle9i RAC Configuration on Linux"

This article will be appearing on otn.oracle.com in the coming months.

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


  January 2004 Update — (24-January-2004)

I hope everyone is enjoying the New Year. Here is an update as to some of 
the additions and changes to the www.idevelopment.info website.

Several new articles on installing and configuring the Concurrent Versions 
System (CVS). I have several new articles planned for this section that include 
on to maintain the CVS Repository along with other helpful tips. To access 
these articles, navigate from the topic menu to "Programming | Change 
Management".

The Oracle DBA Tips section now includes an Index at the top of the page that 
allows quick access to all folders. Also within the Oracle DBA Tips section, I 
added a section on Recovery Manager (for release 9i) that I plan to populated 
within the next month. To access the Oracle DBA Tips section, navigate 
to "Oracle | DBA Tips".

Lastly, I enhanced the performance of the built in Search Engine for the site. 
Searches now occur much faster over a broader range of content.

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