OEL7.6安裝Oracle Database 19C（VERSION 19.3.0.0）

1.eDelivery中下載Oracle Database 19C和Oel的安裝介質，並安裝好操作系統

2.安裝Oracle環境準備工具

環境準備工具會自動完成用戶和用戶組的創建、系統參數配置、依賴包檢查與安裝，實現一鍵準備好oracle安裝環境

[root@localhost ~]# yum -y install oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 will be installed
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-1.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-1.el7.x86_64

(many more lines suppressed)

Installed:
  oracle-database-preinstall-19c.x86_64 0:1.0-1.el7                                                

Dependency Installed:
  compat-libcap1.x86_64 0:1.10-7.el7              compat-libstdc++-33.x86_64 0:3.2.3-72.el7        
  glibc-devel.x86_64 0:2.17-260.0.17.el7_6.6      glibc-headers.x86_64 0:2.17-260.0.17.el7_6.6     
  kernel-headers.x86_64 0:3.10.0-957.21.3.el7     ksh.x86_64 0:20120801-139.0.1.el7                
  libaio-devel.x86_64 0:0.3.109-13.el7            libstdc++-devel.x86_64 0:4.8.5-36.0.1.el7_6.2    

Dependency Updated:
  glibc.x86_64 0:2.17-260.0.17.el7_6.6           glibc-common.x86_64 0:2.17-260.0.17.el7_6.6       
  libstdc++.x86_64 0:4.8.5-36.0.1.el7_6.2       

Complete!
[root@localhost ~]# 

3.創建目錄

[root@localhost ~]# mkdir -p /u01/app/oraInventory
[root@localhost ~]# mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
[root@localhost ~]# chown -R oracle: /u01/app/oraInventory
[root@localhost ~]# chown -R oracle: /u01/app/oracle
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ unzip -q /stage/db/V982063-01.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@localhost ~]$ 

4.開始安裝

[oracle@localhost ~]$ unzip -q /stage/db/V982063-01.zip -d /u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1
[oracle@localhost ~]$ export DISPLAY=10.0.0.1:0.0
[oracle@localhost ~]$ /u01/app/oracle/product/19.3.0/dbhome_1/runInstaller 

選擇”Create and configure a single instance database”

選擇”Server class”來獲得更多高級選項選擇企業版選擇oracle base目錄選擇inventory目錄選擇一般資料庫填寫資料庫名，保持orcl不變選擇記憶體大小選擇數據文件存訪路徑不用oem測試用途，不用恢復區設置資料庫密碼查用戶和用戶組輸入系統密碼，自動執行root腳本

預檢查點擊安裝

安裝開始

點擊yes以繼續，讓安裝程式自動執行root腳本

[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1
[oracle@localhost ~]$ export ORACLE_BASE=/u01/app/oracle/
[oracle@localhost ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 25 17:59:11 2019
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 ORCLPDB                        READ WRITE NO
SQL> 

可以玩玩19C有啥新特性了

註意從Oracle 18c開始，在安裝資料庫軟體時，需要把壓縮文件解壓到 $ORACLE_HOME 路徑下，在此目錄下運行 ./runInstaller

保存下相應文件，以備後查

[root@localhost db]# cat db.rsp |grep -v ^#|grep -v ^$
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_AND_CONFIG
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_BASE=/u01/app/oracle
      
                               
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oper
oracle.install.db.OSBACKUPDBA_GROUP=backupdba
oracle.install.db.OSDGDBA_GROUP=dgdba
oracle.install.db.OSKMDBA_GROUP=kmdba
oracle.install.db.OSRACDBA_GROUP=racdba
oracle.install.db.rootconfig.executeRootScript=true
oracle.install.db.rootconfig.configMethod=ROOT
oracle.install.db.rootconfig.sudoPath=
oracle.install.db.rootconfig.sudoUserName=
oracle.install.db.CLUSTER_NODES=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.ConfigureAsContainerDB=true
oracle.install.db.config.PDBName=orclpdb
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=1471
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.password.PDBADMIN=
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=0
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=
oracle.install.db.config.starterdb.enableRecovery=false
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
[root@localhost db]#