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

环境介绍：

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 ccmain07/ccmain07@baidu 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 ccmain07/ccmain07@baidu 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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10130206/viewspace-1044544/