Skip to content

Can't install utPLSQL on AlwaysFree ATP 21c #1127

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
MaikMichel opened this issue Mar 11, 2021 · 3 comments
Closed

Can't install utPLSQL on AlwaysFree ATP 21c #1127

MaikMichel opened this issue Mar 11, 2021 · 3 comments
Assignees

Comments

@MaikMichel
Copy link

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.0

To Reproduce
Steps to reproduce the behavior:

  1. Go to OCI
  2. Create an AlwaysFree ATP Instance and choose 21c as your Database Version
  3. Connect as Admin and install utPLSQL (I did it headless)
  4. 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

@PhilippSalvisberg PhilippSalvisberg self-assigned this Mar 11, 2021
@PhilippSalvisberg
Copy link
Member

utPLSQL version 3.1.10 cannot be installed in an Oracle Database 21c.

However, you can install the current develop version in 21c. See also #1111 .

@MaikMichel
Copy link
Author

Ok, thank you for your fast response ;-)

@PhilippSalvisberg
Copy link
Member

You're welcome. I close this issue.

Feel free to reopen it if you encounter problems installing the current develop version.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants