美文网首页后端开发了解下
CENTOS7中ORACLE12静默安装记录

CENTOS7中ORACLE12静默安装记录

作者: 梨捉阳笆 | 来源:发表于2016-09-04 16:50 被阅读3010次

    操作系统环境设置

    检查系统版本：

    cat /etc/redhat-release

    结果如下：

    CentOS Linux release 7.0.1406 (Core)

    查看IP地址

    ifconfig ent0
    192.168.0.115

    配置系统和安装所需软件包

    关闭selinux

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

    关闭防火墙

    systemctl disable iptables

    进行一次升级

    
yum update -y

    修改主机名并重启

    将主机名修改为mes.dfec.com

    
vim /etc/hostname

    修改hosts，添加一条主机记录

    
echo "127.0.0.1      mes mes.dfec.com" >> /etc/hosts 

ping mes.dfec.com

    安装oracle所需的软件包

    
yum install gcc gcc-c++ glibc glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel zlib-devel unzip compat-libcap1 compat-libstdc++-33

    结果如下：

    已加载插件：fastestmirror, langpacks

Loading mirror speeds from cached hostfile

 * base: mirrors.cn99.com

 * extras: mirrors.cn99.com

 * updates: mirrors.cn99.com

软件包 gcc-4.8.5-4.el7.x86_64 已安装并且是最新版本

软件包 glibc-2.17-106.el7_2.8.x86_64 已安装并且是最新版本

软件包 glibc-devel-2.17-106.el7_2.8.x86_64 已安装并且是最新版本

软件包 glibc-headers-2.17-106.el7_2.8.x86_64 已安装并且是最新版本

软件包 libaio-0.3.109-13.el7.x86_64 已安装并且是最新版本

软件包 libgcc-4.8.5-4.el7.x86_64 已安装并且是最新版本

软件包 libstdc++-4.8.5-4.el7.x86_64 已安装并且是最新版本

软件包 1:make-3.82-21.el7.x86_64 已安装并且是最新版本

软件包 sysstat-10.1.5-7.el7.x86_64 已安装并且是最新版本

软件包 unzip-6.0-15.el7.x86_64 已安装并且是最新版本

正在解决依赖关系

--> 正在检查事务

---> 软件包 compat-libcap1.x86_64.0.1.10-7.el7 将被 安装

---> 软件包 compat-libstdc++-33.x86_64.0.3.2.3-72.el7 将被 安装

---> 软件包 gcc-c++.x86_64.0.4.8.5-4.el7 将被 安装

---> 软件包 ksh.x86_64.0.20120801-22.el7_1.3 将被 安装

---> 软件包 libaio-devel.x86_64.0.0.3.109-13.el7 将被 安装

---> 软件包 libstdc++-devel.x86_64.0.4.8.5-4.el7 将被 安装

---> 软件包 unixODBC.x86_64.0.2.3.1-11.el7 将被 安装

---> 软件包 unixODBC-devel.x86_64.0.2.3.1-11.el7 将被 安装

---> 软件包 zlib-devel.x86_64.0.1.2.7-15.el7 将被 安装

--> 解决依赖关系完成

依赖关系解决

==================================================================================

 Package                  架构        版本                     源            大小

==================================================================================

正在安装:

 compat-libcap1           x86_64      1.10-7.el7               base          19 k

 compat-libstdc++-33      x86_64      3.2.3-72.el7             base         191 k

 gcc-c++                  x86_64      4.8.5-4.el7              base         7.2 M

 ksh                      x86_64      20120801-22.el7_1.3      updates      881 k

 libaio-devel             x86_64      0.3.109-13.el7           base          13 k

 libstdc++-devel          x86_64      4.8.5-4.el7              base         1.5 M

 unixODBC                 x86_64      2.3.1-11.el7             base         413 k

 unixODBC-devel           x86_64      2.3.1-11.el7             base          55 k

 zlib-devel               x86_64      1.2.7-15.el7             base          50 k

事务概要

==================================================================================

安装  9 软件包

总下载量：10 M

安装大小：30 M

Is this ok [y/d/N]: y

Downloading packages:

(1/9): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm         | 191 kB  00:00:05

(2/9): gcc-c++-4.8.5-4.el7.x86_64.rpm                      | 7.2 MB  00:00:01

(3/9): libaio-devel-0.3.109-13.el7.x86_64.rpm              |  13 kB  00:00:00

(4/9): libstdc++-devel-4.8.5-4.el7.x86_64.rpm              | 1.5 MB  00:00:00

(5/9): unixODBC-2.3.1-11.el7.x86_64.rpm                    | 413 kB  00:00:00

(6/9): unixODBC-devel-2.3.1-11.el7.x86_64.rpm              |  55 kB  00:00:00

(7/9): zlib-devel-1.2.7-15.el7.x86_64.rpm                  |  50 kB  00:00:00

(8/9): ksh-20120801-22.el7_1.3.x86_64.rpm                  | 881 kB  00:00:02

(9/9): compat-libcap1-1.10-7.el7.x86_64.rpm                |  19 kB  00:00:10

----------------------------------------------------------------------------------

总计                                                 977 kB/s |  10 MB  00:10

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  正在安装    : unixODBC-2.3.1-11.el7.x86_64                                  1/9

  正在安装    : libstdc++-devel-4.8.5-4.el7.x86_64                            2/9

  正在安装    : gcc-c++-4.8.5-4.el7.x86_64                                    3/9

  正在安装    : unixODBC-devel-2.3.1-11.el7.x86_64                            4/9

  正在安装    : ksh-20120801-22.el7_1.3.x86_64                                5/9

  正在安装    : libaio-devel-0.3.109-13.el7.x86_64                            6/9

  正在安装    : compat-libcap1-1.10-7.el7.x86_64                              7/9

  正在安装    : compat-libstdc++-33-3.2.3-72.el7.x86_64                       8/9

  正在安装    : zlib-devel-1.2.7-15.el7.x86_64                                9/9

  验证中      : zlib-devel-1.2.7-15.el7.x86_64                                1/9

  验证中      : gcc-c++-4.8.5-4.el7.x86_64                                    2/9

  验证中      : libstdc++-devel-4.8.5-4.el7.x86_64                            3/9

  验证中      : unixODBC-devel-2.3.1-11.el7.x86_64                            4/9

  验证中      : unixODBC-2.3.1-11.el7.x86_64                                  5/9

  验证中      : compat-libstdc++-33-3.2.3-72.el7.x86_64                       6/9

  验证中      : compat-libcap1-1.10-7.el7.x86_64                              7/9

  验证中      : libaio-devel-0.3.109-13.el7.x86_64                            8/9

  验证中      : ksh-20120801-22.el7_1.3.x86_64                                9/9

已安装:

  compat-libcap1.x86_64 0:1.10-7.el7    compat-libstdc++-33.x86_64 0:3.2.3-72.el7

  gcc-c++.x86_64 0:4.8.5-4.el7          ksh.x86_64 0:20120801-22.el7_1.3

  libaio-devel.x86_64 0:0.3.109-13.el7  libstdc++-devel.x86_64 0:4.8.5-4.el7

  unixODBC.x86_64 0:2.3.1-11.el7        unixODBC-devel.x86_64 0:2.3.1-11.el7

  zlib-devel.x86_64 0:1.2.7-15.el7

完毕！

    添加oracle用户组

    groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba,oper oracle

    修改系统参数

    /etc/sysctl.conf

    vim  /etc/sysctl.conf

    添加如下内容：

    fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

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

net.ipv4.ip_local_port_range = 9000 65500

    应用核心参数

    sysctl -p

    /etc/security/limits.conf

    vim /etc/security/limits.conf

    添加如下内容：

    oracle   soft   nofile   1024

oracle   hard   nofile   65536

oracle   soft   nproc    2047

oracle   hard   nproc    16384

oracle   soft   stack    10240

oracle   hard   stack    32768

    创建安装文件夹

    mkdir -p /oracle/app/oracle/product/12.1.2/db_1

chown oracle:oinstall /oracle -R

    配置oracle用户环境变量

    切换到oracle用户

    su - oracle

    配置环境变量

    vim ~/.bash_profile

    添加如下内容：

    export TMP=/tmp

export ORACLE_HOSTNAME=mes.dfec.com

export ORACLE_UNQNAME=LIVENUX

export ORACLE_BASE=/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.1.2/db_1

export ORACLE_SID=ORCL

PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$HOME/bin:/$HOME/.local/bin

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

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

alias cdob='cd $ORACLE_BASE'

alias cdoh='cd $ORACLE_HOME'

alias tns='cd $ORACLE_HOME/network/admin'

alias envo='env | grep ORACLE'

    应用环境变量

    source .bash_profile

    准备安装文件

    下载安装文件

    从http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html 下载oracle12c安装包

    上传oracle安装文件

    scp /Users/lihongjun/software/oracle12c/p21419221_121020_Linux-x86-64_1of10.zip root@192.168.0.115:/software
    scp /Users/lihongjun/software/oracle12c/p21419221_121020_Linux-x86-64_2of10.zip root@192.168.0.115:/software
    scp /Users/lihongjun/Downloads/CentOS-7.0-1406-x86_64-DVD.iso root@192.168.0.115:/software

    解压oracle安装文件

    unzip p21419221_121020_Linux-x86-64_1of10.zip
    unzip p21419221_121020_Linux-x86-64_2of10.zip

    复制一个应答文件

    cd /software

cd database

cp response/db_install.rsp inst.rsp

mkdir -p /oracle/orainst/12.1.2/database/stage

    修改应答文件

    vim /software/database/inst.rsp

    修改内容如下：

    oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=ora1
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/orainst/12.1.2/database/stage
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/oracle/app/oracle/product/12.1.2/db_1
ORACLE_BASE=/oracle/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

    执行安装程序

    ./runInstaller -ignoreSysPrereqs -force -silent -responseFile /software/database/inst.rsp

    查看是否有出错日志

    The installation of Oracle Database 12c was successful.
Please check '/oracle/orainst/12.1.2/database/stage/logs/silentInstall2016-09-03_07-24-04PM.log' for more details.

As a root user, execute the following script(s):
        1. /oracle/orainst/12.1.2/database/stage/orainstRoot.sh
        2. /oracle/app/oracle/product/12.1.2/db_1/root.sh

Successfully Setup Software.

    执行root.sh

    su - root
cd /oracle/app/oracle/product/12.1.2/db_1
sh ./root.sh

    执行结果如下：

    Check /oracle/app/oracle/product/12.1.2/db_1/install/root_mes.dfec.com_2016-09-03_20-15-41.log for the output of root script

    执行orainstRoot.sh

    cd /oracle/orainst/12.1.2/database/stage
sh ./orainstRoot.sh

    执行结果如下：

    Changing permissions of /oracle/orainst/12.1.2/database/stage.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /oracle/orainst/12.1.2/database/stage to oinstall.
The execution of the script is complete.

    配置监听器

    查看netca response file参数

    cd /software/database/response
sed -n '/^[^#]/p' netca.rsp

    结果如下：

    [GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
[root@#localhost response]# pwd
/software/database/response

    编辑netca response file参数

    cp /software/database/response/netca.rsp /software/database/netca.rsp
vim /software/database/netca.rsp

    修改后的结果如下：

    [GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""custom""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

    静默安装NET Listener

    su - oracle
cd /oracle/app/oracle/product/12.1.2/db_1/bin
/oracle/app/oracle/product/12.1.2/db_1/bin/netca -silent -responseFile /software/database/netca.rsp

    执行结果如下：

    Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /software/database/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
    Running Listener Control:
      /oracle/app/oracle/product/12.1.2/db_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Profile configuration complete.
Oracle Net Services configuration successful. The exit code is 0

    创建数据库

    查看响应文件

    cd /software/database
sed -n '/^[^#]/p' dbca.rsp

    结果如下：

    [GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl12c.us.oracle.com"
SID = "orcl12c"
TEMPLATENAME = "General_Purpose.dbc"
[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 = "orcl12.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
NODENAME=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
INSTANCENAME = "orcl12c"
SYSDBAUSERNAME = "sys"
[CREATEPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
[UNPLUGDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
ARCHIVETYPE = "TAR"
[DELETEPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
[CONFIGUREPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"

    编辑响应文件dbca.rsp

    cp /software/database/response/dbca.rsp /software/database/dbca.rsp
vim /software/database/dbca.rsp

    修改的结果如下：

    [GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl12c.mes.dfec.com"
SID = "orcl12c"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "SYS"
SYSTEMPASSWORD = "SYSTEM"
[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 = "orcl12.mes.dfec.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl12c.mes.dfec.com"
NODENAME=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl12c.mes.dfec.com"
INSTANCENAME = "orcl12c"
SYSDBAUSERNAME = "sys"
[CREATEPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
[UNPLUGDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
ARCHIVETYPE = "TAR"
[DELETEPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
[CONFIGUREPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"

    创建数据库

    /oracle/app/oracle/product/12.1.2/db_1/bin/dbca -silent -responseFile /software/database/dbca.rsp

    执行结果如下：

    Copying database files
1% complete
2% complete
4% complete
DBCA Operation failed.
Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/orcl12c/orcl12c.log" for further details.

    执行失败，查看log：

    vim /oracle/app/oracle/cfgtoollogs/dbca/orcl12c/orcl12c.log

    结果如下：

    Database Configuration Assistant failed to detect options for this Oracle Installation.
ORA-12547: TNS:lost contact

Due to this failure some Database Configuration Assistant features will not be available. Do you want to continue?

Unique database identifier check passed.

/ has enough space. Required space is 6140 MB , available space is 33031 MB.
File Validations Successful.
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-12547: TNS:lost contact

DBCA_PROGRESS : 4%
Error while cataloging RMAN Backups
DBCA_PROGRESS : DBCA Operation failed.

    查看IP地址

    ifconfig eth0

    结果如下：

    eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.0.115  netmask 255.255.255.0  broadcast 192.168.0.255
        inet6 fe80::21c:42ff:fe11:61b  prefixlen 64  scopeid 0x20<link>
        ether 00:1c:42:11:06:1b  txqueuelen 1000  (Ethernet)
        RX packets 114131  bytes 30342139 (28.9 MiB)
        RX errors 0  dropped 190  overruns 0  frame 0
        TX packets 16014  bytes 4278352 (4.0 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

    参考文档

    http://blog.itpub.net/13804621/viewspace-767741/
    http://www.cnblogs.com/fincod/p/3997503.html
    http://www.linuxidc.com/Linux/2013-07/87696.htm
    http://blog.csdn.net/yabingshi_tech/article/details/46801539

    相关文章

      网友评论

        本文标题：CENTOS7中ORACLE12静默安装记录

        本文链接：https://www.haomeiwen.com/subject/goblettx.html

        延伸阅读

        深度阅读

        • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

        栏目导航

        热点阅读

        后端开发了解下

        关于我们|服务条款|联系我们|CENTOS7中ORACLE12静默安装记录|投稿指南|网站地图|RSS订阅|排版工具|手机版

        提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

        Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

        备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

        本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

        所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！