报错信息:10.2.0.1升级到10.2.0.5运行catupgrd.sql后一切正常,没有出现异常。
1、在运行utlrp.sql脚本重新编译无效PL/SQL包时,出现如下错误:
ERROR at line 1:
ORA-12801: error signaled in parallel query server P064
ORA-00018: maximum number of sessions exceeded
ORA-06512: at "SYS.UTL_RECOMP", line 662
ORA-06512: at line 4
2、在运行命令检查所有组件是否成功:
SQL> select comp_name,version,status from sys.dba_registry;
出现如下错误:
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
Oracle Database Catalog Views 10.2.0.5.0 VALID
Oracle Database Packages and Types 10.2.0.5.0 INVALID
Oracle Workspace Manager 10.2.0.5.0 VALID