oracle 23c 发布推荐的操作系统是oracle linux 8.7,手头有学习openGauss时的openEuler 20.03 sp3,尝试看安装是否顺利。
确认操作系统版本
[omm@eu1 ~]$ cat /etc/os-release
NAME="openEuler"
VERSION="20.03 (LTS-SP3)"
ID="openEuler"
VERSION_ID="20.03"
PRETTY_NAME="openEuler 20.03 (LTS-SP3)"
ANSI_COLOR="0;31"
下载安装文件，这次可以不用注册
wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
wget https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
安装相关软件，以下是openGauss不需要的
[root@eu1 ~]# dnf -y install bind-utils ksh libnsl nfs-utils policycoreutils-python-utils psmisc
Repository OS is listed more than once in the configuration
Last metadata expiration check: 1:27:29 ago on Mon 17 Apr 2023 07:27:27 AM CST.
Dependencies resolved.
==============================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================
Installing:
bind-utils x86_64 32:9.11.21-9.oe1 update 325 k
ksh x86_64 1:2020.0.0-5.oe1 everything 784 k
libnsl x86_64 2.28-79.oe1 update 52 k
nfs-utils x86_64 1:2.5.1-4.oe1 update 318 k
policycoreutils-python-utils noarch 3.1-7.oe1 OS 25 k
psmisc x86_64 23.3-5.oe1 OS 148 k
Installing dependencies:
bind x86_64 32:9.11.21-9.oe1 update 2.0 M
bind-libs x86_64 32:9.11.21-9.oe1 update 77 k
bind-libs-lite x86_64 32:9.11.21-9.oe1 update 1.0 M
checkpolicy x86_64 3.1-1.oe1 OS 285 k
ding-libs x86_64 0.6.1-42.oe1 OS 93 k
gssproxy x86_64 0.8.3-1.oe1 OS 90 k
keyutils x86_64 1.6.3-1.oe1 OS 55 k
krb5 x86_64 1.18.2-5.oe1 update 81 k
lmdb x86_64 0.9.24-1.oe1 OS 67 k
nfs-utils-help x86_64 1:2.5.1-4.oe1 update 97 k
python3-IPy noarch 1.00-1.oe1 OS 39 k
python3-audit x86_64 1:3.0-3.oe1 OS 72 k
python3-bind noarch 32:9.11.21-9.oe1 update 61 k
python3-libsemanage x86_64 3.1-3.oe1 OS 73 k
python3-ply noarch 3.11-1.oe1 OS 90 k
python3-policycoreutils noarch 3.1-7.oe1 OS 1.7 M
python3-setools x86_64 4.3.0-4.oe1 OS 572 k
quota x86_64 1:4.05-1.oe1 OS 225 k
rpcbind x86_64 1.2.5-5.oe1 OS 47 k
Downgrading:
audit x86_64 1:3.0-3.oe1 OS 176 k
audit-libs x86_64 1:3.0-3.oe1 OS 94 k
glibc x86_64 2.28-79.oe1 update 3.2 M
glibc-common x86_64 2.28-79.oe1 update 26 M
glibc-devel x86_64 2.28-79.oe1 update 2.8 M
policycoreutils x86_64 3.1-7.oe1 OS 533 k
Transaction Summary
==============================================================================================================================================================
Install 25 Packages
Downgrade 6 Packages
Total size: 41 M
Total download size: 37 M
Downloading Packages:
(1/13): glibc-2.28-79.oe1.x86_64.rpm 135 kB/s | 3.2 MB 00:23
(2/13): ksh-2020.0.0-5.oe1.x86_64.rpm 128 kB/s | 784 kB 00:06
(3/13): glibc-devel-2.28-79.oe1.x86_64.rpm 75 kB/s | 2.8 MB 00:38
(4/13): bind-libs-9.11.21-9.oe1.x86_64.rpm 114 kB/s | 77 kB 00:00
(5/13): bind-9.11.21-9.oe1.x86_64.rpm 167 kB/s | 2.0 MB 00:12
(6/13): bind-utils-9.11.21-9.oe1.x86_64.rpm 120 kB/s | 325 kB 00:02
(7/13): krb5-1.18.2-5.oe1.x86_64.rpm 232 kB/s | 81 kB 00:00
(8/13): libnsl-2.28-79.oe1.x86_64.rpm 169 kB/s | 52 kB 00:00
(9/13): nfs-utils-2.5.1-4.oe1.x86_64.rpm 228 kB/s | 318 kB 00:01
(10/13): nfs-utils-help-2.5.1-4.oe1.x86_64.rpm 170 kB/s | 97 kB 00:00
(11/13): python3-bind-9.11.21-9.oe1.noarch.rpm 94 kB/s | 61 kB 00:00
(12/13): bind-libs-lite-9.11.21-9.oe1.x86_64.rpm 99 kB/s | 1.0 MB 00:10
(13/13): glibc-common-2.28-79.oe1.x86_64.rpm 58 kB/s | 26 MB 07:44
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 82 kB/s | 37 MB 07:44
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: glibc-common-2.28-79.oe1.x86_64 1/1
Downgrading : glibc-common-2.28-79.oe1.x86_64 1/37
Running scriptlet: glibc-2.28-79.oe1.x86_64 2/37
Downgrading : glibc-2.28-79.oe1.x86_64 2/37
Running scriptlet: glibc-2.28-79.oe1.x86_64 2/37
Installing : lmdb-0.9.24-1.oe1.x86_64 3/37
Running scriptlet: lmdb-0.9.24-1.oe1.x86_64 3/37
Downgrading : audit-libs-1:3.0-3.oe1.x86_64 4/37
Installing : keyutils-1.6.3-1.oe1.x86_64 5/37
Running scriptlet: rpcbind-1.2.5-5.oe1.x86_64 6/37
Installing : rpcbind-1.2.5-5.oe1.x86_64 6/37
Running scriptlet: rpcbind-1.2.5-5.oe1.x86_64 6/37
Created symlink /etc/systemd/system/multi-user.target.wants/rpcbind.service → /usr/lib/systemd/system/rpcbind.service.
Created symlink /etc/systemd/system/sockets.target.wants/rpcbind.socket → /usr/lib/systemd/system/rpcbind.socket.
Installing : quota-1:4.05-1.oe1.x86_64 7/37
Running scriptlet: quota-1:4.05-1.oe1.x86_64 7/37
Running scriptlet: audit-1:3.0-3.oe1.x86_64 8/37
Downgrading : audit-1:3.0-3.oe1.x86_64 8/37
Running scriptlet: audit-1:3.0-3.oe1.x86_64 8/37
Installing : python3-audit-1:3.0-3.oe1.x86_64 9/37
Downgrading : policycoreutils-3.1-7.oe1.x86_64 10/37
Running scriptlet: policycoreutils-3.1-7.oe1.x86_64 10/37
Running scriptlet: checkpolicy-3.1-1.oe1.x86_64 11/37
Installing : checkpolicy-3.1-1.oe1.x86_64 11/37
Running scriptlet: checkpolicy-3.1-1.oe1.x86_64 11/37
Installing : ding-libs-0.6.1-42.oe1.x86_64 12/37
Installing : python3-libsemanage-3.1-3.oe1.x86_64 13/37
Installing : python3-setools-4.3.0-4.oe1.x86_64 14/37
Installing : krb5-1.18.2-5.oe1.x86_64 15/37
Running scriptlet: krb5-1.18.2-5.oe1.x86_64 15/37
Installing : gssproxy-0.8.3-1.oe1.x86_64 16/37
Running scriptlet: gssproxy-0.8.3-1.oe1.x86_64 16/37
Installing : nfs-utils-help-1:2.5.1-4.oe1.x86_64 17/37
Installing : python3-ply-3.11-1.oe1.noarch 18/37
Installing : python3-IPy-1.00-1.oe1.noarch 19/37
Installing : python3-policycoreutils-3.1-7.oe1.noarch 20/37
Installing : policycoreutils-python-utils-3.1-7.oe1.noarch 21/37
Installing : bind-libs-32:9.11.21-9.oe1.x86_64 22/37
Running scriptlet: bind-libs-32:9.11.21-9.oe1.x86_64 22/37
Installing : bind-libs-lite-32:9.11.21-9.oe1.x86_64 23/37
Running scriptlet: bind-libs-lite-32:9.11.21-9.oe1.x86_64 23/37
Installing : python3-bind-32:9.11.21-9.oe1.noarch 24/37
Running scriptlet: bind-32:9.11.21-9.oe1.x86_64 25/37
Installing : bind-32:9.11.21-9.oe1.x86_64 25/37
Running scriptlet: bind-32:9.11.21-9.oe1.x86_64 25/37
Installing : bind-utils-32:9.11.21-9.oe1.x86_64 26/37
Running scriptlet: nfs-utils-1:2.5.1-4.oe1.x86_64 27/37
Installing : nfs-utils-1:2.5.1-4.oe1.x86_64 27/37
Running scriptlet: nfs-utils-1:2.5.1-4.oe1.x86_64 27/37
Running scriptlet: glibc-devel-2.28-79.oe1.x86_64 28/37
Downgrading : glibc-devel-2.28-79.oe1.x86_64 28/37
Running scriptlet: glibc-devel-2.28-79.oe1.x86_64 28/37
Installing : psmisc-23.3-5.oe1.x86_64 29/37
Installing : ksh-1:2020.0.0-5.oe1.x86_64 30/37
Running scriptlet: ksh-1:2020.0.0-5.oe1.x86_64 30/37
Installing : libnsl-2.28-79.oe1.x86_64 31/37
Running scriptlet: audit-1:3.0-4.oe1.x86_64 32/37
Cleanup : audit-1:3.0-4.oe1.x86_64 32/37
Running scriptlet: audit-1:3.0-4.oe1.x86_64 32/37
Running scriptlet: policycoreutils-3.1-8.oe1.x86_64 33/37
Cleanup : policycoreutils-3.1-8.oe1.x86_64 33/37
Running scriptlet: policycoreutils-3.1-8.oe1.x86_64 33/37
Running scriptlet: glibc-devel-2.28-84.oe1.x86_64 34/37
Cleanup : glibc-devel-2.28-84.oe1.x86_64 34/37
Cleanup : audit-libs-1:3.0-4.oe1.x86_64 35/37
Cleanup : glibc-2.28-84.oe1.x86_64 36/37
Cleanup : glibc-common-2.28-84.oe1.x86_64 37/37
Running scriptlet: glibc-common-2.28-84.oe1.x86_64 37/37
Running scriptlet: glibc-common-2.28-79.oe1.x86_64 37/37
Running scriptlet: glibc-common-2.28-84.oe1.x86_64 37/37
Running scriptlet: glibc-common-2.28-79.oe1.x86_64 37/37
Verifying : audit-1:3.0-3.oe1.x86_64 1/37
Verifying : audit-1:3.0-4.oe1.x86_64 2/37
Verifying : audit-libs-1:3.0-3.oe1.x86_64 3/37
Verifying : audit-libs-1:3.0-4.oe1.x86_64 4/37
Verifying : policycoreutils-3.1-7.oe1.x86_64 5/37
Verifying : policycoreutils-3.1-8.oe1.x86_64 6/37
Verifying : glibc-2.28-79.oe1.x86_64 7/37
Verifying : glibc-2.28-84.oe1.x86_64 8/37
Verifying : glibc-common-2.28-79.oe1.x86_64 9/37
Verifying : glibc-common-2.28-84.oe1.x86_64 10/37
Verifying : glibc-devel-2.28-79.oe1.x86_64 11/37
Verifying : glibc-devel-2.28-84.oe1.x86_64 12/37
Verifying : checkpolicy-3.1-1.oe1.x86_64 13/37
Verifying : ding-libs-0.6.1-42.oe1.x86_64 14/37
Verifying : gssproxy-0.8.3-1.oe1.x86_64 15/37
Verifying : keyutils-1.6.3-1.oe1.x86_64 16/37
Verifying : lmdb-0.9.24-1.oe1.x86_64 17/37
Verifying : policycoreutils-python-utils-3.1-7.oe1.noarch 18/37
Verifying : psmisc-23.3-5.oe1.x86_64 19/37
Verifying : python3-IPy-1.00-1.oe1.noarch 20/37
Verifying : python3-audit-1:3.0-3.oe1.x86_64 21/37
Verifying : python3-libsemanage-3.1-3.oe1.x86_64 22/37
Verifying : python3-ply-3.11-1.oe1.noarch 23/37
Verifying : python3-policycoreutils-3.1-7.oe1.noarch 24/37
Verifying : python3-setools-4.3.0-4.oe1.x86_64 25/37
Verifying : quota-1:4.05-1.oe1.x86_64 26/37
Verifying : rpcbind-1.2.5-5.oe1.x86_64 27/37
Verifying : ksh-1:2020.0.0-5.oe1.x86_64 28/37
Verifying : bind-32:9.11.21-9.oe1.x86_64 29/37
Verifying : bind-libs-32:9.11.21-9.oe1.x86_64 30/37
Verifying : bind-libs-lite-32:9.11.21-9.oe1.x86_64 31/37
Verifying : bind-utils-32:9.11.21-9.oe1.x86_64 32/37
Verifying : krb5-1.18.2-5.oe1.x86_64 33/37
Verifying : libnsl-2.28-79.oe1.x86_64 34/37
Verifying : nfs-utils-1:2.5.1-4.oe1.x86_64 35/37
Verifying : nfs-utils-help-1:2.5.1-4.oe1.x86_64 36/37
Verifying : python3-bind-32:9.11.21-9.oe1.noarch 37/37
Downgraded:
audit-1:3.0-3.oe1.x86_64 audit-libs-1:3.0-3.oe1.x86_64 glibc-2.28-79.oe1.x86_64 glibc-common-2.28-79.oe1.x86_64 glibc-devel-2.28-79.oe1.x86_64
policycoreutils-3.1-7.oe1.x86_64
Installed:
bind-32:9.11.21-9.oe1.x86_64 bind-libs-32:9.11.21-9.oe1.x86_64 bind-libs-lite-32:9.11.21-9.oe1.x86_64 bind-utils-32:9.11.21-9.oe1.x86_64
checkpolicy-3.1-1.oe1.x86_64 ding-libs-0.6.1-42.oe1.x86_64 gssproxy-0.8.3-1.oe1.x86_64 keyutils-1.6.3-1.oe1.x86_64
krb5-1.18.2-5.oe1.x86_64 ksh-1:2020.0.0-5.oe1.x86_64 libnsl-2.28-79.oe1.x86_64 lmdb-0.9.24-1.oe1.x86_64
nfs-utils-1:2.5.1-4.oe1.x86_64 nfs-utils-help-1:2.5.1-4.oe1.x86_64 policycoreutils-python-utils-3.1-7.oe1.noarch psmisc-23.3-5.oe1.x86_64
python3-IPy-1.00-1.oe1.noarch python3-audit-1:3.0-3.oe1.x86_64 python3-bind-32:9.11.21-9.oe1.noarch python3-libsemanage-3.1-3.oe1.x86_64
python3-ply-3.11-1.oe1.noarch python3-policycoreutils-3.1-7.oe1.noarch python3-setools-4.3.0-4.oe1.x86_64 quota-1:4.05-1.oe1.x86_64
rpcbind-1.2.5-5.oe1.x86_64
Complete!
[root@eu1 ~]#
再次尝试
[root@eu1 ~]# rpm -ivh oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
warning: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
error: Failed dependencies:
/etc/redhat-release is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
compat-openssl10 is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
smartmontools is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
sysstat is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
xorg-x11-utils is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
xorg-x11-xauth is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
再次添加包
[root@eu1 ~]# dnf -y install sysstat xorg-x11-utils xorg-x11-xauth smartmontools
Repository OS is listed more than once in the configuration
Last metadata expiration check: 1:47:34 ago on Mon 17 Apr 2023 07:27:27 AM CST.
Dependencies resolved.
==============================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================
Installing:
smartmontools x86_64 1:7.1-1.oe1 OS 461 k
sysstat x86_64 12.2.1-1.oe1 OS 402 k
xorg-x11-utils x86_64 7.5-32.oe1 OS 100 k
xorg-x11-xauth x86_64 1:1.1-1.oe1 OS 27 k
Installing dependencies:
libXv x86_64 1.0.11-11.oe1 OS 17 k
libXxf86dga x86_64 1.1.4-16.oe1 OS 18 k
libdmx x86_64 1.1.4-6.oe1 OS 15 k
lm_sensors x86_64 3.6.0-4.oe1 OS 141 k
xorg-x11-utils-help noarch 7.5-32.oe1 OS 25 k
Installing weak dependencies:
lm_sensors-help x86_64 3.6.0-4.oe1 OS 30 k
Transaction Summary
==============================================================================================================================================================
Install 10 Packages
Total size: 1.2 M
Installed size: 4.4 M
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : xorg-x11-utils-help-7.5-32.oe1.noarch 1/10
Installing : lm_sensors-help-3.6.0-4.oe1.x86_64 2/10
Installing : lm_sensors-3.6.0-4.oe1.x86_64 3/10
Running scriptlet: lm_sensors-3.6.0-4.oe1.x86_64 3/10
Created symlink /etc/systemd/system/multi-user.target.wants/lm_sensors.service → /usr/lib/systemd/system/lm_sensors.service.
Installing : libdmx-1.1.4-6.oe1.x86_64 4/10
Installing : libXxf86dga-1.1.4-16.oe1.x86_64 5/10
Installing : libXv-1.0.11-11.oe1.x86_64 6/10
Running scriptlet: xorg-x11-utils-7.5-32.oe1.x86_64 7/10
Installing : xorg-x11-utils-7.5-32.oe1.x86_64 7/10
Running scriptlet: xorg-x11-utils-7.5-32.oe1.x86_64 7/10
Running scriptlet: sysstat-12.2.1-1.oe1.x86_64 8/10
Installing : sysstat-12.2.1-1.oe1.x86_64 8/10
Running scriptlet: sysstat-12.2.1-1.oe1.x86_64 8/10
Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /usr/lib/systemd/system/sysstat.service.
Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /usr/lib/systemd/system/sysstat-collect.timer.
Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /usr/lib/systemd/system/sysstat-summary.timer.
Installing : xorg-x11-xauth-1:1.1-1.oe1.x86_64 9/10
Installing : smartmontools-1:7.1-1.oe1.x86_64 10/10
Running scriptlet: smartmontools-1:7.1-1.oe1.x86_64 10/10
Created symlink /etc/systemd/system/multi-user.target.wants/smartd.service → /usr/lib/systemd/system/smartd.service.
Verifying : libXv-1.0.11-11.oe1.x86_64 1/10
Verifying : libXxf86dga-1.1.4-16.oe1.x86_64 2/10
Verifying : libdmx-1.1.4-6.oe1.x86_64 3/10
Verifying : lm_sensors-3.6.0-4.oe1.x86_64 4/10
Verifying : lm_sensors-help-3.6.0-4.oe1.x86_64 5/10
Verifying : smartmontools-1:7.1-1.oe1.x86_64 6/10
Verifying : sysstat-12.2.1-1.oe1.x86_64 7/10
Verifying : xorg-x11-utils-7.5-32.oe1.x86_64 8/10
Verifying : xorg-x11-utils-help-7.5-32.oe1.noarch 9/10
Verifying : xorg-x11-xauth-1:1.1-1.oe1.x86_64 10/10
Installed:
libXv-1.0.11-11.oe1.x86_64 libXxf86dga-1.1.4-16.oe1.x86_64 libdmx-1.1.4-6.oe1.x86_64 lm_sensors-3.6.0-4.oe1.x86_64
lm_sensors-help-3.6.0-4.oe1.x86_64 smartmontools-1:7.1-1.oe1.x86_64 sysstat-12.2.1-1.oe1.x86_64 xorg-x11-utils-7.5-32.oe1.x86_64
xorg-x11-utils-help-7.5-32.oe1.noarch xorg-x11-xauth-1:1.1-1.oe1.x86_64
Complete!
再来
[root@eu1 ~]# rpm -ivh oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
warning: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
error: Failed dependencies:
/etc/redhat-release is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
compat-openssl10 is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
openeuler 没有这两个包，忽略再试
[root@eu1 ~]# rpm -ivh oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm --nodeps
warning: 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%]
安装oracle 23c
[root@eu1 ~]# rpm -ivh oracle-database-free-23c-1.0-1.el8.x86_64.rpm
warning: oracle-database-free-23c-1.0-1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
installing package oracle-database-free-23c-1.0-1.x86_64 needs 1806MB on the / filesystem
删除文件后存储空间
[root@eu1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 2.7G 0 2.7G 0% /dev
tmpfs 2.7G 0 2.7G 0% /dev/shm
tmpfs 2.7G 8.6M 2.7G 1% /run
tmpfs 2.7G 0 2.7G 0% /sys/fs/cgroup
/dev/mapper/openeuler-root 54G 43G 8.8G 83% /
tmpfs 2.7G 0 2.7G 0% /tmp
/dev/sda1 974M 180M 727M 20% /boot
tmpfs 545M 0 545M 0% /run/user/0
开始安装
[root@eu1 ~]# rpm -ivh oracle-database-free-23c-1.0-1.el8.x86_64.rpm
warning: oracle-database-free-23c-1.0-1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:oracle-database-free-23c-1.0-1 ################################# [100%]
[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.
执行配置数据库，
[root@eu1 ~]# /etc/init.d/oracle-free-23c configure
The location '/opt/oracle' specified for database files has insufficient space.
Database creation needs at least '4.5GB' disk space.
Specify a different database file destination that has enough space in the configuration file '/etc/sysconfig/oracle-free-23c.conf'.
空间还不够，再删除文件
[root@eu1 opt]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 2.7G 0 2.7G 0% /dev
tmpfs 2.7G 0 2.7G 0% /dev/shm
tmpfs 2.7G 8.6M 2.7G 1% /run
tmpfs 2.7G 0 2.7G 0% /sys/fs/cgroup
/dev/mapper/openeuler-root 54G 42G 9.2G 83% /
tmpfs 2.7G 0 2.7G 0% /tmp
/dev/sda1 974M 180M 727M 20% /boot
tmpfs 545M 0 545M 0% /run/user/0
初始化数据库
[root@eu1 opt]# /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:
The password you entered contains invalid characters. Enter password:
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: eu1/FREEPDB1
Multitenant container database: eu1
为oracle 用户设定环境变量
vim ~/.bash_profile
export ORACLE_SID=FREE
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/23c/dbhomeFree
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
source ~/.bash_profile
连接数据库
[oracle@eu1 ~]$ sqlplus /nolog
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Apr 17 10:24:37 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
SQL> select status from v$instance;
SP2-0640: Not connected
SQL> conn / as sysdba
Connected.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
SQL> show parameter MAX_COLUMNS;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_columns string STANDARD
SQL> alter system set MAX_COLUMNS=EXTENDED scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1608409784 bytes
Fixed Size 10044088 bytes
Variable Size 419430400 bytes
Database Buffers 1174405120 bytes
Redo Buffers 4530176 bytes
Database mounted.
Database opened.
SQL> show parameter MAX_COLUMNS;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_columns string EXTENDED
除空间不足外，在openEuler上安装还是比较顺利的。
879
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
