openEuler学习06-安装oracle23c

操作系统版本-openEuler 22.03 (LTS-SP2)

23c下载地址，下载后都上传到数据库主机的/opt目录下
https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm

compat-openssl10下载地址
https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm

报错1：安装oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm报错

[root@db ~]# dnf -y localinstall /opt/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Last metadata expiration check: 0:03:23 ago on Sun 17 Dec 2023 09:31:55 AM CST.
Error:
?Problem: conflicting requests
? - nothing provides /etc/redhat-release needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
? - nothing provides compat-openssl10 needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
[root@db ~]#

compat-openssl处理办法：

[root@db opt]# rpm -ivh compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm
warning: compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying...????????????????????????? ################################# [100%]
Preparing...????????????????????????? ################################# [100%]
Updating / installing...
?? 1:compat-openssl10-1:1.0.2o-4.el8_6################################# [100%]
[root@db opt]#

redhat-release和openEuler-release冲突，且无法删除openEuler-release再安装redhat-release，直接加--nodeps参数处理

[root@db ~]# rpm -ivh /opt/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm --nodeps
warning: /opt/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying...????????????????????????? ################################# [100%]
Preparing...????????????????????????? ################################# [100%]
Updating / installing...
?? 1:oracle-database-preinstall-23c-1.################################# [100%]
[root@db ~]#

报错2：configure报错[INS-08109] Unexpected error occurred while validating inputs at state 'ConfigurationParams'.

处理办法1：

配置前先执行下export CV_ASSUME_DISTID=RHEL8.8后再执行/etc/init.d/oracle-free-23c configure

处理办法2：

[root@db ~]# dnf -y localinstall /opt/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:12:36 ago on Sun 17 Dec 2023 10:00:54 AM CST.
Dependencies resolved.
============================================================================================================================================================================
?Package????????????????????????????????????????????? Architecture?????????????????????? Version???????????????????????????? Repository??????????????????????????????? Size
============================================================================================================================================================================
Installing:
?oracle-database-free-23c???????????????????????????? x86_64???????????????????????????? 1.0-1?????????????????????????????? @commandline???????????????????????????? 1.6 G

Transaction Summary
============================================================================================================================================================================
Install? 1 Package

Total size: 1.6 G
Installed size: 4.0 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
? Preparing??????? :??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1/1
? Running scriptlet: oracle-database-free-23c-1.0-1.x86_64????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1/1
? Installing?????? : oracle-database-free-23c-1.0-1.x86_64????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1/1
? Running scriptlet: oracle-database-free-23c-1.0-1.x86_64????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root.

? Verifying??????? : oracle-database-free-23c-1.0-1.x86_64????????????????????????????????????????????????????????????????????????????????????????????????????????????? 1/1

Installed:
? oracle-database-free-23c-1.0-1.x86_64??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?

Complete!

[root@db ~]# export CV_ASSUME_DISTID=RHEL8.8
[root@db ~]# /etc/init.d/oracle-free-23c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ***************
Enter SYSTEM user password:
************
Enter PDBADMIN User Password:
***********
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
?/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.

Connect to Oracle Database using one of the connect strings:
???? Pluggable database: localhost.localdomain/FREEPDB1
???? Multitenant container database: localhost.localdomain
[root@db ~]