一、安裝Oracle 11G前環(huán)境搭建
本次實(shí)驗(yàn)是基于Linux（CentOS6.7_64）下搭建oracle 11g環(huán)境，這里選擇CentOS安裝oracle并不是最佳選擇，可以根據(jù)需要選擇不同的Linux發(fā)行版，如Oracle Linux、SuSE Linux、Red Hat、IBM AIX等。
VM或物理機(jī)的配置要求：
在實(shí)驗(yàn)環(huán)境安裝oracle11g最少需要2G內(nèi)存、2個(gè)cpu、2G交換分區(qū)、磁盤空間不低于20G。
生產(chǎn)環(huán)境中，要保證oracle的性能，建議最低配置為8G內(nèi)存、4個(gè)cpu、8G交換分區(qū)，如果生產(chǎn)環(huán)境比較繁忙，則需要更高的配置。
二、安裝Oracle 11G前準(zhǔn)備工作
上傳oracle11g安裝包，解壓
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
配置/etc/hosts文件，添加ip與主機(jī)名的解析
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #eth0 10.11.12.88 hm創(chuàng)建oracle相關(guān)用戶和組
[root@hm ~]# groupadd dba [root@hm ~]# groupadd oinstall [root@hm ~]# useradd -g oinstall -G dba -m oracle [root@hm ~]# id oracle uid=500(oracle) gid=501(oinstall) groups=501(oinstall),500(dba)創(chuàng)建oracle軟件安裝目錄
[root@hm ~]# mkdir /u01/app/oracle -p [root@hm ~]# chown -R oracle. /u01/ [root@hm ~]# chmod 775 -R /u01/ [root@hm ~]# ls -ld /u01/ drwxr-xr-x. 3 oracle oinstall 4096 Oct 14 22:58 /u01/oracle用戶環(huán)境變量設(shè)置，su進(jìn)入oracle用戶下，修改~/.bash_profile文件，添加以下內(nèi)容
export TMP=/tmp export TMPDIR=$TMP export ORACLE_TERM=xterm export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/db export ORACLE_SID=orcl export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/lib64 if [ $USER = "oracle" ];then if [ $SHELL = "/bin/ksh" ];then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi修改內(nèi)核參數(shù)，打開/etc/sysctl.conf文件，添加以下參數(shù)，并修改/etc/security/limits.conf文件
kernel.shmmax = 68719476736 kernel.shmall = 4294967296 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 [root@hm ~]# sysctl -p net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmmax = 68719476736 kernel.shmall = 4294967296 kernel.shmmax = 68719476736 kernel.shmall = 4294967296 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 在/etc/security/limits.conf文件末尾添加如下內(nèi)容 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 并同時(shí)修改/etc/pam.d/login文件，添加以下內(nèi)容 session required pam_limits.so安裝oracle依賴的軟件包
[root@hm ~]# yum install gcc gcc-c++ libaio glibc compat-libstdc++-33 elfutils-libelf-devel libaio-devel libgcc libstdc++ libstdc++-devel unixODBC unixODBC-devel glibc-common ksh make sysstat pdksh [root@hm ~]# yum install glibc-2.12-1.192.el6.i686 檢查是否安裝 [root@hm ~]# for i in gcc gcc-c++ libaio glibc compat-libstdc++-33 elfutils-libelf-devel libaio-devel libgcc libstdc++ libstdc++-devel unixODBC unixODBC-devel glibc-common ksh make sysstat pdksh;do rpm -q $i;done |
三、安裝oracle11g軟件
解壓oracle11g軟件包
[root@hm oracle]# unzip linux.x64_11gR2_database_1of2.zip
[root@hm oracle]# unzip linux.x64_11gR2_database_2of2.zip
[root@hm oracle]# chown -R oracle. database/ [root@hm oracle]# ls -l database/ total 36 drwxr-xr-x. 12 oracle oinstall 4096 Aug 17 2009 doc drwxr-xr-x. 4 oracle oinstall 4096 Aug 15 2009 install drwxrwxr-x. 2 oracle oinstall 4096 Aug 15 2009 response drwxr-xr-x. 2 oracle oinstall 4096 Aug 15 2009 rpm -rwxr-xr-x. 1 oracle oinstall 3226 Aug 15 2009 runInstaller drwxrwxr-x. 2 oracle oinstall 4096 Aug 15 2009 sshsetup drwxr-xr-x. 14 oracle oinstall 4096 Aug 15 2009 stage -rw-r--r--. 1 oracle oinstall 5402 Aug 18 2009 welcome.html以orcle用戶登錄圖形界面安裝oracle，也可以使用vnc遠(yuǎn)程安裝。這里直接用Xshell遠(yuǎn)程調(diào)用linux圖形界面進(jìn)行安裝
[root@hm ~]# su - oracle [oracle@hm ~]$ export DISPLAY=10.11.12.1:0.0 [oracle@hm ~]$ xhost +進(jìn)入database目錄，執(zhí)行runInstalle
[oracle@hm ~]$ cd /usr/local/src/oracle/database/ [oracle@hm database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 21645 MB Passed Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-10-15_12-48-55PM. Please wait ...進(jìn)入圖形界面安裝
啟動監(jiān)聽
[oracle@hm ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-OCT-2016 23:30:07 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /u01/app/oracle/db/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production Log messages written to /u01/app/oracle/diag/tnslsnr/hm/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hm)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 15-OCT-2016 23:30:09 Uptime 0 days 0 hr. 0 min. 1 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/diag/tnslsnr/hm/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hm)(PORT=1521))) The listener supports no services The command completed successfully創(chuàng)建數(shù)據(jù)庫實(shí)例，oracle用戶下使用dbca工具創(chuàng)建
[oracle@hm ~]$ dbca
安裝完成檢查，查看oracle進(jìn)程與監(jiān)聽狀態(tài)
[oracle@hm ~]$ ps -ef | grep ora_ oracle 6636 1 0 23:41 ? 00:00:00 ora_pmon_orcl oracle 6638 1 0 23:41 ? 00:00:04 ora_vktm_orcl oracle 6642 1 0 23:41 ? 00:00:00 ora_gen0_orcl oracle 6644 1 0 23:41 ? 00:00:00 ora_diag_orcl oracle 6646 1 0 23:41 ? 00:00:00 ora_dbrm_orcl oracle 6648 1 0 23:41 ? 00:00:00 ora_psp0_orcl oracle 6650 1 0 23:41 ? 00:00:05 ora_dia0_orcl oracle 6652 1 0 23:41 ? 00:00:00 ora_mman_orcl oracle 6654 1 0 23:41 ? 00:00:00 ora_dbw0_orcl oracle 6656 1 0 23:41 ? 00:00:00 ora_lgwr_orcl oracle 6658 1 0 23:41 ? 00:00:00 ora_ckpt_orcl oracle 6660 1 0 23:41 ? 00:00:00 ora_smon_orcl oracle 6662 1 0 23:41 ? 00:00:00 ora_reco_orcl oracle 6664 1 0 23:41 ? 00:00:02 ora_mmon_orcl oracle 6666 1 0 23:41 ? 00:00:02 ora_mmnl_orcl oracle 6668 1 0 23:41 ? 00:00:00 ora_d000_orcl oracle 6670 1 0 23:41 ? 00:00:00 ora_s000_orcl oracle 6719 1 0 23:41 ? 00:00:00 ora_qmnc_orcl oracle 6739 1 0 23:41 ? 00:00:01 ora_cjq0_orcl oracle 6832 1 0 23:41 ? 00:00:00 ora_q000_orcl oracle 6834 1 0 23:41 ? 00:00:00 ora_q001_orcl oracle 6842 1 0 23:42 ? 00:00:00 ora_smco_orcl oracle 6844 1 0 23:42 ? 00:00:00 ora_w000_orcl oracle 15858 2208 0 23:59 pts/0 00:00:00 grep ora_ [oracle@hm ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-OCT-2016 23:59:58 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 15-OCT-2016 23:30:09 Uptime 0 days 0 hr. 29 min. 50 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/diag/tnslsnr/hm/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hm)(PORT=1521))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully登錄oracle數(shù)據(jù)庫，查看數(shù)據(jù)庫實(shí)例狀態(tài)、實(shí)例名、數(shù)據(jù)庫文件、日志文件
SQL> select status from v$instance; STATUS ------------ OPEN SQL> select name from v$database; NAME --------- ORCL SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl/system01.dbf /u01/app/oracle/oradata/orcl/sysaux01.dbf /u01/app/oracle/oradata/orcl/undotbs01.dbf /u01/app/oracle/oradata/orcl/users01.dbf SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl/redo03.log /u01/app/oracle/oradata/orcl/redo02.log /u01/app/oracle/oradata/orcl/redo01.log查看oracle數(shù)據(jù)庫版本
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production關(guān)閉與啟動
關(guān)閉數(shù)據(jù)庫實(shí)例
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.關(guān)閉監(jiān)聽
[oracle@hm ~]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-OCT-2016 00:16:41 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully [oracle@hm ~]$ ps -ef | grep ora_ oracle 16987 2208 0 00:17 pts/0 00:00:00 grep ora_啟動監(jiān)聽
[oracle@hm ~]$ lsnrctl start啟動實(shí)例
[oracle@hm ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 16 00:19:39 2016 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup; ORACLE instance started. Total System Global Area 780824576 bytes Fixed Size 2217424 bytes Variable Size 599788080 bytes Database Buffers 171966464 bytes Redo Buffers 6852608 bytes Database mounted. Database opened. SQL> select status from v$instance; STATUS ------------ OPEN另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。
重慶分公司
重慶分公司
