ORA-06554

刚新建一库,SQLPLUS连接时提示：ERROR:ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
Error accessing package DBMS_APPLICATION_INFO
ERROR:ORA-06554: package DBMS_STANDARD must be created before using PL/SQL


于是用$ORACLE_HOME/RDBMS/ADMIN下面的相关文件重新创建一下这些包。
SYSDBA登陆运行
$ORACLE_HOME/RDBMS/ADMIN/CATALOG.SQL
$ORACLE_HOME/RDBMS/ADMIN/CATPROC.SQL





ORA-06509: PL/SQL: ICD vector missing for this package

      This can happen if something went wrong during the execution of catproc.sql or catalog.sql, or these scripts were run using a user other than SYS (internal).

      First of all you need to check if the faulty object also exists in a schema other then SYS:

      select owner, object_name, object_type
      from dba_objects
      where object_name=''

      Only the object under SYS schema and possibly a SYNONYM should exist.

      If there's only an object under the SYS schema, try to reexecute the catalog.sql and catproc.sql scripts.