Return
-
Title
Execute a user defined collection only if the database is in primary mode -
Description
When using a user defined collection (UDC) in a data guard setup, is there an option to run the query only when the database is in primary mode? If the UDC is running on the standby database the following error appears:---DBO_Cust_Oracle_YourUDCName Failed with the exception: Failed to execute query on instance [YourAgentName], user account [foglight]. Reason : [ORA-01219: database not open: queries allowed on fixed tables/views only - Profile:OracleProfile{host='YourHost', instance='YourInstance', username='foglight', asSysDBA=true, ports='1521', properties={oracle.jdbc.ReadTimeout=900000}} Query: "select ....")]. [Oracle Error Code = 1219. SQL state : 64000].---Error "ORA-01219: database not open: queries allowed on fixed tables/views only" is correct as the database is not open when it is in standby mode -
Cause
Product defect -
Resolution
WORKAROUND:None.STATUS:A change request has been created. CR number: ORAFOG-761It will be fixed in a future release. -
Defect ID
ORAFOG-761