The version of the repository must be compatible with the version of the Oracle Data Miner client. If the client and server versions are not compatible, then the client cannot connect to the server.
The following query returns the repository version and status:
set echo on; -- value of VERSION and REPOSITORY_STATUS SELECT property_name, property_str_value FROM ODMRSYS.ODMR$REPOSITORY_PROPERTIES WHERE property_name IN ('VERSION','REPOSITORY_STATUS', 'WF_VERSION'); PROPERTY_NAME PROPERTY_STR_VALUE ------------------------------ ------------------------------ REPOSITORY_STATUS LOADED VERSION 12.1.0.2.3 WF_VERSION 12.1.0.2.3
The Oracle Data Miner repository has two values for status: NOT_LOADED
and LOADED
.The status NOT_LOADED
, usually indicates that the Repository is being upgraded to support a new version of SQL Developer or a new patch release. When the upgrade completes, then the status is LOADED
.
Parent topic: Managing the Oracle Data Miner Repository