Setup Oracle Database Environment

In order to setup Oracle Database environment, follow the steps mentioned below to set up the environment for using the Oracle Dependency.

Setup Oracle Database Environment: Configuring Notification on Oracle Server

NCache tracks changes in a database using the notifications received from Oracle Server about changes in the database. For this purpose, NCache registers a CHANGE NOTIFICATION with the Oracle Server. The NCache server should have the CHANGE NOTIFICATION privileges to create a notification registration. If the NCache server machine does not have these privileges, the following statement can be used to grant the CHANGE NOTIFICATION privilege to the user:

CONNECT sys/{your system password} as SYSDBA;
GRANT CHANGE NOTIFICATION TO {your user};
GRANT EXECUTE ON DBMS_CHANGE_NOTIFICATION TO {your user};
ALTER SYSTEM SET "job_queue_processes" = 1;

Once the environment is set, use Oracle dependency using Sync Cache with Oracle in the Programmer's Guide.

See Also

Setup SQL Server Environment
Setup Ole​Db Environment
Setup SQL Server for CLR Procedures
Monitor Caches