Oracle 9.2.0.6升级至10.2.0.4时报如下错误
[quote]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[/quote]
alert日志显示:
[quote]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[/quote]
catupgrd.sql执行日志显示:
[quote]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+/dsOn61XI
49 oaU3XDKHU3RJhvtXdyYzwm+ritl+SARZ2zpw1svTtSg8Ub1u3+xBaf1597LlcBoiVLIUwgE0
50 qlu/IQx5PB0J2dY93fUUJeteFji1oz/HdC5wJnqtYx/XRejyIZd9XrROJ2FUVvbADXHPr3kV
51 ltkqk1ado4P8VGp8vAeyB4vSJ8oBEm6iR9OYaGv1M7cjAmgJon8oVcTjBnHfQKcsinEiBSU9
52 w2L/OvcKK1IAChemDgDf/tYSHcLM1jUlqQYinmiaBVOSySBtOX9fSet6HjBu0pikmGNuh12X
53 NiTyYFFMQBmrrhVtRyRjC0p0veG2KrKtBFlpxM3ygrQhF25oC6TEG0H/LBI/cH/LTsnhlvX4
54 UV5uxiJoeT27x+AsNdA8nXn/6O9NFmEhCgypqxfVuilVb2KLQ+YPZVEIoT+DVg2angqXj+KY
55 P5YZAwqjwddV0aW8HWojvO5HUTVtjJBrvyWoB9YFFbGzrt9HAOPfLE8WsN/yyCfzU61p3uwb
56 JogODuwcWHwKcGOIYKDEWKXPWQO2UXD5rm05RYeWsWSBeG91TrruLGJDxFiDD4ecYKenHq3/
57 1P70CVZImEkv9nErT0ZUwJAc3o5TfHZ+QPTPc3VZx93rKzTb0jR1bkHzRJbgxsUZCoamizPG
58 +9ni45OJD209ZA/SpkpyZrpFCX3u3St0VQutpLi9AkEVBx4laKublW7abQO5JhzQGNvKwTd+
59 FZC1ZEOxqXa1df4cXxL9uuJ5fr4NLUMl1Kfa/brifnVqMKCty7WEXp9vJsvESms7paSzATPv
60 /QeTbycHMgP9H2BF/um0uv2vdCA57pQC0YJsUAPPVn85BIURh6lEQGA/j7TrQQYmYzRfjA0z
61 LnwiVZj959Ry2UVWXY3LPEKNbUVxA4JJiM3tVZbIxGJ1HGDyPeqekugKiOSG9Lc4Y68ESM+W
62 FdJOrAN8DCUdVCWqW1qZcsI42mOWI91jdZc2D++f0jXvwNI170jSNe8nIzkFdbNbmMT7iTXv
63 h+yvGRF/2z0L6cszRBgi6IaHF+W8LoRdhkPjOTMuxlkZNHnMwvpzezC0OiIliHWDolUbEQ7e
64 Ur/B9afCOEWDecvD8KXD5XhA5jsVDou/aiPv/71CBEz9H7nWfVAB0agoh9BJsAc7bDczZ7eg
65 O246QWHrwaxlNsCos0VH6NqIESMYZExkx4HE43WB3SlbijJyJpyQb4rojdWKDQjop87xvfRM
66 bPzCiMtFwiD2laB74c/pPvdMXBLI1FMCf7mQsLe9LnktgEZlyuKOVMs6Hv3e5z0H7XgMBQHE
67 +Lr6DUi3ukxi90gXJckr6i4a4vdXxILgV2lKui4XPmtmGZI1CsXctZMJ0seL4j+2aBCEmyc6
68 QjKCTz6/FJoDE20gQSa/mkEQS6NsdgjCzKGbio0LfIFRh2vEZ4cZ9bkC7acbg56m3WVyD86c
69 hbYobTDA0vxrjnZTmDsb5JuM7nXEqf6d1hb/7Tott+ictfW53UrOmEnIk93EH/CDMMmILv2U
70 lilFGd4/9QX78Dc0+CUo0P+kFvA8KgaEJ4UwSxchl5/Z5SWr/KiytKA7/b+K/LXbQM4FLjvS
71 aovMhL/B9AtXZuqQMGqd5CjZWSOg
72
73 /
警告: 创建的包体带有编译错误。
SQL> show errors;
PACKAGE BODY DBMS_SQLPA 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
113/5 PL/SQL: SQL Statement ignored
118/44 PL/SQL: ORA-00904: "OTHER_XML": 标识符无效[/quote]
解决方法如下:
[quote]SQL> drop table plan_table;
SQL> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlxplan
SQL> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\prvtspao.plb
SQL> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlrp.sql[/quote]
dba_registry显示如下:
[quote]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 VALID 10.2.0.4.0[/quote]
[quote]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[/quote]
alert日志显示:
[quote]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[/quote]
catupgrd.sql执行日志显示:
[quote]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+/dsOn61XI
49 oaU3XDKHU3RJhvtXdyYzwm+ritl+SARZ2zpw1svTtSg8Ub1u3+xBaf1597LlcBoiVLIUwgE0
50 qlu/IQx5PB0J2dY93fUUJeteFji1oz/HdC5wJnqtYx/XRejyIZd9XrROJ2FUVvbADXHPr3kV
51 ltkqk1ado4P8VGp8vAeyB4vSJ8oBEm6iR9OYaGv1M7cjAmgJon8oVcTjBnHfQKcsinEiBSU9
52 w2L/OvcKK1IAChemDgDf/tYSHcLM1jUlqQYinmiaBVOSySBtOX9fSet6HjBu0pikmGNuh12X
53 NiTyYFFMQBmrrhVtRyRjC0p0veG2KrKtBFlpxM3ygrQhF25oC6TEG0H/LBI/cH/LTsnhlvX4
54 UV5uxiJoeT27x+AsNdA8nXn/6O9NFmEhCgypqxfVuilVb2KLQ+YPZVEIoT+DVg2angqXj+KY
55 P5YZAwqjwddV0aW8HWojvO5HUTVtjJBrvyWoB9YFFbGzrt9HAOPfLE8WsN/yyCfzU61p3uwb
56 JogODuwcWHwKcGOIYKDEWKXPWQO2UXD5rm05RYeWsWSBeG91TrruLGJDxFiDD4ecYKenHq3/
57 1P70CVZImEkv9nErT0ZUwJAc3o5TfHZ+QPTPc3VZx93rKzTb0jR1bkHzRJbgxsUZCoamizPG
58 +9ni45OJD209ZA/SpkpyZrpFCX3u3St0VQutpLi9AkEVBx4laKublW7abQO5JhzQGNvKwTd+
59 FZC1ZEOxqXa1df4cXxL9uuJ5fr4NLUMl1Kfa/brifnVqMKCty7WEXp9vJsvESms7paSzATPv
60 /QeTbycHMgP9H2BF/um0uv2vdCA57pQC0YJsUAPPVn85BIURh6lEQGA/j7TrQQYmYzRfjA0z
61 LnwiVZj959Ry2UVWXY3LPEKNbUVxA4JJiM3tVZbIxGJ1HGDyPeqekugKiOSG9Lc4Y68ESM+W
62 FdJOrAN8DCUdVCWqW1qZcsI42mOWI91jdZc2D++f0jXvwNI170jSNe8nIzkFdbNbmMT7iTXv
63 h+yvGRF/2z0L6cszRBgi6IaHF+W8LoRdhkPjOTMuxlkZNHnMwvpzezC0OiIliHWDolUbEQ7e
64 Ur/B9afCOEWDecvD8KXD5XhA5jsVDou/aiPv/71CBEz9H7nWfVAB0agoh9BJsAc7bDczZ7eg
65 O246QWHrwaxlNsCos0VH6NqIESMYZExkx4HE43WB3SlbijJyJpyQb4rojdWKDQjop87xvfRM
66 bPzCiMtFwiD2laB74c/pPvdMXBLI1FMCf7mQsLe9LnktgEZlyuKOVMs6Hv3e5z0H7XgMBQHE
67 +Lr6DUi3ukxi90gXJckr6i4a4vdXxILgV2lKui4XPmtmGZI1CsXctZMJ0seL4j+2aBCEmyc6
68 QjKCTz6/FJoDE20gQSa/mkEQS6NsdgjCzKGbio0LfIFRh2vEZ4cZ9bkC7acbg56m3WVyD86c
69 hbYobTDA0vxrjnZTmDsb5JuM7nXEqf6d1hb/7Tott+ictfW53UrOmEnIk93EH/CDMMmILv2U
70 lilFGd4/9QX78Dc0+CUo0P+kFvA8KgaEJ4UwSxchl5/Z5SWr/KiytKA7/b+K/LXbQM4FLjvS
71 aovMhL/B9AtXZuqQMGqd5CjZWSOg
72
73 /
警告: 创建的包体带有编译错误。
SQL> show errors;
PACKAGE BODY DBMS_SQLPA 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
113/5 PL/SQL: SQL Statement ignored
118/44 PL/SQL: ORA-00904: "OTHER_XML": 标识符无效[/quote]
解决方法如下:
[quote]SQL> drop table plan_table;
SQL> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlxplan
SQL> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\prvtspao.plb
SQL> @D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlrp.sql[/quote]
dba_registry显示如下:
[quote]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 VALID 10.2.0.4.0[/quote]