环境介绍:
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
今天在对生产环境的非使用账户进行例行清理的时候居然在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也能很好的解决这个问题,但是由于生产环境不敢苟同,以后可以在测试环境测下!
在正式环境中如果非迫不得已还是少执行一些涉及面很广的动作。
本文转自glying 51CTO博客,原文链接:http://blog.51cto.com/liying/967723,如需转载请自行联系原作者