【原创】鲲鹏ARM构架openEuler操作系统安装Oracle 19c

作者:einyboy 【原创】鲲鹏ARM构架openEuler操作系统安装Oracle 19c | 云非云计算机科学、自然科学技术科谱http://www.nclound.com/index.php/2023/09/03/%E3%80%90%E5%8E%9F%E5%88%9B%E3%80%91%E9%B2%B2%E9%B9%8Farm%E6%9E%84%E6%9E%B6openeuler%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E5%AE%89%E8%A3%85oracle-19c/

1. 一、操作系统版本

二、安装介质

Database Software Downloads | Oracle

这个链接是下载oracle安装包

OracleDB_19.19_Linux-for-arm.zip

Oracle Linux 8 (aarch64) AppStream | Oracle, Software. Hardware. Complete.

这个链接是下载oracle准备包

oracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm

三、安装步骤

3.1 使用操作系统yum源

yum install -y ksh libaio-devel libgfortran libstdc+±devel psmisc xorg-x11-utils xorg-x11-xauth

3.2 安装oracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm

rpm -ivh oracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm –-nodeps

如果不是忽略关联安装的话会报这个错

/etc/redhat-release is needed by oracle-database-preinstall-19c-1.0-3.el8.aarch64

libnsl is needed by oracle-database-preinstall-19c-1.0-3.el8.aarch64

3.3 设置编译工具

Oracle软件relink时，会到指定位置找ar和as工具，在CentOS 8上，虽然有这两个工具，但是位置不对，在Orace软件引用的位置创建符号链接：

mkdir -p /opt/rh/devtoolset-8/root/usr/bin/

cd /opt/rh/devtoolset-8/root/usr/bin/

ln -s /usr/bin/ar ar

ln -s /usr/bin/as as

3.4 设置Oracle环境变量

3.5 建好oracle目录

mkdir -p /oracle/admin/orcl/adump

mkdir -p /oracle/oradata/orcl

chown oracle:oracle -R /oracle

3.6 设置CV_ASSUME_DISTID

export CV_ASSUME_DISTID=RHEL8.0

规避这个报错参考连接：

ARM Linux（麒麟操作系统）安装Oracle数据库 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 17813235971 - 惜分飞

3.7安装开始

su – oracle

cd $ORACLE_HOME

unzip LINUX.ARM64_1919000_db_home.zip

./runInstaller

3.8 手工建库

Dbca不能建库，只能手工建库.

1) pfile文件设置

vi initorcl.ora

*._library_cache_advice=FALSE

*._serial_direct_read='NEVER'

*.audit_file_dest='/oracle/admin/orcl/adump'

*.audit_trail='NONE'

*.compatible='19.0.0' #兼容版本

*.control_files='/oracle/oradata/orcl/control01.ctl','/oracle/oradata/orcl/control02.ctl'

*.db_block_size=8192

*.db_files=1500

*.db_name='orcl' #库名

*.deferred_segment_creation=FALSE

*.diagnostic_dest='/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

.event='10949 TRACE NAME CONTEXT FOREVER:28401 TRACE NAME CONTEXT FOREVER,level 1' #.local_listener='LISTENER_SJYZDB03'

*.max_dump_file_size='500M'

*.nls_language='SIMPLIFIED CHINESE'

*.nls_territory='CHINA'

*.open_cursors=2000

*.parallel_force_local=TRUE

*.pga_aggregate_target=1289m

*.processes=1000

*.remote_listener=''

*.remote_login_passwordfile='EXCLUSIVE'

*.session_cached_cursors=200

*.sga_target=5868m

*.undo_tablespace='UNDOTBS1'

2) 设置密码文件

orapwd file=/home/oracle/oracle_install/dbs/orapworcl entries=10

3）连接实例

4）连接实例

SQL> create spfile from pfile;

File created.

5）启动到nomount状态

SQL> startup nomount

6）创建库

CREATE DATABASE orcl

USER SYS IDENTIFIED BY Oracle123

USER SYSTEM IDENTIFIED BY Oracle123

LOGFILE GROUP 1 ('/oracle/oradata/orcl/redo0101.log','/oracle/oradata/orcl/redo0102.log') SIZE 1000M BLOCKSIZE 512,

GROUP 2 ('/oracle/oradata/orcl/redo0201.log','/oracle/oradata/orcl/redo0202.log') SIZE 1000M BLOCKSIZE 512,

GROUP 3 ('/oracle/oradata/orcl/redo0301.log','/oracle/oradata/orcl/redo0302.log') SIZE 1000M BLOCKSIZE 512

MAXLOGFILES 30

MAXLOGMEMBERS 5

MAXLOGHISTORY 1000

MAXDATAFILES 5000

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE '/oracle/oradata/orcl/system01.dbf' SIZE 2G REUSE

SYSAUX DATAFILE '/oracle/oradata/orcl/sysaux01.dbf' SIZE 10G REUSE

DEFAULT TABLESPACE users

DATAFILE '/oracle/oradata/orcl/users01.dbf' SIZE 2G REUSE

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/oracle/oradata/orcl/temp01.dbf' SIZE 2G REUSE

UNDO TABLESPACE undotbs1

DATAFILE '/oracle/oradata/orcl/undotbs01.dbf' SIZE 2G REUSE;

7）运行脚本建立数据字典视图

以SYSDBA管理权限运行下面的脚本：

SQL> @?/rdbms/admin/catalog.sql --->创建数据字典视图、动态性能视图和同义词

SQL> @?/rdbms/admin/catproc.sql --->运行所有PL/SQL需要或使用的脚本

SQL> @?/rdbms/admin/utlrp.sql --->重新编译失效状态的PL/SQL模块，包括包、过程或类型

以SYSTEM用户执行下面的脚本：

SQL> conn system/oracle

Connected.

SQL> @?/sqlplus/admin/pupbld.sql