ORA-20200

APPLIES TO:

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:

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:

To reset numformat back to the default and verify:

最后

以上就是花痴鼠标为你收集整理的ORA-20200的全部内容，希望文章能够帮你解决ORA-20200所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。