centos 6.5_x64上静默模式安装oracle 11.2.0.1
1. 检查软件包依赖,Oracle官方要求redhat enterprise linux 6 以上需要安装以下包:
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
执行:
yum -install binutils compat-libcap1 compat-libstdc++-33-* gcc gcc-c++ glibc-* glibc-devel-* ksh libgcc-* libstdc++-* libstdc++-devel-* libaio-* libaio-devel-* make sysstat
2. 配置内核参数、设置资源,创建相关用户、用户组并配置oracle用户环境
cp /etc/sysctl.conf{,.bak}
cat >> /etc/sysctl.conf <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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 = 1048576
EOF
sysctl -p
cp /etc/pam.d/login{,.bak}
cat >> /etc/pam.d/login <<EOF
session required /lib64/security/pam_selinux.so open
EOF
cp /etc/security/limits.conf{,.bak}
cat >> /etc//security/limits.conf <<EOF
oracle soft nofile 131072
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 50000000
oracle hard memlock 50000000
EOF
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 asm
groupadd -g 504 oper
useradd -g oinstall -G dba, asm, oper -u 501 oracle
cat >> /home/oracle/.bash_profile <<EOF
export ORACLE_BASE=/u01/app
export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib:/lib64:/usr/lib64
export PATH=\$ORACLE_HOME/bin:\$PATH
EOF
vim /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
mkdir /u01/app
chown -R oracle.oinstall /u01
passwd oracle
su - oracle
mkdir -p $ORACLE_HOME
tar xvf linux.x64_11gR2_database_1of2.zip
tar xvf linux.x64_11gR2_database_2of2.zip
rm -rf linux.x64_11gR2_database_*
cd database
cp response/install_db.rsp ~/oracle_install_swonly.rsp
cp response/netca.rsp ~/netca.rsp
cp response/dbca.rsp ~/dbca.rsp
vim ~/oracle_install_swonly.rsp
vim ~/netca.rsp
vim ~/dbca.rsp
## 仅安装oracle软件
./runInstaller -silent -noconfig -responseFile /home/oracle/oracle_install_swonly.rsp
查看安装日志,等待安装完成后,执行
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0.1/db_1/root.sh
## 使用静默模式创建监听
netca -silent -responseFile /home/oracle/netca.rsp
监听程序配置完成,尚需要配置TNS服务,在$ORACLE_HOME/network/admin目录下新建tnsnames.ora文件,输入以下内容:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
)
## 使用静默模式建库
dbca -silent -responseFile /home/oracle/dbca.rsp
创建过程,输出如下:
[oracle@node3 ~]$ dbca -silent -responseFile /home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/cfgtoollogs/dbca/orcl/orcl.log" for further details.
# dbca.rsp中createDatabase部分参数
[oracle@node3 ~]$ cat dbca.rsp | grep -v "^#" | grep -v "^$"
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl"
SID = "orcl"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16"
MEMORYPERCENTAGE = "30"
TOTALMEMORY = "800"
## 使用dbca静默方式删除建立的数据库,修改dbca.rsp中的OPERATION_TYPE = "deleteDatabase"
dbca -silent -deleteDatabase -responseFile /home/oracle/dbca.rsp
## 让oracle 实例、监听服务开机自启动
[oracle@node3 ~]$ vim +80 /u01/app/product/11.2.0/db_1/bin/dbstart
ORACLE_HOME_LISTNER=$1
改为
ORACLE_HOME_LISTNER=$ORACLE_HOME
[oracle@node3 ~]$ vim /etc/oratab
orcl:/u01/app/product/11.2.0/db_1:N
改为
orcl:/u01/app/product/11.2.0/db_1:Y
[oracle@node3 ~]$ echo "su - oracle -c \"/u01/app/product/11.2.0/db_1/bin/dbstart\"" >> /etc/rc.local