ITPub博客

首页 > 数据库 > Oracle > Oracle 18c rpm 安装及解析安装过程

Oracle 18c rpm 安装及解析安装过程

原创 Oracle 作者:gycixput 时间:2018-11-01 17:56:36 1 删除 编辑


环境:

OEL 6.8

DB:18.3


安装过程中包括两个RPM包

oracle-database-ee-18c-1.0-1.x86_64.rpm

oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm


安装过程分为在线安装和离线安装,决定于oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm。


在线安装:

# curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

# yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm



离线安装,下载oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm后,手动安装。

下载地址:

该过程采取离线安装,下载软件包:

oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm软件包检查系统软件包,调整系统参数,添加数据库用户组和用户

通过shell脚本定制Oracle安装条件,实现最佳安装环境配置。

开始安装:

[root@oeldb soft]# rpm -ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm 

warning: oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

error: Failed dependencies:

        compat-libcap1 is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

        compat-libstdc++-33 is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

        ksh is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

        libaio-devel is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

        libstdc++-devel is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

        xorg-x11-utils is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

        xorg-x11-xauth is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64


提示所需安装软件包:

[root@oeldb soft]# yum -y install xorg-x11-xauth xorg-x11-utils libstdc++-devel libaio-devel ksh compat-libstdc++-33 compat-libcap1


[root@oeldb soft]# rpm -ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm 

Preparing...                ########################################### [100%]

   1:oracle-database-preinst########################################### [100%]

检查安装后环境:

[root@oeldb ~]# cat /etc/passwd | grep oracle

oracle:x:54321:54321::/home/oracle:/bin/bash

[root@oeldb ~]# more /etc/group| tail -10

stapsys:x:157:

stapdev:x:158:

tcpdump:x:72:

oinstall:x:54321:oracle

dba:x:54322:oracle

oper:x:54323:oracle

backupdba:x:54324:oracle

dgdba:x:54325:oracle

kmdba:x:54326:oracle

racdba:x:54330:oracle


检查RPM包内容:

[root@oeldb soft]# rpm -qlp oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm 

/etc/rc.d/init.d/oracle-database-preinstall-18c-firstboot

/etc/security/limits.d/oracle-database-preinstall-18c.conf

/etc/sysconfig/oracle-database-preinstall-18c

/etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c-verify

/etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c.param

/usr/bin/oracle-database-preinstall-18c-verify

/var/log/oracle-database-preinstall-18c

/var/log/oracle-database-preinstall-18c/results

解压软件包:

[root@oeldb soft]# rpm2cpio oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm | cpio -idmv

./etc/rc.d/init.d/oracle-database-preinstall-18c-firstboot

./etc/sysconfig/oracle-database-preinstall-18c

./etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c-verify

./etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c.param

./usr/bin/oracle-database-preinstall-18c-verify

./var/log/oracle-database-preinstall-18c

./var/log/oracle-database-preinstall-18c/results


数据库相关用户、组、参数:

./etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c.param



安装数据库软件:

首先检查RPM包内容,包括创建数据库、监听、数据库软件,内容如下:

root@oeldb soft]# rpm -qlp oracle-database-ee-18c-1.0-1.x86_64.rpm 

/etc/init.d/oracledb_ORCLCDB-18c

/etc/sysconfig/oracledb_ORCLCDB-18c.conf

/opt/oracle/product/18c

/opt/oracle/product/18c/dbhome_1

/opt/oracle/product/18c/dbhome_1/.opatchauto_storage

/opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches

/opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches/28096386

/opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches/28096386/bundle.xml

/opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches/systemPatchInformationStore.xml

/opt/oracle/product/18c/dbhome_1/.patch_storage

......

/opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxtr.msb

/opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxus.msb

/opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxus.msg

/opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxzhs.msb

/opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxzht.msb

[root@oeldb soft]# 


[root@oeldb soft]# rpm -ivh oracle-database-ee-18c-1.0-1.x86_64.rpm 

Preparing...                ########################################### [100%]

   1:oracle-database-ee-18c ############################################### [100%]

[INFO] Executing post installation scripts...

[INFO] Oracle home installed successfully and ready to be configured.

To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-18c configure


检查文件内容:

/etc/init.d/oracledb_ORCLCDB-18c 文件中configure方法内容如下

......

configure()

{

    check_for_configuration

    RETVAL=$?

    if [ $RETVAL -eq 0 ]

    then

        echo "Oracle Database instance $ORACLE_SID is already configured."

        exit 1

    fi

    read_config_file

    check_port_availability

    check_em_express_port_availability

    configure_perform

}

......

该文件包括数据库启动、停止、重启等相关脚本集合。

[root@oeldb ~]# more /etc/init.d/oracledb_ORCLCDB-18c | grep '()'

start()

stop()

configure_perform()

unset_proxy_vars()

check_for_configuration()

read_config_file()

configure()

check_port_availability()

check_em_express_port_availability()

restart()


创建数据库,默认创建sid:ORCLCDB,pdb_name:ORCLPDB1,可根据要求调整文件内容。

[root@oeldb ~]# /etc/init.d/oracledb_ORCLCDB-18c configure

Configuring Oracle Database ORCLCDB.

Prepare for db operation

8% complete

Copying database files

31% complete

Creating and starting Oracle instance

32% complete

36% complete

40% complete

43% complete

46% complete

Completing Database Creation

51% complete

 54% complete

Creating Pluggable Databases

58% complete

77% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.

Database Information:

Global Database Name:ORCLCDB

System Identifier(SID):ORCLCDB

Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.


Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.


Oracle环境变量未配置,配置环境变量,检查监听

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1

export ORACLE_SID=ORCLCDB

export PATH=$PATH:$ORACLE_HOME/bin

[oracle@oeldb ~]$ . .bash_profile 

[oracle@oeldb ~]$ lsnrctl  status


LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 31-OCT-2018 14:54:11


Copyright (c) 1991, 2018, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oeldb)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production

Start Date                31-OCT-2018 14:07:48

Uptime                    0 days 0 hr. 46 min. 25 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /opt/oracle/product/18c/dbhome_1/network/admin/listener.ora

Listener Log File         /opt/oracle/diag/tnslsnr/oeldb/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oeldb)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oeldb)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/ORCLCDB/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "7981b2318b511a4ce053c80fa8c07ea4" has 1 instance(s).

  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...

Service "ORCLCDB" has 1 instance(s).

  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...

Service "ORCLCDBXDB" has 1 instance(s).

  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...

Service "orclpdb1" has 1 instance(s).

  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...

The command completed successfully


测试停止、启动

[root@oeldb ~]# /etc/init.d/oracledb_ORCLCDB-18c stop

Shutting down Oracle Database instance ORCLCDB.

Oracle Database instance ORCLCDB shut down.

Stopping Oracle Net Listener.

Oracle Net Listener stopped.


[root@oeldb ~]# /etc/init.d/oracledb_ORCLCDB-18c start

Starting Oracle Net Listener.

Oracle Net Listener started.

Starting Oracle Database instance ORCLCDB.

Oracle Database instance ORCLCDB started.



整体上rpm安装简化了安装过程,改进很多,创建可以根据脚本内容针对于适合自己的数据库信息。


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24585765/viewspace-2218439/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-11-05

  • 博文量
    57
  • 访问量
    182595