ORA-20200

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

SYMPTOMS

• Some SQL scripts from ORACLE_HOME/rdbms/admin, such as addmrpt.sql, ashrpt.sql, awrinfo.sql, awrrpti.sql, etc... generate errors similar to the following:  
  
  

  SQL>  @?/rdbms/admin/awrrpt.sql
  
  Current Instance
  ~~~~~~~~~~~~~~~~
  
  ...
  
  
  Instances in this Workload Repository schema
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
    DB Id     Inst Num DB Name   Instance Host
  ------------ -------- ------------ ------------ ------------
  * 126907423    1 IDHPR9   idhpr9 endecprtp1
  
  Using   126,907,423 for database Id
  Using     1 for instance number
   :dbid      :=       126,907,423;
                          *
  ERROR at line 2:
  ORA-06550: line 2, column 26:
  PLS-00103: Encountered the symbol "," when expecting one of the following:
  * & = - + ; < / > at in is mod remainder not rem
  <an exponent (**)> <> or != or ~= >= <= <> and or like like2
  like4 likec between || multiset member submultiset
  
  
  declare
  *
  ERROR at line 1:
  ORA-20200: Database/Instance / does not exist in DBA_HIST_DATABASE_INSTANCE
  ORA-06512: at line 23
  
  
  

 

  

CHANGES

The numformat SQL*Plus Environment Variables has been updated to a non-standard format

CAUSE

The numformat SQL*Plus Environment Variables being set to an unexpected format caused the issue. For example:

SQL> show numformat
numformat "999,999,999,999"

AWR script inputs are influenced via SQL*Plus Environment Variables, since they are executed within the SQL*Plus environment.

Issue is reproducible for all *.SQL scripts from @$ORACLE_HOME/rdbms/admin like, addmrpt.sql, ashrpt.sql, awrinfo.sql, awrrpti.sql.

 

SOLUTION

Reset the numformat SQL*Plus environment to the default using the following:

To see the current value:

SQL> show numformat

To reset numformat back to the default and verify:

SQL> set numformat ""
SQL> show numformat