Newsletters Archive - 2005

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


  April 2005 Update — (15-April-2005)

This newsletter includes the following topics:

  *) New Oracle DBA Scripts
  *) Killing Runaway Oracle Processes on Windows with OraKill
  *) Installing Oracle10g on Solaris 9


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


During the month of March, I introduced several new sections to the Oracle DBA 
Scripts page. Some of the new sections include "Automatic Storage Management - 
(ASM)", "Oracle Wait Interface - (OWI)", and "Workspace Manager". Note that the 
ASM scripts require you be logged into the actual ASM instance (i.e. +ASM). 

These new sections and many other helpful Oracle DBA scripts can be found by 
going to 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.


-------------------------------------------------------------
Killing Runaway Oracle Processes on Windows with OraKill
-------------------------------------------------------------

A new article on the site provides details on how to kill runaway Oracle 
processes in Microsoft Windows using the orakill.exe command-line utility. The 
OraKill utility is included with the Oracle database on all Windows platforms. 
It allows the DBA to kill an Oracle session directly from an MS-DOS 
command-line without requiring any login connection to the database. 

This article can be found on the site by navigating to 
"Oracle" -> "DBA Tips" -> "Microsoft Windows" or by using the link 
http://www.idevelopment.info/data/Oracle/DBA_tips/Microsoft_Windows/WINDOWS_1.shtml.


-------------------------------------------------------------
Installing Oracle10g on Solaris 9
-------------------------------------------------------------

Another new article to the site that is gathering a lot of attention is a 
detailed guide on installing Oracle10g on the Solaris 9 Operating Environment. 
This newest article provides the necessary steps to install and configure 
Oracle10g using a SCSI disk array (on a single channel with 6 disks) using 
Automatic Storage Management (ASM). 

This article can be found on the site by navigating to
"Oracle" -> "DBA Tips" -> "Unix" or by using the link 
http://www.idevelopment.info/data/Oracle/DBA_tips/Unix/UNIX_32.shtml.

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