linux 装Oracle DB 11.r2 前期工作
安装系统附带安装
- Base System
- Base
- Compatibility libraries
- Legacy UNIX compatibility
- Servers
- Ftp server
- System administration tools 的 ocfs2-tools and oracleasm-support
- Desktops
- Desktops 的 tigervnc-server(远程桌面)
- Applications
- Development
- Additional Development
- Development tools
ip/Hostname 配置
- vi /etc/sysconfig/network-scripts/ifcfg-eth0
IPADDR=192.168.1.66
NETMASK=255.255.255.0
ONBOOT=yes
USERCTL=no
BOOTPROTO=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/oraInventory
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oraInventory
chmod -R 775 /u01/app/oraInventory
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle
这里写代码片
安装资源限制
- vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
内核参数
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
环境变量
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export TERM=xterm
export ORA_NLS33=/oracle/db/product/11.2.0/db_1/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib
export PATH=$ORACLE_HOME/bin:/usr/bin:/etc/:/usr/sbin:/usr/ucb:/sbin:$ORACLE_HOME/OPach:/bin:/usr/css/bin:$PATH
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
磁盘
fdisk /dev/sdb
oracleasm configure -i [oracle oinstall y y done]
disabled
/etc/init.d/oracleasm createdisk DATA01 /dev/sdb1
...
oracleasm listdisks
注:
- linux版本采用 OEL6.5
- Oracle Database 11.r2
- 单实例数据库前期安装工作