查看版本號(hào)
sqlplus / as sysdba
>select * from v$version;
備份orcl數(shù)據(jù)庫(kù)
export ORACLE_SID=orcl
rman targer /
>backup full database plus archivelog;
升級(jí)
./runInstall 安裝升級(jí)包
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; ----------> 無(wú)選定行說(shuō)明無(wú)錯(cuò)誤
檢查
>select name from v$database ------->確認(rèn)ORACLE_SID正確,為oral
>show user ------->確認(rèn)當(dāng)前使用者為SYS
>select tablespace_name,bytes from dba_data_files ------>確認(rèn)表空間大小
>@$ORACLE_HOME/rdbms/admin/catalog.sql
>shutdown immediate
>startup
手工卸載oracle:
/etc/ora*
/usr/local/bin/oraenv
/usr/local/bin/dbhome
/usr/local/bin/coraenv
$ORACLE_BASE/*
您可能感興趣的文章:- web前端從Oracle數(shù)據(jù)庫(kù)加載動(dòng)態(tài)菜單所用到的數(shù)據(jù)表
- Oracle 高速批量數(shù)據(jù)加載工具sql*loader使用說(shuō)明
- 安裝Oracle加載數(shù)據(jù)庫(kù)錯(cuò)誤areasQueries的解決
- 完美卸載Oracle數(shù)據(jù)庫(kù)
- Oracle 11g數(shù)據(jù)庫(kù)安裝與卸載的方法圖解
- oracle停止數(shù)據(jù)庫(kù)后linux完全卸載oracle的詳細(xì)步驟
- Oracle數(shù)據(jù)加載和卸載的實(shí)現(xiàn)方法