Oracle11g安裝手冊

1、用戶名密碼root12345678hostname rzip 35RedHat6.2 LINUX設(shè)置清空防火墻iptables F或chkconfig iptables offservice iptables stop查看命令service iptables statuschkconfig -listchkconfig level 2345 iptables off關(guān)閉selinuxsetenforce 0vim /etc/sysconfig/selinux將SELINUX的值由默認(rèn)的enforcing修改為disabled安裝ORACLE所需的軟件包cd /home/ap

2、p/Packages/rpm -ivh binutils-.2-5.28.el6.x86_64.rpmrpm -ivh compat-libstdc+-33-3.2.3-69.el6.x86_64.rpmrpm -ivh elfutils-libelf-0.152-1.el6.x86_64.rpmrpm -ivh elfutils-libelf-devel-0.152-1.el6.x86_64.rpmrpm -ivh gcc-4.4.6-3.el6.x86_64.rpmrpm -ivh gcc-c+-4.4.6-3.el6.x86_64.rpmrpm -ivh glibc-2

3、.12-1.47.el6.x86_64.rpmrpm -ivh glibc-common-2.12-1.47.el6.x86_64.rpmrpm -ivh glibc-devel-2.12-1.47.el6.x86_64.rpmrpm -ivh glibc-headers-2.12-1.47.el6.x86_64.rpmrpm -ivh ksh-20100621-12.el6.x86_64.rpmrpm -ivh libaio-0.3.107-10.el6.x86_64.rpmrpm -ivh libaio-devel-0.3.107-10.el6.x86_64.rpmrpm -ivh lib

4、gcc-4.4.6-3.el6.x86_64.rpmrpm -ivh libstdc+-4.4.6-3.el6.x86_64.rpmrpm -ivh libstdc+-devel-4.4.6-3.el6.x86_64.rpmrpm -ivh make-3.81-19.el6.x86_64.rpmrpm -ivh numactl-devel-2.0.3-9.el6.x86_64.rpmrpm -ivh sysstat-9.0.4-18.el6.x86_64.rpmrpm -ivh unixODBC-2.2.14-11.el6.x86_64.rpmrpm -ivh unixODBC-devel-2

5、.2.14-11.el6.x86_64.rpmrpm -ivh xterm-253-1.el6.x86_64.rpm修改參數(shù)1、 修改用戶的SHELL的限制，修改/etc/security/limits.conf文件vi /etc/security/limits.conf將下列內(nèi)容加入oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655362、 修改linux內(nèi)核，vi /etc/sysctl.conf注釋掉kernel.shmmax和kernel.shmall兩行，

6、并添加以下行數(shù)fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_

7、max = 1048576/etc/sysctl.conf 更改立即生效，執(zhí)行以下命令。 輸入：sysctl -p3、 編輯 /etc/profile vi /etc/profile將下列內(nèi)容加入該文件if $USER = "oracle" ; thenif $SHELL = "/bin/ksh" ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi4、 修改/etc/pam.d/login 文件vi /etc/pam.d/login下列內(nèi)容加入該文件。session r

8、equired /lib64/security/pam_limits.sosession required pam_limits.so添加ORACLE用戶創(chuàng)建用戶組oinstallgroupadd oinstall創(chuàng)建用戶組dbagroupadd dba創(chuàng)建屬于oinstall用戶組的用戶oracle,并添加附加組dbauseradd g oinstall g dba oraclepasswd oracle輸入一次密碼12345678重新輸入一次密碼12345678創(chuàng)建成功創(chuàng)建數(shù)據(jù)庫軟件目錄和數(shù)據(jù)文件存放目錄，目錄的位置，注意磁盤空間即可，這里我把其放到oracle用戶下su oraclemk

9、dir /home/oracle/appmkdir /home/oracle/app/oraclevim .bash_profile 添加以下內(nèi)容TMP=/tmp;TMPDIR=$TMPexport TMPexport TMPDIRexport ORACLE_SID=orclexport ORACLE_BASE=/home/oracle/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export PATH=$ORACLE_HOME/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/l

10、ib:/usr/lib;CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export LD_LIBRARY_PATHexport CLASSPATH. .bash_profile運行生效,檢測是否生效echo $ORACLE_HOME顯示/home/oracle/app/oracle/product/11.2.0/db_1echo $ORACLE_BASE顯示/home/oracle/app/oracleecho $ORACLE_SID顯示orcl顯示正確表示成功修改ORACLE安裝包文件執(zhí)行權(quán)限chmo

11、d 777 database R#中文語言亂碼，輸入export LANG=en_US圖形界面cd database./runInstaller報錯表示主機名與IP不匹配su -rootvim /etc/sysconfig/network修改主機名為db.localdomain重啟生效vim /etc/hosts 添加一條IP與主機名對應(yīng)的記錄例如68 oracle168 localhost localhost.localdomain實際35 db.localdomain db可以不選擇發(fā)送郵件選擇只裝數(shù)據(jù)庫軟件，之后再建立數(shù)據(jù)

12、庫Single模式語言ENGLISH企業(yè)版，select optionselect allok這里的ORACLE BASE 要對應(yīng)之前定義的為止，SOFTWARE LOCATION就是ORACLE_HOMEINVENTORY DIRECTORY可以隨便選擇，不過oracle用戶必須對這個目錄有完全控制權(quán)限下一步軟件包監(jiān)測，顯示有以下包沒裝，不過其實我們之前用yum安裝的包的版本比這些包更高，我們可以直接忽略，點ignore all檢查安裝命令 rpm -all -query -queryformat "%NAME-%VERSION-%RELEASE-(%ARCH)n&quo

13、t; | grep glibcSave response file之后，下一步等待安裝完畢系統(tǒng) 默認(rèn)是把所有賬戶都鎖定不可用了(除sys和system賬戶可用外)，建議點右邊的口令管理，將常用的scott賬戶解鎖并輸入密碼。 如圖：解鎖scott賬戶， 去掉前面的綠色小勾，輸入密碼。同樣可以輸入平常用的短小的密碼，不必非得按oracle建議的8位以上大小寫加數(shù)字，麻煩。呵呵。如圖：先以root身份運行兩個腳本su rootcd /home/oracle/app/oraInventory./orainstRoot.shcd /home/oracle/app/oracle/product

14、/11.2.0/db_1./root.sh至此，數(shù)據(jù)庫軟件安裝完畢使用DBCA建立數(shù)據(jù)庫接下來，建立數(shù)據(jù)庫在oracle用戶模式下輸入dbca不配置EM，待會手動配置這里我輸入的密碼過于簡單，系統(tǒng)報警，不管他，點擊YES數(shù)據(jù)庫建立完畢sys 12345678system 12345678scott 12345678開啟數(shù)據(jù)庫使用oracle用戶開啟數(shù)據(jù)庫 dbstart,報錯 修改dbstart配置文件vim $ORACLE_HOME/bin/dbstart 把上圖中的$1修改為$ORACLE_HOME即可Dbshut文件也需要在同樣位置修改重新dbstart允許實例自啟動vim /etc/o

15、rataborcl:/home/oracle/app/oracle/product/11.2.0/db_1:N改為orcl:/home/oracle/app/oracle/product/11.2.0/db_1:Y設(shè)置開機自啟動切換到root用戶：vim /etc/rc.d/rc.local添加以下內(nèi)容su oracle -lc "/home/oracle/app/oracle/product/11.2.0/db_1/bin/lsnrctl start"su oracle -lc "/home/oracle/app/oracle/product/11.2.0/db

16、_1/bin/dbstart"su oracle -lc "/home/oracle/app/oracle/oracle/product/11.2.0/db_1/bin/emctl start dbconsole"LISTENER CONFIGURATION使用oracle用戶netcaLOCAL NET SERVICE NAME CONFIGURATIONhostnamedb.localdomain測試連接點擊Change login這里需要修改system的密碼在oracle用戶模式下輸入sqlplus /nologConn / as sysdbaALTER

17、USER system IDENTIFIED by 123456;(修改system密碼為123456)顯示如下，表示測試成功啟動EMemctl start dbconsole 報錯ORACLE_UNQNAME沒定義 在ORACLE用戶模式輸入：export ORACLE_UNQNAME=orclexport重新emctl start dbconsole還是報錯重新配置emctlemca -config dbcontrol dboracledb bin$ emca -config dbcontrol dbSTARTED EMCA at Aug 25, 2015 7:15:17 AMEM Con

18、figuration Assistant, Version .2 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.Enter the following information:Database SID: orclListener port number: 1521Listener ORACLE_HOME /home/oracle/app/oracle/product/11.2.0/db_1 : Password for SYS user: 123456Password for DBSNMP use

19、r: 123456Password for SYSMAN user: 123456Email address for notifications (optional): dbOutgoing Mail (SMTP) server for notifications (optional): -You have specified the following settingsDatabase ORACLE_HOME . /home/oracle/app/oracle/product/11.2.0/db_1Local hostname . db.localdomainListener ORACLE_

20、HOME . /home/oracle/app/oracle/product/11.2.0/db_1Listener port number . 1521Database SID . orclEmail address for notifications . dbOutgoing Mail (SMTP) server for notifications . -Do you wish to continue? yes(Y)/no(N): yAug 25, 2015 7:16:24 AM oracle.sysman.emcp.EMConfig performINFO: This operation

21、 is being logged at /home/oracle/app/oracle/cfgtoollogs/emca/orcl/emca_2015_08_25_07_15_17.log.Aug 25, 2015 7:16:33 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepositoryINFO: Uploading configuration data to EM repository (this may take a while) .Aug 25, 2015 7:17:31 AM oracle.sysman.emcp.

22、EMReposConfig invokeINFO: Uploaded configuration data successfullyAug 25, 2015 7:17:34 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLibINFO: Software library configured successfully.Aug 25, 2015 7:17:34 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibraryINFO: Deploying Provisi

23、oning archives .Aug 25, 2015 7:18:18 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibraryINFO: Provisioning archives deployed successfully.Aug 25, 2015 7:18:18 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) .Aug 25, 2015 7:19:

24、15 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Aug 25, 2015 7:19:15 AM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) .Aug 25, 2015 7:20:39 AM oracle.sysman.emcp.EMDBPostConfig performConfi

25、gurationINFO: Database Control started successfullyAug 25, 2015 7:20:39 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https:/db.localdomain:1158/em <<<<<<<<<<<Aug 25, 2015 7:20:48 AM oracle.sysman.emcp.EMDBPostConfig invokeWARNING: * WARNING *Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: