Newsletters Archive - 2005

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


  May 2005 Update — (24-May-2005)

This newsletter includes the following topics:

  *) How to Recreate the Database Control Repository - (Oracle10g)
  *) Adding a Node to an Oracle10g RAC Cluster - (RHEL 3) 
  *) New Statspack SQL Scripts for Oracle10g
  *) Search and Replace with REPLACE Function



-------------------------------------------------------------
How to Recreate the Database Control Repository - (Oracle10g)
-------------------------------------------------------------

If you have ever been in the situation where you needed to re-create the EM 
Database Control Repository, a new article on my site provides a step-by-step 
approach to achieve this. This article can be located at 
http://www.idevelopment.info/ and from the Topics menu navigate to 
"Oracle" -> "DBA Tips" -> "Enterprise Manager" -> "How to Recreate the Database 
Control Repository - (Oracle10g)".


-------------------------------------------------------------
Adding a Node to an Oracle10g RAC Cluster - (RHEL 3)
-------------------------------------------------------------

I completed a new article that describes how to add a new node to an 
existing 10g RAC configuration. This article uses an existing two-node 
RAC configuration and describes how to add another Linux node (using RHEL 3) 
to a shared FireWire drive. The article can be located at 
http://www.idevelopment.info/ and from the Topics menu navigate to 
"Oracle" -> "DBA Tips" -> "Oracle10g RAC" -> 
"Adding a Node to an Oracle10g RAC Cluster - (RHEL 3)".


-------------------------------------------------------------
New Statspack SQL Scripts for Oracle10g
-------------------------------------------------------------

I recently updated all scripts within the Statspack section 
of the "Oracle DBA Scripts" page to work with Oracle10g. These scripts 
can be found at http://www.idevelopment.info/ and from the Topics menu navigate 
to "Oracle" -> "DBA Scripts" -> "Statspack".


-------------------------------------------------------------
Search and Replace with REPLACE Function
-------------------------------------------------------------

Did you know that is possible to replace string content 
using the build-in REPLACE function in Oracle? 

In the following example, I want to replace all occurances of 
"http://secure." with "https://secure." within 
the table "company_config": 

    UPDATE company_config
    SET company_url = REPLACE(company_url, 'http://secure.', 'https://secure.')
    WHERE company_url like 'http://secure.%';

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