記一次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也能很好的解決這個問題,但是由於生產環境不敢苟同,以後可以在測試環境測下!
在正式環境中如果非迫不得已還是少執行一些涉及面很廣的動作。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10130206/viewspace-1044544/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 簡單記錄一次ORA-00600: internal error code, arguments: [2662]Error
- 簡單記錄一次ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600internal error code argumentsError
- 記一次ORA-00600: internal error code, arguments: [kdtdelrow-2]的處理Error
- 記一次ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- 記一次無歸檔恢復ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- 記一次ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []ErrorOBJ
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載:ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error