Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/608510 (SAP Service marketplace login required)

Summary :
The system may encounter ABAP dump DBIF_DSQL2_OBJ_UNKNOWN and Oracle error ORA-00942 when accessing DBA or V$ views in transactions DB02 or ST04 with user SAPR3 or SAP. This issue arises because the 'SELECT_CATALOG_ROLE' is not assigned to the user. To resolve, connect as sysdba in sqlplus, verify role assignment, and grant 'SELECT_CATALOG_ROLE' if necessary. Changes require a system restart or work process restart to take effect. The involvement of 'select_catalog_role', especially after upgrades or support package installations, is crucial.

Key words :
terms dbif_dsql2_obj_unknown ora-00942 db02 st04 select_catalog_role upgrade support package reason, abap dbif_dsql2_obj_unknown short dump, sap<sid> database user, ora-00942 oracle error, sap<sid> user, 'select_catalog_role' database role, database user sapr3, transaction db02, 'select_catalog_role' role, grant select_catalog_role

Related Notes :

700548

FAQ: Oracle authorizations