19c(19.3) 單機資料庫安裝
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. 開始安裝資料庫 軟體
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
四、 建立監聽
五、 建立資料庫
六、 建立一個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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 19c(19.3) 單機資料庫靜默安裝資料庫
- 19c(19.3) RPM方式單機資料庫安裝資料庫
- 19C 單例項資料庫安裝單例資料庫
- ClickHouse資料庫單機安裝及備份恢復資料庫
- RedHat 7.7 平臺安裝19c(19.3) RAC 詳細操作過程Redhat
- RedHat 7.7 平臺安裝19c(19.3) RAC 靜默詳細操作過程Redhat
- 使用ansible-playbook自動化安裝Oracle DG資料庫19cOracle資料庫
- centos 7.4靜默安裝oracle 19.3CentOSOracle
- MongoDB資料庫安裝MongoDB資料庫
- Redis 資料庫安裝Redis資料庫
- oricle資料庫安裝資料庫
- GreenPlum資料庫安裝資料庫
- Oracle 11G資料庫單例項安裝Oracle資料庫單例
- 華為GaussDB資料庫（單機版）在ARM環境下的安裝指南資料庫
- oracle 11g 單例項資料庫的安裝Oracle單例資料庫
- Oracle 資料庫打包安裝Oracle資料庫
- Ubuntu安裝MySQL資料庫UbuntuMySql資料庫
- tar方式安裝資料庫資料庫
- 達夢資料庫安裝資料庫
- 「Oracle」Oracle 資料庫安裝Oracle資料庫
- Hbase資料庫安裝部署資料庫
- Oracle 19.3資料庫impdp匯入view時hang住Oracle資料庫View
- oracle 19c 安裝、解除安裝Oracle
- PostgreSQL 資料庫學習 - 0. 資料庫安裝SQL資料庫
- 達夢8資料庫安裝和解除安裝資料庫
- oracle rac資料庫的安裝Oracle資料庫
- 講解Linux資料庫安裝Linux資料庫
- Linux下安裝Mysql資料庫LinuxMySql資料庫
- vgant 安裝oracle資料庫racOracle資料庫
- 安裝MySQL8資料庫MySql資料庫
- sqlserver資料庫下載安裝SQLServer資料庫
- Linux安裝MariaDB資料庫-1Linux資料庫
- 1. PostgreSQL 資料庫安裝SQL資料庫
- 安裝RAC 19C
- 19c安裝配置
- kubernetes單機安裝
- Zookeeper單機安裝
- 【PG資料庫】PG資料庫的安裝及連線方法資料庫