Closed
Description
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
Metadata
Metadata
Assignees
Labels
No labels