Product: OpenFusion Notification Service
Version: 2.1 and above
Description:
Can I view the instrumentation values for a remote Notification Service?
Solution:
The following steps are needed in order to set up the Oracle DB plug-in for the Notification Service:
a) Bring up the OpenFusion Administration Manager
b) Choose the Notification Service and go to the Persistence tag
c) Change the option JDBC Database type so it reads Oracle
d) Change the jdbc URL to the one you are using for Oracle. This will be of the form jdbc:oracle:thin:@DS where DS is the name of the JDBC data source that has been configured by your Database Administrator for the OpenFusion CORBA Services. The data source name explicitly lists the host name, TCP/IP port and Oracle SID of the database. An example for the above Database URL entry could therefore be:
jdbc:oracle:thin:@linux4:1521:test1
where linux4 is the host name, 1521 the TCP/IP port, and test1 the Oracle SID of the database in this instance.
e) Change the JDBC driver name to oracle.jdbc.driver.OracleDriver
f) Enter your Oracle user name in the JDBC user box and your Oracle password in the JDBC password box
g) Save the settings by clicking on the disk icon
The tables also need to be loaded into the database so these are available to the service. This can be done in one of the following two ways:
1. For OpenFusion v4 tick the "JDBC Auto Create Tables" option on the Persistence tag of the Notification Service. This will cause the tables to be generated when the service is started.
2. Create the tables manually using the sql scripts provided in the OpenFusion installation/admin/database/oracle directory. The tables can be added in two ways:
a) Use sqlplus with the following command:
sqlplus / < File.sql
b) Use the generic OpenFusion JDBC Loader class and use the following command:
run com.prismt.jdbc.Loader -dt oracle -db -dr oracle.jdbc.driver.OracleDriver -u -p -s
#OpenFusion
#KnowledgeDocs
#notificationservice
