exp 报错 ORA-06550

tjyyz

執行exp時出現錯誤訊息：
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored

猜測原因：oracle版本升級不完整
使用以下查詢來確定：
SQL> col comp_name format a30
SQL> col comp_id format a10
SQL> list
1 select substr(comp_id,1,15) comp_id,status,substr(version,1,10) version
2 ,substr(comp_name,1,30) comp_name
3* from dba_registry order by 1
SQL> /
COMP_ID STATUS VERSION?? COMP_NAME
------------ ----------- -------------------- ------------------------------
AMD???? INVALID 9.2.0.1.0 OLAP Catalog
APS???? LOADED? 9.2.0.1.0 OLAP Analytic Workspace
CATALOG VALID?? 9.2.0.1.0 Oracle9i Catalog Views
CATJAVA VALID?? 9.2.0.1.0 Oracle9i Java Packages
CATPROC VALID?? 9.2.0.1.0 Oracle9i Packages and Types
CONTEXT VALID?? 9.2.0.1.0 Oracle Text
JAVAVM? VALID?? 9.2.0.1.0 JServer JAVA Virtual Machine
ODM???? LOADED? 9.2.0.1.0 Oracle Data Mining
ORDIM?? LOADED? 9.2.0.1.0 Oracle interMedia
OWM???? VALID?? 9.2.0.1.0 Oracle Workspace Manager
SDO???? LOADED? 9.2.0.1.0 Spatial
WK????? VALID?? 9.2.0.1.0 Oracle Ultra Search
XDB???? INVALID 9.2.0.1.0 Oracle XML Database
XML???? VALID?? 9.2.0.2.0 Oracle XDK for Java
XOQ???? LOADED? 9.2.0.1.0 Oracle OLAP API

發現版本不對。

解決方法：
SQL> SHUTDOWN IMMEDIATE 
SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE 

SQL> startup

之後再執行exp就沒有問題了

執行後的狀態

COMP_ID STATUS VERSION?? COMP_NAME
---------- ----------- -------------------- ------------------------------
AMD???? VALID? 9.2.0.4.0 OLAP Catalog
APS???? LOADED 9.2.0.4.0 OLAP Analytic Workspace
CATALOG VALID? 9.2.0.4.0 Oracle9i Catalog Views
CATJAVA VALID? 9.2.0.4.0 Oracle9i Java Packages
CATPROC VALID? 9.2.0.4.0 Oracle9i Packages and Types
CONTEXT VALID? 9.2.0.4.0 Oracle Text
JAVAVM? VALID? 9.2.0.4.0 JServer JAVA Virtual Machine
ODM???? LOADED 9.2.0.1.0 Oracle Data Mining
ORDIM?? VALID? 9.2.0.4.0 Oracle interMedia
OWM???? VALID? 9.2.0.1.0 Oracle Workspace Manager
SDO???? LOADED 9.2.0.4.0 Spatial
WK????? VALID? 9.2.0.4.0 Oracle Ultra Search
XDB???? VALID? 9.2.0.4.0 Oracle XML Database
XML???? VALID? 9.2.0.6.0 Oracle XDK for Java
XOQ???? LOADED 9.2.0.4.0 Oracle OLAP API

转自

http://blog.blueshop.com.tw/endymion/archive/2009/04/23/58447.aspx

有部分更改