The INTERNAL_VERSION_CHECK procedure verifies whether the database version matches the DBMS_PROFILER version. If the DBMS_PROFILER system package delivered together with the OceanBase Database package to the admin user is modified unexpectedly, the system package may fail to properly work and even compromise system stability. In this case, we recommend that you back up the data and redeploy OceanBase Database by using the installation media. If you follow the standard deployment and upgrade processes, the issue of version mismatch seldom occurs.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_PROFILER.INTERNAL_VERSION_CHECK
RETURN BINARY_INTEGER;
Examples
obclient> select dbms_profiler.INTERNAL_VERSION_CHECK() from dual;
+----------------------------------------+
| DBMS_PROFILER.INTERNAL_VERSION_CHECK() |
+----------------------------------------+
| 0 |
+----------------------------------------+
1 row in set (0.063 sec)