記一次RA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []

qqmengxue發表於2011-01-12

環境介紹:

HP-UNIX 64BIT

ORACLE9.2.0.5 RAC

在做exp匯出的時候報:

RA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []
ORA-19206: Invalid value for query or REF CURSOR parameter

[@more@]

今天在對生產環境的非使用賬戶進行例行清理的時候居然在EXP的時候報錯了:

[oracle@CRMTEST 20110112_allbackup]$ exp file=20110112_fullback.dmp log=dmp.log
Export: Release 9.2.0.4.0 - Production on Wed Jan 12 19:05:14 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CCMAIN07
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CCMAIN07
About to export CCMAIN07's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []
ORA-19206: Invalid value for query or REF CURSOR parameter
EXP-00000: Export terminated unsuccessfully
[oracle@CRMTEST 20110112_allbackup]$

最終解決方式:

[oracle@CRMTEST 20110112_allbackup]$ exp file=20110112_fullback.dmp full=y

Export: Release 9.2.0.4.0 - Production on Wed Jan 12 19:06:17 2011

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
EXP-00023: must be a DBA to do Full Database or Tablespace export
(2)U(sers), or (3)T(ables): (2)U > u

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CCMAIN07
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CCMAIN07
About to export CCMAIN07's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CCMAIN07's tables via Conventional Path ...
. . exporting table CRM_AGENT_FUNCTION 0 rows exported

則可以!

不過也看其他同仁執行@?/rdbms/admin/catmet.sql也能很好的解決這個問題,但是由於生產環境不敢苟同,以後可以在測試環境測下!

在正式環境中如果非迫不得已還是少執行一些涉及面很廣的動作。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10130206/viewspace-1044544/,如需轉載,請註明出處,否則將追究法律責任。

相關文章