Setup Oracle Database Environment

Note

This feature is only available in NCache Enterprise Edition.

In order to create Oracle Dependency, set the environment for using Oracle Dependency. Follow the steps below to set up environment for using Oracle Dependency.

Configuring Notification on Oracle Server

NCache tracks changes in a database using notifications received from Oracle server about changes in the database. For this purpose, NCache registers CHANGE NOTIFICATION with the Oracle server. NCache server should have the CHANGE NOTIFICATION privileges to create a notification registration. If 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 Programmer's Guide.

Setup Oracle Database Environment

Note

Configuring Notification on Oracle Server

See Also