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


 

今天在对生产环境的非使用账户进行例行清理的时候居然在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,如需转载请自行联系原作者



相关文章
error C2449: found ‘{‘ at file scope (missing function header?)和error C2059: syntax error : ‘}‘
error C2449: found ‘{‘ at file scope (missing function header?)和error C2059: syntax error : ‘}‘
130 0
|
7月前
|
Perl
报错:error Parsing error: x-invalid-end-tag
报错:error Parsing error: x-invalid-end-tag
155 0
|
关系型数据库 MySQL C++
Error:error C2601: ‘b‘ : local function definitions are illegal error C2063: ‘b‘ : not a function
Error:error C2601: ‘b‘ : local function definitions are illegal error C2063: ‘b‘ : not a function
189 0
error C2041: illegal digit ‘9‘ for base ‘8‘ | error C2059: syntax error: ‘bad suffix on number‘
error C2041: illegal digit ‘9‘ for base ‘8‘ | error C2059: syntax error: ‘bad suffix on number‘
146 0
error: static assertion failed: Signal and slot arguments are not compatible.
error: static assertion failed: Signal and slot arguments are not compatible.
error: static assertion failed: Signal and slot arguments are not compatible.
|
C语言
error: implicit declaration of function ‘VerifyFixClassname‘ is invalid in C99 [-Werror,-Wimplicit-f
error: implicit declaration of function ‘VerifyFixClassname‘ is invalid in C99 [-Werror,-Wimplicit-f
151 0
Whitelabel Error Page There was an unexpected error (type=Not Found, status=404). No message availab
Whitelabel Error Page There was an unexpected error (type=Not Found, status=404). No message availab
187 0
|
SQL 数据库
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
今天在PlateSpin Forge(关于PlateSpin相关介绍,请见最下面部分简单介绍) 复制出来的一台数据库服务器上,测试数据库能否正常启动时,遇到了“ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], ...
1351 0