Setup Oracle Database Environment [Deprecated]
In order to set up Oracle Database environment, follow the steps mentioned below to set up the environment for using the Oracle Dependency.
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
