Setup Oracle Database Environment [Deprecated]
In order to set up Oracle Database environment, you need to configure change notification on the Oracle Server as described below.
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 OleDb Environment
Setup SQL Server for CLR Procedures
Monitor Caches
