Can't install utPLSQL on AlwaysFree ATP 21c
Describe the bug
Install-Routine exits with the following error:
-------------------------------------------------------------- Validating installation -------------------------------------------------------------- PACKAGE BODY UT_COVERAGE_REPORT_HTML_HELPER 1 93 41 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.MD5' must be declared PACKAGE BODY UT_COVERAGE_REPORT_HTML_HELPER 2 93 5 PL/SQL: Statement ignored begin * ERROR at line 1: ORA-20000: Not all sources were successfully installed. ORA-06512: at line 3
Provide version info
Information about utPLSQL and Database version,
SQL> set serveroutput on declare SQL> 2 l_version varchar2(255); l_compatibility varchar2(255); 3 4 begin 5 dbms_utility.db_version( l_version, l_compatibility ); 6 dbms_output.put_line( l_version ); 7 dbms_output.put_line( l_compatibility ); 8 end; 9 / 21.0.0.0.0 21.0.0 PL/SQL procedure successfully completed. SQL> select substr(ut.version(),1,60) as ut_version from dual; select * from v$version; select substr(ut.version(),1,60) as ut_version from dual * ERROR at line 1: ORA-00904: "UT"."VERSION": invalid identifier select * from nls_session_parameters; SQL> BANNER BANNER_FULL BANNER_LEGACY CON_ID -------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production 0 Version 21.2.0.0.0 SQL> PARAMETER VALUE ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM PARAMETER VALUE ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE 17 rows selected. SQL> select substr(dbms_utility.port_string,1,60) as port_string from dual; PORT_STRING ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ x86_64/Linux 2.4.xx SQL>
Information about client software
Installation was initiated by SQLPlus 19
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 11 07:57:59 2021
Version 19.9.0.0.0To Reproduce
Steps to reproduce the behavior:
- Go to OCI
- Create an AlwaysFree ATP Instance and choose 21c as your Database Version
- Connect as Admin and install utPLSQL (I did it headless)
- See error
Expected behavior
utPLSQL runs through it's installation process without error ;-)
Example code
/
Additional context
The reason why installation is failing is caused by the fact that oracle has deprecated Package DBMS_OBFUSCATION_TOOLKIT
see: https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/behavior-changes-deprecated-desupport-oracle-database.html#GUID-92A36569-B4B6-49AB-857E-6963D93D6A0D