Closed
Description
Problem:
In alertlog.go
the application attempts to execute SELECT against SYS.V_$DIAG_ALERT_EXT.
However, the docker-compose/oracle/grant_permissions.sql script does not include the necessary GRANT SELECT statement for the pdbadmin user to access this view.
This discrepancy results in three error occurrences upon
docker-compose startup, as the application lacks the required permissions to query the view.Steps to Reproduce:
- docker compose up
- Observe the application logs for errors related to querying
SYS.V_$DIAG_ALERT_EXT.
observability-exporter | time=2025-04-02T00:45:35.414Z level=INFO source=alertlog.go:40 msg="Log destination file does not exist, will try to create it: /log/alert.log"
observability-exporter | time=2025-04-02T00:45:35.577Z level=ERROR source=alertlog.go:113 msg="Error querying the alert logs" !BADKEY="dpiStmt_execute: ORA-00942: table or view \"SYS\".\"V_$DIAG_ALERT_EXT\" does not exist"
observability-exporter | time=2025-04-02T00:45:50.416Z level=ERROR source=alertlog.go:113 msg="Error querying the alert logs" !BADKEY="dpiStmt_execute: ORA-00942: table or view \"SYS\".\"V_$DIAG_ALERT_EXT\" does not exist"
observability-exporter | time=2025-04-02T00:46:05.415Z level=ERROR source=alertlog.go:113 msg="Error querying the alert logs" !BADKEY="dpiStmt_execute: ORA-00942: table or view \"SYS\".\"V_$DIAG_ALERT_EXT\" does not exist"
observability-exporter | time=2025-04-02T00:46:20.413Z level=INFO source=alertlog.go:29 msg="Failed to query the alert log three consecutive times, so will not try any more"
Expected Behavior:
The grant_permissions.sql script should include the following SQL statement to grant the pdbadmin user the necessary permissions:
grant select on sys.v_$diag_alert_ext TO pdbadmin;Metadata
Metadata
Assignees
Labels
No labels