【案例】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 not accessible


grant select on dba_xml_schemas to select_catalog_role
                *
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBA_XML_SCHEMAS
ORA-06553: PLS-213: package STANDARD not accessible
ORA-06553: PLS-213: package STANDARD not accessible
随便做任何操作基本上都要报ORA-06553的错误，open错误的时候也会报这个错误，但是数据库能正常打开。

2，禁用触发器

SQL> alter system set "_system_trig_enabled"=false;
                                                   
System altered.                                    
再次升级还是报相同的错误。

3，查询无效对象

SQL> SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS'                             
  2  AND OBJECT_NAME = 'STANDARD';                                             
                                                                               
OWNER                                                                          
------------------------------                                                 
OBJECT_NAME                                                                    
--------------------------------------------------------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE           
------------------------------ ---------- -------------- ------------------    
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S                          
--------- --------- ------------------- ------- - - -                          
SYS                                                                            
STANDARD                                                                       
                                      647                PACKAGE               
10-MAR-04 24-APR-13 2001-11-19:00:00:00 INVALID N N N                          
                                                                               
SYS                                                                            
STANDARD                                                                       
                                      648                PACKAGE BODY          
10-MAR-04 10-MAR-04 2004-03-10:12:18:22 INVALID N N N                          
编译无效对象，使用系统自带的utlrp.sql来编译，仍然报相同的错误。使用命令来手动编译

SQL> Alter package sys.standard compile;               
                                                       
Warning: Package altered with compilation errors.      
                                                       
SQL> show error                                        
Errors for PACKAGE SYS.STANDARD:                       
                                                       
LINE/COL                                               
--------------------------------------------------------
ERROR                                                  
--------------------------------------------------------
0/0                                                    
PLS-00920: parameter plsql_native_library_dir is not set

发现了plsql_native_library_dir，突然想起了，上次在做11G迁移到9I的时候，好像弄个plsql相关的参数

SQL> show parameter plsql                                                   
                                                                            
NAME_COL_PLUS_SHOW_PARAM                                         TYPE       
---------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM                                                   
--------------------------------------------------------------------------
plsql_compiler_flags                                             string   
NATIVE                                                                    
plsql_native_c_compiOracle?о?????ler                                          string   
plsql_native_library_dir                                         string   
plsql_native_library_subdir_count                                integer  
0                                                                        
plsql_native_linker                                              string   
plsql_native_make_file_name                                      string   
plsql_native_make_utility                                        string   
plsql_v2_compatibility                                           boolean    
FALSE                                                                      

SQL> alter system set plsql_compiler_flags=INTERPRETED,NON_DEBUG scope=both; 
System altered.                                                     
SQL> Alter package sys.standard compile;                                                                  
Package altered.                                                            
编译通过，再次执行catpatch.sql没有再报于此相关的错误。

本文固定链接: http://www.htz.pw/2013/04/25/ora-06553-pls-213-package-standard-not-accessible.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle报错ORA-06553:PLS-213:package STANDARD not accessible

本文由大师惜分飞原创分享，网址：http://www.oracleplus.net/arch/987.html

Oracle研究中心

关键词：

plsql_compiler_flags引起Oracle升级报错ORA-06553

Oracle报错ORA-06553:PLS-213产生原因和解决办法

Oracle数据库升级报错ORA-06553:PLS-213