这个问题解决了已经。与其他机器的9201版本进行比对,发现dbms_lob文件没办法编译通过,那执行exp、imp等命令肯定是失败的了。后来去重新执行dbms的sql脚本,发现还是没办法编译通过。
一个办法:升级!
从9201到9204,执行升级脚本,对oracle本身的一些文件进行重编译,搞定!
好像找不到上传附件的东西,脚本也没去好好整理,简单把一些操作过程抓出来,供参考一下吧。
升级脚本:
1、 connect /nolog-->conn sys/**** as sysdba
2、进入SQL* PLUS
3、进入迁移模式
A:startup migrate
B:spool patch.log
C @\rdbms\admin\catpath.sql
D:spool off
E:如果出现错误,则回到B,重新执行C
F:shutdown (immediate)
G:startup,重新正常启动
H:执行@ %ORACLE_HOME%\rdbms\admin\utlrp.sql scrīpt,如果是双处理器,需要再执行@utlrp.sql脚本。
I:如果是OLAP模式的话,还需要继续执行
alter user olapsys identified by password account unlock;
connect olapsys/password
@cwmlite\admin\postamd.sql
J:EXIT
4、如果在ORACLE HOME中安装有ORACLE INTENET DIRECTORY VERSION 9.2.0.x.x
A:、Temporarily set the ORACLE_HOME and ORACLE_SID environment variables. For example:
C:\> set ORACLE_HOME=D:\oracle\ora92
C:\> set ORACLE_SID=sales
B:Verify that the WINDIR system variable is set. For example:
C:\winnt
C:Verify that the PATH system variable contains the Oracle home bin directory. For example:
D:\oracle\ora92\bin
D:Ensure the database and database listener are running, and all oidpatchca.bat parameters are specified correctly prior to running the scrīpt:
ORACLE_BASE\ORACLE_HOME\bin\oidpatchca.bat
-connect Connect String\
-lsnrport Listener Port\
-systempwd SYSTEM Password\
-odspwd ODS Password\
-sudn Super-User DN\
-supwd Super-User Password\
-dippwd Password to register DIP Server\
-windir %windir%
In the preceding command, Password to register DIP Server must conform to the password policy in the Oracle Internet Directory server.
5、如果装有ORACLE RECOVERY MANAGER CATALOG的。继续执行
rman catalog <user/passwd@alias>
upgrade catalog;
upgrade catalog;
一个办法:升级!
从9201到9204,执行升级脚本,对oracle本身的一些文件进行重编译,搞定!
好像找不到上传附件的东西,脚本也没去好好整理,简单把一些操作过程抓出来,供参考一下吧。
升级脚本:
1、 connect /nolog-->conn sys/**** as sysdba
2、进入SQL* PLUS
3、进入迁移模式
A:startup migrate
B:spool patch.log
C @\rdbms\admin\catpath.sql
D:spool off
E:如果出现错误,则回到B,重新执行C
F:shutdown (immediate)
G:startup,重新正常启动
H:执行@ %ORACLE_HOME%\rdbms\admin\utlrp.sql scrīpt,如果是双处理器,需要再执行@utlrp.sql脚本。
I:如果是OLAP模式的话,还需要继续执行
alter user olapsys identified by password account unlock;
connect olapsys/password
@cwmlite\admin\postamd.sql
J:EXIT
4、如果在ORACLE HOME中安装有ORACLE INTENET DIRECTORY VERSION 9.2.0.x.x
A:、Temporarily set the ORACLE_HOME and ORACLE_SID environment variables. For example:
C:\> set ORACLE_HOME=D:\oracle\ora92
C:\> set ORACLE_SID=sales
B:Verify that the WINDIR system variable is set. For example:
C:\winnt
C:Verify that the PATH system variable contains the Oracle home bin directory. For example:
D:\oracle\ora92\bin
D:Ensure the database and database listener are running, and all oidpatchca.bat parameters are specified correctly prior to running the scrīpt:
ORACLE_BASE\ORACLE_HOME\bin\oidpatchca.bat
-connect Connect String\
-lsnrport Listener Port\
-systempwd SYSTEM Password\
-odspwd ODS Password\
-sudn Super-User DN\
-supwd Super-User Password\
-dippwd Password to register DIP Server\
-windir %windir%
In the preceding command, Password to register DIP Server must conform to the password policy in the Oracle Internet Directory server.
5、如果装有ORACLE RECOVERY MANAGER CATALOG的。继续执行
rman catalog <user/passwd@alias>
upgrade catalog;
upgrade catalog;