1.关闭数据库实例:shutdown immediate
2.关闭oracle服务:emctl stop dbconsole
isqlplusctl stop
oracle 其他服务
关闭Distributed Transaction Coordinator
关闭distributed filesystem
(这一步最好是把所有服务改为手动,然后重启计算机)
3.运行升级文件的setup.exe
4.升级数据库字典:启动监听服务和专用服务
conn / as sysdba
startup upgrade
@$ORACLE_HOME/rdbms/admin/utlu102i.sql
@$ORACLE_HOME/rdbms/admin/catupgrd.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql
shutdown immediate
startup
升级存储过程和java包:$ORACLE_HOME/rdbms/admin/olstrig.sql
编译无效对象:$ORACLE_HOME/rdbms/admin/utlrp.sql (出错)
编译出错执行:$ORACLE_HOME/rdbms/admin/catproc.sql
查看编译错误:select * from utl_recomp_errors;
查看数据库版本:select * from v$version;
查看数据库组件:select comp_id,version,status from dba_registry;
查看无效对象:SELECT count(*) FROM dba_objects WHERE status='INVALID';
查看数据库对象:select * from dba_objects;
查看表空间:select * from dba_tablespaces;
查看数据库文件:select * from dba_data_files;
5.启动服务,使用数据库
2.关闭oracle服务:emctl stop dbconsole
isqlplusctl stop
oracle 其他服务
关闭Distributed Transaction Coordinator
关闭distributed filesystem
(这一步最好是把所有服务改为手动,然后重启计算机)
3.运行升级文件的setup.exe
4.升级数据库字典:启动监听服务和专用服务
conn / as sysdba
startup upgrade
@$ORACLE_HOME/rdbms/admin/utlu102i.sql
@$ORACLE_HOME/rdbms/admin/catupgrd.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql
shutdown immediate
startup
升级存储过程和java包:$ORACLE_HOME/rdbms/admin/olstrig.sql
编译无效对象:$ORACLE_HOME/rdbms/admin/utlrp.sql (出错)
编译出错执行:$ORACLE_HOME/rdbms/admin/catproc.sql
查看编译错误:select * from utl_recomp_errors;
查看数据库版本:select * from v$version;
查看数据库组件:select comp_id,version,status from dba_registry;
查看无效对象:SELECT count(*) FROM dba_objects WHERE status='INVALID';
查看数据库对象:select * from dba_objects;
查看表空间:select * from dba_tablespaces;
查看数据库文件:select * from dba_data_files;
5.启动服务,使用数据库
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22275400/viewspace-683752/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22275400/viewspace-683752/