Database monitoring in the cloud. — oracle-tech

    Forum Stats

  • 3,702,034 Users
  • 2,239,551 Discussions
  • 7,835,724 Comments

Discussions

Database monitoring in the cloud.

DarshankyDarshanky Posts: 1

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

Tagged:

Answers

  • JohnWatson2JohnWatson2 Posts: 4,147 Bronze Crown
    edited September 14

    _oracle_script does not exist in release 11. Neither does cdb_data_files.

    Darshanky
  • Andris Perkons-OracleAndris Perkons-Oracle Posts: 1,099 Employee
    edited September 14
    Any suggestion on this please? 

    Ask newrelic to fix their documentation to at least mention that some statements won't work with 11.2

    Andris

    Darshanky
Sign In or Register to comment.