Oracle monitoring : error to fetch data on tablespace

[studero]

Hi,

In the zabbix_server.log file, I see the following error message. This errors comes after a script remove the data of the tablespace and insert new values after. I need to kill the zabbix session on the Oracle server and put disable / enable the host on the Zabbix console to recive again correctly the data. Why ? What I need to do to not have this error ?

1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_used_pct["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded.
  1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_used_file_pct["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded.
  1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_used_bytes["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded.
  1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_status["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded.
  1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_max_bytes["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded.
  1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_free_bytes["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded.
  1268:20231231:050106.007 error reason for "svx-ora-11e - IAP1:oracle.tbs_alloc_bytes["UNIFR_LIFE"]" changed: Cannot fetch data: Next: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
​

I need help
Regards
Olivier