1、Oracle 11g 數(shù)據(jù)庫單機(jī)安裝文檔1.配置Linux Kernel在sysctl.conf文件添加一下內(nèi)容kernel.shmmax = 68719476736kernel.shmall = 4294967296kernel.shmmni = 4096kernel.sem = 250 32000 100 142fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 1048576net.core.rmem_max = 4194304net.core.wmem_default

2、 = 262144net.core.wmem_max = 2097152vm.swappiness=40vm.vfs_cache_pressure=200vm.min_free_kbytes=409600fs.aio-max-nr=3145728rootORACLEDB data# sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ip

3、v4.tcp_syncookies = 1error: net.bridge.bridge-nf-call-ip6tables is an unknown keyerror: net.bridge.bridge-nf-call-iptables is an unknown keyerror: net.bridge.bridge-nf-call-arptables is an unknown keykernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 68719476736kernel.shmall = 4294967296kerne

4、l.shmmax = 68719476736kernel.shmall = 4294967296kernel.shmmni = 4096kernel.sem = 250 32000 100 142fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 1048576net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 2097152vm.swappiness = 40vm.vfs_

5、cache_pressure = 200vm.min_free_kbytes = 409600fs.aio-max-nr = 31457282.為oracle用戶配置Resource Limit 參數(shù)在/etc/security/limits.conf 文件末尾添加如下內(nèi)容oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655363.檢查防火墻、SElinux配置 rootORACLEDB # iptables -LChain INPUT (policy ACCEPT)

6、target prot opt source destination Chain FORWARD (policy ACCEPT)target prot opt source destination Chain OUTPUT (policy ACCEPT)target prot opt source destination rootORACLEDB #rootORACLEDB # /usr/sbin/sestatus -vSELinux status: disabled4.創(chuàng)建oracle用戶及其用戶組rootORACLEDB # groupadd oinstallrootORACLEDB #

7、groupadd dbarootORACLEDB # groupadd operrootORACLEDB # rootORACLEDB # useradd -g oinstall -G dba,oper oraclerootORACLEDB # passwd oracle Changing password for user oracle.New password: Retype new password: passwd: all authentication tokens updated successfully.5.創(chuàng)建oracle software安裝目錄及賦予相應(yīng)權(quán)限r(nóng)ootORACL

8、EDB # mkdir -p /u01/app/oracle/product/11.2.0/db_1rootORACLEDB # chown -R oracle:oinstall /u01/approotORACLEDB # rootORACLEDB # chmod -R 775 /u01/app6.安裝相應(yīng)軟件包yum install compat-libcap1yum install compat-libstdc+-33yum install libstdc+-develyum install gccyum install gcc-c+yum install kshyum install

9、glibc-develyum install libaio-devel7.配置用戶環(huán)境變量oracleORACLEDB $ vim .bash_profile # .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/1

10、1.2.0/db_1ORACLE_SID=bjbdPATH=$PATH:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATHoracleORACLEDB $ oracleORACLEDB $ . .bash_profile8.通過xmanager連接oracle用戶安裝，步驟如下：使用root用戶執(zhí)行此處兩個腳本：rootORACLEDB # /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding re

11、ad,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.rootORACLEDB # /u01/app/oracle/product/11.2.0/db_1/root.shPerforming root user operation for Oracle 11g The following envir

12、onment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1Enter the full pathname of the local bin directory: /usr/local/bin: Copying dbhome to /usr/local/bin . Copying oraenv to /usr/local/bin . Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Ent

13、ries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.9.配置監(jiān)聽服務(wù)檢查監(jiān)聽服務(wù)oracleORACLEDB $ lsnrctl statusLSNRC

14、TL for Linux: Version 11.2.0.4.0 - Production on 15-DEC-2015 13:15:25Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLEDB)(PORT=1521)STATUS of the LISTENER-Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date 15-DEC-2015 13:14:35Uptime 0 days 0 hr. 0 min. 51 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/ORACLEDB/listener/a