19c相关技术文档
Oracle 18c 相当于 12.2.0.2
Oracle 19c 相当于 12.2.0.3
https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html Release Schedule of Current Database Releases (文档 ID 742060.1)
19c的安装，支持图形、命令行、静默安装和RPM安装
19c的RPM包下载链接：
https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html
Oracle Text需要的compat-libstdc++-33下载地址： http://www.rpmfind.net/linux/rpm2html/search.php?query=compat-libstdc%2B%2B-33(x86-64)
通过RPM安装19c数据库，只需要两步操作。
安装用户root，安装包大小2.5G，需要的空间根目录大小6.9G，数据库默认位置/opt/oracle/oradata
步骤1：安装oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
步骤2：安装oracle-database-ee-19c-1.0-1.x86_64.rpm
软件安装完成后，创建数据库：
/etc/init.d/oracledb_ORCLCDB-19c configure
创建数据库的脚本时，遇到错误。
以下这个脚本用于初始化一个数据库：
/etc/init.d/oracledb_ORCLCDB-19c configure
遇到的错误是 DBT-00006 ：
[root@sdb2 ~]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
[FATAL] [INS-00001] Unknown irrecoverable error
CAUSE: No additional information available.
ACTION: Refer to the logs or contact Oracle Support Services
SUMMARY:
- [DBT-00006] The logging directory could not be created.
- [DBT-00006] The logging directory could not be created.
Database configuration failed.
sqlplus / as sysdba
sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /opt/oracle/product/19c/dbhome_1/lib/libclntsh.so.19.1)
将 glibc 从 2.12 更新到 2.14
glibc-2.14.1-6.x86_64.rpm
glibc-common-2.14.1-6.x86_64.rpm
glibc-devel-2.14.1-6.x86_64.rpm
glibc-headers-2.14.1-6.x86_64.rpm
ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/fedora/linux/updates/15/x86_64/
wget ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/fedora/linux/updates/15/x86_64/glibc-2.14.1-6.x86_64.rpm
wget ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/fedora/linux/updates/15/x86_64/glibc-common-2.14.1-6.x86_64.rpm
wget ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/fedora/linux/updates/15/x86_64/glibc-devel-2.14.1-6.x86_64.rpm
wget ftp://ftp.pbone.net/mirror/archive.fedoraproject.org/fedora/linux/updates/15/x86_64/glibc-headers-2.14.1-6.x86_64.rpm
rpm -Fhv glibc*rpm
升级到 Glibc 2.17:
wget http://copr-be.cloud.fedoraproject.org/results/mosquito/myrepo-el6/epel-6-x86_64/glibc-2.17-55.fc20/glibc-2.17-55.el6.x86_64.rpm
wget http://copr-be.cloud.fedoraproject.org/results/mosquito/myrepo-el6/epel-6-x86_64/glibc-2.17-55.fc20/glibc-common-2.17-55.el6.x86_64.rpm
wget http://copr-be.cloud.fedoraproject.org/results/mosquito/myrepo-el6/epel-6-x86_64/glibc-2.17-55.fc20/glibc-devel-2.17-55.el6.x86_64.rpm
wget http://copr-be.cloud.fedoraproject.org/results/mosquito/myrepo-el6/epel-6-x86_64/glibc-2.17-55.fc20/glibc-headers-2.17-55.el6.x86_64.rpm
修改ORACLE用户环境变量：
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ORCLCDB
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin
-----------------
使用dbca建立一个 12.2非多租户的数据库：
[oracle12c@iz2zeezinabu7k6olgelwez ~]$
dbca -silent -createDatabase \
> -templateName General_Purpose.dbc \
> -gdbname demo -sid demo -responseFile NO_VALUE \
> -characterSet AL32UTF8 \
> -sysPassword OraPasswd1 \
> -systemPassword OraPasswd1 \
> -createAsContainerDatabase false \
> -databaseType MULTIPURPOSE \
> -automaticMemoryManagement false \
> -totalMemory 1536 \
> -storageType FS \
> -datafileDestination "/u01/oracle12c/db/oradata/" \
> -redoLogFileSize 50 \
> -emConfiguration NONE \
> -ignorePreReqs
多租户数据库，增加几个参数如下：
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname cdb01 -sid cdb01 -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword OraPasswd1 \
-systemPassword OraPasswd1 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName pdb1 \
-pdbAdminPassword OraPasswd1 \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1536 \
-storageType FS \
-datafileDestination "/u01/app/oracle/oradata/" \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs