Setup Oracle Database Environment

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:

GRANT CHANGE NOTIFICATION TO <database_user>;
GRANT EXECUTE ON DBMS_CHANGE_NOTIFICATION TO <database_user>;

Note

Replace the <database_user> with your own user name.

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

Setup Oracle Database Environment

Configuring Notification on Oracle Server

Note

See Also