1. 先檢查數(shù)據(jù)庫(kù)當(dāng)前版本：SELECT * FROM v$version; 2. 使用RMAN或exp 進(jìn)行全庫(kù)備份 【這一步非常非常重要，因升級(jí)到數(shù)據(jù)部分時(shí)，虛擬機(jī)沒(méi)空間了，導(dǎo)致VM崩潰，升級(jí)失敗.orcl庫(kù)也掛了，不得不從另一臺(tái)Oracle上創(chuàng)建了一個(gè)Orcl,然后，
創(chuàng)新互聯(lián)公司是一家朝氣蓬勃的網(wǎng)站建設(shè)公司。公司專(zhuān)注于為企業(yè)提供信息化建設(shè)解決方案。從事網(wǎng)站開(kāi)發(fā)，網(wǎng)站制作，網(wǎng)站設(shè)計(jì)，網(wǎng)站模板，微信公眾號(hào)開(kāi)發(fā)，軟件開(kāi)發(fā)，成都小程序開(kāi)發(fā)，十載建站對(duì)建筑動(dòng)畫(huà)等多個(gè)領(lǐng)域，擁有豐富的網(wǎng)站推廣經(jīng)驗(yàn)。
可以直接升級(jí)到12C的數(shù)據(jù)庫(kù)版本有：
?Oracle數(shù)據(jù)庫(kù)10g(10.2.0.5)
?Oracle 數(shù)據(jù)庫(kù) 11g (11.1.0.7)
?Oracle 數(shù)據(jù)庫(kù) 11g (11.2.0.2 或后續(xù)版本)
如果數(shù)據(jù)庫(kù)版本非以上三種，比如是10.2.0.1.0想要升級(jí)到12C，需要先將數(shù)據(jù)庫(kù)升級(jí)到10.2.0.5或其他直接版本，才能再次升級(jí)到12C。
一般生產(chǎn)系統(tǒng)不會(huì)進(jìn)行這種大版本的升級(jí)操作。一般都是將數(shù)據(jù)expdp導(dǎo)出，然后再導(dǎo)入到要升級(jí)到的版本中。這種數(shù)據(jù)庫(kù)需要應(yīng)用去配合更改應(yīng)用。
比較簡(jiǎn)單的方式是通過(guò)EXP導(dǎo)出8.17的數(shù)據(jù)，然后在9i中建立同樣的表空間和用戶，用IMP導(dǎo)入數(shù)據(jù)。
1. 修改快捷鍵 選擇 Tools-Preferences-Shortcut Keys 2. 查找當(dāng)前編輯的代碼所在的頁(yè)面 使用 Alt + Home 組合鍵 3. 復(fù)制文件的路徑到剪切板 選擇Edit-Copy Path 4. 設(shè)置外部程序的快捷方式 選擇Tools-External Tools-Find Tools
ORACLE10G 10.2.0.1升級(jí)到10.2.0.5 2014-06-06 17:23:17
OS: linux redhat 4 U8 64bit
DB: oracle 10.2.0.1
升級(jí)：oracle 10.2.0.5
對(duì)當(dāng)前環(huán)境的查詢
查看磁盤(pán)空間使用情況
[root@dongyang ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 18G 11G 6.2G 64% /
/dev/sda1 988M 42M 896M 5% /boot
tmpfs 1002M 0 1002M 0% /dev/shm
/dev/sdb1 12G 2.3G 9.0G 21% /u01
[root@dongyang ~]#
查看操作系統(tǒng)版本
[root@dongyang ~]# cat /proc/version
Linux version 2.6.32-200.13.1.el5uek (mockbuild@ca-build9.us.oracle.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50)) #1 SMP Wed Jul 27 21:02:33 EDT 2011
[root@dongyang ~]# uname -r
2.6.32-200.13.1.el5uek
[root@dongyang ~]#
查看當(dāng)前數(shù)據(jù)庫(kù)版本
SQL select * from v$version;
select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL
查看oracle用戶環(huán)境變量
[oracle@dongyang ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
alias uni="uniread sqlplus"
export PATH
unset USERNAME
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export ORACLE_SID=fengzi
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATA_FORMAT="YYYY-MM-DD HH24:MI:SS"
export NLS_DATA_LANGUAGE="AMERICAN"
export DISPLAY=192.168.56.1:0.0
要先對(duì)數(shù)據(jù)庫(kù)進(jìn)行冷備與軟件備份
備份數(shù)據(jù)庫(kù)軟件（磁盤(pán)空間足夠）
[root@dongyang ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 18G 11G 6.2G 64% /
/dev/sda1 988M 42M 896M 5% /boot
tmpfs 1002M 0 1002M 0% /dev/shm
/dev/sdb1 12G 2.3G 9.0G 21% /u01
[root@dongyang ~]#
[root@dongyang ~]# mkdir /u02
[root@dongyang ~]# cd /u01
[root@dongyang u01]# cp -r * /u02
關(guān)閉當(dāng)前數(shù)據(jù)庫(kù)
[oracle@dongyang ~]$ echo $ORACLE_SID
fengzi
[oracle@dongyang ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 5 13:46:04 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL
登錄RMAN 啟動(dòng)數(shù)據(jù)庫(kù)到mount狀態(tài)
[oracle@dongyang ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 5 13:48:42 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMANstartup mount
database is already started
database mounted
備份當(dāng)前控制文件
RMAN backup current controlfile;
Starting backup at 05-JUN-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=322 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 05-JUN-14
channel ORA_DISK_1: finished piece 1 at 05-JUN-14
piece handle=+DATA/fengzi/backupset/2014_06_05/ncnnf0_tag20140605t140242_0.380.849448965 tag=TAG20140605T140242 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
Finished backup at 05-JUN-14
Starting Control File and SPFILE Autobackup at 05-JUN-14
piece handle=+DATA/fengzi/autobackup/2014_06_05/s_849447979.381.849448969 comment=NONE
Finished Control File and SPFILE Autobackup at 05-JUN-14
備份數(shù)據(jù)庫(kù)到 /u01/backup/目錄下
RMAN backup database format '/u01/backup/2014_06_01_%U';
Starting backup at 05-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/fengzi/datafile/system.277.842187103
channel ORA_DISK_1: starting piece 1 at 05-JUN-14
channel ORA_DISK_1: finished piece 1 at 05-JUN-14
piece handle=/u01/backup/2014_06_01_27pa3431_1_1 tag=TAG20140605T140417 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00007 name=/u01/app/oracle/oradata/FENGZI/datafile/o1_mf_wer_9ns1wd2n_.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/yyyy12.dbf
input datafile fno=00009 name=/u01/app/oracle/oradata/tt.dbf
input datafile fno=00004 name=+DATA/fengzi/datafile/users2.dbf
input datafile fno=00005 name=+DATA/fengzi/datafile/undotbs.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUN-14
channel ORA_DISK_1: finished piece 1 at 05-JUN-14
piece handle=/u01/backup/2014_06_01_28pa345d_1_1 tag=TAG20140605T140417 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00003 name=+DATA/fengzi/datafile/sysaux.279.842187235
channel ORA_DISK_1: starting piece 1 at 05-JUN-14
channel ORA_DISK_1: finished piece 1 at 05-JUN-14
piece handle=/u01/backup/2014_06_01_29pa3466_1_1 tag=TAG20140605T140417 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/fengzi/datafile/undotbs1.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUN-14
channel ORA_DISK_1: finished piece 1 at 05-JUN-14
piece handle=/u01/backup/2014_06_01_2apa347j_1_1 tag=TAG20140605T140417 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=+DATA/fengzi/datafile/users1.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUN-14
channel ORA_DISK_1: finished piece 1 at 05-JUN-14
piece handle=/u01/backup/2014_06_01_2bpa348d_1_1 tag=TAG20140605T140417 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 05-JUN-14
Starting Control File and SPFILE Autobackup at 05-JUN-14
piece handle=+DATA/fengzi/autobackup/2014_06_05/s_849447979.382.849449239 comment=NONE
Finished Control File and SPFILE Autobackup at 05-JUN-14
RMAN
停止所有oracle服務(wù)，太長(zhǎng)請(qǐng)自己看http //blog.itpub.net/29532781/viewspace-1177188/
重慶分公司
重慶分公司
