Configuring Your Machine for Oracle Database
For configuring your machine for Oracle databse, you need to install OCI drivers.
In production environments, you might have to ask a database administrator to create a database user for you. You should then be able to run the other SQL scripts yourself, logged on as the user created by the administrator.
Minimum User Permissions
By default the TIBCO BusinessEvents user permissions are set to DBA privileges. At a minimum, the user must be able to create tables and views. For example for an Oracle database you could use the following:
DROP USER BE_USER CASCADE; CREATE USER BE_USER IDENTIFIED BY BE_USER; GRANT CONNECT TO BE_USER; GRANT RESOURCE TO BE_USER; GRANT CREATE ANY VIEW TO BE_USER; GRANT CREATE ANY TABLE TO BE_USER;
- Installing an OCI Driver - OCI Driver Support
This procedure installs an OCI driver for the Oracle database. - Oracle Real Application Cluster (RAC)
Oracle Real Application Cluster (RAC) supports both thin and OCI drivers. - Other Information about Oracle Database and Drivers
A few helpful points about Oracle database and drivers.
Copyright © TIBCO Software Inc. All rights reserved.