Centos7.6上静默安装oracle11.2.0.4.0
2020-09-22
加入收藏
很多同学使用图形化安装oracle数据库，可是生产上大多数，是不会安装图形化包的，所以必须掌握怎么静默安装oracle数据库，下面就详细介绍怎么静默安装oracle11g数据库。
1.配置主机名
vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=host100
2.配置hosts信息
vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.100 host100
3.安装必要的包
先检查哪些包没安装
for i in binutils compat-gcc-44 compat-libstdc++-33 control-center
gcc gcc-c++ glibc glibc-common glibc-devel libaio libgcc elfutils-libelf-devel libstdc++ libstdc++-devel libXp make compat-libcap1 compat-libstdc++-33 libaio-devel sysstat unixODBC unixODBC-devel kshdo rpm -q $i &>/dev/null || F="$F $i"
done ;echo $F;unset F’
缺少的包，用YUM安装就可以
4.修改内核参数
vi /etc/sysctl.conf 到末尾 以下只出自oracle-rdbms-server-11gR2-preinstall自动做的修改
用#注释掉kernel.shmmax和kernel.shmall开头的两行
添加如下：
kernel.shmmax = 4398046511104
kernel.shmall = 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 = 1048576
fs.aio-max-nr = 1048576
fs.file-max = 6815744
vm.swAppiness=10
以上参数为使用oracle 验证包自动配置的参数结果，vm.swappiness=10为减少使用SWAP，该值默认是60
kernel.shmall:表示共享内存总量，以页为单位
kernel.shmmax:参数用来定义单个共享内存段的最大值,单位为Byte(字节)。
可以用一下脚本，设置kernel.shmall,kernel.shmmax参数值，其它值不用修改
#!/bin/bash
page_size=`getconf PAGE_SIZE`
phys_pages=`getconf _PHYS_PAGES`
if [ -z "$page_size" ]; then
echo Error: cannot determine page size
exit 1
fi
if [ -z "$phys_pages" ]; then
echo Error: cannot determine number of memory pages
exit 2
fi
shmall=`expr $phys_pages`
shmmax=`expr $shmall * $page_size`
echo # Maximum shared segment size in bytes
echo kernel.shmmax = $shmmax
echo # Maximum number of shared memory segments in pages
echo kernel.shmall = $shmall
5.修改的oracle用户限制
vi /etc/security/limits.conf 末尾添加：
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
6. 修改的/etc/pam.d/login
vi /etc/pam.d/login 末尾添加：
session required pam_limits.so
7. 关闭的防火墙和selinux
关闭的防火墙:
linux6：
service iptables stop
chkconfig iptables off
linux7：
systemctl stop firewalld
systemctl mask firewalld
禁用selinux：
setenforce 0
getenforce
vi /etc/selinux/config 确保以下内容
SELINUX=disabled
8. 更改ulimit 设置
vi /etc/profile 末尾添加：
if [ /$USER = "oracle" ]; then
if [ /$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
9. 建立组合用户
groupadd -g 501 oinstall
groupadd -g 502 dba
useradd -u 501 -g oinstall -G dba oracle -d /home/oracle
passwd oracle
10. 建立安装目录
[root@ ~]#
mkdir -p /u01/app/oracle/product/11.2.0/db_1
mkdir -p /oracle/oradata
chmod -R 775 /oracle
chmod -R 775 /u01
chown -R oracle:oinstall /oracle
chown -R oracle:oinstall /u01
11. 设置oracle用户的环境变量
su - oracle
vi .bash_profile 末尾添加：
export ORACLE_BASE=/u01/app
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=crmdbexport PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORACLE_UNQNAME=crmdbexport NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
如果是UT8，可以设置export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
12.swap分区设置
fallocate -l 250M /swapfile
chmod 600 /swapfile
mkswap /swapfileswapon /swapfileswapon -s
在/etc/fstab中添加以下内容
/swapfile swap swap sw 0 0
13.获取软件安装配置文件
INVENTORY_LOCATION不要存放在ORACLE_BASE之下
cat db_install.rsp |grep -v "#"|sed '/^ *$/d'
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=cbov10-tidb57-206UNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventorySELECTED_LANGUAGES=en,zh_CNORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/u01/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.EEOptionsSelection=falseoracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.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=dbaoracle.install.db.OPER_GROUP=oinstallSECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=trueoracle.installer.autoupdates.option=SKIP_UPDATES./runInstaller -silent -showProgress -responseFile /u01/soft/database/response/dbinstall.rsp
14.配置监听
export DISPLAY=127.0.0.1:1.0
netca -silent -responsefile /u01/soft/database/response/netca.rsp在/u01/app/oracle/product/11.2.0/db_1/network/admin目录下创建tnsnames.ora文件
CRMDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cbov10-tidb57-206)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = crmdb) ) )
如果监听一直出不来，可以使用alter system register手工注册
15.dbca静默建库
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]GDBNAME = "crmdb"
SID="crmdb"
TEMPLATENAME = "General_Purpose.dbc"
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "512"
SYSPASSword = "oracle"
SYSTEMPASSWORD = "oracle"
/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc
在上述文件中，可以修改数据库文件，redo，归档模式，Controlfile存放位置和大小
dbca -silent -initParams log_archive_dest_1='location=/oracle/archivelog' -responseFile /u01/soft/database/response/db_create.rsp
设置timestamp时间显示格式
alter system set nls_date_format='yyyy-mm-dd hh24:mi:ss' scope=spfile;
/u03/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc文件修改
<?xml version = '1.0'?>
<DatabaseTemplate name="General_Purpose" description="" version="11.1.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="OWB" value="true"/>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value=""/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
<initParam name="compatible" value="11.2.0.0.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="processes" value="150"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/flash_recovery_area/{DB_UNIQUE_NAME}/control02.ctl")"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/flash_recovery_area"/>
<initParam name="audit_trail" value="db"/>
<initParam name="memory_target" value="250" unit="MB"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="" unit="MB"/>
<initParam name="nls_date_format" value="yyyy-mm-dd hh24:mi:ss"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<customSGA>false</customSGA>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<DataFiles>
<Location>{ORACLE_HOME}/assistants/dbca/templates/Seed_Database.dfb</Location>
<SourceDBName>seeddata</SourceDBName>
<Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="670" autoextend="true" blocksize="8192">{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf</Name>
<Name id="2" Tablespace="SYSAUX" Contents="PERMANENT" Size="440" autoextend="true" blocksize="8192">{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf</Name>
<Name id="3" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192">{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf</Name>
<Name id="4" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192">{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf</Name>
</DataFiles>
<TempFiles>
<Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="20">{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/temp01.dbf</Name>
</TempFiles>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>100</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
<image name="control02.ctl" filepath="{ORACLE_BASE}/flash_recovery_area/{DB_UNIQUE_NAME}/"/>
</ControlfileAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">51200</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01a.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
<member ordinal="1" memberName="redo01b.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">51200</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02a.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
<member ordinal="1" memberName="redo02b.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">51200</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03a.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
<member ordinal="1" memberName="redo03b.log" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
16.安全配置
解除密码180天有效期限制，这个一步非常重要
alter profile default limit password_life_time unlimited; 
