I have an HPUX server running Oracle database in it and I would like to monitor the Oracle components via APM v4.2. I have been just informed by the support team that there is no existing templates for Unix based Oracle servers.
Has anyone created any custom script or template to monitor Oracle in Unix or Linux OS server before? If yes, would you be able to share it?
Or else is there any way I can monitor my Oracle database?
Solved! Go to Solution.
Fortunately for you support was mistaken. The Oracle templates that are included in APM/SAM are OS agnostic. They function by using the Oracle client installed on the APM/SAM server to connect to a remote Oracle database running on Windows/Linux/Unix. So regardless of which operating system your Oracle Database server is running on the Oracle Application Template will work.
As a side note, you should consider upgrading to the latest version of SAM 5.2. If you're under maintenance there's zero cost, but you benefit from a wealth of new features.
Thanks for you advise. Yes, we are upgrading our APM to SAM 5.2 tonight. I did try using the Oracle template to this HPUX server but I got the below error. Any idea what does that mean? We have installed Basic Lite Oracle Client in our APM server.
Based on the screenshot above it appears as though the Destination Point Type and Destination Point Name have not been properly configured in SAM with the appropriate settings for your Oracle server. You may need to work with your Oracle DBA to determine if you're Oracle server is configured to use a SID or a Service Name to connect, and what that Service Name is. These settings can be normally be found in the tnsnames.ora file that is typically provided by the Oracle DBA with the Oracle Client.
You're right. it is working now. I have changed the "Destination Point Type" to SID and "Destination Point Name" to the database name.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.