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