Gathering Data from Multiple Oracle Databases.
To gather data from multiple Oracle databases, you can either use a separate data source for each database, or use a single data source. When tuning the data collection process, consider the following:
You will need a separate Oracle ODBC proxy for each database. Include these computers in the Oracle ODBC computers site.
In the TNSNAMES.ORA file, configure the TNS Name for each Oracle ODBC proxy as its computer name.
When configuring the connection string in the Database Log template, specify the server name using the keyword: SERVER=%COMPUTER_NAME% When connecting to the database, this keyword will be replaced with the Oracle ODBC proxy name.
Since the data source will use the same connection string (and, thus, the same credentials for database access) for all databases, make sure this user account is granted access rights to these databases.
It is recommended that you verify the connection string on the Oracle ODBC proxy side. To test the connection string, you can use, for example, ODBC Data Source Administration.
NOTE: You can use the same ODBC proxy for multiple databases. In this case, however, you will have to create a separate data source for each database.
