Hey All,
I am trying to set up the monitoring for Oracle Database 11gR2 running on RHEL6. We are using NewRelic infrastructure agent to monitor the servers, DB and application health.
The instructions to set up the monitoring is documented here https://docs.newrelic.com/docs/integrations/host-integrations/host-integrations-list/oracledatabase-monitoring-integration
When setting up the account and privileges for monitoring account I am getting the below errors in step 1: (I connected to the DB as sysdba)
SQL> ALTER SESSION set "_Oracle_SCRIPT"=true;
ALTER SESSION set "_Oracle_SCRIPT"=true
*
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION
SQL>
Step 4:
SQL> GRANT SELECT ON cdb_data_files TO newrelic;
GRANT SELECT ON cdb_data_files TO newrelic
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
Any suggestion on this please?
Regards,
Darshan