Oracle Autonomous Advisor returns ORA-00001

Hi guys,

I am using Oracle Autonomous Database Schema Advisor on an Oracle 19c for Linux x86-64bit to produce a report on a schema.

I successfully installed the Advisor as follows:

SQL> @/media/sf_staging/install_adb_advisor.sql ADB_ADVISOR mypassword

old  1: CREATE USER &&1 identified by "&&2"

new  1: CREATE USER ADB_ADVISOR identified by "mypassword"

User created.

...

Package created.

Package body created.

No errors.

When I run the advisor script, it returns ORA-00001 error as follows:

SQL> CONN adb_advisor/mypassword@//srv1.localdomain/pdb1.localdomain

Connected.

SQL> SET SERVEROUTPUT ON FORMAT WRAPPED

SET LINES 200

exec ADB_ADVISOR.REPORT(schemas=>'SOE', adb_type=>'ATP');SQL> SQL>