Friday, July 27, 2007

Log Miner Implementation Summary

"Log Miner is a powerful tool and all DBA's should know and master it."
- read more -

How manage database without spending a fortune

Very good article in Computerworld discussing how DBAs manage their systems.

New Oracle Linux Test (OLT) Kit

What is OLT?

Oracle Linux Tests are designed to verify Linux kernel functionality and stability essential for the Oracle Database. The Oracle Linux Test (OLT) kit, which is distributed as a set of rpms, provides an automated mechanism to define, execute and analyze tests. The kit contains tools such as DBT2 and DBT3 workloads against Oracle single instance or clustered databases, as well as specialized workload simulators. OLT can be used for running tests on Oracle Enterprise Linux, RHEL and SLES distributions and a variety of topologies ( storage attached network, network attached storage).
project site

Monday, July 16, 2007

Wednesday, July 11, 2007

Step by Step build RAC

Part 1 : Install VMWare and Linux
Part 2 : Install virtual disk and network card
Part 3 : Install Oracle Clusterware and Cluster Database

Oracle 10g RAC On Linux Using NFS
Oracle 10g RAC On Windows 2003 Using VMware Server

Oracle 10g RAC Series

Tuesday, July 10, 2007

Server Monitoring With munin And monit On Debian Etch

In this article Falko Timme describes how you can monitor your Debian Etch server with munin and monit. Munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix ...

Thursday, July 05, 2007

Access migration to Application Express

The only requirement, is that you have SQL access to any Oracle database (9iR2+), because the workbench is driven using an underlying migration repository. You could use the Express Edition of Oracle for this purpose, which is totally free, if you didn't have SQL access to an existing Oracle database.
Full text

Monday, July 02, 2007

Custom APEX Authentication / Authorisation Schemes

Duncan Mein has created a nice How-to for setting up Custom Authentication (Part 1).