19c(19.3) 單機資料庫安裝

wuweilong發表於2020-03-11

          19c(19.3) 單機資料庫安裝

 

一、           環境介紹

作業系統

Red Hat Enterprise Linux Server release   7.7 (Maipo)

資料庫版本

Oracle database 19.3

主機名

adg19c

IP地址

192.168.84.99

安裝目錄

/DBSoft/oracle/product/19.3/dbhome_1

資料庫名稱

woo

字符集

AL32UTF8

 

二、           環境準備

2.1.    關閉防火牆

[root@adg19c ~]# systemctl stop firewalld
[root@adg19c ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

2.2.    禁用NetworkManager服務

[root@adg19c ~]# systemctl stop NetworkManager
[root@adg19c ~]# systemctl disable NetworkManager

2.3.    禁用SELINUX

[root@adg19c ~]# setenforce 0
setenforce: SELinux is disabled
[root@adg19c ~]# sed -i "/^SELINUX=/s#enforcing#disabled#" /etc/selinux/config

2.4.    配置HOSTS解析

[root@adg19c ~]# cat >> /etc/hosts <<EOF
> 
> 192.168.84.99        adg19c
> EOF

2.5.    修改主機名

[root@adg19c ~]#sed -i 's#^HOSTNAME=.*$#HOSTNAME=db01#' /etc/sysconfig/network
[root@adg19c ~]# sed -i 's#^NETWORKING_IPV6=.*$#NETWORKING_IPV6=no#' /etc/sysconfig/network

 

2.6.        配置NOZEROCONFIG

[root@adg19c ~]# cat >> /etc/sysconfig/network <<EOF
> NOZEROCONF=yes
> EOF

2.7.    建立組和使用者

# 建立dba和onstall兩個使用者組
[root@adg19c ~]# groupadd -g 501 dba
[root@adg19c ~]# groupadd -g 502 oinstall
 
# 建立oracle使用者
[root@adg19c ~]# useradd -u 503 -g oinstall -G dba oracle
 
# 配置oracle使用者密碼
[root@adg19c ~]# echo "oracle"|passwd --stdin oracle
Changing password for user oracle.
passwd: all authentication tokens updated successfully.

2.8.    建立安裝目錄並賦權

# 建立目錄
[root@adg19c ~]# mkdir -p /DBSoft/oraInventory
[root@adg19c ~]# mkdir -p /DBSoft/oracle/product/19.3/dbhome_1
 
# 賦權
[root@adg19c ~]# chown -R oracle:oinstall /DBSoft
[root@adg19c ~]# chmod -R 775 /DBSoft

2.9.    配置使用者環境變數

[root@adg19c ~]# cat >> /home/oracle/.bash_profile <<EOF
> export TMP=/tmp
> export TMPDIR=\$TMP
> export EDIT=vi
> alias  vi=vim
> export ORACLE_HOSTNAME=$HOST_NAME
> export ORACLE_UNQNAME=woo
> export ORACLE_BASE=/DBSoft/oracle
> export ORACLE_HOME=\$ORACLE_BASE/product/19.3/dbhome_1
> export ORACLE_SID=woo
> export ORACLE_TERM=xterm
> export PATH=/usr/sbin:\$PATH
> export PATH=\$ORACLE_HOME/bin:\$PATH
> export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
> export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
> export NLS_LANG=AMERICAN_AMERICA AL32UTF16
> umask 022
> EOF

2.10. 配置系統環境變數

[root@adg19c ~]#cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then  
    if [ \$SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi
EOF

2.11. 修改系統核心引數

[root@adg19c ~]# cat >> /etc/sysctl.conf <<EOF
> kernel.shmall = 4294967296
> kernel.sem = 5130 65280 510 256
> kernel.shmmni = 4096
> kernel.shmmax = 549755813888             #support max TotalMemory 512GB
> net.ipv4.ip_local_port_range = 9000 65500
> net.core.rmem_default = 1048576
> net.core.rmem_max = 4194304
> net.core.wmem_default = 262144
> net.core.wmem_max = 1048576
> fs.file-max = 6815744
> fs.aio-max-nr = 1048576
> vm.swappiness = 10
> vm.dirty_background_ratio = 20
> vm.dirty_ratio = 80
> vm.dirty_expire_centisecs = 500
> vm.dirty_writeback_centisecs = 100
> net.ipv4.tcp_sack = 0
> net.ipv4.tcp_timestamps = 0
> net.ipv4.conf.default.rp_filter = 0
> net.ipv4.tcp_wmem = 262144
> net.ipv4.tcp_rmem = 4194304
> EOF
 
[root@adg19c ~]# /sbin/sysctl  -p
kernel.shmall = 4294967296
kernel.sem = 5130 65280 510 256
kernel.shmmni = 4096
kernel.shmmax = 549755813888              #support max TotalMemory 512GB
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.file-max = 6815744
fs.aio-max-nr = 1048576
vm.swappiness = 10
vm.dirty_background_ratio = 20
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
net.ipv4.tcp_sack = 0
net.ipv4.tcp_timestamps = 0
net.ipv4.conf.default.rp_filter = 0
net.ipv4.tcp_wmem = 262144
net.ipv4.tcp_rmem = 4194304

2.12. 配置LIMITS限制引數

[root@adg19c ~]# cat >> /etc/security/limits.conf <<EOF
> oracle          soft    nproc           16384
> oracle          hard    nproc           16384
> oracle          soft    nofile          65536
> oracle          hard    nofile          65536
> oracle          soft    memlock         3145728
> oracle          hard    memlock         3145728
> 
> EOF

2.13. 配置PAM驗證

[root@adg19c ~]# cat  >> /etc/pam.d/login <<EOF
> session    required     /lib64/security/pam_limits.so 
> EOF

2.14. 安裝依賴包

2.13.1     掛載系統介質

[root@adg19c ~]# mount /dev/sr0 /mnt/
mount: /dev/sr0 is write-protected, mounting read-only

2.13.2     配置yum包

[root@adg19c ~]# cat > /etc/yum.repos.d/local.repo <<EOF
> [base]
> name=base
> baseurl=file:///mnt
> enabled=1
> gpgcheck=0
> multilib_policy=all
> EOF
[root@adg19c ~]# yum clean all
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Cleaning repos: base
[root@adg19c ~]# yum makecache
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
base                                                                                                           | 2.8 kB  00:00:00    
(1/4): base/group_gz                                                                                           | 103 kB  00:00:00    
(2/4): base/primary                                                                                            | 2.0 MB  00:00:00    
(3/4): base/filelists                                                                                          | 3.1 MB  00:00:00    
(4/4): base/other                                                                                              | 1.1 MB  00:00:00    
base                                                                                                                        5229/5229
base                                                                                                                        5229/5229
base                                                                                                                        5229/5229
Metadata Cache Created2.13.3

[root@adg19c ~]# yum install -y bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat unzip vim
Loaded plugins: product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
base                                                                                                           | 2.8 kB  00:00:00     
(1/2): base/group_gz                                                                                           | 103 kB  00:00:00     
(2/2): base/primary                                                                                            | 2.0 MB  00:00:00     
base                                                                                                                        5229/5229
Package binutils-2.27-41.base.el7.x86_64 already installed and latest version
No package compat-libstdc++ available.
Package elfutils-libelf-0.176-2.el7.x86_64 already installed and latest version
Package glibc-2.17-292.el7.x86_64 already installed and latest version
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Package libgcc-4.8.5-39.el7.x86_64 already installed and latest version
Package libstdc++-4.8.5-39.el7.x86_64 already installed and latest version
Package 1:make-3.82-24.el7.x86_64 already installed and latest version
Package python-2.7.5-86.el7.x86_64 already installed and latest version
Package python-six-1.9.0-2.el7.noarch already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package bc.x86_64 0:1.06.95-13.el7 will be installed
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package elfutils-libelf-devel.x86_64 0:0.176-2.el7 will be installed
--> Processing Dependency: pkgconfig(zlib) for package: elfutils-libelf-devel-0.176-2.el7.x86_64
---> Package fontconfig-devel.x86_64 0:2.13.0-4.3.el7 will be installed
--> Processing Dependency: fontconfig(x86-64) = 2.13.0-4.3.el7 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: pkgconfig(freetype2) >= 20.0.14 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: freetype-devel >= 2.8-7 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: pkgconfig(uuid) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: pkgconfig(expat) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
--> Processing Dependency: libfontconfig.so.1()(64bit) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64
---> Package glibc-devel.x86_64 0:2.17-292.el7 will be installed
--> Processing Dependency: glibc-headers = 2.17-292.el7 for package: glibc-devel-2.17-292.el7.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-292.el7.x86_64
---> Package ksh.x86_64 0:20120801-139.el7 will be installed
---> Package libX11.x86_64 0:1.6.7-2.el7 will be installed
--> Processing Dependency: libX11-common >= 1.6.7-2.el7 for package: libX11-1.6.7-2.el7.x86_64
---> Package libXau.x86_64 0:1.0.8-2.1.el7 will be installed
---> Package libXi.x86_64 0:1.7.9-1.el7 will be installed
--> Processing Dependency: libXext.so.6()(64bit) for package: libXi-1.7.9-1.el7.x86_64
---> Package libXrender.x86_64 0:0.9.10-1.el7 will be installed
---> Package libXrender-devel.x86_64 0:0.9.10-1.el7 will be installed
--> Processing Dependency: pkgconfig(renderproto) >= 0.9 for package: libXrender-devel-0.9.10-1.el7.x86_64
--> Processing Dependency: pkgconfig(xproto) for package: libXrender-devel-0.9.10-1.el7.x86_64
--> Processing Dependency: pkgconfig(x11) for package: libXrender-devel-0.9.10-1.el7.x86_64
---> Package libXtst.x86_64 0:1.2.3-1.el7 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-39.el7 will be installed
---> Package libxcb.x86_64 0:1.13-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
---> Package nfs-utils.x86_64 1:1.3.0-0.65.el7 will be installed
--> Processing Dependency: libtirpc >= 0.2.4-0.7 for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: gssproxy >= 0.7.0-3 for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: rpcbind for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: quota for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: libnfsidmap for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: libevent for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: keyutils for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: libtirpc.so.1()(64bit) for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: libnfsidmap.so.0()(64bit) for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
--> Processing Dependency: libevent-2.0.so.5()(64bit) for package: 1:nfs-utils-1.3.0-0.65.el7.x86_64
---> Package python-configshell.noarch 1:1.1.fb25-1.el7 will be installed
--> Processing Dependency: python-urwid for package: 1:python-configshell-1.1.fb25-1.el7.noarch
--> Processing Dependency: pyparsing for package: 1:python-configshell-1.1.fb25-1.el7.noarch
---> Package python-rtslib.noarch 0:2.1.fb69-3.el7 will be installed
--> Processing Dependency: python-kmod for package: python-rtslib-2.1.fb69-3.el7.noarch
---> Package smartmontools.x86_64 1:7.0-1.el7 will be installed
--> Processing Dependency: mailx for package: 1:smartmontools-7.0-1.el7.x86_64
---> Package sysstat.x86_64 0:10.1.5-18.el7 will be installed
--> Processing Dependency: libsensors.so.4()(64bit) for package: sysstat-10.1.5-18.el7.x86_64
---> Package targetcli.noarch 0:2.1.fb49-1.el7 will be installed
---> Package unzip.x86_64 0:6.0-20.el7 will be installed
---> Package vim-enhanced.x86_64 2:7.4.629-6.el7 will be installed
--> Running transaction check
---> Package expat-devel.x86_64 0:2.1.0-10.el7_3 will be installed
---> Package fontconfig.x86_64 0:2.13.0-4.3.el7 will be installed
--> Processing Dependency: fontpackages-filesystem for package: fontconfig-2.13.0-4.3.el7.x86_64
--> Processing Dependency: dejavu-sans-fonts for package: fontconfig-2.13.0-4.3.el7.x86_64
---> Package freetype-devel.x86_64 0:2.8-14.el7 will be installed
--> Processing Dependency: pkgconfig(libpng) for package: freetype-devel-2.8-14.el7.x86_64
---> Package glibc-headers.x86_64 0:2.17-292.el7 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-292.el7.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-292.el7.x86_64
---> Package gssproxy.x86_64 0:0.7.0-26.el7 will be installed
--> Processing Dependency: libini_config >= 1.3.1-31 for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libverto-module-base for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libref_array.so.1(REF_ARRAY_0.1.1)(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libini_config.so.3(INI_CONFIG_1.2.0)(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libini_config.so.3(INI_CONFIG_1.1.0)(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libref_array.so.1()(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libini_config.so.3()(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libcollection.so.2()(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
--> Processing Dependency: libbasicobjects.so.0()(64bit) for package: gssproxy-0.7.0-26.el7.x86_64
---> Package keyutils.x86_64 0:1.5.8-3.el7 will be installed
---> Package libX11-common.noarch 0:1.6.7-2.el7 will be installed
---> Package libX11-devel.x86_64 0:1.6.7-2.el7 will be installed
--> Processing Dependency: pkgconfig(xcb) >= 1.11.1 for package: libX11-devel-1.6.7-2.el7.x86_64
--> Processing Dependency: pkgconfig(xcb) for package: libX11-devel-1.6.7-2.el7.x86_64
---> Package libXext.x86_64 0:1.3.3-3.el7 will be installed
---> Package libevent.x86_64 0:2.0.21-4.el7 will be installed
---> Package libnfsidmap.x86_64 0:0.25-19.el7 will be installed
---> Package libtirpc.x86_64 0:0.2.4-0.16.el7 will be installed
---> Package libuuid-devel.x86_64 0:2.23.2-61.el7 will be installed
---> Package lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7 will be installed
---> Package mailx.x86_64 0:12.5-19.el7 will be installed
---> Package pyparsing.noarch 0:1.5.6-9.el7 will be installed
---> Package python-kmod.x86_64 0:0.9-4.el7 will be installed
---> Package python-urwid.x86_64 0:1.1.1-3.el7 will be installed
---> Package quota.x86_64 1:4.01-19.el7 will be installed
--> Processing Dependency: quota-nls = 1:4.01-19.el7 for package: 1:quota-4.01-19.el7.x86_64
--> Processing Dependency: tcp_wrappers for package: 1:quota-4.01-19.el7.x86_64
---> Package rpcbind.x86_64 0:0.2.0-48.el7 will be installed
---> Package xorg-x11-proto-devel.noarch 0:2018.4-1.el7 will be installed
---> Package zlib-devel.x86_64 0:1.2.7-18.el7 will be installed
--> Running transaction check
---> Package dejavu-sans-fonts.noarch 0:2.33-6.el7 will be installed
--> Processing Dependency: dejavu-fonts-common = 2.33-6.el7 for package: dejavu-sans-fonts-2.33-6.el7.noarch
---> Package fontpackages-filesystem.noarch 0:1.44-8.el7 will be installed
---> Package kernel-headers.x86_64 0:3.10.0-1062.el7 will be installed
---> Package libbasicobjects.x86_64 0:0.1.1-32.el7 will be installed
---> Package libcollection.x86_64 0:0.7.0-32.el7 will be installed
---> Package libini_config.x86_64 0:1.3.1-32.el7 will be installed
--> Processing Dependency: libpath_utils.so.1(PATH_UTILS_0.2.1)(64bit) for package: libini_config-1.3.1-32.el7.x86_64
--> Processing Dependency: libpath_utils.so.1()(64bit) for package: libini_config-1.3.1-32.el7.x86_64
---> Package libpng-devel.x86_64 2:1.5.13-7.el7_2 will be installed
---> Package libref_array.x86_64 0:0.1.5-32.el7 will be installed
---> Package libverto-libevent.x86_64 0:0.2.5-4.el7 will be installed
---> Package libxcb-devel.x86_64 0:1.13-1.el7 will be installed
--> Processing Dependency: pkgconfig(xau) >= 0.99.2 for package: libxcb-devel-1.13-1.el7.x86_64
---> Package quota-nls.noarch 1:4.01-19.el7 will be installed
---> Package tcp_wrappers.x86_64 0:7.6-77.el7 will be installed
--> Running transaction check
---> Package dejavu-fonts-common.noarch 0:2.33-6.el7 will be installed
---> Package libXau-devel.x86_64 0:1.0.8-2.1.el7 will be installed
---> Package libpath_utils.x86_64 0:0.2.1-32.el7 will be installed
--> Finished Dependency Resolution
 
Dependencies Resolved
 
======================================================================================================================================
 Package                                Arch                  Version                                       Repository           Size
======================================================================================================================================
Installing:
 bc                                     x86_64                1.06.95-13.el7                                base                115 k
 compat-libcap1                         x86_64                1.10-7.el7                                    base                 19 k
 elfutils-libelf-devel                  x86_64                0.176-2.el7                                   base                 39 k
 fontconfig-devel                       x86_64                2.13.0-4.3.el7                                base                138 k
 glibc-devel                            x86_64                2.17-292.el7                                  base                1.1 M
 ksh                                    x86_64                20120801-139.el7                              base                885 k
 libX11                                 x86_64                1.6.7-2.el7                                   base                607 k
 libXau                                 x86_64                1.0.8-2.1.el7                                 base                 29 k
 libXi                                  x86_64                1.7.9-1.el7                                   base                 40 k
 libXrender                             x86_64                0.9.10-1.el7                                  base                 26 k
 libXrender-devel                       x86_64                0.9.10-1.el7                                  base                 17 k
 libXtst                                x86_64                1.2.3-1.el7                                   base                 20 k
 libaio-devel                           x86_64                0.3.109-13.el7                                base                 13 k
 libstdc++-devel                        x86_64                4.8.5-39.el7                                  base                1.5 M
 libxcb                                 x86_64                1.13-1.el7                                    base                214 k
 net-tools                              x86_64                2.0-0.25.20131004git.el7                      base                306 k
 nfs-utils                              x86_64                1:1.3.0-0.65.el7                              base                412 k
 python-configshell                     noarch                1:1.1.fb25-1.el7                              base                 68 k
 python-rtslib                          noarch                2.1.fb69-3.el7                                base                102 k
 smartmontools                          x86_64                1:7.0-1.el7                                   base                546 k
 sysstat                                x86_64                10.1.5-18.el7                                 base                316 k
 targetcli                              noarch                2.1.fb49-1.el7                                base                 68 k
 unzip                                  x86_64                6.0-20.el7                                    base                170 k
 vim-enhanced                           x86_64                2:7.4.629-6.el7                               base                1.1 M
Installing for dependencies:
 dejavu-fonts-common                    noarch                2.33-6.el7                                    base                 64 k
 dejavu-sans-fonts                      noarch                2.33-6.el7                                    base                1.4 M
 expat-devel                            x86_64                2.1.0-10.el7_3                                base                 57 k
 fontconfig                             x86_64                2.13.0-4.3.el7                                base                254 k
 fontpackages-filesystem                noarch                1.44-8.el7                                    base                9.9 k
 freetype-devel                         x86_64                2.8-14.el7                                    base                447 k
 glibc-headers                          x86_64                2.17-292.el7                                  base                687 k
 gssproxy                               x86_64                0.7.0-26.el7                                  base                110 k
 kernel-headers                         x86_64                3.10.0-1062.el7                               base                8.7 M
 keyutils                               x86_64                1.5.8-3.el7                                   base                 54 k
 libX11-common                          noarch                1.6.7-2.el7                                   base                164 k
 libX11-devel                           x86_64                1.6.7-2.el7                                   base                981 k
 libXau-devel                           x86_64                1.0.8-2.1.el7                                 base                 14 k
 libXext                                x86_64                1.3.3-3.el7                                   base                 39 k
 libbasicobjects                        x86_64                0.1.1-32.el7                                  base                 26 k
 libcollection                          x86_64                0.7.0-32.el7                                  base                 42 k
 libevent                               x86_64                2.0.21-4.el7                                  base                214 k
 libini_config                          x86_64                1.3.1-32.el7                                  base                 64 k
 libnfsidmap                            x86_64                0.25-19.el7                                   base                 50 k
 libpath_utils                          x86_64                0.2.1-32.el7                                  base                 28 k
 libpng-devel                           x86_64                2:1.5.13-7.el7_2                              base                122 k
 libref_array                           x86_64                0.1.5-32.el7                                  base                 27 k
 libtirpc                               x86_64                0.2.4-0.16.el7                                base                 89 k
 libuuid-devel                          x86_64                2.23.2-61.el7                                 base                 92 k
 libverto-libevent                      x86_64                0.2.5-4.el7                                   base                8.9 k
 libxcb-devel                           x86_64                1.13-1.el7                                    base                1.1 M
 lm_sensors-libs                        x86_64                3.4.0-8.20160601gitf9185e5.el7                base                 42 k
 mailx                                  x86_64                12.5-19.el7                                   base                245 k
 pyparsing                              noarch                1.5.6-9.el7                                   base                 94 k
 python-kmod                            x86_64                0.9-4.el7                                     base                 57 k
 python-urwid                           x86_64                1.1.1-3.el7                                   base                654 k
 quota                                  x86_64                1:4.01-19.el7                                 base                179 k
 quota-nls                              noarch                1:4.01-19.el7                                 base                 90 k
 rpcbind                                x86_64                0.2.0-48.el7                                  base                 60 k
 tcp_wrappers                           x86_64                7.6-77.el7                                    base                 79 k
 xorg-x11-proto-devel                   noarch                2018.4-1.el7                                  base                279 k
 zlib-devel                             x86_64                1.2.7-18.el7                                  base                 50 k
 
Transaction Summary
======================================================================================================================================
Install  24 Packages (+37 Dependent packages)
 
Total download size: 24 M
Installed size: 53 M
Downloading packages:
--------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                 108 MB/s |  24 MB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : xorg-x11-proto-devel-2018.4-1.el7.noarch                                                                          1/61 
  Installing : zlib-devel-1.2.7-18.el7.x86_64                                                                                    2/61 
  Installing : libcollection-0.7.0-32.el7.x86_64                                                                                 3/61 
  Installing : libXau-1.0.8-2.1.el7.x86_64                                                                                       4/61 
  Installing : libxcb-1.13-1.el7.x86_64                                                                                          5/61 
  Installing : libref_array-0.1.5-32.el7.x86_64                                                                                  6/61 
  Installing : libevent-2.0.21-4.el7.x86_64                                                                                      7/61 
  Installing : fontpackages-filesystem-1.44-8.el7.noarch                                                                         8/61 
  Installing : libbasicobjects-0.1.1-32.el7.x86_64                                                                               9/61 
  Installing : libtirpc-0.2.4-0.16.el7.x86_64                                                                                   10/61 
  Installing : rpcbind-0.2.0-48.el7.x86_64                                                                                      11/61 
  Installing : dejavu-fonts-common-2.33-6.el7.noarch                                                                            12/61 
  Installing : dejavu-sans-fonts-2.33-6.el7.noarch                                                                              13/61 
  Installing : fontconfig-2.13.0-4.3.el7.x86_64                                                                                 14/61 
  Installing : libverto-libevent-0.2.5-4.el7.x86_64                                                                             15/61 
  Installing : libXau-devel-1.0.8-2.1.el7.x86_64                                                                                16/61 
  Installing : libxcb-devel-1.13-1.el7.x86_64                                                                                   17/61 
  Installing : 2:libpng-devel-1.5.13-7.el7_2.x86_64                                                                             18/61 
  Installing : freetype-devel-2.8-14.el7.x86_64                                                                                 19/61 
  Installing : expat-devel-2.1.0-10.el7_3.x86_64                                                                                20/61 
  Installing : mailx-12.5-19.el7.x86_64                                                                                         21/61 
  Installing : 1:quota-nls-4.01-19.el7.noarch                                                                                   22/61 
  Installing : libnfsidmap-0.25-19.el7.x86_64                                                                                   23/61 
  Installing : keyutils-1.5.8-3.el7.x86_64                                                                                      24/61 
  Installing : libpath_utils-0.2.1-32.el7.x86_64                                                                                25/61 
  Installing : libini_config-1.3.1-32.el7.x86_64                                                                                26/61 
  Installing : gssproxy-0.7.0-26.el7.x86_64                                                                                     27/61 
  Installing : python-kmod-0.9-4.el7.x86_64                                                                                     28/61 
  Installing : python-rtslib-2.1.fb69-3.el7.noarch                                                                              29/61 
  Installing : python-urwid-1.1.1-3.el7.x86_64                                                                                  30/61 
  Installing : libX11-common-1.6.7-2.el7.noarch                                                                                 31/61 
  Installing : libX11-1.6.7-2.el7.x86_64                                                                                        32/61 
  Installing : libXext-1.3.3-3.el7.x86_64                                                                                       33/61 
  Installing : libXi-1.7.9-1.el7.x86_64                                                                                         34/61 
  Installing : libX11-devel-1.6.7-2.el7.x86_64                                                                                  35/61 
  Installing : libXrender-0.9.10-1.el7.x86_64                                                                                   36/61 
  Installing : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64                                                            37/61 
  Installing : tcp_wrappers-7.6-77.el7.x86_64                                                                                   38/61 
  Installing : 1:quota-4.01-19.el7.x86_64                                                                                       39/61 
  Installing : pyparsing-1.5.6-9.el7.noarch                                                                                     40/61 
  Installing : 1:python-configshell-1.1.fb25-1.el7.noarch                                                                       41/61 
  Installing : kernel-headers-3.10.0-1062.el7.x86_64                                                                            42/61 
  Installing : glibc-headers-2.17-292.el7.x86_64                                                                                43/61 
  Installing : libuuid-devel-2.23.2-61.el7.x86_64                                                                               44/61 
  Installing : fontconfig-devel-2.13.0-4.3.el7.x86_64                                                                           45/61 
  Installing : glibc-devel-2.17-292.el7.x86_64                                                                                  46/61 
  Installing : targetcli-2.1.fb49-1.el7.noarch                                                                                  47/61 
  Installing : 1:nfs-utils-1.3.0-0.65.el7.x86_64                                                                                48/61 
  Installing : sysstat-10.1.5-18.el7.x86_64                                                                                     49/61 
  Installing : libXrender-devel-0.9.10-1.el7.x86_64                                                                             50/61 
  Installing : libXtst-1.2.3-1.el7.x86_64                                                                                       51/61 
  Installing : 1:smartmontools-7.0-1.el7.x86_64                                                                                 52/61 
  Installing : elfutils-libelf-devel-0.176-2.el7.x86_64                                                                         53/61 
  Installing : libaio-devel-0.3.109-13.el7.x86_64                                                                               54/61 
  Installing : compat-libcap1-1.10-7.el7.x86_64                                                                                 55/61 
  Installing : ksh-20120801-139.el7.x86_64                                                                                      56/61 
  Installing : 2:vim-enhanced-7.4.629-6.el7.x86_64                                                                              57/61 
  Installing : libstdc++-devel-4.8.5-39.el7.x86_64                                                                              58/61 
  Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                        59/61 
  Installing : bc-1.06.95-13.el7.x86_64                                                                                         60/61 
  Installing : unzip-6.0-20.el7.x86_64                                                                                          61/61 
  Verifying  : libXext-1.3.3-3.el7.x86_64                                                                                        1/61 
  Verifying  : libtirpc-0.2.4-0.16.el7.x86_64                                                                                    2/61 
  Verifying  : libXi-1.7.9-1.el7.x86_64                                                                                          3/61 
  Verifying  : libX11-devel-1.6.7-2.el7.x86_64                                                                                   4/61 
  Verifying  : fontconfig-2.13.0-4.3.el7.x86_64                                                                                  5/61 
  Verifying  : 2:libpng-devel-1.5.13-7.el7_2.x86_64                                                                              6/61 
  Verifying  : libXrender-0.9.10-1.el7.x86_64                                                                                    7/61 
  Verifying  : libuuid-devel-2.23.2-61.el7.x86_64                                                                                8/61 
  Verifying  : 1:nfs-utils-1.3.0-0.65.el7.x86_64                                                                                 9/61 
  Verifying  : kernel-headers-3.10.0-1062.el7.x86_64                                                                            10/61 
  Verifying  : libbasicobjects-0.1.1-32.el7.x86_64                                                                              11/61 
  Verifying  : unzip-6.0-20.el7.x86_64                                                                                          12/61 
  Verifying  : pyparsing-1.5.6-9.el7.noarch                                                                                     13/61 
  Verifying  : fontpackages-filesystem-1.44-8.el7.noarch                                                                        14/61 
  Verifying  : bc-1.06.95-13.el7.x86_64                                                                                         15/61 
  Verifying  : fontconfig-devel-2.13.0-4.3.el7.x86_64                                                                           16/61 
  Verifying  : tcp_wrappers-7.6-77.el7.x86_64                                                                                   17/61 
  Verifying  : zlib-devel-1.2.7-18.el7.x86_64                                                                                   18/61 
  Verifying  : xorg-x11-proto-devel-2018.4-1.el7.noarch                                                                         19/61 
  Verifying  : dejavu-fonts-common-2.33-6.el7.noarch                                                                            20/61 
  Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                        21/61 
  Verifying  : libXtst-1.2.3-1.el7.x86_64                                                                                       22/61 
  Verifying  : libX11-1.6.7-2.el7.x86_64                                                                                        23/61 
  Verifying  : targetcli-2.1.fb49-1.el7.noarch                                                                                  24/61 
  Verifying  : libxcb-1.13-1.el7.x86_64                                                                                         25/61 
  Verifying  : freetype-devel-2.8-14.el7.x86_64                                                                                 26/61 
  Verifying  : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64                                                            27/61 
  Verifying  : libstdc++-devel-4.8.5-39.el7.x86_64                                                                              28/61 
  Verifying  : libini_config-1.3.1-32.el7.x86_64                                                                                29/61 
  Verifying  : libX11-common-1.6.7-2.el7.noarch                                                                                 30/61 
  Verifying  : libXrender-devel-0.9.10-1.el7.x86_64                                                                             31/61 
  Verifying  : 2:vim-enhanced-7.4.629-6.el7.x86_64                                                                              32/61 
  Verifying  : python-urwid-1.1.1-3.el7.x86_64                                                                                  33/61 
  Verifying  : sysstat-10.1.5-18.el7.x86_64                                                                                     34/61 
  Verifying  : ksh-20120801-139.el7.x86_64                                                                                      35/61 
  Verifying  : libevent-2.0.21-4.el7.x86_64                                                                                     36/61 
  Verifying  : elfutils-libelf-devel-0.176-2.el7.x86_64                                                                         37/61 
  Verifying  : libverto-libevent-0.2.5-4.el7.x86_64                                                                             38/61 
  Verifying  : dejavu-sans-fonts-2.33-6.el7.noarch                                                                              39/61 
  Verifying  : compat-libcap1-1.10-7.el7.x86_64                                                                                 40/61 
  Verifying  : libaio-devel-0.3.109-13.el7.x86_64                                                                               41/61 
  Verifying  : 1:python-configshell-1.1.fb25-1.el7.noarch                                                                       42/61 
  Verifying  : libref_array-0.1.5-32.el7.x86_64                                                                                 43/61 
  Verifying  : rpcbind-0.2.0-48.el7.x86_64                                                                                      44/61 
  Verifying  : python-kmod-0.9-4.el7.x86_64                                                                                     45/61 
  Verifying  : glibc-devel-2.17-292.el7.x86_64                                                                                  46/61 
  Verifying  : libpath_utils-0.2.1-32.el7.x86_64                                                                                47/61 
  Verifying  : 1:quota-4.01-19.el7.x86_64                                                                                       48/61 
  Verifying  : libxcb-devel-1.13-1.el7.x86_64                                                                                   49/61 
  Verifying  : gssproxy-0.7.0-26.el7.x86_64                                                                                     50/61 
  Verifying  : libXau-1.0.8-2.1.el7.x86_64                                                                                      51/61 
  Verifying  : 1:smartmontools-7.0-1.el7.x86_64                                                                                 52/61 
  Verifying  : libcollection-0.7.0-32.el7.x86_64                                                                                53/61 
  Verifying  : keyutils-1.5.8-3.el7.x86_64                                                                                      54/61 
  Verifying  : libnfsidmap-0.25-19.el7.x86_64                                                                                   55/61 
  Verifying  : 1:quota-nls-4.01-19.el7.noarch                                                                                   56/61 
  Verifying  : python-rtslib-2.1.fb69-3.el7.noarch                                                                              57/61 
  Verifying  : mailx-12.5-19.el7.x86_64                                                                                         58/61 
  Verifying  : expat-devel-2.1.0-10.el7_3.x86_64                                                                                59/61 
  Verifying  : glibc-headers-2.17-292.el7.x86_64                                                                                60/61 
  Verifying  : libXau-devel-1.0.8-2.1.el7.x86_64                                                                                61/61 
 
Installed:
  bc.x86_64 0:1.06.95-13.el7                    compat-libcap1.x86_64 0:1.10-7.el7       elfutils-libelf-devel.x86_64 0:0.176-2.el7  
  fontconfig-devel.x86_64 0:2.13.0-4.3.el7      glibc-devel.x86_64 0:2.17-292.el7        ksh.x86_64 0:20120801-139.el7               
  libX11.x86_64 0:1.6.7-2.el7                   libXau.x86_64 0:1.0.8-2.1.el7            libXi.x86_64 0:1.7.9-1.el7                  
  libXrender.x86_64 0:0.9.10-1.el7              libXrender-devel.x86_64 0:0.9.10-1.el7   libXtst.x86_64 0:1.2.3-1.el7                
  libaio-devel.x86_64 0:0.3.109-13.el7          libstdc++-devel.x86_64 0:4.8.5-39.el7    libxcb.x86_64 0:1.13-1.el7                  
  net-tools.x86_64 0:2.0-0.25.20131004git.el7   nfs-utils.x86_64 1:1.3.0-0.65.el7        python-configshell.noarch 1:1.1.fb25-1.el7  
  python-rtslib.noarch 0:2.1.fb69-3.el7         smartmontools.x86_64 1:7.0-1.el7         sysstat.x86_64 0:10.1.5-18.el7              
  targetcli.noarch 0:2.1.fb49-1.el7             unzip.x86_64 0:6.0-20.el7                vim-enhanced.x86_64 2:7.4.629-6.el7         
 
Dependency Installed:
  dejavu-fonts-common.noarch 0:2.33-6.el7                                  dejavu-sans-fonts.noarch 0:2.33-6.el7                      
  expat-devel.x86_64 0:2.1.0-10.el7_3                                      fontconfig.x86_64 0:2.13.0-4.3.el7                         
  fontpackages-filesystem.noarch 0:1.44-8.el7                              freetype-devel.x86_64 0:2.8-14.el7                         
  glibc-headers.x86_64 0:2.17-292.el7                                      gssproxy.x86_64 0:0.7.0-26.el7                             
  kernel-headers.x86_64 0:3.10.0-1062.el7                                  keyutils.x86_64 0:1.5.8-3.el7                              
  libX11-common.noarch 0:1.6.7-2.el7                                       libX11-devel.x86_64 0:1.6.7-2.el7                          
  libXau-devel.x86_64 0:1.0.8-2.1.el7                                      libXext.x86_64 0:1.3.3-3.el7                               
  libbasicobjects.x86_64 0:0.1.1-32.el7                                    libcollection.x86_64 0:0.7.0-32.el7                        
  libevent.x86_64 0:2.0.21-4.el7                                           libini_config.x86_64 0:1.3.1-32.el7                        
  libnfsidmap.x86_64 0:0.25-19.el7                                         libpath_utils.x86_64 0:0.2.1-32.el7                        
  libpng-devel.x86_64 2:1.5.13-7.el7_2                                     libref_array.x86_64 0:0.1.5-32.el7                         
  libtirpc.x86_64 0:0.2.4-0.16.el7                                         libuuid-devel.x86_64 0:2.23.2-61.el7                       
  libverto-libevent.x86_64 0:0.2.5-4.el7                                   libxcb-devel.x86_64 0:1.13-1.el7                           
  lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7                  mailx.x86_64 0:12.5-19.el7                                 
  pyparsing.noarch 0:1.5.6-9.el7                                           python-kmod.x86_64 0:0.9-4.el7                             
  python-urwid.x86_64 0:1.1.1-3.el7                                        quota.x86_64 1:4.01-19.el7                                 
  quota-nls.noarch 1:4.01-19.el7                                           rpcbind.x86_64 0:0.2.0-48.el7                              
  tcp_wrappers.x86_64 0:7.6-77.el7                                         xorg-x11-proto-devel.noarch 0:2018.4-1.el7                 
  zlib-devel.x86_64 0:1.2.7-18.el7                                        
 
Complete!

2.13.4     安裝compat-libstdc++

[root@adg19c ~]# rpm -ivh /home/oracle/compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm 
warning: /home/oracle/compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:compat-libstdc++-33-3.2.3-69.el6 ################################# [100%]

備註:這個包在RHEL 7的系統盤裡面沒有,需要單獨下載後手工安裝。

2.13.5     檢查已安裝依賴包

[root@adg19c ~]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat unzip vim 
bc-1.06.95-13.el7 (x86_64)
binutils-2.27-41.base.el7 (x86_64)
compat-libcap1-1.10-7.el7 (x86_64)
package compat-libstdc++ is not installed  --只要安裝了這個報錯沒有關係。
elfutils-libelf-0.176-2.el7 (x86_64)
elfutils-libelf-devel-0.176-2.el7 (x86_64)
fontconfig-devel-2.13.0-4.3.el7 (x86_64)
glibc-2.17-292.el7 (x86_64)
glibc-devel-2.17-292.el7 (x86_64)
ksh-20120801-139.el7 (x86_64)
libaio-0.3.109-13.el7 (x86_64)
libaio-devel-0.3.109-13.el7 (x86_64)
libX11-1.6.7-2.el7 (x86_64)
libXau-1.0.8-2.1.el7 (x86_64)
libXi-1.7.9-1.el7 (x86_64)
libXtst-1.2.3-1.el7 (x86_64)
libXrender-0.9.10-1.el7 (x86_64)
libXrender-devel-0.9.10-1.el7 (x86_64)
libgcc-4.8.5-39.el7 (x86_64)
libstdc++-4.8.5-39.el7 (x86_64)
libstdc++-devel-4.8.5-39.el7 (x86_64)
libxcb-1.13-1.el7 (x86_64)
make-3.82-24.el7 (x86_64)
net-tools-2.0-0.25.20131004git.el7 (x86_64)
nfs-utils-1.3.0-0.65.el7 (x86_64)
python-2.7.5-86.el7 (x86_64)
python-configshell-1.1.fb25-1.el7 (noarch)
python-rtslib-2.1.fb69-3.el7 (noarch)
python-six-1.9.0-2.el7 (noarch)
targetcli-2.1.fb49-1.el7 (noarch)
smartmontools-7.0-1.el7 (x86_64)
sysstat-10.1.5-18.el7 (x86_64)
unzip-6.0-20.el7 (x86_64)

三、           安裝軟體

3.1.         解壓資料庫軟體

[oracle@adg19c ~]$ unzip -q LINUX.X64_193000_db_home.zip  -d $ORACLE_HOME
[oracle@adg19c ~]$ du -sh $ORACLE_HOME
6.5G    /DBSoft/oracle/product/19.3/dbhome_1

3.2.    開始安裝資料庫 軟體

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝


19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝



3.3.    3.3 執行root.sh指令碼

[root@adg19c ~]# /DBSoft/oraInventory/orainstRoot.sh 
Changing permissions of /DBSoft/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
 
Changing groupname of /DBSoft/oraInventory to oinstall.
The execution of the script is complete.
 
[root@adg19c ~]# /DBSoft/oracle/product/19.3/dbhome_1/root.sh
Performing root user operation.
 
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /DBSoft/oracle/product/19.3/dbhome_1
 
Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...
 
 
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
    /DBSoft/oracle/product/19.3/dbhome_1/bin/tfactl
 
Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed

四、      建立監聽

19c(19.3) 單機資料庫安裝

  19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝



五、      建立資料庫

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝

19c(19.3) 單機資料庫安裝


六、      建立一個PDBs

[oracle@adg19c ~]$ sqlplus / as sysdba
 
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 12 06:43:25 2020
Version 19.3.0.0.0
 
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
 
SQL> show pdbs;
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
 
SQL> create pluggable database pdbwoo from pdb file_name_convert=('pdb/','pdbwoo/');
 
Pluggable database created.
 
SQL> show pdbs;
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
         4 PDBWOO                         MOUNTED
 
SQL> alter pluggable database all save state;
 
Pluggable database altered.
 
SQL> show pdbs;
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO
         4 PDBWOO                         READ WRITE NO

七、      檢查監聽註冊狀態

[oracle@adg19c ~]$ lsnrctl status
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-MAR-2020 06:53:55
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adg19c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                12-MAR-2020 06:17:19
Uptime                    0 days 0 hr. 36 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /DBSoft/oracle/product/19.3/dbhome_1/network/admin/listener.ora
Listener Log File         /DBSoft/oracle/diag/tnslsnr/adg19c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adg19c)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=adg19c)(PORT=5500))(Security=(my_wallet_directory=/DBSoft/oracle/admin/woo/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
Service "a09cefc7b6a2b892e0536354a8c08331" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
Service "a09cfefe92a3b95de0536354a8c024a2" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
Service "pdb" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
Service "pdbwoo" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
Service "woo" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
Service "wooXDB" has 1 instance(s).
  Instance "woo", status READY, has 1 handler(s) for this service...
The command completed successfully


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-2679714/,如需轉載,請註明出處,否則將追究法律責任。

相關文章