I'm new to Grid Control so I may be setting up my user defined metric incorrectly.
We are running Grid Control version 10.2.0.5. The target is an Oracle Database Instance version 126.96.36.199 on a remote server. Grid Control is successfully monitoring the Database Instance for some of the default metrics such as CPU utilization, active sessions, sql response time, invalid objects, broken jobs, etc.
I tried to create a user-defined metric that run a sql statement against a specific schema and I'm getting the ORA-03113: end-of-file on communication channel error. The sql statement is correct--when I copy it into sqlplus it runs fine, and I can actually go to the DB instance in Grid Control, to the Execute SQL link and run the sql and it runs fine with the preffered credentials for that database instance.
I created a 2nd user-defined metric with a very simple sql statement (select '1' as testnum from dual) and it gave me the same error.
Your help is appreciated.
grant sysdba to dbsnmp and reconfigure the database from gridcontrol as below and check
Go to Targets tab.
Select the Database
From the Configure Database Instance: Properties page set the Role field to sysdba
Set the Monitor Username field to dbsnmp
Provide a valid password in the Monitor Password field.