当前位置：首页 > news >正文

银河麒麟V10SP3-arm版本安装oracle19C数据库

news 2026/6/16 15:46:25

银河麒麟V10SP3-arm版本安装oracle19C数据库

项目上经常有在银河麒麟arm上安装oracle的需求，网上搜的资料过于零散，整理一下自己测试的过程。

1.安装依赖

yuminstallbinutils glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel libxcbmakenfs-utils net-tools smartmontools sysstat unixODBC unixODBC-devel libnsl-y# 无网的话下载依赖包手动导入rpm-ivh*.rpm--nodeps--force--replacefiles

2.初始化环境

# 关闭防火墙systemctl stop firewalld systemctl disable firewalld# 关闭selinuxvim/etc/selinux/configSELINUX=disabled# 这个是oracle官方提供的初始化脚本可以自动创建oralce用户，修改参数等rpm-ivhoracle-database-preinstall-19c-1.0-3.el8.aarch64.rpm--nodeps# 环境初始化之后最好重启一下服务器

3.软连接编译文件

mkdir-p/opt/rh/devtoolset-8/root/usr/bin/cd/opt/rh/devtoolset-8/root/usr/bin/ln-s/usr/bin/ar arln-s/usr/bin/as asln-s/lib64/libnsl.so.1 /lib64/libnsl.so.2

4.环境变量配置

oracle用户登录vim .bash_profile

exportCV_ASSUME_DISTID=OEL8.8# Oracle SettingsexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1exportORA_INVENTORY=/u01/app/oraInventoryexportORACLE_SID=orclexportPATH=.:$PATH:$HOME/bin:$ORACLE_HOME/binexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

5.建好oracle目录，root用户执行

mkdir-p/u01/software/Oracle19cunzip/u01/software/Oracle19c/LINUX.ARM64_1919000_db_home.zip-d/u01/app/oracle/product/19.0.0/dbhome_1mkdir-p/u01/app/oracle/product/19.0.0/dbhome_1mkdir/u01/app/oraInventorychown-Roracle:oinstall /u01chmod-R777/u01

6.安装数据库软件

su- oracle#静默方式修改响应文件(压缩包解压完成后得到名为database的文件夹，其中包含安装文件。一般在根目录install/response里)[oracle@creating ~]$cd/u01/app/oracle/product/19.0.0/dbhome_1/install/response[oracle@creating response]$vimdb_install.rsporacle.install.option=INSTALL_DB_SWONLYUNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventoryORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1ORACLE_BASE=/u01/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.OSDBA_GROUP=dbaoracle.install.db.OSOPER_GROUP=dbaoracle.install.db.OSBACKUPDBA_GROUP=dbaoracle.install.db.OSDGDBA_GROUP=dbaoracle.install.db.OSKMDBA_GROUP=dbaoracle.install.db.OSRACDBA_GROUP=dbacd$ORACLE_HOME./runInstaller-silent-waitForCompletion-ignorePrereqFailure-responseFile/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp

7.手动建库，arm架构目前在银河麒麟V10SP3上dbca无法使用

# 1. 建库脚本中指定的数据文件目录（必须与你CREATE DATABASE语句中的路径一致）mkdir-p/oracledata/ORCL/datafilemkdir-p/oracledata/ORCL/onlinelogmkdir-p/oracledata/ORCL/tempfile# 2. Oracle系统必需目录（基于你的ORACLE_BASE）mkdir-p/u01/app/oracle/admin/orcl/adumpmkdir-p/u01/app/oracle/cfgtoollogs# 3. 授予oracle用户完全权限（关键！否则会报权限不足）chown-Roracle:oinstall /oracledatachmod-R775/oracledatachown-Roracle:oinstall /u01/app/oraclechmod-R775/u01/app/oracle# 切换oracle用户# 创建初始化参数文件vi$ORACLE_HOME/dbs/initorcl.oradb_name=orcldb_unique_name=orclinstance_name=orclservice_names=orclmemory_target=8Gmemory_max_target=16Gprocesses=300sessions=335control_files=(/oracledata/ORCL/control01.ctl, /oracledata/ORCL/control02.ctl)audit_file_dest=/u01/app/oracle/admin/orcl/adumpdiagnostic_dest=/u01/app/oraclecompatible=19.0.0remote_login_passwordfile=EXCLUSIVEundo_management=AUTOundo_tablespace=UNDOTBS1db_block_size=8192open_cursors=300# 切换到root用户重新给下属组chown-Roracle:oinstall /u01/app/oracle/product/19.0.0/dbhome_1/dbs/initorcl.ora# 创建oracle密码文件orapwdfile=$ORACLE_HOME/dbs/orapworclpassword=Oracle_2026entries=10force=y# sqlplus启动sqlplus / as sysdba -- 使用我们创建的参数文件启动 startup nomountpfile='$ORACLE_HOME/dbs/initorcl.ora';-- 验证实例状态（应该显示STARTED）selectstatus fromv$instance;

建库命令

CREATE DATABASE orclUSERSYS IDENTIFIED BY Oracle_2026USERSYSTEM IDENTIFIED BY Oracle_2026 LOGFILE GROUP1('/oracledata/ORCL/onlinelog/redo01a.log')SIZE 200M BLOCKSIZE512, GROUP2('/oracledata/ORCL/onlinelog/redo02a.log')SIZE 200M BLOCKSIZE512, GROUP3('/oracledata/ORCL/onlinelog/redo03a.log')SIZE 200M BLOCKSIZE512MAXLOGHISTORY1MAXLOGFILES16MAXLOGMEMBERS3MAXDATAFILES8192CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE'/oracledata/ORCL/datafile/system01.dbf'SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED SYSAUX DATAFILE'/oracledata/ORCL/datafile/sysaux01.dbf'SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TABLESPACEusersDATAFILE'/oracledata/ORCL/datafile/users01.dbf'SIZE 5M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE'/oracledata/ORCL/tempfile/temp01.dbf'SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE UNDOTBS1 DATAFILE'/oracledata/ORCL/datafile/undotbs01.dbf'SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

执行脚本

@?/rdbms/admin/catalog.sql @?/rdbms/admin/catproc.sql @?/rdbms/admin/utlrp.sql -- 必须切换到SYSTEM用户执行，不能用SYS用户 connect system/Creating_2026 @?/sqlplus/admin/pupbld.sql --1. 检查数据库状态（应该显示OPEN）selectname, open_mode fromv$database;--2. 检查所有表空间状态selecttablespace_name, status, contents from dba_tablespaces;--3. 检查所有数据文件状态selectname, status, bytes/1024/1024 as size_mb fromv$datafileorder by name;--4. 检查无效对象数量（应该为0或个位数）selectcount(*)from dba_objects wherestatus='INVALID';create spfile frompfile='$ORACLE_HOME/dbs/initorcl.ora';-- 重启数据库验证SPFILE生效shutdownimmediate startup -- 确认使用的是SPFILE show parameter spfile;

8.创建监听文件

vim$ORACLE_HOME/network/admin/listener.ora LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=你的服务器IP地址)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=orcl)(ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1)(SID_NAME=orcl)))vim$ORACLE_HOME/network/admin/tnsnames.ora ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=你的服务器IP地址)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))# 启动监听lsnrctl start# 查看监听状态lsnrctl status# 测试本地网络连接sqlplus system/Creating2026@orcl

9.设置数据库自启动

sudovim/etc/oratab orcl:/u01/app/oracle/product/19.0.0/dbhome_1:Y# 创建系统服务sudovim/etc/systemd/system/oracle.service[Unit]Description=Oracle Database ServiceAfter=network.target[Service]Type=forkingExecStart=/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbstart$ORACLE_HOMEExecStop=/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbshut$ORACLE_HOMEUser=oracleGroup=oinstallRestart=alwaysRestartSec=30[Install]WantedBy=multi-user.target# 启动服务sudosystemctl daemon-reloadsudosystemctlenableoraclesudosystemctl start oracle