Newsletters Archive - 2003

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

  Change Management / IDE Development Solutions — (14-December-2003)

Over the past several weeks, I added several new sub-sections under the 
Programming section dedicated to "Change Management" and "IDE Development" 
solutions. Both sections are available under the "Programming" link from the 
left Topics menu.

Included in the "Change Management" section are articles on configuring and 
managing Oracle Software Configuration Manager (Oracle SCM) and a brief 
introduction to WinCVS.

Within the IDE Development section, two articles are present on working in 
Oracle JDeveloper and IntelliJ IDEA.

Jeffrey M. Hunter
Sr. Database Administrator

  New LDAP Section — (14-December-2003)

Last week, I added a new section to the website dedicated to LDAP technologies. 
At this time, I have completed only two articles that primarily deal with 
Oracle's LDAP features: "Oracle Internet Directory (OID) - Version 9.2.0". 
This includes installing and configuring OID along with configuring Net8 to use 
an LDAP directory for Name Resolution.

Some of the articles to come over the next week will include definitions of 
LDAP and it's specifications along with others that will detail ways in which 
to deploy LDAP within your organization.

Jeffrey M. Hunter
Sr. Database Administrator

  New UNIX Section — (16-November-2003)

Over the last month, I have added a new section to the website dedicated to 
Unix technologies. This new section (available from the "Unix" link in the 
Topics menu) will provide users with insight into general Unix tasks along with 
specifics on Solaris and Linux. Some topics of interest include installation 
instructions, using serial consoles, network configuration, configuring RAID 
using Solstice DiskSuite, and other storage management issues. I also included 
a section for Oracle DBAs running the Oracle RDBMS in a Unix environment. Have 
fun with it and let me know if you have anything you would like to add.

In my last email, I indicated that I would be working on "Building an 
Inexpensive Oracle9i RAC Configuration on Linux". This undertaking has brought 
with it some complications in getting the Linux kernel to recognize the shared 
storage device (the shared FireWire hard drive) in non-exclusive mode. While I 
indicate that there is a kernel available (in RPM format) that can be 
installed, I have been unsuccessful in getting it to work properly. For some 
reason the first machine to boot still grabs the shared storage device in 
exclusive mode, which prevents access from the second Linux server. I will be 
sending a note to the author to see if this could be a hardware issue, or 
simply a kernel that cannot be used with Red Hat professional edition. (They 
used Red Hat Advanced Server 2.l) Although this shouldn't be an issue, I have 
tried just about everything. As soon as I find a solution to this issue, I will 
be completing the installation portion of the document and sending it out in 
the next newsletter. Wish me luck!

Like always, I have added several new Java modules under the Programming -> 
Java section. Also fixed a bug in the module "Generate random numbers within a 
given range" ( (Many thanks to Chris Wood for catching 
this one!)

Last but not least, I re-organized the MySQL section to make accessing DBA Tips 
and Scripts similar to that in the Oracle and SQL Server section.

This will be the last Newsletter before Thanksgiving day. With that said, have 
a great Thanksgiving and expect more to be included on Oracle9i RAC, UNIX, and 
Java in the very near future.

Jeffrey M. Hunter
Sr. Database Administrator

  Oracle9i on RAW using Linux and LVM — (05-October-2003)

Over the last week, I made the following changes:

1.) Under the "Oracle" -> "DBA Tips" -> "Linux" section, I added an article
on creating an Oracle9i (9.2.0) database on Linux using RAW devices. This 
document presents the use of the Logical Volume Manager available on must 
Linux distributions. The Linux distribution in this example uses Red Hat 
Professional 8.0. 

2.) Added completely new section to the website dedicate to UNIX. The new
UNIX is available from the Topics menu frame. Many more articles and links
will be available for installing and configuring UNIX systems.

3.) The "Oracle" -> "DBA Scripts" section has been completely updated with
several scripts for Oracle9i.

Jeffrey M. Hunter
Sr. Database Administrator

  LOBs / Java Programming — (22-September-2003)

New in the Oracle -> DBA Tips portion of the website is a section dedicated 
to handling LOBs. Several notes provide and overview of how to maintain LOBs 
in Oracle then leading to several examples in PL/SQL and Java.

You will also find many new sections and examples in the 
Programming -> Java portion of the website including JDBC, Swing, JNDI, 
and Patterns. As time permits within the next month, I will be adding 
many more examples to the JDBC and JNDI sections.

Jeffrey M. Hunter
Sr. Database Administrator

  New Hosting Site — (19-September-2003)

During the last several nights, I have been working on moving to a more stable hosting site ( For 
those attempting to access the site during the past several months 
already know that it has not been available during most of this 

I will be sending another newsletter within the next several weeks 
indicating changes and new additions to the site. For now, you will 
notice many additions to the Programming -> Java and 
Oracle -> DBA Tips sections.

Thank you for your patience during the past several months.

Jeffrey M. Hunter
Sr. Database Administrator

  July 2003 Update — (06-July-2003)

Hello everyone. Hope you are enjoying the beginning of summer.
It has been awhile since my last newsletter and several major 
changes to the content and organization of the website have 
taken place.

As noted in my last newsletter, I will mention again that I 
continue to make updates to the Oracle -> DBA Tips -> Oracle9i 
New Features segment. This section should provide useful for 
those investing time in studying for the Oracle Certified 
Professional (OCP) exam. You will also find new features and 
technologies in the Oracle DBA Tips section for:

  -> Advanced Queuing
  -> Clustering Technologies
  -> LOBS
  -> XMLDB
  -> Oracle Objects

I reorganized the "Programming" section to include a collection 
of useful Java programming tips along with many others for PL/SQL, 
Tcl/TK, Perl, and C. One of the portions under Programming I will 
be spending some additional time on over the summer is the new 
"Data Structures and Algorithms" section. I will provide meaningful 
documentation on data structures along with implementations of them 
in Java and C. Also included will be ways in which to analyze some 
of the more common algorithms.

Not much work has been done on the MySQL section of the website. 
If anyone can provide any useful scripts or tips for posting to 
this section, I would greatly appreciate it.

As usual, if you have any comments or suggestions regarding the 
content or layout of the website, please let me know via email 

Jeffrey M. Hunter
Sr. Database Administrator

  Search Feature Added to Oracle DBA Tips — (03-April-2003)

I recently added a Search Feature to the Oracle DBA Tips section
of the site. Also, I am continuing to add many new articles to the
Oracle / DBA Tips / Oracle9i New Features section. Many of these new
articles will be valuable for DBA's looking to upgrade their
OCP from 8i to 9i.

Jeffrey M. Hunter
Sr. Database Administrator

  Oracle Default Users — (23-March-2003)

Since my most recent newsletter (only two days ago) I have added two Oracle
DBA Tips on how to handle Oracle's default user ids. (ORDSYS, WMSYS, etc.). 
Simply navigate to "Oracle -> DBA Tips" and look under the
"Database Administration" section.

Jeffrey M. Hunter
Sr. Database Administrator

  March 2003 Update — (21-March-2003)

I made significant changes to the organization of the site since 
my last newsletter update. In particular, I added two new sections 
(accessible from the Topics menu):

  -> Programming
  -> Networking

The Programming section includes Programming Languages 
(Java, C, Perl, etc), Data Structures, ASCII and other 
Character Encoding References, plus a section for Web 

Within the "Programming -> Java" section, I added many 
new coding hints for dealing with JDBC, Threads, 
JavaCC, I/O, and Networking. Expect even more concentration 
in this area within the coming weeks.

The Networking section includes references material on 
TCP/IP, Networking Basics, SNMP, Firewalls and Software,
and Inter-Process Communications (IPC).

Within the "Oracle -> DBA Tips" section, I am adding a 
vast amount of information about Oracle9i. The 
information in this section will be helpful for any 
DBA looking to upgrade their OCP certification from 
Oracle8i to Oracle9i. Again, expect even more 
concentration in this area within the coming weeks.

Jeffrey M. Hunter
Sr. Database Administrator

  Added Cryptography Section to Java Programming — (26-January-2003)

I recently added a "Cryptography and Security" label and several code examples 
to the Java Programming section. 

From the topics menu, navigate to "Programming" -> "Java Programming", then 
scroll down the "Cryptography and Security" label.

I will continue to expand this section with code examples on digital 
signatures and encrypting/decrypting files using the DES algorithm.

Jeffrey M. Hunter
Sr. Database Administrator

  January 2003 Update — (11-January-2003)

First, I would like to wish everyone a Happy New Year.

I made several updates to the Java Programming section that includes
"Running External OS Commands" and "Data Type Conversion Examples".
From the topics menu, navigate to "Programming" -> "Java Programming".

In the Oracle DBA Tips section, I updated a previous article on
"Dropping Columns in Oracle8i" under the Database Administration section.
In addition, I added a new article on "Deploying Java Servlets and
JSPs using the Oracle HTTP Server (8i or higher)" under the
"Java" section. From the topics menu, navigate to "Oracle" -> "DBA Tips".

Jeffrey M. Hunter
Sr. Database Administrator