经验首页 前端设计 程序设计 Java相关 移动开发 数据库/运维 软件/图像 大数据/云计算 其他经验
当前位置:技术经验 » 数据库/运维 » Linux/Shell » 查看文章
在OCI上快速静默安装23ai数据库
来源:cnblogs  作者:AlfredZhao  时间:2025/3/7 9:09:18  对本文有异议

拿到同事帮忙申请好的OCI环境【OEL 8.10】后,开始安装23ai数据库用于后续测试,本文选择快速静默安装模式。

OCI环境都是opc用户登录的,执行高权限的操作均需要用到sudo命令。

首先创建存放介质的目录,赋予最高权限:

  1. sudo mkdir -p /u01/media
  2. sudo chmod 777 /u01/media

然后上传23ai的介质到这个目录下。

同时,使用dnf安装oracle-database-preinstall-23ai这个包,会非常省事:

  1. sudo dnf -y install oracle-database-preinstall-23ai

安装完成后,会发现不但将所需依赖包都搞定,连oracle系统用户都给你建好了,此外包括常规系统设置均已完成,要是不放心,可以检查下:

  1. cat /etc/security/limits.d/oracle-database-preinstall-23ai.conf
  2. cat /etc/sysctl.conf

总之,这些相关细节类型统统不用管,非常省心。

那需要我们做什么呢?
只需要建立你按实际情况规划好的安装目录:

  1. sudo mkdir -p /u01/app/oracle
  2. sudo chown -R oracle:oinstall /u01/app

然后使用Oracle用户登录,设置环境变量,这里写入~/.bash_profile中:

  1. export ORACLE_BASE=/u01/app/oracle
  2. export ORACLE_HOME=/u01/app/oracle/product/23.0.0/db_1
  3. export ORACLE_SID=demo
  4. export PATH=$ORACLE_HOME/bin:$PATH

进入到ORACLE_HOME目录后,解压23ai安装介质。

  1. cd $ORACLE_HOME
  2. unzip /u01/media/db23802504.zip

修改静默安装需要用到的响应文件,将之前的备份下,然后编辑修改:

  1. cd /u01/app/oracle/product/23.0.0/db_1/install/response
  2. cp db_install.rsp db_install.rsp.bak
  3. vi db_install.rsp

测试修改后的文件,为缩减篇幅,清理掉注释后,附在文末供大家参考:

修改好之后,开始静默安装Oracle 23ai软件:

  1. ./runInstaller -silent -ignorePrereqFailure -responseFile /u01/app/oracle/product/23.0.0/db_1/install/response/db_install.rsp

执行成功,按提示切换到root用户,执行两个root脚本:

  1. As a root user, run the following script(s):
  2. 1. /u01/app/oraInventory/orainstRoot.sh
  3. 2. /u01/app/oracle/product/23.0.0/db_1/root.sh

root脚本都执行完成后,切换回Oracle用户,执行:

  1. /u01/app/oracle/product/23.0.0/db_1/runInstaller -executeConfigTools -responseFile /u01/app/oracle/product/23.0.0/db_1/install/response/db_install.rsp -silent

会提示你一个日志,可以tail跟踪去看输出,最后提示成功。

  1. [oracle@dbtest ~]$ /u01/app/oracle/product/23.0.0/db_1/runInstaller -executeConfigTools -responseFile /u01/app/oracle/product/23.0.0/db_1/install/response/db_install.rsp -silent
  2. Launching Oracle Database Setup Wizard...
  3. You can find the logs of this session at:
  4. /u01/app/oraInventory/logs/InstallActions2025-03-06_07-17-45AM
  5. Successfully Configured Software.

显示顺利安装完成!
尝试使用sqlplus登录:

  1. [oracle@dbtest ~]$ sqlplus / as sysdba
  2. SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Thu Mar 6 07:26:25 2025
  3. Version 23.8.0.25.04
  4. Copyright (c) 1982, 2025, Oracle. All rights reserved.
  5. Connected to:
  6. Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
  7. Version 23.8.0.25.04
  8. SQL> show pdbs;
  9. CON_ID CON_NAME OPEN MODE RESTRICTED
  10. ---------- ------------------------------ ---------- ----------
  11. 2 PDB$SEED READ ONLY NO
  12. 3 ALFRED READ WRITE NO

OK,至此,23ai的数据库环境准备完成。


FYI:

  1. 响应文件db_install.rsp参考

源文件注释太多,先清理下注释:

  1. # 删除应答文件中的注释行(以#开头)
  2. sed -i 's/^#.*$//g' *.rsp
  3. # 刪除沒有內容的空行(^$)
  4. sed -i '/^$/d' *.rsp

清理注释后响应文件内容如下,根据你的需求DIY修改即可,尤其是密码:

  1. oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
  2. installOption=INSTALL_DB_AND_CONFIG
  3. UNIX_GROUP_NAME=oinstall
  4. INVENTORY_LOCATION=/u01/app/oraInventory
  5. ORACLE_HOME=/u01/app/oracle/product/23.0.0/db_1
  6. ORACLE_BASE=/u01/app/oracle
  7. installEdition=EE
  8. OSDBA=dba
  9. OSOPER=oper
  10. OSBACKUPDBA=backupdba
  11. OSDGDBA=dgdba
  12. OSKMDBA=kmdba
  13. OSRACDBA=racdba
  14. executeRootScript=
  15. configMethod=
  16. sudoPath=
  17. sudoUserName=
  18. clusterNodes=
  19. dbType=GENERAL_PURPOSE
  20. gdbName=demo
  21. dbSID=demo
  22. pdbName=alfred
  23. charSet=AL32UTF8
  24. enableAutoMemoryManagement=false
  25. memoryLimit=16384
  26. allSchemaPassword=ChangeYour_pwd
  27. sysPassword=
  28. systemPassword=
  29. dbsnmpPassword=
  30. pdbadminPassword=
  31. managementOption=DEFAULT
  32. omsHost=
  33. omsPort=
  34. emAdminUser=
  35. emAdminPassword=
  36. enableRecovery=false
  37. storageType=FILE_SYSTEM_STORAGE
  38. dataLocation=/u01/app/oracle/oradata
  39. recoveryLocation=/u01/app/oracle/recovery_area
  40. diskGroup=
  41. asmsnmpPassword=
  1. dnf安装oracle-database-preinstall-23ai的显示
    只是用于参考下它都自动装了哪些依赖包:
  1. [opc@dbtest media]$ sudo dnf -y install oracle-database-preinstall-23ai
  2. Latest Unbreakable Enterprise Kernel Release 7 for Oracle Linux 8 (x86_64) 110 MB/s | 56 MB 00:00
  3. Last metadata expiration check: 0:00:07 ago on Thu 06 Mar 2025 03:49:27 AM GMT.
  4. Dependencies resolved.
  5. ===================================================================================================================================================================
  6. Package Architecture Version Repository Size
  7. ===================================================================================================================================================================
  8. Installing:
  9. oracle-database-preinstall-23ai x86_64 1.0-4.el8 ol8_appstream 31 k
  10. Installing dependencies:
  11. ksh x86_64 20120801-267.0.1.el8 ol8_appstream 923 k
  12. libICE x86_64 1.0.9-15.el8 ol8_appstream 74 k
  13. libSM x86_64 1.2.3-1.el8 ol8_appstream 47 k
  14. libX11-xcb x86_64 1.6.8-9.el8_10 ol8_appstream 14 k
  15. libXcomposite x86_64 0.4.4-14.el8 ol8_appstream 28 k
  16. libXi x86_64 1.7.10-1.el8 ol8_appstream 49 k
  17. libXinerama x86_64 1.1.4-1.el8 ol8_appstream 15 k
  18. libXmu x86_64 1.1.3-1.el8 ol8_appstream 75 k
  19. libXrandr x86_64 1.5.2-1.el8 ol8_appstream 34 k
  20. libXt x86_64 1.1.5-12.el8 ol8_appstream 185 k
  21. libXtst x86_64 1.2.3-7.el8 ol8_appstream 22 k
  22. libXv x86_64 1.0.11-7.el8 ol8_appstream 20 k
  23. libXxf86dga x86_64 1.1.5-1.el8 ol8_appstream 26 k
  24. libXxf86misc x86_64 1.0.4-1.el8 ol8_appstream 23 k
  25. libXxf86vm x86_64 1.1.4-9.el8 ol8_appstream 19 k
  26. libdmx x86_64 1.1.4-3.el8 ol8_appstream 22 k
  27. xorg-x11-utils x86_64 7.5-28.el8 ol8_appstream 136 k
  28. xorg-x11-xauth x86_64 1:1.0.9-12.el8 ol8_appstream 39 k
  29. Transaction Summary
  30. ===================================================================================================================================================================
  31. Install 19 Packages
  32. Total download size: 1.7 M
  33. Installed size: 5.0 M
  34. Downloading Packages:
  35. (1/19): ksh-20120801-267.0.1.el8.x86_64.rpm 14 MB/s | 923 kB 00:00
  36. (2/19): libICE-1.0.9-15.el8.x86_64.rpm 1.1 MB/s | 74 kB 00:00
  37. (3/19): libXcomposite-0.4.4-14.el8.x86_64.rpm 1.2 MB/s | 28 kB 00:00
  38. (4/19): libX11-xcb-1.6.8-9.el8_10.x86_64.rpm 277 kB/s | 14 kB 00:00
  39. (5/19): libSM-1.2.3-1.el8.x86_64.rpm 194 kB/s | 47 kB 00:00
  40. (6/19): libXi-1.7.10-1.el8.x86_64.rpm 217 kB/s | 49 kB 00:00
  41. (7/19): libXinerama-1.1.4-1.el8.x86_64.rpm 68 kB/s | 15 kB 00:00
  42. (8/19): libXt-1.1.5-12.el8.x86_64.rpm 4.7 MB/s | 185 kB 00:00
  43. (9/19): libXrandr-1.5.2-1.el8.x86_64.rpm 465 kB/s | 34 kB 00:00
  44. (10/19): libXtst-1.2.3-7.el8.x86_64.rpm 589 kB/s | 22 kB 00:00
  45. (11/19): libXxf86dga-1.1.5-1.el8.x86_64.rpm 704 kB/s | 26 kB 00:00
  46. (12/19): libXv-1.0.11-7.el8.x86_64.rpm 214 kB/s | 20 kB 00:00
  47. (13/19): libXxf86misc-1.0.4-1.el8.x86_64.rpm 640 kB/s | 23 kB 00:00
  48. (14/19): libdmx-1.1.4-3.el8.x86_64.rpm 290 kB/s | 22 kB 00:00
  49. (15/19): libXxf86vm-1.1.4-9.el8.x86_64.rpm 188 kB/s | 19 kB 00:00
  50. (16/19): xorg-x11-utils-7.5-28.el8.x86_64.rpm 3.6 MB/s | 136 kB 00:00
  51. (17/19): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 1.4 MB/s | 39 kB 00:00
  52. (18/19): oracle-database-preinstall-23ai-1.0-4.el8.x86_64.rpm 368 kB/s | 31 kB 00:00
  53. (19/19): libXmu-1.1.3-1.el8.x86_64.rpm 38 kB/s | 75 kB 00:02
  54. -------------------------------------------------------------------------------------------------------------------------------------------------------------------
  55. Total 791 kB/s | 1.7 MB 00:02
  56. Running transaction check
  57. Transaction check succeeded.
  58. Running transaction test
  59. Transaction test succeeded.
  60. Running transaction
  61. Preparing : 1/1
  62. Installing : libXi-1.7.10-1.el8.x86_64 1/19
  63. Installing : libICE-1.0.9-15.el8.x86_64 2/19
  64. Installing : libSM-1.2.3-1.el8.x86_64 3/19
  65. Installing : libXt-1.1.5-12.el8.x86_64 4/19
  66. Installing : libXmu-1.1.3-1.el8.x86_64 5/19
  67. Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 6/19
  68. Installing : libXtst-1.2.3-7.el8.x86_64 7/19
  69. Installing : libdmx-1.1.4-3.el8.x86_64 8/19
  70. Installing : libXxf86vm-1.1.4-9.el8.x86_64 9/19
  71. Installing : libXxf86misc-1.0.4-1.el8.x86_64 10/19
  72. Installing : libXxf86dga-1.1.5-1.el8.x86_64 11/19
  73. Installing : libXv-1.0.11-7.el8.x86_64 12/19
  74. Installing : libXrandr-1.5.2-1.el8.x86_64 13/19
  75. Installing : libXinerama-1.1.4-1.el8.x86_64 14/19
  76. Installing : libXcomposite-0.4.4-14.el8.x86_64 15/19
  77. Installing : libX11-xcb-1.6.8-9.el8_10.x86_64 16/19
  78. Installing : xorg-x11-utils-7.5-28.el8.x86_64 17/19
  79. Installing : ksh-20120801-267.0.1.el8.x86_64 18/19
  80. Running scriptlet: ksh-20120801-267.0.1.el8.x86_64 18/19
  81. Installing : oracle-database-preinstall-23ai-1.0-4.el8.x86_64 19/19
  82. Running scriptlet: oracle-database-preinstall-23ai-1.0-4.el8.x86_64 19/19
  83. Verifying : ksh-20120801-267.0.1.el8.x86_64 1/19
  84. Verifying : libICE-1.0.9-15.el8.x86_64 2/19
  85. Verifying : libSM-1.2.3-1.el8.x86_64 3/19
  86. Verifying : libX11-xcb-1.6.8-9.el8_10.x86_64 4/19
  87. Verifying : libXcomposite-0.4.4-14.el8.x86_64 5/19
  88. Verifying : libXi-1.7.10-1.el8.x86_64 6/19
  89. Verifying : libXinerama-1.1.4-1.el8.x86_64 7/19
  90. Verifying : libXmu-1.1.3-1.el8.x86_64 8/19
  91. Verifying : libXrandr-1.5.2-1.el8.x86_64 9/19
  92. Verifying : libXt-1.1.5-12.el8.x86_64 10/19
  93. Verifying : libXtst-1.2.3-7.el8.x86_64 11/19
  94. Verifying : libXv-1.0.11-7.el8.x86_64 12/19
  95. Verifying : libXxf86dga-1.1.5-1.el8.x86_64 13/19
  96. Verifying : libXxf86misc-1.0.4-1.el8.x86_64 14/19
  97. Verifying : libXxf86vm-1.1.4-9.el8.x86_64 15/19
  98. Verifying : libdmx-1.1.4-3.el8.x86_64 16/19
  99. Verifying : oracle-database-preinstall-23ai-1.0-4.el8.x86_64 17/19
  100. Verifying : xorg-x11-utils-7.5-28.el8.x86_64 18/19
  101. Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 19/19
  102. Installed:
  103. ksh-20120801-267.0.1.el8.x86_64 libICE-1.0.9-15.el8.x86_64 libSM-1.2.3-1.el8.x86_64 libX11-xcb-1.6.8-9.el8_10.x86_64
  104. libXcomposite-0.4.4-14.el8.x86_64 libXi-1.7.10-1.el8.x86_64 libXinerama-1.1.4-1.el8.x86_64 libXmu-1.1.3-1.el8.x86_64
  105. libXrandr-1.5.2-1.el8.x86_64 libXt-1.1.5-12.el8.x86_64 libXtst-1.2.3-7.el8.x86_64 libXv-1.0.11-7.el8.x86_64
  106. libXxf86dga-1.1.5-1.el8.x86_64 libXxf86misc-1.0.4-1.el8.x86_64 libXxf86vm-1.1.4-9.el8.x86_64 libdmx-1.1.4-3.el8.x86_64
  107. oracle-database-preinstall-23ai-1.0-4.el8.x86_64 xorg-x11-utils-7.5-28.el8.x86_64 xorg-x11-xauth-1:1.0.9-12.el8.x86_64
  108. Complete!

此外,截至目前,Oracle 23ai的通用平台OP版本还没有正式发布出来,想测试功能的伙伴可以移步《23ai免费版本环境快速就绪》。

原文链接:https://www.cnblogs.com/jyzhao/p/18756648/zaioci-shang-kuai-su-jing-mo-an-zhuang23ai-shu-ju

 友情链接:直通硅谷  点职佳  北美留学生论坛

本站QQ群:前端 618073944 | Java 606181507 | Python 626812652 | C/C++ 612253063 | 微信 634508462 | 苹果 692586424 | C#/.net 182808419 | PHP 305140648 | 运维 608723728

W3xue 的所有内容仅供测试,对任何法律问题及风险不承担任何责任。通过使用本站内容随之而来的风险与本站无关。
关于我们  |  意见建议  |  捐助我们  |  报错有奖  |  广告合作、友情链接(目前9元/月)请联系QQ:27243702 沸活量
皖ICP备17017327号-2 皖公网安备34020702000426号