一、安装相应的依赖包
yum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ \
glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio.i686 libaio-devel \
libaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make sysstat unixODBC unixODBC-devel
二、创建相应的文件目录及用户和组
groupadd oinstall
groupadd dba
useradd -g dba -m oracle
usermod -a -G oinstall oracle
passwd oracle # 配置用户密码
mkdir -p /data/{oracle,inventory,src}
chown -R oracle:oinstall /data/oracle
chown -R oracle:oinstall /data/inventory
chown -R oracle:oinstall /data/src
三、修改相应的参数及配置环境变量
1. 修改系统限制参数
vi /etc/security/limits.conf
添加以下内容:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2. 修改内核参数
vi /etc/sysctl.conf
添加以下内容:
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 2147483648
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
3. 配置环境变量
vi /home/oracle/.bashrc
添加以下内容:
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export ORACLE_UNQNAME=orcl
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LANG=C
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
四、上传并解压安装包
unzip linux.x64_11gR2_database_1of2.zip -d /data/src/
unzip linux.x64_11gR2_database_2of2.zip -d /data/src/
chown -R oracle:oinstall /data/src
五、关闭SELinux并重启
vim /etc/selinux/config
修改如下:
SELINUX=disabled
然后重启系统:
reboot
六、配置安装文件
vim /data/src/database/response/db_install.rsp
配置如下:
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=oracle.server
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/data/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/data/oracle/product/11.2.0/db_1
ORACLE_BASE=/data/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryLimit=800
oracle.install.db.config.starterdb.password.ALL=oracle
DECLINE_SECURITY_UPDATES=true
七、执行静默安装
/data/src/database/runInstaller -silent -responseFile /data/src/database/response/db_install.rsp -ignorePrereq
等待安装完成后,切换到root用户执行:
/data/oracle/product/11.2.0/db_1/root.sh
八、配置监听
vim /data/src/database/response/netca.rsp
配置如下:
INSTALL_TYPE="custom"
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START="LISTENER"
然后执行:
/data/oracle/product/11.2.0/db_1/bin/netca -silent -responseFile /data/src/database/response/netca.rsp
九、创建数据库实例
vim /data/src/database/response/dbca.rsp
配置如下:
RESPONSEFILE_VERSION ="11.2.0"
OPERATION_TYPE ="createDatabase"
GDBNAME ="orcl"
SID ="orcl"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
SYSMANPASSWORD= "oracle"
DBSNMPPASSWORD= "oracle"
DATAFILEDESTINATION =/data/oracle/oradata
RECOVERYAREADESTINATION=/data/oracle/flash_recovery_area
CHARACTERSET ="AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16"
TOTALMEMORY ="1638"
然后执行静默创建数据库实例:
/data/oracle/product/11.2.0/db_1/bin/dbca -silent -responseFile /data/src/database/response/dbca.rsp
十、启动 Oracle 数据库
1. 查看实例运行状态
ps -ef | grep ora_ | grep -v grep
2. 设置 Oracle 开机启动
chmod +x /etc/rc.d/rc.local
vim /etc/rc.d/rc.local
追加以下内容:
su oracle -lc "/data/oracle/product/11.2.0/db_1/bin/lsnrctl start"
su oracle -lc "/data/oracle/product/11.2.0/db_1/bin/dbstart"
3. 进入 Oracle 数据库
sqlplus / as sysdba
执行查询命令验证:
SELECT status FROM v$instance;
至此,Oracle 11gR2 安装完成!