When running the Oracle permissions script in the 7.3.2.11 cartridge it tries to grant select privileges improperly on V$ and GV$ views.
Messages like the following result
Error on: GRANT SELECT ON v$session TO C##FOGLIGHT CONTAINER=ALL => ORA-02030: can only select from fixed tables/views
Error on: GRANT SELECT ON gv$archive_dest TO C##FOGLIGHT CONTAINER=ALL => ORA-02030: can only select from fixed tables/views
Oracle doesn't allow you to grant access directly to the V$ views. You must grant access via the SYS schema.
For example, these are being granted:
GRANT SELECT ON v$session TO C##FOGLIGHT
GRANT SELECT ON gv$archive_dest TO C##FOGLIGHT
if should be like this
GRANT SELECT ON v_$session TO C##FOGLIGHT
GRANT SELECT ON gv_$archive_dest TO C##FOGLIGHT
WORKAROUND
Please use the attached fixed Oracle permissions script to correctly assign the necessary privileges to system views. The updated script has been adjusted to grant SELECT_CATALOG_ROLE to the user rather than explicitly status the system views.
STATUS
This issue has been logged as defect FOG-11089 and has been fixed in the 8.0 and higher versions of the Oracle cartridge.
