[oracle@NEOHP380G7 backup]$ exp usa/usa
Export: Release 9.2.0.6.0 - Production on Wed Jan 9 10:33:33 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter array fetch buffer size: 4096 > 326780
Export file: expdat.dmp > usa
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in US7ASCII character set and UTF8 NCHAR character set
server uusa ZHS16GBK character set (possible charset conversion)
server uusa ZHS16GBK character set (possible charset conversion)
About to export specified users ...
User to be exported: (RETURN to quit) > usa
User to be exported: (RETURN to quit) > usa
User to be exported: (RETURN to quit) >
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user usa
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user usa
About to export usa's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully
. exporting foreign function library names for user usa
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user usa
About to export usa's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully
重新导报错又不同
[oracle@NEOHP380G7 backup]$ exp usa/usa
Export: Release 9.2.0.6.0 - Production on Wed Jan 9 10:47:43 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Enter array fetch buffer size: 4096 > 32780
Export file: expdat.dmp > usa
(1)E(ntire database), (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 US7ASCII character set and UTF8 NCHAR character set
server uusa ZHS16GBK character set (possible charset conversion)
server uusa ZHS16GBK character set (possible charset conversion)
About to export specified users ...
User to be exported: (RETURN to quit) > usa
User to be exported: (RETURN to quit) > usa
User to be exported: (RETURN to quit) >
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user usa
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user usa
About to export usa's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
. exporting foreign function library names for user usa
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user usa
About to export usa's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
在网上搜了搜,看到可能要重建XDB用户,可能与升级有关,近期是对库作过升级操作,
但该执行的包都执行过了.
我先把库找了一个合适的时机停了listener,并重新启动后,又开始导,但这次导出成功了。
于是没再进行其他操作,提前结束维护工作,重新起了listener
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26870952/viewspace-752616/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26870952/viewspace-752616/