Menu:

Audit Report Generation For Oracle In HTML Format

In any production environment, you would like to setup auditing for DDLs performed on database. Oracle provides auditing feature that can write audit data to database table or OS file. This document describes steps to setup auditing on Oracle 9i running on Windows environment. It also includes scripts to schedule job, configuration files to easily scale the job to more database, VBScript based email program that sends audit report in HTML format using a SMTP server. 

Install and Configure DB Link to DB2 Database in Linux

Oracle allows access to other database system through a feature called Heteregenous services. It requires you to setup a driver for the external datababase and make configuration changes on listener.ora file and hs.ora files. This document describes how to setup connection to a DB2 database from Oracle. 

Install and Configure DB Link to SQL Server Database in Linux

This document describes how to setup connection to a SQL Server database from Oracle. 

How to Change Interconnect and Public Interface IP in Clusterware in Linux

At many times you may need to change the IP addresses assigned to interconnect interfaces or public network cards. One such situation is moving server from one subnet to another. Since Oracle Cluster Registry saves this information you need to change the configuration before you actually reconfigure the network card.

Rolling Forward Standby Database When Archive Log is Missing

Have you ever run into a situation where standby database has stopped applying logs because an archived log file is missing and you can't find it anywhere. You may be wondering if you need to redo the setup again, don't sweat there is an easy way to fix this.