银河麒麟(kylin_v10)使用RPM安装ORACLE 19C 环境说明

2024年 7月 22日 52.5k 0

服务器操作系统:银河麒麟V10 SP2(Kylin Linux Advanced Server V10 (Sword))

数据库版本:Oracle 19C(19.3.0.0.0)

SSH工具:secureCRT8.0

一、上传安装包

[root]

[root@database ~]# ll *.rpm

-rw-r--r-- 1 root root      19112 Jun 20 00:54 compat-libcap1-1.10-7.el7.x86_64.rpm

-rw-r--r-- 1 root root    195388 Sep  5  2022 compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

-rw-r--r-- 1 root root 2694664264 Jun 19 19:55 oracle-database-ee-19c-1.0-1.x86_64.rpm

-rw-r--r-- 1 root root      18204 Jun 20 00:28 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

银河麒麟V10上使用el7版本的包也是可以安装的

二 、安装依赖包

[root]

rpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm 

rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm 

yum -y install /lib64/libnsl.so.1 

三、安装oracle预准备包

[root]

[root@db1 data]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

warning: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

error: Failed dependencies:

        /etc/redhat-release is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64

        ksh is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64

        libstdc++-devel is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64

对于缺少的包,安装即可

[root]

[root@db1 data]# yum -y install libstdc*

[root@db1 data]# yum -y install ksh*

对于版本依赖,我们跳过即可

[root]

[root@db1 data]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm  --nodeps

warning: oracle-database-preinstall-19c-1.0-1.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%]

四、安装数据库软件

使用root直接安装数据库软件

[root]

[root@db1 data]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

warning: oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

error: Failed dependencies:

        /etc/redhat-release is needed by oracle-database-preinstall-19c-1.0-1.el7.x86_64

[root@db1 data]# cat etc/redhat-release

cat: etc/redhat-release: No such file or directory

[root@db1 data]# cat /etc/redhat-release

Red Hat Enterprise Linux release 8.0 (Ootpa)

[root@db1 data]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm  --nodeps

warning: oracle-database-preinstall-19c-1.0-1.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%]

五、初始化数据库

[root]

[root@db1 data]# /etc/init.d/oracledb_ORCLCDB-19c configure 

Configuring Oracle Database ORCLCDB.

Prepare for db operation

8% complete

Copying database files

31% complete

Creating and starting Oracle instance

32% complete

36% complete

40% complete

43% complete

46% complete

Completing Database Creation

51% complete

54% complete

Creating Pluggable Databases

58% complete

77% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.

Database Information:

Global Database Name:ORCLCDB

System Identifier(SID):ORCLCDB

Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

六、使用

6.1 配置环境变量

[oracle]

cat >> /home/oracle/.bash_profile select open_mode from v$database;

OPEN_MODE

--------------------

READ WRITE

七、总结

本文将详细指导如何通过RPM包在Kylin Server V10上完成Oracle Database 19c的安装,包括前期准备、环境配置、安装步骤,让新手DBA快速在国产操作系统上使用Oracle数据库。

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论