Oracle11gdatabase单机安装文档.doc

,Oracle 11g 数据库单机安装文档1.配置Linux Kernel在sysctl.conf文件添加一下内容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 = 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.ipv4.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 = 4294967296kernel.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_cache_pressure = 200vm.min_free_kbytes = 409600fs.aio-max-nr = 31457282.为oracle用户配置Resource Limit 参数在/etc/security/limits.conf 文件末尾添加如下内容oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 655363.检查防火墙、SElinux配置 rootORACLEDB # iptables -LChain INPUT (policy ACCEPT)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.创建oracle用户及其用户组rootORACLEDB # groupadd oinstallrootORACLEDB # 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.创建oracle software安装目录及赋予相应权限rootORACLEDB # mkdir -p /u01/app/oracle/product/11.2.0/db_1rootORACLEDB # chown -R oracle:oinstall /u01/approotORACLEDB # rootORACLEDB # chmod -R 775 /u01/app6.安装相应软件包yum install compat-libcap1yum install compat-libstdc+-33yum install libstdc+-develyum install gccyum install gcc-c+yum install kshyum install glibc-develyum install libaio-devel7.配置用户环境变量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/11.2.0/db_1ORACLE_SID=bjbdPATH=$PATH:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATHoracleORACLEDB $ oracleORACLEDB $ . .bash_profile8.通过xmanager连接oracle用户安装，步骤如下：使用root用户执行此处两个脚本：rootORACLEDB # /u01/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventory.Adding read,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 environment 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.Entries 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.配置监听服务检查监听服务oracleORACLEDB $ lsnrctl statusLSNRCTL 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/alert/log.xmlListening Endpoints Summary. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLEDB)(PORT=1521) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)The listener supports no servicesThe command completed successfully10.使用DBCA建库