oracle sys.standard,【案例】Oracle报错ORA-06553:PLS-213:package STANDARD not accessible

天萃荷净

运维DBA反映在做完Oracle数据库升级后遇到ORA-06553: PLS-213: package STANDARD not accessible的报错，分析原因为plsql_compiler_flags引导。

测试环境：OS:RHEL 4.8

1，执行catpatch.sql的时候报下面错误

SQL> STARTUP MIGRATE

ORACLE instance started.

Total System Global Area 1075282424 bytes

Fixed Size                   741880 bytes

Variable Size             419430400 bytes

Database Buffers          654311424 bytes

Redo Buffers                 798720 bytes

Database mounted.

Database opened.

SQL> @ /rdbms/admin/catpatch.sql

下面这样的错误，有很多

xdb.xdb$Extname2Intname(s.xmldata.schema_url,s.xmldata.schema_owner),

*

ERROR at line 7:

ORA-04045: errors during recompilation/revalidation of XDB.XDB$EXTNAME2INTNAME

ORA-06553: PLS-213: package STANDARD not accessible

ORA-06553: PLS-213: package STANDARD