oracle ora-16003,ORA-31600错误分析

作者:guoge[@more@]今天在对9i数据库做export时，出现如下错误：

E:>exp system/manager file=backbill.dmp owner=backbill

Export: Release 9.2.0.4.0 - Production on Thu Nov 18 14:42:11 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified users ...

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user BACKBILL

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user BACKBILL

About to export BACKBILL's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

EXP-00056: ORACLE error 31600 encountered

ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TR

ANSFORM_PARAMORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926

ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050

ORA-06512: at "SYS.DBMS_METADATA", line 836

ORA-06512: at line 1

EXP-00000: Export terminated unsuccessfully

出现这个问题我也不知道应该怪我还是怪Oracle。其实这个问题原因和解决方法很简单。

我是先安装oracle9.0.2.1，然后安装9.0.2.4补丁，再创建数据库，我以为这样在创建数据库时就会执行9.0.2.4的脚本，也就没看补丁的README。

其实文档里要求在安装补丁之后，再执行catpatch.sql脚本。

当然上面的问题解决也很简单，就是执行catpatch.sql脚本就可以了。具体过程如下：

1. shutdown immedaite

2. startup migrate

3 @ ?rdbmsadmincatpatch

4. shutdown immedaite

5. startup

需要说明的是： 这种ORA-31600问题只有在给数据库打补丁时才会出现，不打补丁的9i不会出现。