最新国产好看的视频,伊人天堂AV在线,国产Aaaaaa视频,蜜臀视频在线观看一区,人妻av色图,密臀久久久精品影片,青青视频免费观看毛片,久草在线观看视,国产三级精品色情在线

ORACLE 11g從 11.2.0.1升級(jí)到11.2.0.4 詳細(xì)實(shí)戰(zhàn)教程

 更新時(shí)間:2017年03月31日 16:13:03   作者:黃杉  
這篇文章主要介紹了ORACLE 11g從 11.2.0.1升級(jí)到11.2.0.4 詳細(xì)實(shí)戰(zhàn)教程,非常不錯(cuò),具有參考借鑒價(jià)值,需要的朋友可以參考下

 1、準(zhǔn)備安裝

查看當(dāng)前oracle版本,確定是比較舊的11.2.0.1

[oracle@hch_test_121_90 ~]$ rlwrap sqlplus / as sysdba 
SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 17 15:20:45 2017 
Copyright (c) 1982, 2009, Oracle. All rights reserved. 
Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 
SQL> exit 
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 
[oracle@hch_test_121_90 ~]$ 

上傳11.2.0.4的安裝包p13390677_112040_Linux-x86-64_1of7.zip、p13390677_112040_Linux-x86-64_2of7.zip到服務(wù)器上。Oracle11.2.0.4的安裝包下載,請(qǐng)查閱我的blog地址,這上面有下載源:http://blog.csdn.net/mchdba/article/details/51418063

 升級(jí)準(zhǔn)備:

解壓縮: 
[oracle@hch_test_121_90 oracle]$ unzip p13390677_112040_Linux-x86-64_1of7.zip 
[oracle@hch_test_121_90 oracle]$ unzip p13390677_112040_Linux-x86-64_2of7.zip 
打開(kāi)啟動(dòng)圖像界面 
[oracle@hch_test_121_90 oracle]$ cd database/ 
[oracle@hch_test_121_90 database]$ ./runInstaller 
Starting Oracle Universal Installer... 
Checking Temp space: must be greater than 120 MB. Actual 6024 MB Passed 
Checking swap space: must be greater than 150 MB. Actual 1798 MB Passed 
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed 
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-03-17_03-11-29PM. Please wait ...[oracle@hch_test_121_90 database]$ 
[oracle@hch_test_121_90 database]$ 

2、開(kāi)始升級(jí)

C:\pic\oracle\100.png,填寫郵箱地址(也可以忽略不填寫),然后下一步


選擇忽略軟件升級(jí),下一步嗎,如101.png


然后選擇升級(jí),如下102.png


然后繼續(xù)進(jìn)行,有個(gè)INS-35373錯(cuò)誤,選擇Yes,如下

 

 然后選擇好語(yǔ)言種類,簡(jiǎn)體中文、繁體中文、英語(yǔ)、美式英語(yǔ)等,如104.png所示:


繼續(xù)下一步,選擇企業(yè)版,如

接下來(lái),開(kāi)始選擇oracle目錄了,是選擇新建的目錄呢還是選擇原來(lái)的老版本11.2.0.1的目錄呢?這里最好選擇一個(gè)新的目錄,因?yàn)槿f(wàn)一升級(jí)失敗了,老的oracle版本軟件目錄沒(méi)有被覆蓋掉,還可以繼續(xù)使用的,否則升級(jí)失敗,就基本只有徹底暴力清除所有文件以及注冊(cè)信息,之后重新安裝oracle了。

我這里就選擇一個(gè)新的目錄11.2.0.4的目錄,如106.png、107.png所示 


接下來(lái),繼續(xù),選擇新的的Inventory Directory目錄,默認(rèn)的會(huì)報(bào)錯(cuò),如108.png所示

 

接下來(lái)選擇用戶組和操作組,如109.png所示:

 

 接下來(lái),會(huì)有checking各種lib包,一些比較偏的,缺少了也沒(méi)事,直接Ignore忽略掉就ok,如110.png所示:

 下一步看安裝的目錄以及基本信息,如111.png所示:

然后點(diǎn)擊“”Install“”按鈕,開(kāi)始安裝,如圖112.png

 中級(jí)需要執(zhí)行配置腳本,如圖112_1.png

重新打開(kāi)xshell,ssh連接到數(shù)據(jù)庫(kù),在命令行去執(zhí)行命令:

[root@hch_test_121_90 oracle]# bash -x/oracle/app/oraInventory11.2.0.4/orainstRoot.sh
[root@hch_test_121_90 oracle]# bash -x/oracle/app/oracle/product/11.2.0.4/dbhome_1/root.sh

執(zhí)行過(guò)程如下: 

[root@hch_test_121_90 oracle]# bash -x /oracle/app/oraInventory11.2.0.4/orainstRoot.sh 
+ AWK=/bin/awk 
+ CHMOD=/bin/chmod 
+ CHGRP=/bin/chgrp 
+ CP=/bin/cp 
+ ECHO=/bin/echo 
+ MKDIR=/bin/mkdir 
++ /usr/bin/id 
++ /bin/awk '-F(' '{print $1}' 
++ /bin/awk -F= '{print $2}' 
+ RUID=0 
+ '[' 0 '!=' 0 ']' 
+ '[' -d /etc ']' 
+ /bin/chmod 755 /etc 
+ '[' -f /oracle/app/oraInventory11.2.0.4/oraInst.loc ']' 
+ /bin/cp /oracle/app/oraInventory11.2.0.4/oraInst.loc /etc/oraInst.loc 
+ /bin/chmod 644 /etc/oraInst.loc 
+ /bin/echo 'Changing permissions of /oracle/app/oraInventory11.2.0.4. 
Adding read,write permissions for group. 
Removing read,write,execute permissions for world. 
' 
Changing permissions of /oracle/app/oraInventory11.2.0.4. 
Adding read,write permissions for group. 
Removing read,write,execute permissions for world. 
+ /bin/chmod -R g+rw,o-rwx /oracle/app/oraInventory11.2.0.4 
+ '[' 0 '!=' 0 ']' 
+ /bin/echo 'Changing groupname of /oracle/app/oraInventory11.2.0.4 to oinstall.' 
Changing groupname of /oracle/app/oraInventory11.2.0.4 to oinstall. 
+ /bin/chgrp -R oinstall /oracle/app/oraInventory11.2.0.4 
+ '[' 0 '!=' 0 ']' 
+ /bin/echo 'The execution of the script is complete.' 
The execution of the script is complete. 
[root@hch_test_121_90 oracle]# 
[root@hch_test_121_90 oracle]# 
[root@hch_test_121_90 ~]# sh /oracle/app/oracle/product/11.2.0.4/dbhome_1/root.sh 
Performing root user operation for Oracle 11g 
The following environment variables are set as: 
 ORACLE_OWNER= oracle 
 ORACLE_HOME= /oracle/app/oracle/product/11.2.0.4/dbhome_1 
Enter the full pathname of the local bin directory: [/usr/local/bin]: /oracle/app/oracle/product/11.2.0.4/dbhome_1/bin 
The contents of "dbhome" have not changed. No need to overwrite. 
The contents of "oraenv" have not changed. No need to overwrite. 
The contents of "coraenv" have not changed. No need to overwrite. 
Entries will be added to the /etc/oratab file as needed by 
Database Configuration Assistant when a database is created 
Finished running generic part of root script. 
Now product-specific root actions will be performed. 
Finished product-specific root actions. 
[root@hch_test_121_90 ~]# 

之后回到vnc遠(yuǎn)程的窗口,點(diǎn)擊界面的OK,會(huì)提示安裝Oracle Net Configuration Assistant: Welcome操作:

接下來(lái)會(huì)配置網(wǎng)絡(luò),如下113.png、114.png

 


設(shè)置sys密碼,如115.png所示

看到這里,問(wèn)題來(lái)了,中間沒(méi)有數(shù)據(jù)庫(kù)讓你選擇去升級(jí),問(wèn)題在哪里呢,在/etc/oratab沒(méi)有配置,所以趕緊去配置:

[root@hch_test_121_90 ~]# more /etc/oratab 
# 
# This file is used by ORACLE utilities. It is created by root.sh 
# and updated by either Database Configuration Assistant while creating 
# a database or ASM Configuration Assistant while creating ASM instance. 
# A colon, ':', is used as the field terminator. A new line terminates 
# the entry. Lines beginning with a pound sign, '#', are comments. 
# 
# Entries are of the form: 
# $ORACLE_SID:$ORACLE_HOME:<N|Y>: 
# 
# The first and second fields are the system identifier and home 
# directory of the database respectively. The third filed indicates 
# to the dbstart utility that the database should , "Y", or should not, 
# "N", be brought up at system boot time. 
# 
# Multiple entries with the same $ORACLE_SID are not allowed. 
# 
powerdes:/hom/oracle/app/oracle/product/11.2.0/dbhome_1:Y 
[root@hch_test_121_90 ~]# 

配置完后,前面的步驟重新來(lái)一遍,到此就會(huì)有下面的出現(xiàn)的database選擇項(xiàng)讓我們選擇,如116.png、117.png、118.png所示:



接下來(lái),選擇升級(jí)時(shí)區(qū)以及備份數(shù)據(jù)庫(kù),如119.png所示:

選擇升級(jí)過(guò)程中不移動(dòng)數(shù)據(jù)文件,如圖120.png


選擇默認(rèn)的閃回恢復(fù)區(qū)以及恢復(fù)區(qū)大小,也可以自己手動(dòng)調(diào)整,如121.png


 接下來(lái)默認(rèn)下一步,準(zhǔn)備企業(yè)管理器,當(dāng)然也可以選擇不需要的,直接忽略掉,如下圖122.png

 接下來(lái),點(diǎn)擊“Finish”按鈕(這個(gè)時(shí)間會(huì)比較長(zhǎng),至少1個(gè)小時(shí)吧,我這里用了1.5個(gè)小時(shí),可能在ssd上時(shí)間比較短),如圖123.png、124.png、125.png所示




OK,等待進(jìn)度條變成100%,然后基本的升級(jí)就好了,就完成了,后續(xù)記得修改.bash_profile里面的ORACLE_HOME目錄為新的11.2.0.4目錄即可。

以上所述是小編給大家介紹的ORACLE 11g從 11.2.0.1升級(jí)到11.2.0.4 詳細(xì)實(shí)戰(zhàn)教程,希望對(duì)大家有所幫助,如果大家有任何疑問(wèn)請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持

相關(guān)文章

最新評(píng)論

沈阳市| 汽车| 郴州市| 茌平县| 柘荣县| 神木县| 沁源县| 维西| 仁寿县| 泰安市| 左权县| 鲁甸县| 夏邑县| 安义县| 疏附县| 大余县| 长葛市| 乌兰察布市| 吉木萨尔县| 崇阳县| 梅河口市| 寿光市| 江油市| 长子县| 河曲县| 潜江市| 广东省| 醴陵市| 巴里| 加查县| 寿宁县| 桑日县| 泰和县| 南昌市| 芜湖县| 延寿县| 交城县| 军事| 龙泉市| 邯郸市| 万年县|