Euler OS 欧拉系统安装oracle 19c记录

欧拉系统安装oracle 19c记录https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm[oracle@openEuler01 dbs]$ cat /etc/openEuler-releaseopenEuler

lq2003

7861人浏览 · 2021-11-15 17:40:34

lq2003 · 2021-11-15 17:40:34 发布

欧拉系统安装oracle 19c记录

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

[oracle@openEuler01 dbs]$ cat /etc/openEuler-release
openEuler release 20.03 (LTS-SP1)

[oracle@openEuler01 dbs]$ cat /etc/redhat-release
####---Red Hat Enterprise Linux release 8.0 (Ootpa)
CentOS Linux release 7.5.1804 (Core)

错误1：

[root@openEuler01 opt]# rpm -ivh oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm
警告：oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm: 头V3 RSA/SHA256 Signature, 密钥 ID ec551f03: NOKEY
错误：依赖检测失败：
/etc/redhat-release 被 oracle-database-preinstall-19c-1.0-2.el7.x86_64 需要

[root@openEuler01 opt]# rpm -ivh oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm    --nodeps --force
warning: oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-preinstall-19c-1.################################# [100%]

错误2：

[root@openEuler01 opt]# rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
warning: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-ee-19c-1.0-1     ################################# [100%]
Exception java.lang.UnsatisfiedLinkError: /opt/oracle/product/19c/dbhome_1/oui/lib/linux64/liboraInstaller.so: libnsl.so.1: cannot open shared object file: No such file or directory occurred..
java.lang.UnsatisfiedLinkError: /opt/oracle/product/19c/dbhome_1/oui/lib/linux64/liboraInstaller.so: libnsl.so.1: cannot open shared object file: No such file or directory
   at java.lang.ClassLoader$NativeLibrary.load(Native Method)
   at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)
   at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1857)
   at java.lang.Runtime.loadLibrary0(Runtime.java:870)
   at java.lang.System.loadLibrary(System.java:1122)
   at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:388)
   at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.<clinit>(OiipuUnixOps.java:130)
   at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment.java:201)
   at oracle.sysman.oii.oiix.OiixIniPair.instantiateEnvVars(OiixIniPair.java:299)
   at oracle.sysman.oii.oiix.OiixIniPair.updateValue(OiixIniPair.java:230)
   at oracle.sysman.oii.oiix.OiixIniPair.<init>(OiixIniPair.java:148)
   at oracle.sysman.oii.oiix.OiixIniFile.readFile(OiixIniFile.java:809)
   at oracle.sysman.oii.oiix.OiixIniFile.readIniFile(OiixIniFile.java:978)
   at oracle.sysman.oii.oiix.OiixIniFile.getProfileString(OiixIniFile.java:385)
   at oracle.sysman.oii.oiix.OiixOraparam.getOraparamProfileString(OiixOraparam.java:338)
   at oracle.sysman.oii.oiix.OiixOraparam.getOraparamProfileString(OiixOraparam.java:296)
   at oracle.sysman.oii.oiix.OiixOraparam.usePrereqChecker(OiixOraparam.java:416)
   at oracle.sysman.oii.oiic.OiicSessionContext.setVariables(OiicSessionContext.java:1325)
   at oracle.sysman.oii.oiic.OiicBaseInventoryApp.execute(OiicBaseInventoryApp.java:771)
   at oracle.sysman.oii.oiic.OiicBaseInventoryApp.main_helper(OiicBaseInventoryApp.java:690)
   at oracle.sysman.oii.oiic.OiicDetachHome.main(OiicDetachHome.java:420)
'DetachHome' failed.
Exception in thread "main" java.lang.NullPointerException
   at oracle.sysman.oii.oiic.OiicBaseInventoryApp.main_helper(OiicBaseInventoryApp.java:706)
   at oracle.sysman.oii.oiic.OiicDetachHome.main(OiicDetachHome.java:420)
Exception java.lang.NoClassDefFoundError: Could not initialize class oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps occurred..
java.lang.NoClassDefFoundError: Could not initialize class oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps
   at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment.java:201)
   at oracle.sysman.oii.oiix.OiixIniPair.instantiateEnvVars(OiixIniPair.java:299)
   at oracle.sysman.oii.oiix.OiixIniPair.updateValue(OiixIniPair.java:230)
   at oracle.sysman.oii.oiix.OiixIniPair.<init>(OiixIniPair.java:148)
   at oracle.sysman.oii.oiix.OiixIniFile.readFile(OiixIniFile.java:809)
   at oracle.sysman.oii.oiix.OiixIniFile.readIniFile(OiixIniFile.java:978)
   at oracle.sysman.oii.oiix.OiixIniFile.getProfileString(OiixIniFile.java:385)
   at oracle.sysman.oii.oiix.OiixOraparam.getOraparamProfileString(OiixOraparam.java:338)
   at oracle.sysman.oii.oiix.OiixOraparam.getOraparamProfileString(OiixOraparam.java:296)
   at oracle.sysman.oii.oiix.OiixOraparam.usePrereqChecker(OiixOraparam.java:416)
   at oracle.sysman.oii.oiic.OiicSessionContext.setVariables(OiicSessionContext.java:1325)
   at oracle.sysman.oii.oiic.OiicBaseInventoryApp.execute(OiicBaseInventoryApp.java:771)
   at oracle.sysman.oii.oiic.OiicBaseInventoryApp.main_helper(OiicBaseInventoryApp.java:690)
   at oracle.sysman.oii.oiic.OiicAttachHome.main(OiicAttachHome.java:696)
'AttachHome' failed.
Exception in thread "main" java.lang.NullPointerException
   at oracle.sysman.oii.oiic.OiicBaseInventoryApp.main_helper(OiicBaseInventoryApp.java:706)
   at oracle.sysman.oii.oiic.OiicAttachHome.main(OiicAttachHome.java:696)
[SEVERE] An error occurred while registering the Oracle home. Verify logs in /var/log/oracle-database-ee-19c/results/oraInstall.log and /opt/oracle/oraInventory for more details and try again.
warning: %post(oracle-database-ee-19c-1.0-1.x86_64) scriptlet failed, exit status 1

错误3：
[root@openEuler01 opt]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
The java.library.path system variable is missing or invalid. Please set java.library.path with a correct value and retry the operation.
[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.

[root@openEuler01 opt]# chown -R oracle:oinstall /opt/oracle
[oracle@openEuler01 ~]$ mkdir -p /opt/oracle/product/19c/dbhome_1
[oracle@openEuler01 ~]$ mkdir -p /opt/app/oracle/oradata/
[oracle@openEuler01 ~]$ mkdir /opt/oracle/oraInventory
[root@openEuler01 dbs]# mkdir /etc/oratab
[root@openEuler01 dbs]# chown oracle:oinstall /etc/oratab

错误4：
[oracle@openEuler01 tmp]$ lsnrctl status
lsnrctl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory
[oracle@openEuler01 tmp]$ yum install libnsl

[oracle@openEuler01 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-NOV-2021 16:55:44

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@openEuler01 ~]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-NOV-2021 16:55:47

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Log messages written to /opt/oracle/diag/tnslsnr/openEuler01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=openEuler01)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                15-NOV-2021 16:55:48
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /opt/oracle/diag/tnslsnr/openEuler01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=openEuler01)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@openEuler01 ~]$
[oracle@openEuler01 ~]$ 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 "/opt/oracle/oradata/" -redoLogFileSize 50 -emConfiguration NONE -ignorePreReqs
准备执行数据库操作
已完成 8%
复制数据库文件
已完成 31%
正在创建并启动 Oracle 实例
已完成 32%
已完成 36%
已完成 40%
已完成 43%
已完成 46%
正在进行数据库创建
已完成 51%
已完成 53%
已完成 54%
正在创建插接式数据库
已完成 58%
已完成 77%
执行配置后操作
已完成 100%
数据库创建完成。有关详细信息, 请查看以下位置的日志文件:
/opt/oracle/cfgtoollogs/dbca/cdb01。
数据库信息:
全局数据库名:cdb01
系统标识符 (SID):cdb01
有关详细信息, 请参阅日志文件 "/opt/oracle/cfgtoollogs/dbca/cdb01/cdb01.log"。

[oracle@openEuler01 dbs]$ vim ~/.bash_profile

# Source /root/.bashrc if user has one
[ -f ~/.bashrc ] && . ~/.bashrc

ORACLE_BASE=/opt/oracle
PATH=$PATH:$HOME/.local/bin:$HOME/bin
ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
PATH=$PATH:$HOME/.local/bin:$HOME/bin:/opt/oracle/product/19c/dbhome_1/bin
export ORACLE_BASE
export PATH
ORACLE_SID=cdb01
export ORACLE_SID
export ORACLE_HOME

[oracle@openEuler01 dbs]$ echo $ORACLE_SID
cdb01
[oracle@openEuler01 dbs]$ . ~/.bash_profile
[oracle@openEuler01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 15 17:14:06 2021
Version 19.3.0.0.0

???:
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 PDB1                 READ WRITE NO