You can replace the PostgreSQL database with an Oracle database. If you will be using Oracle, you do not need the PostgreSQL database. To connect to Oracle, Oracle will need to be previously installed and you will need an Oracle Client to connect to the Oracle database. You will also need to request a userid and password from your DBA that allows access to create the Meister database objects.
A “Database Parameters” dialog box will display during the install process.
1) Enter in the Oracle userid and password into this dialog.
2) Complete the install process. You will receive an error message that the Knowledgebase Server did not start. Ignore the error message. The error is due to the fact that PostgreSQL is not installed.
3) Complete the install even though errors have occurred.
4) Next, in the Eclipse RCP Client, open Windows -> Preferences -> OpenMake -> Machine. On the Knowledgebase Server tab enter in the following for the Database Driver: oracle.jdbc.OracleDriver.
5) Enter in the following for the Database Name: jdbc:oracle:oci:@<TNS Name> where TNS Name is your TNS Name to connect to the Oracle Database.
6) Finally, save the changes and exit the UI.
7) The Knowledgebase Server needs to have the Oracle .jar files in place to connect to Oracle. First, Stop the Knowledgebase Server if it is still running. Next, delete:
<installdir>/kbserver/tomcat/webapps/openmake.ear/openmake.war/WEB-INF/lib/postgres.jar.
8) Copy ojdbc6.jar and xstreams.jar from your Oracle install to:
<installdir>/kbserver/tomcat/webapps/openmake.ear/openmake.war/WEB-INF/lib.
9) Finally, restart the KB Server. Check for any startup errors by view the log files in the directory:
<install dir>/kbserver/tomcat/webapps/openmake.ear/logs