Oracle11gdatabase单机安装文档.doc

《Oracle11gdatabase单机安装文档.doc》由会员分享，可在线阅读，更多相关《Oracle11gdatabase单机安装文档.doc（32页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、,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_defaul

2、t = 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.i

3、pv4.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 = 4294967296kern

4、el.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 参数在/etc/security/limits.conf 文件末尾添加如下内容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.创建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.创建oracle software安装目录及赋予相应权限rootORAC

8、LEDB # 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

9、 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/

10、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 r

11、ead,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 envi

12、ronment 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.En

13、tries 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 statusLSNR

14、CTL 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

15、 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建库