Oracle RAC is supported but RAC SCAN is NOT supported.
STATUS:
FGL-17506 submitted for consideration in future FMS release post 5.7.5.7
Foglight supports Oracle RAC as an external database.
WORKAROUND:
To use a SCAN Listener additional manual adjustments are needed. There are 2 options to add the correct JDBC connection string, so that the SCAN Listener will be used. By default Foglight creates the JDBC connection string based on the DB SID, DB Host and DB port. Those parameters are located in the $FMS_HOME/confi/server.config and looks like this:
1. Option:
The file "$FMS_HOME/confi/server.config" contains another parameter called "server.database.url". This parameter is not active by default. To activate it remove the # sign at the beginning of the line and add the needed values, for example:
server.database.url = "jdbc:oracle:thin:@myScanListener:1521/myFoglightDB";
2. Option:
Foglight contains an additional file where the JDBC connection string can be defined.
Foglight version 5.7.x and lower:
Go to "$FMS_HOME/server/jboss/conf" and find the file "oracle-ds.xml". In this file the line "<connection-url>${server.database.url}</connection-url>" can be found and modified as followed:
<connection-url>jdbc:oracle:thin:@myScanListener:1521/myFoglightDB</connection-url>
Foglight version 5.9.x and higher:
Go to "$FMS_HOME/config/datasource" and find the file "datasource-oracle.properties". Search for the parameter "url", remove the # sign at the beginning of the line and set the needed value, for example:
url= jdbc:oracle:thin:@myScanListener:1521/myFoglightDB
NOTE:
Before doing any changes at the config files, please make a backup copy of the files.
