Some points to note are:

• If the source is an Autonomous Database, running the ADVISE command is not a supported use of CPAT and the result may be unpredictable.

• The PROPERTIES and ADVISE commands require that the connected user has the SELECT ANY DICTIONARY privilege.

  If you do not have the SELECT ANY DICTIONARY privilege, you see the following error:

  SQL> grant connect, resource, unlimited tablespace to jdoe identified by jdoe;
  Grant succeeded.
  
  SQL> connect jdoe/jdoe
  Connected.
  
  SQL> migrateadvisor advise -schemas hr -outfileprefix pre -targettype adws -reportformat json
  
  CPAT-1004: SQL error while initializing premigration application.
  ORA-00942: table or view does not exist
  
  –-Ensure the JDBC connection information is correct. See the log file for more details.
  
  Additional Information: 255: Internal error - please contact support.
  **Exception** : /Users/xyz/pre_premigration_advisor_report.json
  
  Log file contains:
  Caused by: Error : 942, Position : 20, Sql = SELECT VERSION FROM V$INSTANCE, 
  OriginalSql = SELECT VERSION FROM V$INSTANCE, 
  Error Msg = ORA-00942: table or view does not exist