Linux下安裝Oracle系統(tǒng)最好是1G內(nèi)存,2G的swap空間,硬盤至少需要4.5G空間。
至少環(huán)境在Linux Server release 5.3以上
如果是Linux Server release 5.1,改裝oracle10.2g吧
一、查看Linux版本
[root@localhost ~]# cat /etc/issueRed Hat Enterprise Linux Server release 5.5 (Tikanga)[root@localhost ~]# cat /etc/RedHat-release Red Hat Enterprise Linux Server release 5.5 (Tikanga)
二、到oracle官方網(wǎng)站下載對(duì)應(yīng)版本的oracle,我下的是oracle for linux X86 http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
三、在linux下創(chuàng)建oracle用戶,以及管理組 3.1 以root用戶登錄linux,執(zhí)行以下命令
[root@localhost ~]#/usr/sbin/groupadd dba[root@localhost ~]#/usr/sbin/groupadd oper[root@localhost ~]#/usr/sbin/groupadd oinstall
小技巧: 查看Linux用戶組命令:
[root@localhost ~]# cat /etc/group
3.2 添加oracle用戶
[root@localhost ~]#useradd oracle[root@localhost ~]#/usr/sbin/usermod -g oinstall -G dba oracle[root@localhost ~]#passwd oracleChanging password for user oracle.New UNIX password: oracleBAD PASSWORD: it is based on a dictionary wordRetype new UNIX password: oraclepasswd: all authentication tokens updated successfully.
3.3 預(yù)先創(chuàng)建安裝目錄[root@localhost ~]#mkdir -p /opt/oracle/product[root@localhost ~]#mkdir -p /opt/oracle/product/OraHome[root@localhost ~]#mkdir -p /opt/oraInventory[root@localhost ~]#mkdir -p /opt/oracle/oradata[root@localhost ~]#mkdir -p /var/opt/oracle3.4 設(shè)置目錄的所有者所屬組和權(quán)限
[root@localhost ~]#chown -R oracle.oinstall /opt/oracle[root@localhost ~]#chown -R oracle.oinstall /opt/oracle/oradata[root@localhost ~]#chown -R oracle.oinstall /opt/oracle/product/OraHome[root@localhost ~]#chown -R oracle.dba /opt/oraInventory[root@localhost ~]#chown oracle.dba /var/opt/oracle[root@localhost ~]#chmod -R 775 /opt/oracle[root@localhost ~]#chmod -R 755 /var/opt/oracle
3.5 設(shè)置用戶oracle的環(huán)境變量
#su - oracle[oracle@localhost ~]$ vi /home/oracle/.bash_profile
在文件底部添加
export ORACLE_BASE=/opt/oracleexport ORACLE_HOME=$ORACLE_BASE/product/OraHomeexport ORACLE_SID=orclexport ORACLE_OWNER=oracleexport ORACLE_TERM=vt100export PATH=$PATH:$ORACLE_HOME/bin:$HOME/binexport PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/libexport LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibCLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport CLASSPATHPATH=$PATH:/usr/sbin; export PATHPATH=$PATH:/usr/bin; export PATH
--執(zhí)行以下命令讓配置馬上生效或以oracle用戶登錄使設(shè)置生效
[oracle@localhost ~]$ source $HOME/.bash_profile
四、準(zhǔn)備安裝環(huán)境4.1 安裝環(huán)境檢查Oracle依賴軟件包齊全(版本等于或大于以下版本號(hào))binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24 (32 bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5 (32 bit)glibc-headers-2.5pdksh-5.2.14-36.el5libaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit) libgcc-4.1.2libgcc-4.1.2 (32 bit) libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-2.2.11 (32 bit)unixODBC-devel-2.2.11unixODBC-devel-2.2.11 (32 bit)
[root@localhost ~]# rpm -qa | grep -E "binutils|compat-libstdc++|elfutils-libelf|gcc|glibc|libaio|libgcc|libstdc++|make|sysstat|unixODBC|pdksh"
4.2 上傳安裝包上傳linux_11gR2_database_1of2.zip、linux_11gR2_database_2of2.zip到/home/oracle/目錄4.3 解壓安裝包
[oracle@localhost oracle]$ cd /home/oracle/[oracle@localhost ~]$ lslinux_11gR2_database_1of2.zip linux_11gR2_database_2of2.zip[oracle@localhost oracle]$ unzip linux_11gR2_database_1of2.zip[oracle@localhost oracle]$ unzip linux_11gR2_database_2of2.zip
如果上傳的不是/home/oracle/目,要保證上傳的目錄oracle用戶有足夠的權(quán)限,假如上傳到/opt/soft目錄要切換回root用戶進(jìn)行解壓:
[oracle@localhost oracle]$ su - root[root@localhost ~]# cd /opt/soft/
解壓壓縮包:
[root@localhost soft]# unzip linux_11gR2_database_1of2.zip[root@localhost soft]# unzip linux_11gR2_database_2of2.zip
給解壓后的目錄賦權(quán)限給oracle用戶
#chown -R oracle database#chgrp -R oinstall database
五、正式安裝5.1 重啟服務(wù)器,將配置信息生效5.2 進(jìn)入服務(wù)器界面,以O(shè)racle用戶登錄,執(zhí)行以下命令
[root@localhost ~]#cd /home/oracle/database[root@localhost ~]#./runInstaller
然后進(jìn)入圖形化安裝過(guò)程。注意我們先安裝oracle軟件,安裝完軟件之后再配置監(jiān)聽(tīng)程序和數(shù)據(jù)庫(kù)。下面是安裝過(guò)程的步驟和選項(xiàng):
1.執(zhí)行./runInstaller后,進(jìn)入圖1
2.去掉復(fù)選框選擇,點(diǎn)擊next,會(huì)彈出對(duì)話框如圖2
3.點(diǎn)擊yes,進(jìn)入圖3
4.選擇第2項(xiàng) install database soft onliy,點(diǎn)擊next,進(jìn)入圖4
5.選擇第1項(xiàng) single instance database installation,點(diǎn)擊next,進(jìn)入圖5
6.選擇語(yǔ)言 simplifed Chinese,點(diǎn)擊next,進(jìn)入圖6
7.圖6是選擇數(shù)據(jù)庫(kù)類型,我們選擇企業(yè)版 Enterprise Edition(3.95G),點(diǎn)擊next
8.圖7是為了配置oracle的安裝目錄,配置值應(yīng)該如圖所示,直接點(diǎn)擊next,進(jìn)入圖8
9.圖8是為了配置oracle的管理組,配置值應(yīng)該如圖所示,直接點(diǎn)擊next,進(jìn)入圖9
10.圖9是為了配置oracle的用戶權(quán)限,配置值應(yīng)該如圖所示,直接點(diǎn)擊next,進(jìn)入圖10
11.進(jìn)入圖10會(huì)自動(dòng)安裝,自動(dòng)進(jìn)入圖11
13.安裝失敗的rpm包,具體安裝那些包,請(qǐng)參考圖11的Failed
上傳compat-libstdc++-33-3.2.3-61.i386.rpm到/qsyang/oracle執(zhí)行安裝:[root@localhost home]# cd /qsyang/oracle/[root@localhost oracle]# rpm -ivh compat-libstdc++-33-3.2.3-61.i386.rpm上傳elfutils-libelf-devel-0.137-3.el5.i386.rpmelfutils-libelf-devel-static-0.137-3.el5.i386.rpm到/qsyang/oracle執(zhí)行安裝(由于倆個(gè)包相互依賴,所以一起安裝):[root@localhost soft]# rpm -ivf elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpmwarning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186Preparing packages for installation...elfutils-libelf-devel-static-0.137-3.el5elfutils-libelf-devel-0.137-3.el5上傳libaio-devel-0.3.106-5.i386.rpm到/qsyang/oracle執(zhí)行安裝:[root@localhost soft]# rpm -ivh libaio-devel-0.3.106-5.i386.rpmwarning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186Preparing... ########################################### [100%]1:libaio-devel ########################################### [100%]上傳sysstat-7.0.2-3.el5.i386.rpmunixODBC-devel-2.2.11-7.1.i386.rpm到/qsyang/oracle執(zhí)行安裝:[root@localhost oracle]# rpm -ivh sysstat-7.0.2-3.el5.i386.rpm warning: sysstat-7.0.2-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8562897Preparing... ########################################### [100%]1:sysstat ########################################### [100%]上傳unixODBC-2.2.11-7.1.i386.rpm到/qsyang/oracle執(zhí)行安裝:[root@localhost oracle]# rpm -ivh unixODBC-2.2.11-7.1.i386.rpm Preparing... ########################################### [100%]1:unixODBC ########################################### [100%][root@localhost oracle]# rpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm Preparing... ########################################### [100%]1:unixODBC-devel ########################################### [100%][root@localhost oracle]#
14.安裝完成后,點(diǎn)級(jí)再次檢查"Check Again",進(jìn)入圖12
15.點(diǎn)擊ignore,點(diǎn)擊Finash開始安裝,進(jìn)入圖13
16.安裝完成后彈出圖14
17.點(diǎn)擊Finish,直接關(guān)閉
六、安裝監(jiān)聽(tīng)器執(zhí)行命令#netca
進(jìn)入圖形化配置,如圖16,
直接默認(rèn)下一步,到最后完成,其中你也可以修改監(jiān)聽(tīng)去的名稱,協(xié)議,端口。
安裝完成后可以使用命令#ps -ef來(lái)查看Listener是否配置成功七.安裝數(shù)據(jù)庫(kù)程序執(zhí)行命令:#dbca
進(jìn)入圖形化配置界面,一直下一步如圖18
進(jìn)入圖19后,
提示輸入全局?jǐn)?shù)據(jù)庫(kù)名稱,我輸入的是yakson
一直下一步進(jìn)入圖21,輸入全局密碼:我輸入的是 orcl12344點(diǎn)擊next彈出圖22,點(diǎn)擊yes下一步,橫排第三個(gè)選項(xiàng)下,選擇字符編碼AL32UTF-8然后一直下一步,直到進(jìn)行安裝數(shù)據(jù)庫(kù),并且完成。到此你Oracle就算初步安裝完成了。
新聞熱點(diǎn)
疑難解答
圖片精選