A custom application is an application that was not installed using AutoInstall or, any application that resides outside the database where Oracle Alert resides. For example, an Oracle Application that resides in a different database from Oracle Alert is considered a custom application. Using database links, Oracle Alert can monitor any custom application as if it resides in the same database as Oracle Alert.
CREATE DATABASE LINK linkname CONNECT TO username IDENTIFIED BY password USING 'connect string';
Note: Replace'connect string'with a SQL*Net V1 connect string or a SQL*Net V2 alias. Refer to the SQL*Net User's Guide for your protocol for more information.
CREATE DATABASE LINK CUSTOM_APPL CONNECT TO SCOTT IDENTIFIED BY TIGER USING 't:hqfin:CUSTOM_DB';
Note: If your custom application resides in the same database as Oracle Alert, you need not define a database link.
Attention: If you want to create event alerts for Oracle Applications that reside on another database, you must install Oracle Alert on that database.