oracle11g单实例安装+redhat6.3规划(二)
hkconfig iptables off
[root@JSCS78DB home]# chkconfig --list | grep iptables
iptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off
[root@JSCS78DB home]# vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=enforcing
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
~
三.创建oracle用户组
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
useradd -u 501 -g oinstall -G dba,oper oracle
passwd oracle
mkdir -p /home/oracle/ora11g/db_base
mkdir -p /home/oracle/ora11g/db_base/product/11.2.0/db_1
chown -R oracle:oinstall /home/oracle
chmod -R 775 /home/oracle
chmod -R 775 /oracle/app/oracle/
chmod -R 775 /oracle/app/oracle/product/11.2.0/db_1/
chmod -R 775 /oracle/app/oraInventory
四.编辑配置文件
vi .bash_profile
export PS1="$LOGNAME@`hostname`:\$PWD>"
ORACLE_SID=xyy; export ORACLE_SID
# ORACLE_BASE
ORACLE_BASE=/home/oracle/ora11g/db_base; export ORACLE_BASE
# ORACLE_HOME
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
# JAVA_HOME
JAVA_HOME=$ORACLE_HOME/jdk; export JAVA_HOME
# ORACLE_PATH
ORACLE_PATH=/home/oracle/ora11g/common/oracle/sql; export ORACLE_PATH
# ORACLE_TERM
# NLS_DATE_FORMAT
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
#NLS_LANG
NLS_LANG=american_america.zhs16gbk;export NLS_LANG
# TNS_ADMIN
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
# ORA_NLS11
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
# PATH
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:/goldengate
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/oracle/ora11g/common/oracle/bin
export PATH
# LD_LIBRARY_PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/goldengate
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
# CLASSPATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
# THREADS_FLAG
THREADS_FLAG=native; export THREADS_FLAG
# TEMP, TMP, and TMPDIR
export TEMP=/tmp
export TMPDIR=/tmp
# UMASK
umask 022
vi /etc/hosts
[root@JSCS78DB oracle]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.10 JSCS78DB
vi /etc/sysctl.conf
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.cor