Linux7.8下静默安装oracle11.2

一、使用脚本初始化环境

脚本如下：（标红处修改对应的配置需求）

#!/bin/bash

#1.配置主机名/etc/hosts 并关闭防火墙及selinux

echo ' 172.168.0.xx linux.tk ' >>/etc/hosts

#注意修改为服务器的ip和主机名

systemctl stop firewalld

systemctl disable firewalld

setenforce 0

#sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

#2.安装相关软件包

yum -y install telnet vim lszrz gcc make binutils gcc-c++ compat-libstdc++-33 elfutils-libelf-devel

elfutils-libelf-devel-static ksh libaio libaio-devel numactl-devel sysstat

unixODBC unixODBC-devel pcre-devel wget unzip

#3.配置内核参数

echo "fs.aio-max-nr = 1048576" >>/etc/sysctl.conf

echo "fs.file-max = 6815744" >>/etc/sysctl.conf

echo "kernel.shmmni = 4096" >>/etc/sysctl.conf

echo "kernel.sem = 250 32000 100 128" >>/etc/sysctl.conf

echo "net.ipv4.ip_local_port_range = 9000 65500" >>/etc/sysctl.conf

echo "net.core.rmem_default = 262144" >>/etc/sysctl.conf

echo "net.core.rmem_max = 4194304" >>/etc/sysctl.conf

echo "net.core.wmem_default = 262144" >>/etc/sysctl.conf

echo "net.core.wmem_max = 1048576" >>/etc/sysctl.conf

sysctl -p

#4.oracle用户资源限制

echo "oracle soft nproc 2047" >>/etc/security/limits.conf

echo "oracle hard nproc 16384" >>/etc/security/limits.conf

echo "oracle soft nofile 4096" >>/etc/security/limits.conf

echo "oracle hard nofile 65536" >>/etc/security/limits.conf

#5.登录配置

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

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

#改授权

echo "if [ $USER = 'oracle' ]then" >>/etc/profile

echo "if [ $SHELL = '/bin/ksh' ]then" >>/etc/profile

echo "ulimit -p 16384" >>/etc/profile

echo "ulimit -n 65536" >>/etc/profile

echo "else" >>/etc/profile

echo "ulimit -u 16384 -n 65536" >>/etc/profile

echo "fi" >>/etc/profile

echo "fi" >>/etc/profile

source /etc/profile

#6.创建用户组和用户

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba,oper oracle

echo 'oracle' | passwd --stdin oracle

#7.创建相关目录

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oraInventory

chown -R oracle:oinstall /u01/app

#8.配置oracle用户环境变量

echo "ORACLE_SID=oraexport ORACLE_SID" >>/home/oracle/.bash_profile

#sid指定为现场的sid

echo "ORACLE_BASE= /u01/app/oracle export ORACLE_BASE" >>/home/oracle/.bash_profile

echo "ORACLE_HOME=$ORACLE_BASE/ product/11.2.0/dbhome_1 export ORACLE_HOME" >>/home/oracle/.bash_profile

echo "ORACLE_PATH=/u01/app/common/oracle/sqlexport ORACLE_PATH" >>/home/oracle/.bash_profile

echo "ORACLE_TERM=xtermexport ORACLE_TERM" >>/home/oracle/.bash_profile

echo "TNS_ADMIN=$ORACLE_HOME/network/adminexport TNS_ADMIN" >>/home/oracle/.bash_profile

echo "ORA_NLS11=$ORACLE_HOME/nls/dataexport ORA_NLS11" >>/home/oracle/.bash_profile

echo "PATH=.:${JAVA_HOME}/bin:${PATH}:$ORACLE_HOME/bin " >>/home/oracle/.bash_profile

echo "PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin " >>/home/oracle/.bash_profile

echo "export PATH " >>/home/oracle/.bash_profile

echo "export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" >>/home/oracle/.bash_profile

echo "LD_LIBRARY_PATH=$ORACLE_HOME/lib" >>/home/oracle/.bash_profile

echo "LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib " >>/home/oracle/.bash_profile

echo "LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib " >>/home/oracle/.bash_profile

echo "export LD_LIBRARY_PATH" >>/home/oracle/.bash_profile

echo "export LANG=en_US.UTF-8 " >>/home/oracle/.bash_profile

echo "export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" >>/home/oracle/.bash_profile

echo "CLASSPATH=$ORACLE_HOME/JRE " >>/home/oracle/.bash_profile

echo "CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib" >>/home/oracle/.bash_profile

echo "CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib" >>/home/oracle/.bash_profile

echo "CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib" >>/home/oracle/.bash_profile

echo "export CLASSPATH" >>/home/oracle/.bash_profile

echo "THREADS_FLAG=nativeexport THREADS_FLAG" >>/home/oracle/.bash_profile

echo "nls_date_format='yyyy-mm-dd hh24:mi:ss' " >>/home/oracle/.bash_profile

echo "export nls_date_format " >>/home/oracle/.bash_profile

echo "export TEMP=/tmp " >>/home/oracle/.bash_profile

echo "export TMPDIR=/tmp " >>/home/oracle/.bash_profile

echo "umask 022 " >>/home/oracle/.bash_profile

source ~/.bash_profile

二、上传或者下载oracle安装包并解压，例如放置在/opt/目录下

unzip p13390677_112040_Linux-x86-64_1of7.zip

unzip p13390677_112040_Linux-x86-64_2of7.zip

直接在目录解压，会在当前目录中生成database目录

三、修改应答文件安装数据库软件

修改前建议先备份下

cp /opt/database/response/*.rsp /opt/database/rspbak

3.1、生成修改响应文件（/opt/database/response/db_install.rsp）

备注：清空源文件，复制粘贴如下内容（标红处需要修改对应的设置需求）：

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME= linux.tk

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION= /u01/app/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1

ORACLE_BASE= /u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.EEOptionsSelection=false

oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:10.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oper

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES

3.2、开始安装

1）、用oracle用户登录 *** 作

# su - oracle

$ cd /opt/database

$ ./runInstaller -silent -responseFile /opt/database/response/db_install.rsp

2）、在安装过程中可以新开会话，使用tailf 命令查看进度

# tailf /u01/app/oraInventory/logs/installActions2022-XX-XX_03-28-06PM.log

提示安装结束，需要在root用户执行两个脚本，如下：

# /u01/app/oraInventory/orainstRoot.sh

# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

四、修改应答文件安装数据库实例（/opt/database/response/dbca.rsp）

安装实例前，需要新建一个实例存放的目录（/home/OracleData/），如下：

# mkdir /home/OracleData

# chown -R oracle:oinstall /home/OracleData/

4.1、修改应答文件

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "ora"

SID = "ora"

TEMPLATENAME = "General_Purpose.dbc"

SYSPASSWORD = "***012"

SYSTEMPASSWORD = "***012"

DATAFILEDESTINATION = /home/OracleData/

RECOVERYAREADESTINATION = /u01/app/oracle/flash_recovery_area

CHARACTERSET = "ZHS16GBK"

TOTALMEMORY = "2048"

4.2、建实例,登录oracle用户

# su - oracle

$ dbca -silent -responseFile /opt/database/response/dbca.rsp

此安装过程是有进度显示，不用tailf查看，不过也可以查看对应的log日志查看进度

4.3、删除实例

编辑应答文件

#vim /opt/database/response/del_dbca.rsp

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "deleteDatabase"

[DELETEDATABASE]

SOURCEDB = "ora "

$ dbca -silent -responseFile del_dbca.rsp

五、启动监听，配置自启动等

5.1、启动监听

# su – oracle

$ lsnrctl start

查看状态 lsnrctl status

# netstat -tnulp | grep 1521

# ps -ef | grep ora_ | grep -v grep

5.2、设置自启动

修改vim /etc/oratab 如下

ora:/u01/app/oracle/product/11.2.0/dbhome_1: Y

5.3、修改dbstart文件

vim /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart

将ORACLE_HOME_LISTNER=$1

修改为ORACLE_HOME_LISTNER=$ORACLE_HOME

5.4、将dbstart加入开机自启动，/etc/rc.d/rc.local中增加

su - oracle -lc /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart

赋权限 chmod +x /etc/rc.d/rc.local

5.3、登录数据库设置权限等

sqlplus / as sysdba

startup

alter system register

create user ora identified by ***012

grant dba to ora

exit

六、远程连接数据库

6.1、开放1521端口

firewall-cmd --zone=public --add-port=1521/tcp --permanent

firewall-cmd –reload

firewall-cmd --list-ports

从Oracle服务器上拷贝相应的sqlldr 执行程序 。  1>scp /usr/local/oracle/sqlldr  2>mkdir -p /usr/local/oracle/rdbms/mesg cd /usr/local/oracle/rdbms/mesg/   scp ./ulus.msb 进入etc/profile修改环境变量 vim etc/profile   按i编辑   esc+q/q!强退    esc+wq保存编辑并退出export ORACLE_HOME=/usr/local/oracle export TNS_ADMIN=$ORACLE_HOME export  LD_LIBRARY_PATH =$ORACLE_HOME:/usr/local/oracle/lib:${ LD_LIBRARY_PATH } export SQLPATH=$ORACLE_HOME export PATH=$PATH:$ORACLE_HOME其中lib文件夹因为有sqlldr后来的报错：sqlldr: error while loading shared libraries: libclntsh.so.11.1: cannot open 所以整个lib都从oracle服务器上下下来了，这总不会错了吧之后sqlldr发现权限问题 chmod a+x /usr/local/oracle/sqlldr 然后差不多了 source etc/profile sqlldr命令有在正常提示信息了

*** 作系统：Redhat 6.1 64Bit

数据库：Oracle11.2.0.1 客户端 64Bit

1：需要创建一个数据库的 *** 作系统帐号：比如ora

2：使用SSH将数据库客户端软件传输到ora用户下

执行安装之前，需要对install文件夹和runInstaller有775的权限即可

[ora@redhat6 client]$ ll

total 24

drwxr-xr-x.  8 ora oinstall 4096 Jul 19  2012 doc

drwxrwxrwx.  4 ora oinstall 4096 Jul 19  2012 install

drwxr-xr-x.  2 ora oinstall 4096 Jul 19  2012 response

-rwxrwxrwx.  1 ora oinstall 3230 Aug 15  2009 runInstaller

drwxr-xr-x. 14 ora oinstall 4096 Jul 19  2012 stage

-rw-r--r--.  1 ora oinstall 3924 Aug 17  2009 welcome.html

3：注意在root用户下执行xhost+这样才可以调出图形化界面

4：安装就比较简单了，其实安装有个系统依赖包检查，其实这个可以跳过去，好多包其实都安装过了（不过还是谨慎点好）

5：安装过程到最后，需要使用root用户执行两个脚本，系统会提示的

[root@redhat6 app]# cd oraInventory/

[root@redhat6 oraInventory]# ls

ContentsXML       logs                     oraInst.loc     oui

install.platform  oraInstaller.properties  orainstRoot.sh

[root@redhat6 oraInventory]# ./orainstRoot.sh

Changing permissions of /home/ora/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/ora/app/oraInventory to oinstall.

The execution of the script is complete.

还有一个

执行完毕之后，把相关的环境变量写上去就可以了

PATH=$PATH:$HOME/bin

export PATH

export  ORACLE_OWNER= ora

export  ORACLE_HOME=/home/ora/app/ora/product/11.2.0/client_1  

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export LANG=en_US

然后在ora用户下执行netca配置netservicename,配置完毕之后就可以使用了

[ora@redhat6 ~]$ sqlplus system/oracle@orcl

SQL*Plus: Release 11.2.0.1.0 Production on Sat Jun 16 03:38:24 2012  

Copyright (c) 1982, 2009, Oracle.  All rights reserved.  

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options  

SQL>

另外需要注意的就是，因为发布服务是需要使用ArcGIS Server用户来发布服务，那么需要ArcGIS Server用户可以使用Sqlplus执行，那么就需要

1：要么我们的oracle安装在/opt目录下

2：要么Oracle安装在其他目录下，ArcGIS Server用户可以对这个目录有相关权限

---