aix 5.309
oracle：10204
中午在导库时候报错：
misdb1:/home/oracle$exp userid=system/oracle full=y direct=y recordlength=65535 file=/backup/oracle/exp_full.dmp log=/backup/oracle/exp_full.log
Export: Release 10.2.0.4.0 – Production on Fri Jun 10 12:39:19 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export the entire database …
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully
——————————————————————————————
登陆sqlplus 执行以下脚本解决
/oracle/product/10.2.0/rdbms/admin/catmetx.sql
/opt/oracle/product/10.2.0/rdbms/admin/utlrp.sql
添加几个dump进程的查询脚本
select sid, serial#
from v$session s, dba_datapump_sessions d
where s.saddr = d.saddr;
select sid, program from v$session where paddr in
(select addr from v$process where pid in (—–));
这里的PID可以在后来的告警日志文件中找到。
使用并行的时候，可以在后台日志中找到PID，就是这里qcsid
select sid from v$px_session where qcsid = 23;
