如何升級(jí)oracle版本

　1. 先檢查數(shù)據(jù)庫(kù)當(dāng)前版本：SELECT * FROM v$version;

成都創(chuàng)新互聯(lián)公司長(zhǎng)期為上千多家客戶提供的網(wǎng)站建設(shè)服務(wù)，團(tuán)隊(duì)從業(yè)經(jīng)驗(yàn)10年，關(guān)注不同地域、不同群體，并針對(duì)不同對(duì)象提供差異化的產(chǎn)品和服務(wù)；打造開放共贏平臺(tái)，與合作伙伴共同營(yíng)造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為正藍(lán)企業(yè)提供專業(yè)的成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作，正藍(lán)網(wǎng)站改版等技術(shù)服務(wù)。擁有十多年豐富建站經(jīng)驗(yàn)和眾多成功案例,為您定制開發(fā)。

2. 使用RMAN或exp 進(jìn)行全庫(kù)備份

【這一步非常非常重要，因升級(jí)到數(shù)據(jù)部分時(shí)，虛擬機(jī)沒空間了，導(dǎo)致VM崩潰，升級(jí)失敗.orcl庫(kù)也掛了，不得不從另一臺(tái)Oracle上創(chuàng)建了一個(gè)Orcl,然后，冷備遷移過來，才得以重新升級(jí)。】

怎樣單獨(dú)升級(jí)oracle的客戶端

簡(jiǎn)單點(diǎn)就把心版本裝好，然后將舊版本卸載即可。主要設(shè)置好環(huán)境變量即可。

如何升級(jí)Oracle Grid Infrastructure和RAC從11.2.0.3到11.2.0.4

為新版本的GI新建一個(gè)新home目錄，解壓升級(jí)包 執(zhí)行安裝程序 會(huì)自動(dòng)檢測(cè)到正在運(yùn)行的cluster,選升級(jí)選項(xiàng) ，目錄選新home ，后面的按提示完成升級(jí) 升級(jí)好后更改環(huán)境變量指向新home

如何實(shí)現(xiàn)最快的Oracle EBS 12升級(jí)

首先這兩個(gè)面對(duì)的對(duì)象就是不同的，EBS面對(duì)的是企業(yè)業(yè)務(wù)邏輯。DBA面對(duì)的是數(shù)據(jù)庫(kù)管理。前者更偏向于與人的交流。 要說有前途的話，個(gè)人感覺EBS比較有前途，畢竟與人交流是王道。

oracle怎么升級(jí)10.2.0.5

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)境的查詢

查看磁盤空間使用情況

[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ù)軟件（磁盤空間足夠）

[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/

如何將 Oracle 11g 升級(jí)到 Orcale 12c

下載12c的安裝包，如果是linux環(huán)境，運(yùn)行./runinstaller，如果是windows環(huán)境，運(yùn)行setup.exe程序。安裝選項(xiàng)選擇升級(jí)現(xiàn)有的數(shù)據(jù)庫(kù)，需要注意的是，保證11g的小版本達(dá)到11.2.0.4或以上

12c引入了多租戶的概念，即一個(gè)實(shí)例可有多個(gè)數(shù)據(jù)庫(kù)。但是通過11g升級(jí)上來的數(shù)據(jù)庫(kù)依然是一個(gè)NON-CDB的數(shù)據(jù)庫(kù)。

網(wǎng)頁題目：如何升級(jí)oracle 如何升級(jí)鴻蒙系統(tǒng)
轉(zhuǎn)載來源：http://chinadenli.net/article8/hhpdip.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供電子商務(wù)、自適應(yīng)網(wǎng)站、品牌網(wǎng)站設(shè)計(jì)、商城網(wǎng)站、定制網(wǎng)站、關(guān)鍵詞優(yōu)化

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)