Centos6.5静默安装oracle11g

软件目录

# pwd
/usr/local/src/oracle11g
#tar -zxvf database.tar.gz


安装目录
/opt/oracle

1.系统设置

内核参数设置
#vim /etc/sysctl.conf
#ORACLE SETTING
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 8388608
kernel.shmmax = 17179869184
kernel.shmmax = 1073741824
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
#sysctl -p

#vim /etc/security/limits.conf
#ORACLE SETTING
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
done

#sysctl -p 

验证设置

#echo "session    required     pam_limits.so" >> /etc/pam.d/login


环境变量设置
#vim /etc/profile
#ORACLE SETTING
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
# source /etc/profile



#vim /etc/hosts
127.0.0.1 oracle


2.安装
检查安装oracle所需软件包,有缺少的yum安装
# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat |grep not --color


创建用户租
#/usr/sbin/groupadd oinstall
#/usr/sbin/groupadd dba
#/usr/sbin/useradd -g oinstall -G dba -m oracle


#passwd oracle << EOF
oracle
oracle
EOF


创建目录
#mkdir -p /opt/oracle
#mkdir -p /opt/oraInventory
#mkdir -p /opt/oracle/product/11.2.0/dbome_1
#chown -R oracle.oinstall /opt/oracle
#chown -R oracle.oinstall /opt/oraInventory


解压
# cd /usr/local/src/oracle11g/
# tar -zxf database.tar.gz 

设置oracle用户环境变量
#su - oracle 
$vim ~/.bash_profile
PATH=$PATH:$HOME/bin
ORACLE_BASE=/opt/oracle;
export ORACLE_BASE
ORACLE_SID=orcl;
export ORACLE_SID;
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

$source ~/.bash_profile

$export LC_ALL=en_US

$cd /usr/local/src/oracle11g/database
$cp response/db_install.rsp db_install.rsp
$vim db_install.rsp
修改以下参数
oracle.install.option=INSTALL_DB_SWONLY
INVENTORY_LOCATION=/opt/oraInventory
UNIX_GROUP_NAME=oinstall
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/opt/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.memoryOption=false
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true



执行安装脚本
$./runInstaller -silent -waitforcompletion -nowait -ignorePrereq -force -responseFile /usr/local/src/oracle11g/database/db_install.rsp
#sh /opt/oraInventory/orainstRoot.sh
#sh /opt/oracle/product/11.2.0/dbhome_1/root.sh



创建监听
$ cp response/netca.rsp netca.rsp
$ netca /silent /responseFile /usr/local/src/oracle11g/database/netca.rsp


创建实例

$ dbca -silent -createDatabase -templateName /opt/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Data_Warehouse.dbc -gdbname orcl -sid orcl -sysPassword "orclpwd" -systemPassword "orclpwd" -CHARACTERSET "AL32UTF8"

PS：

oracle 启动

# su - oracle

启动监听

$ lsnrctl start

启动实例

#su - oracle

$export ORACLE_SID=orcl

$ sqlplus /nolog

SQL> conn /as sysdba;
已连接。
SQL> startup

创建表空间
create temporary tablespace admin_temp tempfile '/opt/oracle/oradata/orcl/admin_temp.dbf'  size 50m   autoextend on   next 50 maxsize 20480m extent management local;
create tablespace ADMIN_SPACE logging  datafile '/opt/oracle/oradata/orcl/admin_data.dbf'  size 50m   autoextend on   next 50m maxsize 20480m  extent management local; 
创建用户
create user admin identified by admin default tablespace ADMIN_SPACE temporary tablespace admin_temp;




删除用户和表空间
SQL> drop user admin cascade;
SQL> drop tablespace admin_temp including contents and datafiles;
SQL> drop tablespace IG_SPACE including contents and datafiles;