银河麒麟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--replacefiles2.初始化环境# 关闭防火墙systemctl stop firewalld systemctl disable firewalld# 关闭selinuxvim/etc/selinux/configSELINUXdisabled# 这个是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.24.环境变量配置oracle用户登录vim .bash_profileexportCV_ASSUME_DISTIDOEL8.8# Oracle SettingsexportORACLE_BASE/u01/app/oracleexportORACLE_HOME$ORACLE_BASE/product/19.0.0/dbhome_1exportORA_INVENTORY/u01/app/oraInventoryexportORACLE_SIDorclexportPATH.:$PATH:$HOME/bin:$ORACLE_HOME/binexportLD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib5.建好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/u016.安装数据库软件su- oracle#静默方式修改响应文件(压缩包解压完成后得到名为database的文件夹其中包含安装文件。一般在根目录install/response里)[oraclecreating ~]$cd/u01/app/oracle/product/19.0.0/dbhome_1/install/response[oraclecreating response]$vimdb_install.rsporacle.install.optionINSTALL_DB_SWONLYUNIX_GROUP_NAMEoinstallINVENTORY_LOCATION/u01/app/oraInventoryORACLE_HOME/u01/app/oracle/product/19.0.0/dbhome_1ORACLE_BASE/u01/app/oracleoracle.install.db.InstallEditionEEoracle.install.db.OSDBA_GROUPdbaoracle.install.db.OSOPER_GROUPdbaoracle.install.db.OSBACKUPDBA_GROUPdbaoracle.install.db.OSDGDBA_GROUPdbaoracle.install.db.OSKMDBA_GROUPdbaoracle.install.db.OSRACDBA_GROUPdbacd$ORACLE_HOME./runInstaller-silent-waitForCompletion-ignorePrereqFailure-responseFile/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp7.手动建库arm架构目前在银河麒麟V10SP3上dbca无法使用# 1. 建库脚本中指定的数据文件目录必须与你CREATE DATABASE语句中的路径一致mkdir-p/oracledata/ORCL/datafilemkdir-p/oracledata/ORCL/onlinelogmkdir-p/oracledata/ORCL/tempfile# 2. Oracle系统必需目录基于你的ORACLE_BASEmkdir-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_nameorcldb_unique_nameorclinstance_nameorclservice_namesorclmemory_target8Gmemory_max_target16Gprocesses300sessions335control_files(/oracledata/ORCL/control01.ctl, /oracledata/ORCL/control02.ctl)audit_file_dest/u01/app/oracle/admin/orcl/adumpdiagnostic_dest/u01/app/oraclecompatible19.0.0remote_login_passwordfileEXCLUSIVEundo_managementAUTOundo_tablespaceUNDOTBS1db_block_size8192open_cursors300# 切换到root用户重新给下属组chown-Roracle:oinstall /u01/app/oracle/product/19.0.0/dbhome_1/dbs/initorcl.ora# 创建oracle密码文件orapwdfile$ORACLE_HOME/dbs/orapworclpasswordOracle_2026entries10forcey# sqlplus启动sqlplus / as sysdba -- 使用我们创建的参数文件启动 startup nomountpfile$ORACLE_HOME/dbs/initorcl.ora;-- 验证实例状态应该显示STARTEDselectstatus 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.dbfSIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED SYSAUX DATAFILE/oracledata/ORCL/datafile/sysaux01.dbfSIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TABLESPACEusersDATAFILE/oracledata/ORCL/datafile/users01.dbfSIZE 5M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE/oracledata/ORCL/tempfile/temp01.dbfSIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE UNDOTBS1 DATAFILE/oracledata/ORCL/datafile/undotbs01.dbfSIZE 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. 检查数据库状态应该显示OPENselectname, 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 wherestatusINVALID;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(PROTOCOLTCP)(HOST你的服务器IP地址)(PORT1521))(ADDRESS(PROTOCOLIPC)(KEYEXTPROC1521))))SID_LIST_LISTENER(SID_LIST(SID_DESC(GLOBAL_DBNAMEorcl)(ORACLE_HOME/u01/app/oracle/product/19.0.0/dbhome_1)(SID_NAMEorcl)))vim$ORACLE_HOME/network/admin/tnsnames.ora ORCL(DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST你的服务器IP地址)(PORT1521))(CONNECT_DATA(SERVERDEDICATED)(SERVICE_NAMEorcl)))# 启动监听lsnrctl start# 查看监听状态lsnrctl status# 测试本地网络连接sqlplus system/Creating2026orcl9.设置数据库自启动sudovim/etc/oratab orcl:/u01/app/oracle/product/19.0.0/dbhome_1:Y# 创建系统服务sudovim/etc/systemd/system/oracle.service[Unit]DescriptionOracle Database ServiceAfternetwork.target[Service]TypeforkingExecStart/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_HOMEUseroracleGroupoinstallRestartalwaysRestartSec30[Install]WantedBymulti-user.target# 启动服务sudosystemctl daemon-reloadsudosystemctlenableoraclesudosystemctl start oracle10.依赖包和一键安装脚本整理中后续补充
银河麒麟V10SP3-arm版本安装oracle19C数据库
发布时间：2026/5/19 22:54:58
银河麒麟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--replacefiles2.初始化环境# 关闭防火墙systemctl stop firewalld systemctl disable firewalld# 关闭selinuxvim/etc/selinux/configSELINUXdisabled# 这个是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.24.环境变量配置oracle用户登录vim .bash_profileexportCV_ASSUME_DISTIDOEL8.8# Oracle SettingsexportORACLE_BASE/u01/app/oracleexportORACLE_HOME$ORACLE_BASE/product/19.0.0/dbhome_1exportORA_INVENTORY/u01/app/oraInventoryexportORACLE_SIDorclexportPATH.:$PATH:$HOME/bin:$ORACLE_HOME/binexportLD_LIBRARY_PATH$ORACLE_HOME/lib:/lib:/usr/libexportCLASSPATH$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib5.建好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/u016.安装数据库软件su- oracle#静默方式修改响应文件(压缩包解压完成后得到名为database的文件夹其中包含安装文件。一般在根目录install/response里)[oraclecreating ~]$cd/u01/app/oracle/product/19.0.0/dbhome_1/install/response[oraclecreating response]$vimdb_install.rsporacle.install.optionINSTALL_DB_SWONLYUNIX_GROUP_NAMEoinstallINVENTORY_LOCATION/u01/app/oraInventoryORACLE_HOME/u01/app/oracle/product/19.0.0/dbhome_1ORACLE_BASE/u01/app/oracleoracle.install.db.InstallEditionEEoracle.install.db.OSDBA_GROUPdbaoracle.install.db.OSOPER_GROUPdbaoracle.install.db.OSBACKUPDBA_GROUPdbaoracle.install.db.OSDGDBA_GROUPdbaoracle.install.db.OSKMDBA_GROUPdbaoracle.install.db.OSRACDBA_GROUPdbacd$ORACLE_HOME./runInstaller-silent-waitForCompletion-ignorePrereqFailure-responseFile/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp7.手动建库arm架构目前在银河麒麟V10SP3上dbca无法使用# 1. 建库脚本中指定的数据文件目录必须与你CREATE DATABASE语句中的路径一致mkdir-p/oracledata/ORCL/datafilemkdir-p/oracledata/ORCL/onlinelogmkdir-p/oracledata/ORCL/tempfile# 2. Oracle系统必需目录基于你的ORACLE_BASEmkdir-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_nameorcldb_unique_nameorclinstance_nameorclservice_namesorclmemory_target8Gmemory_max_target16Gprocesses300sessions335control_files(/oracledata/ORCL/control01.ctl, /oracledata/ORCL/control02.ctl)audit_file_dest/u01/app/oracle/admin/orcl/adumpdiagnostic_dest/u01/app/oraclecompatible19.0.0remote_login_passwordfileEXCLUSIVEundo_managementAUTOundo_tablespaceUNDOTBS1db_block_size8192open_cursors300# 切换到root用户重新给下属组chown-Roracle:oinstall /u01/app/oracle/product/19.0.0/dbhome_1/dbs/initorcl.ora# 创建oracle密码文件orapwdfile$ORACLE_HOME/dbs/orapworclpasswordOracle_2026entries10forcey# sqlplus启动sqlplus / as sysdba -- 使用我们创建的参数文件启动 startup nomountpfile$ORACLE_HOME/dbs/initorcl.ora;-- 验证实例状态应该显示STARTEDselectstatus 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.dbfSIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED SYSAUX DATAFILE/oracledata/ORCL/datafile/sysaux01.dbfSIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TABLESPACEusersDATAFILE/oracledata/ORCL/datafile/users01.dbfSIZE 5M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE/oracledata/ORCL/tempfile/temp01.dbfSIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE UNDOTBS1 DATAFILE/oracledata/ORCL/datafile/undotbs01.dbfSIZE 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. 检查数据库状态应该显示OPENselectname, 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 wherestatusINVALID;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(PROTOCOLTCP)(HOST你的服务器IP地址)(PORT1521))(ADDRESS(PROTOCOLIPC)(KEYEXTPROC1521))))SID_LIST_LISTENER(SID_LIST(SID_DESC(GLOBAL_DBNAMEorcl)(ORACLE_HOME/u01/app/oracle/product/19.0.0/dbhome_1)(SID_NAMEorcl)))vim$ORACLE_HOME/network/admin/tnsnames.ora ORCL(DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST你的服务器IP地址)(PORT1521))(CONNECT_DATA(SERVERDEDICATED)(SERVICE_NAMEorcl)))# 启动监听lsnrctl start# 查看监听状态lsnrctl status# 测试本地网络连接sqlplus system/Creating2026orcl9.设置数据库自启动sudovim/etc/oratab orcl:/u01/app/oracle/product/19.0.0/dbhome_1:Y# 创建系统服务sudovim/etc/systemd/system/oracle.service[Unit]DescriptionOracle Database ServiceAfternetwork.target[Service]TypeforkingExecStart/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_HOMEUseroracleGroupoinstallRestartalwaysRestartSec30[Install]WantedBymulti-user.target# 启动服务sudosystemctl daemon-reloadsudosystemctlenableoraclesudosystemctl start oracle10.依赖包和一键安装脚本整理中后续补充
