When adding Oracle Databases 12c to Foglight, they are coming up as Standby Database and it is showing no data for tablespaces and other database related metrics. Moreover, It is not picking up the ASM cluster already running on that node.
The DB_Oracle_RAC agent logs show multiple instances of this error even after running the Oracle grant script multiple times:
ORA-01435: user does not exist
This issue is caused by the Oracle Multitenant option for Pluggable Databases being enabled.
To confirm, run these statements:
SELECT version FROM v$instance;
SELECT name, VALUE FROM "V$PARAMETER" WHERE name = 'enable_pluggable_database';
If version is higher or equal to 12 and VALUE is True, then a few changes will be required.
Before running the grant script for the agent user account, create the user account with these commands ('c##foglight' and password 'foglight1234' for this example).
create user c##foglight identified by foglight1234 container=all;
grant connect to c##foglight container=all;
After this step, the normal grant script can be executed for the 'c##foglight' account or go through agent setup wizard and entering a sysdba user account information when prompted.
PLEASE NOTE: When running a grant script the same account must be used in the Foglight database agent as is used in the permissions script, this includes case sensitivity (c##FOGDB might not be the treated the same by Oracle as c##fogdb).
Output from the system view look like the following once the grants have been applied for the new user.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center