linux 装Oracle DB 11.r2 前期工作

linux 装Oracle DB 11.r2 前期工作

---

安装系统附带安装

1. Base System
   
   • Base
   • Compatibility libraries
   • Legacy UNIX compatibility
2. Servers
   
   • Ftp server
   • System administration tools 的 ocfs2-tools and oracleasm-support
3. Desktops
   
   • Desktops 的 tigervnc-server(远程桌面)
4. Applications
   
   • Internet Browser
5. Development
   
   • Additional Development
   • Development tools

ip/Hostname 配置

• vi /etc/sysconfig/network-scripts/ifcfg-eth0

IPADDR=192.168.1.66NETMASK=255.255.255.0ONBOOT=yesUSERCTL=noBOOTPROTO=none

• vi /etc/sysconfig/network

HOSTNAME=valen

用户分组

groupadd -g 500 oinstall;groupadd -g 501 dba;useradd -g oinstall -G dba -u 500 oracle；echo “oracle” | passwd --stdin oracle；

文件及权限

mkdir -p /u01/app/oraInventorymkdir -p /u01/app/oraclechown -R oracle:oinstall /u01/app/oraInventorychmod -R 775 /u01/app/oraInventorychown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01/app/oracle

这里写代码片

安装资源限制

• vi /etc/security/limits.conf

oracle      soft    nproc   2047oracle      hard    nproc   16384oracle      soft    nofile  1024oracle      hard    nofile  65536

内核参数

• vi /etc/sysctl.conf

fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586

环境变量

• vi ~/.bash_profile

umask 022export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=orclexport TERM=xtermexport ORA_NLS33=/oracle/db/product/11.2.0/db_1/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/libexport PATH=$ORACLE_HOME/bin:/usr/bin:/etc/:/usr/sbin:/usr/ucb:/sbin:$ORACLE_HOME/OPach:/bin:/usr/css/bin:$PATHexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

磁盘

fdisk /dev/sdboracleasm configure -i [oracle oinstall y y done]

• vi /etc/selinux/config

disabled

• 重启

/etc/init.d/oracleasm createdisk DATA01 /dev/sdb1...oracleasm listdisks

---

注：

1. linux版本采用 OEL6.5
2. Oracle Database 11.r2
3. 单实例数据库前期安装工作