查看版本号
select * from v$version;
@H_403_5@
备份orcl数据库
rman targer /
backup full database plus archivelog;
@H_403_5@
升级
./runInstall 安装升级包
startup upgrade
@$ORACLE_HOME/rdbms/admin/catupgrd.sql
shutdown immediate
startup
@$ORACLE_HOME/rdbms/admin/utlrp.sql
select * from utl_recomp_errors; ----------> 无选定行说明无错误
@H_403_5@
检查
select name from v$database ------->确认ORACLE_SID正确,为oral
>show user ------->确认当前使用者为SYS
>select tablespace_name,bytes from dba_data_files ------>确认表空间大小
>@$ORACLE_HOME/rdbms/admin/catalog.sql
>shutdown immediate
>startup
@H_403_5@
手工卸载oracle:
403_5@