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.
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.
This document describes how to setup connection to a SQL Server database from Oracle.
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.