查看版本号
|
1 2 3 |
sqlplus / as sysdba
> select * from v $version; |
备份orcl数据库
|
1 2 3 4 5 |
export ORACLE_SID=orcl
rman targer /
>backup full database plus archivelog; |
升级
./runInstall 安装升级包
|
1 2 3 4 5 6 7 8 |
sqlplus / as sysdba
>startup upgrade >@$ORACLE_HOME /rdbms/admin/catupgrd .sql > shutdown immediate >startup >@$ORACLE_HOME /rdbms/admin/utlrp .sql > select * from utl_recomp_errors; ----------> 无选定行说明无错误 |
检查
|
1 2 3 4 5 6 |
> 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 |
手工卸载oracle：
|
1 2 3 4 5 |
/etc/ora * /usr/local/bin/oraenv /usr/local/bin/dbhome /usr/local/bin/coraenv $ORACLE_BASE/* |
查看更多关于升级和卸载Oracle数据库软件的命令整理的详细内容...