How should I specify database name for Oracle DB monitor?
Q: What shall I enter into “Oracle Database Name” field when creating Oracle DB monitor? Alias from tnsnames.ora, server name (IP address) or service name (TRAD11P_PROD)?
A: “Oracle Database Name” is database instance name. Oracle database monitor type doesn’t make use of TNS.
Note: it is required to install Oracle Database Instant Client on computer where IPNetwork Monitor is running, to allow using Oracle database monitors. Here are the steps:
a) Download appropriate Instant Client packages (Basic or Basic Lite) for your platform:
https://www.oracle.com/database/technologies/instant-client/downloads.html
b) Unzip the packages into a single directory such as “C:\OracleClient”
c) Append the Instance Client directory path to the “PATH” environment variable, e.g.:
PATH=”%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\OracleClient”
d) Restart both IPNetwork Monitor Client and Service to make them use the newly installed Oracle client libraries.
Related topics
How big can monitoring database grow?
Check out our Knowledge Base where we answer questions regarding various topics. Enter the Oracle database instance name. The Oracle DB monitor does not use TNS aliases from tnsnames.ora. Yes. Install Oracle Database Instant Client on the computer where IPNetwork Monitor runs, then restart both the client and monitoring service. The Instant Client directory must be in the system PATH so IPNetwork Monitor can load the Oracle client libraries when the monitor runs.
Frequently Asked Questions
What value goes in the Oracle Database Name field?
Does the Oracle DB monitor need Oracle client software?
Why is the PATH variable important for Oracle monitoring?