日期:2014-05-16  浏览次数:20457 次

Oracle 9206升级至10204错误
Oracle 9.2.0.6升级至10.2.0.4时报如下错误
引用
SQL> select comp_name,status,version from dba_registry
  2  where comp_name='Oracle Database Packages and Types';

COMP_NAME                                STATUS     VERSION
---------------------------------------- ---------- ----------
Oracle Database Packages and Types       INVALID      10.2.0.4.0


alert日志显示:
引用
Wed May 19 23:40:01 2010
SERVER COMPONENT id=CATPROC: timestamp=2010-05-19 23:40:01
SERVER COMPONENT id=RDBMS: status=INVALID, version=10.2.0.4.0, timestamp=2010-05-19 23:40:10

catupgrd.sql执行日志显示:
引用
SQL> CREATE OR REPLACE PACKAGE BODY dbms_sqlpa wrapped
  2  a000000
  3  1
  4  abcd
  5  abcd
  6  abcd
  7  abcd
  8  abcd
  9  abcd
10  abcd
11  abcd
12  abcd
13  abcd
14  abcd
15  abcd
16  abcd
17  abcd
18  abcd
19  b
20  30cb e5e
21  B55TJBGKX8j07noMa5AUAp5czFkwgz2jHiAFV9OdcvnVMO0o8UVFISmk4mftYiundaLqk5vy
22  wBzqjqwTEZivRWGxCYMcS6rk16Wo94l2SZ8llYjpzeNu7no/TsqV9MGdTtwWiGyvbL75zr7F
23  5ZrBCogIwvuo/J16gc+jGvVuXaDjt3XT5M6hbkOHbrfMBBIpAfPUrQBrPkJzQHbLLsUj+6ob
24  6+TR5aHA3F74YwzLkMvtu+mzYVz9ku8OH/EP3Ba9mQ6FbV+LFEdaufBm8vEL067G78p0hqmH
25  yLNsrU4JtXcMD4O1qYH0cHyhtk85646+bmlwm8c2RWlPLUeK+xjbi5GI4+wujG6mgObR1PPi
26  zcK9jCkIfy73Igt7DqTO/M9oT1ltenbHAzNf64UTkSERi3WGNXXt1j3tyh6wF4bB3nXr+YHr
27  XXrVRm8hfUosgBmhYIMoxU0TmjdCcLrfE4j92Ni0EIU51IcjrBoYYw+8krHVWxAfLjTdYeOV
28  bgfPYI7BywQ4MFmKzOeHKH4bGAWVQIQ/z5lTqDo+8Ftxl3Ah/1APOiHoWf8hM1EdSzWHNNnd
29  dYUVIsBjVKrkNdibuu1BTD0a5CuH9+VBPT322YieP+Ac5wppL20o61emfwfmcEgNFGz5jvtg
30  il9gd3L6x2XK1MFXLtR0YucMBSMto5Zkl+XFPAEy2mQPfKgZtcO1v1y8QkDgVTx42ZUDKH7d
31  /MILT/ScATjP4OEDqsJPoutSbve0Hbgmf6Z+m17gLY2H5KB1ENGv2nN6/zQR8gFnPpGnhnys
32  FqEbrMB4D7kGLunDuGr76yhMM6s0OZrOX/pVV1T+OJmRuvGCGt/1hCUwHIG2qvFvpqO0HQFq
33  ckWj0eUTRXF3lbDC4lYH5A7LGeKxzchwCmPnkLH8YU0g3a3A5adioCZDz2Hll/YQRad6oCmx
34  eD0gqWoxMmOup1ga2joeq6AVMfIEuF6lERs7AnuTgIZhhz9i4qfEbYPAo6pQmU/cm3z0urFB
35  HaJa4Wehgjkfsk9VRMsTcFxs5BwpY/sxy5PeQrpkSLtPGJ+jhoZJdJnvfnQvu4wdDsPbkK8P
36  4RIsi0PPXPv+0ccqjjOTjyPtr3t5pYqV+R5MikJTzWosUaG0xnFnKPO+YLfnlXJB/xeFURdQ
37  KfcVV4w+T3r0NHV4WpuWVgIxAZ/KtdFUs9WDYCbeIXAGiznvsIa9z/TAahXsKOeNxA0fHWIs
38  iLVrGOt2w4jQ3i8jpdlF0cEBTPE9z2EW/DHGQt4Qu4qvNDADTZcy8NSRUXree1OjKyqEWdac
39  ej5QTZ+GMe/B3a7CaPdja3OuIdo/ZfDH+L4d/0e2uSE8iqBBnGzHW/vBeG3Ckv0t6h4ls7Zt
40  jo4fou5auujwOfALjW2xngGi5y1q3QI76W/gQ1Khpmx9d2z6RugcqvFL7DY/rmC1Oe2Zio4j
41  q2yaDB2p9Y6LnNF+eGfanIhjhRsOQQxQddG9NSMzHU5mtT0BAil0kZslbr0C81iLktaRJZe3
42  NnwTlKFQpRqAIVqCQqtK6HEs5xcaC50ATyrIt47gr/51R8Y4NssJLDLOc3oY07WQfEbI4Y7+
43  ZT450pg0f4nwCG3BJMhD5dErA4GKA3nusc+H/23ohmKXRGAZKqJLgdl+hzW15kGdUOrfQzB2
44  xgBBmhwxedCKDfhX8EnedOC8TPf63fdMg3CxRs5MxzkUeO/efoWrJyWPjVBNIO3BNq+OUPtD
45  1RZmuPdity5nhm61ZuGnF5vPZ/8BC4X9T5E0i7KJdKoXAYbVhfVWGBT4pfI+OQksqT14jy6W
46  nqKOfnbXAkDXRqbVZuwsvJRFd9oXdO4FP0IwtDxUbAVlVCEYFUCCr145NtaDvrslmBlW4vrk
47  6OX0O791JSbXwlt0D8tk0FozvJKPNEgz1fLLMQkJMYsidNFQOIBbW9Thsh9oH8VSBfmD9nj2
48  +6lEz2NAyp6xl80hMYfPvf+byw4HamCZhpgq5+/1jnN/mgGJtP5rCYLnBeMxb5+/ds