Linux下Oracle11g静默方式安装

最新推荐文章于 2021-05-28 17:04:52 发布

置顶丶冷静

最新推荐文章于 2021-05-28 17:04:52 发布

阅读量292

点赞数

分类专栏：数据库安装及维护文章标签：数据库

本文链接：https://blog.csdn.net/weixin_45950088/article/details/104209907

版权

数据库安装及维护专栏收录该内容

12 篇文章 1 订阅

订阅专栏

1、查看当前swap大小需大于150M

free -h

2、查看当前系统信息

uname -m

cat /etc/redhat-release

3、修改主机名

vim /etc/sysconfig/network

hostname=hwx

vim /etc/hosts

192.168.1.4  hwx

4、关闭SELINUX

vim /etc/selinux/config

SELINUX=disabled

5、关闭防火墙

systemctl stop firewalld

systemctl disable firewalld

6、安装依赖包

yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686

yum -y install gcc make binutils gcc-c++ compat-libstdc++-33 elfutils-libelf-devel elfutils-libelf-devel-static elfutils-libelf-devel ksh libaio libaio-devel numactl-devel sysstat unixODBC unixODBC-devel pcre-devel

7、检测安装好的依赖包

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst  make sysstat  unixODBC unixODBC-devel

8、检测未安装成功的依赖包

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel |grep "not installed"

9、添加oinstall 、dba 组，新建oracle用户并加入oinstall、dba组

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle 
passwd oracle

查看oracle用户相关组信息

id oracle

10、修改内核参数

vim /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
kernel.shmmax = 100579217408
kernel.shmall = 6286201088
kernel.shmmni = 4096

11、执行命令使其生效

sysctl -p

12、修改用户的限制文件

vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240

13、修改etc/pam.d/login

vim /etc/pam.d/login

session  required   /lib64/security/pam_limits.so
session  required   pam_limits.so

14、修改/etc/profile文件

vim /etc/profile

#oralce

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
   ulimit -p 16384
   ulimit -n 65536
  else
   ulimit -u 16384 -n 65536
  fi
fi

15、创建安装目录、修改文件权限

mkdir -p /app/oracle/product/11.2.0/dbhome_1
mkdir /app/oracle/oradata
mkdir /app/oracle/inventory
mkdir /app/oracle/fast_recovery_area
chown -R oracle:oinstall /app
chmod -R 775 /app

16、上传oracle安装包到/tmp目录下

unzip /tmp/p13390677_112040_Linux-x86-64_1of7.zip && unzip /tmp/p13390677_112040_Linux-x86-64_2of7.zip

17、切换到oracle用户，设置oracle用户环境变量

vim .bash_profile

export PATH
ORACLE_BASE=/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_SID=
ORACLE_PID=ora11g
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
PATH=$PATH:$ORACLE_HOME/bin
NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_PID LD_LIBRARY PATH NLS_LANG
export LANGUAGE="zh_CN"

18、root下编辑静默安装响应文件

cp /tmp/database/response/db_install.rsp /tmp/database/response/db_install.rsp.bak

vim /tmp/database/response/db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY  #安装类型
ORACLE_HOSTNAME=test #主机名
UNIX_GROUP_NAME=oinstall #用户组
INVENTORY_LOCATION=/app/oracle/oraInventory #创建目录地址
SELECTED_LANGUAGES=en,zh_CN #语言选择
ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1/ #oracle目录
ORACLE_BASE=/app/oracle #oracle主目录
oracle.install.db.InstallEdition=EE #oracle版本
oracle.install.db.EEOptionsSelection=false #默认
oracle.install.db.DBA_GROUP=dba #dba用户组
oracle.install.db.OPER_GROUP=oinstall #用户组
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #数据库类型
oracle.install.db.config.starterdb.globalDBName=test#数据库名
oracle.install.db.config.starterdb.SID=test #数据库实例名
oracle.install.db.config.starterdb.characterSet=ZHS16GBK #数据库字符集
oracle.install.db.config.starterdb.memoryOption=true #自动管理启用
oracle.install.db.config.starterdb.memoryLimit=19200 #分配内存大小
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=passwd #所有用户统一密码
oracle.install.db.config.starterdb.automatedBackup.enable=false
DECLINE_SECURITY_UPDATES=true #设置安全更新

19、切换至oracle用户执行静默安装

su - oracle

cd /tmp/database

./runInstaller -silent -ignorePrereq -ignoreSysPrereqs -responseFile /tmp/database/response/db_install.rsp

20、根据提示可打开另外窗口查看日志

tail -f /app/oracle/inventory/logs/installActions2017-06-09_03-00-09PM.log

21、切换root用户执行两个运行脚本

su - root

sh /app/oracle/inventory/orainstRoot.sh
sh /app/oracle/product/11.2.0/db_1/root.sh

22、用oracle用户登录配置监听

su - oracle

export DISPLAY=localhost:0.0

netca -silent -responseFile /tmp/database/response/netca.rsp

运行成功之后，会在/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/中生成listener.ora和sqlnet.ora两个文件
若失败再次执行

netca -silent -responseFile /tmp/database/response/netca.rsp

修改监听配置文件

vim /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.8)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /app/oracle

vim /app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

test =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.8)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME =test )
    )
  )

关闭监听

lsnrctl stop

启动监听

lsnrctl start

查看监听状态

lsnrctl status

23、静默配置orcl实例，修改实例创建文件

vim /tmp/database/response/dbca.rsp

[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "test"
SID = "test"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "PASSWORD"
SYSTEMPASSWORD = "PASSWORD"
SYSMANPASSWORD = "PASSWORD"
DATAFILEDESTINATION =/app/oracle/oradata
RECOVERYAREADESTINATION=/app/oracle/fast_recovery_area
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "19646"
[createTemplateFromDB]
SOURCEDB = "myhost:1521:orcl"
SYSDBAUSERNAME = "system"
TEMPLATENAME = "My Copy TEMPLATE"
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
[generateScripts]
TEMPLATENAME = "New Database"
GDBNAME = "orcl11.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
NODELIST=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
INSTANCENAME = "orcl11g"
SYSDBAUSERNAME = "sys"

24、切换至oracle用户执行创建

su - oracle

dbca -silent -responseFile /tmp/database/response/dbca.rsp

25、完成建库后进行实例检查

ps -ef | grep ora_ | grep -v grep

丶冷静

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Linux下Oracle11g静默方式安装

1、查看当前swap大小需大于150Mfree -h2、查看当前系统信息uname -mcat /etc/redhat-release3、修改主机名vim /etc/sysconfig/networkhostname=hwxvim /etc/hosts192.168.1.4 hwx4、关闭SELINUXvim /etc/selinux/configSELI...
复制链接

扫一扫