在知识库中专注阅读，并随时返回相关工具与课程
@TOC目录 最近拿到了 23ai 的本地版安装包，之前也写了一篇手动安装 Oracle 23ai RAC 的文章：装个 Oracle 23ai RAC 玩玩~https://mp.weixin.qq.com/s/UIZEEFnFClr60JmfS4XZPA，当时文章里说会尽快适配好 23ai 的一键安装，正好晚上有空适配了一下，花了半小时左右调整了一下静默安装的模版，已经搞定了！ 本文先演示一下
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
最近拿到了 23ai 的本地版安装包，之前也写了一篇手动安装 Oracle 23ai RAC 的文章：装个 Oracle 23ai RAC 玩玩~，当时文章里说会尽快适配好 23ai 的一键安装，正好晚上有空适配了一下，花了半小时左右调整了一下静默安装的模版，已经搞定了！
本文先演示一下用一键安装脚本安装 Oracle 23ai 的过程，过两天再发一篇 23ai RAC 的一键安装。
安装使用方式和之前一样，安装命令通用，不分操作系统版本，同一套命令安装所有 Oracle 场景。
操作系统版本：
1[root@orcl:/root]# cat /etc/os-release 2NAME="Oracle Linux Server"3VERSION="8.10"4ID="ol"5ID_LIKE="fedora"6VARIANT="Server"7VARIANT_ID="server"8VERSION_ID="8.10"9PLATFORM_ID="platform:el8"10PRETTY_NAME="Oracle Linux Server 8.10"11ANSI_COLOR="0;31"12CPE_NAME="cpe:/o:oracle:linux:8:10:server"13HOME_URL="https://linux.oracle.com/"14BUG_REPORT_URL="https://github.com/oracle/oracle-linux"1516ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"17ORACLE_BUGZILLA_PRODUCT_VERSION=8.1018ORACLE_SUPPORT_PRODUCT="Oracle Linux"19ORACLE_SUPPORT_PRODUCT_VERSION=8.10查看网络配置情况：
1[root@orcl:/root]# ip a21: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 10003 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:004 inet 127.0.0.1/8 scope host lo5 valid_lft forever preferred_lft forever6 inet6 ::1/128 scope host 7 valid_lft forever preferred_lft forever82: ens192: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 10009 link/ether 00:0c:29:8f:22:48 brd ff:ff:ff:ff:ff:ff10 altname enp11s011 inet 192.168.31.102/24 brd 192.168.31.255 scope global noprefixroute ens19212 valid_lft forever preferred_lft forever13 inet6 fe80::20c:29ff:fe8f:2248/64 scope link noprefixroute 14 valid_lft forever preferred_lft forever获取网卡名称 ens192。
手动挂载操作系统镜像，脚本会自动配置本地 YUM 源：
1[root@orcl:/root]# mount /dev/cdrom /mnt/2mount: /mnt: WARNING: device write-protected, mounted read-only.3[root@orcl:/root]# df -h | grep /mnt4/dev/sr0 14G 14G 0 100% /mnt要用 everything 版本的镜像，否则可能会缺包。
提前上传安装介质和安装脚本：
1[root@orcl:/soft]# ls2LINUX.X64_235000_db_home.zip OracleShellInstall默认使用专业版脚本。脚本下载：ora100.com/shell-install
使用我配套开发的 Oracle 一键安装命令生成工具 可视化填写参数，获取一键安装命令：
切换到安装包和脚本所在目录，执行一键安装即可：
1[root@orcl23ai soft]# ./OracleShellInstall \2-lf ens192 `# 公网IP的网卡名称`\3-pdb pdb01 `# PDB名称`\4-opd Y `# 优化数据库`56 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██7 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██8 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██9░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██10░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██11░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██12 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███13 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 141516注意：本脚本仅用于新服务器上实施部署数据库使用，严禁在已运行数据库的主机上执行，以免发生数据丢失或者损坏，造成不可挽回的损失！！！ 1718请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : si1920数据库安装模式: single 2122请选择数据库版本 [11|12|19|21|23] : 232324数据库版本: 23 2526OracleShellInstall 开始安装，详细安装过程可查看日志： tail -2000f /soft/print_shell_install_20250825214052.log 2728正在进行安装前检查，请稍等...... 2930正在检测安装包 /soft/LINUX.X64_235000_db_home.zip 的 MD5 值是否正确，请稍等...... 3132正在配置本地软件源......已完成 (耗时: 1 秒)33正在获取操作系统信息......已完成 (耗时: 1 秒)34正在安装依赖包......已完成 (耗时: 113 秒)35正在禁用防火墙......已完成 (耗时: 2 秒)36正在禁用 selinux......已完成 (耗时: 1 秒)37正在配置 nsyctl......已完成 (耗时: 1 秒)38正在配置主机名和 hosts 文件......已完成 (耗时: 1 秒)39正在创建用户和组......已完成 (耗时: 2 秒)40正在创建安装目录......已完成 (耗时: 1 秒)41正在配置 Avahi-daemon 服务......已完成 (耗时: 1 秒)42正在配置透明大页 && NUMA && 磁盘 IO 调度器......已完成 (耗时: 4 秒)43正在配置操作系统参数 sysctl......已完成 (耗时: 1 秒)44正在配置 RemoveIPC......已完成 (耗时: 1 秒)45正在配置用户限制 limit......已完成 (耗时: 1 秒)46正在配置 shm 目录......已完成 (耗时: 1 秒)47正在安装 rlwrap 插件......已完成 (耗时: 16 秒)48正在配置用户环境变量......已完成 (耗时: 1 秒)49正在解压 Oracle 安装包以及补丁......已完成 (耗时: 51 秒)50正在安装 Oracle 软件以及补丁......已完成 (耗时: 170 秒)51正在创建监听......已完成 (耗时: 5 秒)52正在创建数据库......已完成 (耗时: 473 秒)53正在优化数据库......已完成 (耗时: 121 秒)5455恭喜！Oracle 一键安装执行完成 (耗时: 973 秒)，现在是否重启主机：[Y/N] Y5657正在重启当前节点主机......默认使用专业版脚本。脚本下载：ora100.com/shell-install 因为我虚拟化环境的磁盘是机械盘，所以安装不是很快，如果是 SSD，估计 10 分钟不到就装完了。
重启主机后，数据库自动启动：
1[root@orcl:/soft]# so23## 数据库开机自启4[oracle@orcl:/home/oracle]$ ps -ef|grep pmon5oracle 1861 1 0 22:36 ? 00:00:00 ora_pmon_orcl6oracle 3353 3313 0 22:58 pts/0 00:00:00 grep --color=auto pmon78## 自动配置归档删除和备份定时任务9[oracle@orcl:/home/oracle]$ crontab -l10# OracleBegin1100 02 * * * /home/oracle/scripts/del_arch_orcl.sh12#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0_orcl.sh13#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1_orcl.sh1415## 自动配置 SQLNET 优化16[oracle@orcl:/home/oracle]$ cat $TNS_ADMIN/sqlnet.ora17# sqlnet.ora Network Configuration File: /u01/app/oracle/product/23.5.0/db/network/admin/sqlnet.ora18# Generated by Oracle configuration tools.1920NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)2122# OracleBegin23SQLNET.ALLOWED_LOGON_VERSION_CLIENT=824SQLNET.ALLOWED_LOGON_VERSION_SERVER=82526## 各种快捷别名，运维便捷27alias sas='sqlplus / as sysdba'28alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'29alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'30alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'31export PS1="[`whoami`@`hostname`:"'$PWD]$ '32alias bdf='df -Th'33alias acd='cd $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace'34alias dblog='tail -200f $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'3536## 支持别名快速连接数据库37[oracle@orcl:/home/oracle]$ sas3839SQL*Plus: Release 23.0.0.0.0 - Production on Mon Aug 25 22:58:35 202540Version 23.8.0.25.044142Copyright (c) 1982, 2025, Oracle. All rights reserved.434445Connected to:46Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Limited Availability47Version 23.8.0.25.044849## 默认创建一个 PDB01，可根据参数自定义 PDB 名称（支持安装过程中同时创建多个 PDB）50SYS@orcl SQL> show pdbs5152 CON_ID CON_NAME OPEN MODE RESTRICTED53---------- ------------------------------ ---------- ----------54 2 PDB$SEED READ ONLY NO55 3 PDB01 READ WRITE NO5657## 默认开启归档模式，可根据参数自定义是否开启归档58SYS@orcl SQL> archive log list59Database log mode Archive Mode60Automatic archival Enabled61Archive destination /oradata/archivelog62Oldest online log sequence 263Next log sequence to archive 264Current log sequence 16566## 默认创建 8 组 1G 的在线重做日志，可根据参数定义日志文件大小（默认 1G）67SYS@orcl SQL> select group#,thread#,bytes/1024/1024,status from v$log;6869 GROUP# THREAD# BYTES/1024/1024 STATUS70---------- ---------- --------------- ----------------71 1 1 1024 INACTIVE72 2 1 1024 CURRENT73 3 1 1024 UNUSED74 4 1 1024 UNUSED75 5 1 1024 UNUSED76 6 1 1024 UNUSED77 7 1 1024 UNUSED78 8 1 1024 UNUSED79808 rows selected.以上都是一键安装脚本自动完成，没有任何人为配置，更多优化内容不一一展示，最后附上完整的一键安装详细日志：
1Mon Aug 25 21:40:55 CST 202523#==============================================================# 4配置本地软件源 5#==============================================================# 67[BaseOS]8name=BaseOS9baseurl=file:///mnt/BaseOS10enabled=111gpgcheck=012[AppStream]13name=AppStream14baseurl=file:///mnt/AppStream15enabled=116gpgcheck=01718#==============================================================# 19打印系统信息 20#==============================================================# 2122服务器时间: 2324Mon Aug 25 21:41:00 CST 20252526操作系统版本: 2728NAME="Oracle Linux Server"29VERSION="8.10"30ID="ol"31ID_LIKE="fedora"32VARIANT="Server"33VARIANT_ID="server"34VERSION_ID="8.10"35PLATFORM_ID="platform:el8"36PRETTY_NAME="Oracle Linux Server 8.10"37ANSI_COLOR="0;31"38CPE_NAME="cpe:/o:oracle:linux:8:10:server"39HOME_URL="https://linux.oracle.com/"40BUG_REPORT_URL="https://github.com/oracle/oracle-linux"4142ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"43ORACLE_BUGZILLA_PRODUCT_VERSION=8.1044ORACLE_SUPPORT_PRODUCT="Oracle Linux"45ORACLE_SUPPORT_PRODUCT_VERSION=8.104647内核信息: 4849Linux version 5.15.0-206.153.7.1.el8uek.x86_64 (mockbuild@host-100-100-224-14) (gcc (GCC) 11.4.1 20230605 (Red Hat 11.4.1-2.1.0.1), GNU ld version 2.36.1-4.0.2.el8_6) #2 SMP Wed May 22 20:49:34 PDT 20245051Glibc 版本: 52532.285455CPU 信息: 5657型号名称 ：Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz 58物理 CPU 个数 ：4 59每个物理 CPU 的逻辑核数 ：2 60系统的 CPU 线程数 ：8 61系统的 CPU 类型 ：x86_64 6263内存信息: 6465 total used free shared buff/cache available66Mem: 7932 637 4636 10 2658 702367Swap: 8191 0 81916869挂载信息: 7071/dev/mapper/ol-root / xfs defaults 0 072UUID=92390a0d-1af9-4e77-9403-6c705eec2494 /boot xfs defaults 0 073UUID=D974-8153 /boot/efi vfat umask=0077,shortname=winnt 0 274/dev/mapper/ol-swap none swap defaults 0 07576目录信息: 7778Filesystem Size Used Avail Use% Mounted on79devtmpfs 3.9G 0 3.9G 0% /dev80tmpfs 3.9G 0 3.9G 0% /dev/shm81tmpfs 3.9G 9.3M 3.9G 1% /run82tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup83/dev/mapper/ol-root 91G 8.2G 83G 9% /84/dev/sda2 1014M 322M 693M 32% /boot85/dev/sda1 599M 6.0M 593M 1% /boot/efi86tmpfs 794M 12K 794M 1% /run/user/4287tmpfs 794M 0 794M 0% /run/user/088/dev/sr0 14G 14G 0 100% /mnt8990#==============================================================# 91安装依赖软件包 92#==============================================================# 9394psmisc \95tar \96glibc \97libaio \98libgcc \99libstdc++ \100bc \101make \102binutils \103glibc-devel \104ksh \105libstdc++-devel \106unzip \107gcc \108gcc-c++ \109libnsl \110initscripts \111libaio-devel \112e2fsprogs \113e2fsprogs-libs \114smartmontools \115net-tools \116nfs-utils \117elfutils-libelf \118elfutils-libelf-devel \119libibverbs \120librdmacm \121fontconfig \122fontconfig-devel \123libXrender \124libXrender-devel \125libX11 \126libXau \127libXi \128libXtst \129libxcb \130unixODBC \131sysstat \132readline \133readline-devel \134policycoreutils \135libvirt-libs \136policycoreutils-python-utils \137libnsl2 \138libasan \139liblsan \140compat-openssl10 \141libxcrypt-compat \142compat-openssl11 \143libgfortran \144rlwrap 145146147#==============================================================# 148静默安装软件包 149#==============================================================# 150151检查必需软件包安装情况： 152153psmisc-23.1-5.el8.x86_64154tar-1.30-9.el8.x86_64155glibc-2.28-251.0.2.el8.x86_64156libaio-0.3.112-1.el8.x86_64157libgcc-8.5.0-21.0.1.el8.x86_64158libstdc++-8.5.0-21.0.1.el8.x86_64159bc-1.07.1-5.el8.x86_64160make-4.2.1-11.el8.x86_64161binutils-2.30-123.0.2.el8.x86_64162glibc-devel-2.28-251.0.2.el8.x86_64163ksh-20120801-267.0.1.el8.x86_64164libstdc++-devel-8.5.0-21.0.1.el8.x86_64165unzip-6.0-46.0.1.el8.x86_64166gcc-8.5.0-21.0.1.el8.x86_64167gcc-c++-8.5.0-21.0.1.el8.x86_64168libnsl-2.28-251.0.2.el8.x86_64169initscripts-10.00.18-1.0.1.el8.x86_64170171#==============================================================# 172禁用防火墙 173#==============================================================# 174175● firewalld.service - firewalld - dynamic firewall daemon176 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)177 Active: inactive (dead) since Mon 2025-08-25 21:42:54 CST; 402ms ago178 Docs: man:firewalld(1)179 Main PID: 1209 (code=exited, status=0/SUCCESS)180181Aug 24 22:17:46 orcl23ai systemd[1]: Starting firewalld - dynamic firewall daemon...182Aug 24 22:18:00 orcl23ai systemd[1]: Started firewalld - dynamic firewall daemon.183Aug 24 22:18:01 orcl23ai firewalld[1209]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.184Aug 25 21:42:54 orcl23ai systemd[1]: Stopping firewalld - dynamic firewall daemon...185Aug 25 21:42:54 orcl23ai systemd[1]: firewalld.service: Succeeded.186Aug 25 21:42:54 orcl23ai systemd[1]: Stopped firewalld - dynamic firewall daemon.187188#==============================================================# 189禁用 SELinux 190#==============================================================# 191192SELinux status: enabled193SELinuxfs mount: /sys/fs/selinux194SELinux root directory: /etc/selinux195Loaded policy name: targeted196Current mode: permissive197Mode from config file: disabled198Policy MLS status: enabled199Policy deny_unknown status: allowed200Memory protection checking: actual (secure)201Max kernel policy version: 33202203#==============================================================# 204配置 nsysctl.conf 205#==============================================================# 206207NOZEROCONF=yes208209#==============================================================# 210配置主机名 211#==============================================================# 212213 Static hostname: orcl214 Icon name: computer-vm215 Chassis: vm216 Machine ID: 2361e9c20d1d4403aeb1be8b44a81b87217 Boot ID: 4f1c9139827648d9bd79e9cf6a072ca3218 Virtualization: vmware219 Operating System: Oracle Linux Server 8.10220 CPE OS Name: cpe:/o:oracle:linux:8:10:server221 Kernel: Linux 5.15.0-206.153.7.1.el8uek.x86_64222 Architecture: x86-64223224#==============================================================# 225配置 /etc/hosts 文件 226#==============================================================# 227228127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4229::1 localhost localhost.localdomain localhost6 localhost6.localdomain6230192.168.31.102 orcl231232#==============================================================# 233创建用户和组 234#==============================================================# 235236oracle 用户： 237238uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)239240241#==============================================================# 242配置 Avahi-daemon 服务 243#==============================================================# 244245● avahi-daemon.service - Avahi mDNS/DNS-SD Stack246 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)247 Active: inactive (dead)248249Aug 24 22:18:16 orcl23ai avahi-daemon[1107]: New relevant interface virbr0.IPv4 for mDNS.250Aug 24 22:18:16 orcl23ai avahi-daemon[1107]: Registering new address record for 192.168.122.1 on virbr0.IPv4.251Aug 25 21:43:02 orcl systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...252Aug 25 21:43:02 orcl avahi-daemon[1107]: Got SIGTERM, quitting.253Aug 25 21:43:02 orcl avahi-daemon[1107]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.254Aug 25 21:43:02 orcl avahi-daemon[1107]: Leaving mDNS multicast group on interface ens192.IPv6 with address fe80::20c:29ff:fe8f:2248.255Aug 25 21:43:02 orcl avahi-daemon[1107]: Leaving mDNS multicast group on interface ens192.IPv4 with address 192.168.31.102.256Aug 25 21:43:02 orcl avahi-daemon[1107]: avahi-daemon 0.7 exiting.257Aug 25 21:43:02 orcl systemd[1]: avahi-daemon.service: Succeeded.258Aug 25 21:43:02 orcl systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.259260#==============================================================# 261配置透明大页 && NUMA && 磁盘 IO 调度器 262#==============================================================# 263264args="ro resume=/dev/mapper/ol-swap rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline $tuned_params"265-resume=/dev/mapper/ol-swap266-args="ro267args="ro resume=/dev/mapper/ol-swap rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline $tuned_params"268-elevator=deadline269-transparent_hugepage=never270args="ro resume=/dev/mapper/ol-swap rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline $tuned_params"271-272-273274#==============================================================# 275配置 sysctl.conf 276#==============================================================# 277278查看 sysctl.conf 配置情况 ：sysctl -p 279280fs.aio-max-nr = 1048576281fs.file-max = 6815744282kernel.shmall = 2097152283kernel.shmmax = 8317681654284kernel.shmmni = 4096285kernel.sem = 250 32000 100 128286net.ipv4.ip_local_port_range = 9000 65500287net.core.rmem_default = 262144288net.core.rmem_max = 4194304289net.core.wmem_default = 262144290net.core.wmem_max = 1048576291vm.min_free_kbytes = 32490292net.ipv4.conf.ens192.rp_filter = 1293vm.swappiness = 10294kernel.panic_on_oops = 1295kernel.randomize_va_space = 2296vm.hugetlb_shm_group = 54321297kernel.numa_balancing = 0298299#==============================================================# 300配置 RemoveIPC 301#==============================================================# 302303查看 RemoveIPC ：/etc/systemd/logind.conf 304305RemoveIPC=no306RemoveIPC=no307308#==============================================================# 309配置 /etc/security/limits.conf 和 /etc/pam.d/login 310#==============================================================# 311312查看 /etc/security/limits.conf： 313314oracle soft nofile 1024315oracle hard nofile 65536316oracle soft stack 10240317oracle hard stack 32768318oracle soft nproc 16384319oracle hard nproc 16384320oracle hard memlock unlimited321oracle soft memlock unlimited322323查看 /etc/pam.d/login 文件： 324325auth substack system-auth326auth include postlogin327account required pam_nologin.so328account include system-auth329password include system-auth330session required pam_selinux.so close331session required pam_loginuid.so332session optional pam_console.so333session required pam_selinux.so open334session required pam_namespace.so335session optional pam_keyinit.so force revoke336session include system-auth337session include postlogin338-session optional pam_ck_connector.so339session required pam_limits.so340341#==============================================================# 342配置 /dev/shm 343#==============================================================# 344345查看 Linux 挂载情况：/etc/fstab 346347/dev/mapper/ol-root / xfs defaults 0 0348UUID=92390a0d-1af9-4e77-9403-6c705eec2494 /boot xfs defaults 0 0349UUID=D974-8153 /boot/efi vfat umask=0077,shortname=winnt 0 2350/dev/mapper/ol-swap none swap defaults 0 0351tmpfs /dev/shm tmpfs size=8122736k 0 0352353#==============================================================# 354安装 rlwrap 插件 355#==============================================================# 356357成功安装 rlwrap： rlwrap 0.44 358359#==============================================================# 360Root 用户环境变量 361#==============================================================# 362363查看 root 用户环境变量：/root/.bash_profile 364365if [ -f ~/.bashrc ]; then366 . ~/.bashrc367fi368PATH=$PATH:$HOME/bin369export PATH370alias so='su - oracle'371export PS1=[`whoami`@`hostname`:'$PWD]# '372alias bdf='df -Th'373alias syslog='vi /var/log/messages'374375#==============================================================# 376oracle 用户环境变量，实例名：orcl 377#==============================================================# 378379查看 oracle 用户环境变量：/home/oracle/.bash_profile 380381if [ -f ~/.bashrc ]; then382 . ~/.bashrc383fi384umask 022385export TMP=/tmp386export TMPDIR=$TMP387export NLS_LANG=AMERICAN_AMERICA.AL32UTF8388export ORACLE_BASE=/u01/app/oracle389export ORACLE_HOME=/u01/app/oracle/product/23.5.0/db390export ORACLE_TERM=xterm391export TNS_ADMIN=$ORACLE_HOME/network/admin392export ORACLE_SID=orcl393export PATH=/usr/sbin:$PATH394export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH395export PERL5LIB=$ORACLE_HOME/perl/lib396alias sas='sqlplus / as sysdba'397alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'398alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'399alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'400export PS1="[`whoami`@`hostname`:"'$PWD]$ '401alias bdf='df -Th'402alias acd='cd $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace'403alias dblog='tail -200f $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'404export CV_ASSUME_DISTID=OL8405alias sqlplus='rlwrap sqlplus'406alias rman='rlwrap rman'407alias adrci='rlwrap adrci'408409#==============================================================# 410静默解压 Oracle 软件包 411#==============================================================# 412413正在静默解压缩 Oracle 软件包，请稍等： 414415416静默解压 Oracle 软件安装包： /soft/LINUX.X64_235000_db_home.zip 417418#==============================================================# 419Oracle 安装静默文件 420#==============================================================# 421422oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0423installOption=INSTALL_DB_SWONLY424UNIX_GROUP_NAME=oinstall425INVENTORY_LOCATION=/u01/app/oraInventory426ORACLE_BASE=/u01/app/oracle427ORACLE_HOME=/u01/app/oracle/product/23.5.0/db428installEdition=EE429OSDBA=dba430OSOPER=oper431OSBACKUPDBA=backupdba432OSDGDBA=dgdba433OSKMDBA=kmdba434OSRACDBA=racdba435436#==============================================================# 437静默安装 Oracle 软件命令 438#==============================================================# 439440/u01/app/oracle/product/23.5.0/db/runInstaller \441-silent \442-ignorePrereqFailure \443-responseFile /soft/oracle.rsp \444-waitForCompletion 445446447#==============================================================# 448静默安装数据库软件 449#==============================================================# 450451检查 Oracle 软件 OPacth 版本： 452453OPatch Version: 12.2.0.1.46454455OPatch succeeded.456457正在安装 Oracle 软件： 458459Launching Oracle Database Setup Wizard...460461The response file for this session can be found at:462 /u01/app/oracle/product/23.5.0/db/install/response/db_2025-08-25_09-44-21PM.rsp463464You can find the log of this install session at:465 /tmp/InstallActions2025-08-25_09-44-21PM/installActions2025-08-25_09-44-21PM.log466467As a root user, run the following script(s):468 1. /u01/app/oraInventory/orainstRoot.sh469 2. /u01/app/oracle/product/23.5.0/db/root.sh470471Run /u01/app/oraInventory/orainstRoot.sh on the following nodes: 472[orcl]473Run /u01/app/oracle/product/23.5.0/db/root.sh on the following nodes: 474[orcl]475476477Successfully Setup Software.478Moved the install session logs to:479 /u01/app/oraInventory/logs/InstallActions2025-08-25_09-44-21PM480481#==============================================================# 482执行 root 脚本 483#==============================================================# 484485执行命令：/u01/app/oraInventory/orainstRoot.sh 486487Changing permissions of /u01/app/oraInventory.488Adding read,write permissions for group.489Removing read,write,execute permissions for world.490491Changing groupname of /u01/app/oraInventory to oinstall.492The execution of the script is complete.493494执行命令：/u01/app/oracle/product/23.5.0/db/root.sh 495496Check /u01/app/oracle/product/23.5.0/db/install/root_orcl_2025-08-25_21-47-03-468441092.log for the output of root script497498#==============================================================# 499Oracle 软件版本 500#==============================================================# 501502503SQL*Plus: Release 23.0.0.0.0 - Production504Version 23.8.0.25.04505506507#==============================================================# 508Oracle 补丁信息 509#==============================================================# 51051137701424;OCW RELEASE UPDATE 23.8.0.25.04 (37701424) Gold Image51237701421;Database Release Update : 23.8.0.25.04 (37701421) Gold Image513514OPatch succeeded.515516#==============================================================# 517静默安装 Oracle 软件命令 518#==============================================================# 519520/u01/app/oracle/product/23.5.0/db/bin/netca -silent \521-responsefile /u01/app/oracle/product/23.5.0/db/assistants/netca/netca.rsp 522523524#==============================================================# 525创建监听 526#==============================================================# 527528正在创建监听： 529530531Parsing command line arguments:532 Parameter "silent" = true533 Parameter "responsefile" = /u01/app/oracle/product/23.5.0/db/assistants/netca/netca.rsp534Done parsing command line arguments.535Oracle Net Services Configuration:536Profile configuration complete.537Oracle Net Listener Startup:538 Running Listener Control: 539 /u01/app/oracle/product/23.5.0/db/bin/lsnrctl start LISTENER540 Listener Control complete.541 Listener started successfully.542Listener configuration complete.543Oracle Net Services configuration successful. The exit code is 0544545546#==============================================================# 547检查监听状态 548#==============================================================# 549550551LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 25-AUG-2025 21:47:13552553Copyright (c) 1991, 2025, Oracle. All rights reserved.554555Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl)(PORT=1521)))556STATUS of the LISTENER557------------------------558Alias LISTENER559Version TNSLSNR for Linux: Version 23.0.0.0.0 - Production560Start Date 25-AUG-2025 21:47:13561Uptime 0 days 0 hr. 0 min. 1 sec562Trace Level off563Security ON: Local OS Authentication564SNMP OFF565Listener Parameter File /u01/app/oracle/product/23.5.0/db/network/admin/listener.ora566Listener Log File /u01/app/oracle/diag/tnslsnr/orcl/listener/alert/log.xml567Listening Endpoints Summary...568 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl)(PORT=1521)))569 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))570The listener supports no services571The command completed successfully572573#==============================================================# 574DBCA 静默建库文件：orcl 575#==============================================================# 576577gdbName=orcl578sid=orcl579templateName=General_Purpose.dbc580sysPassword=oracle581systemPassword=oracle582characterSet=AL32UTF8583nationalCharacterSet=AL16UTF16584automaticMemoryManagement=false585totalMemory=6345586initParams=db_block_size=8192BYTES587createAsContainerDatabase=true588databaseConfigType=SI589storageType=FS590datafileDestination=/oradata591recoveryAreaDestination=/oradata592responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v23.0.0593594#==============================================================# 595静默创建数据库命令 596#==============================================================# 597598/u01/app/oracle/product/23.5.0/db/bin/dbca -silent -createDatabase \599-responseFile /soft/db.rsp \600-ignorePreReqs \601-ignorePrereqFailure \602-J-Doracle.assistants.dbca.validate.ConfigurationParams=false \603-initParams _exadata_feature_on=true 604605606#==============================================================# 607创建数据库实例：orcl 608#==============================================================# 609610正在创建数据库：orcl 611612[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.613 CAUSE: 614a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].615b.The password entered is a keyword that Oracle does not recommend to be used as password616 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.617[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.618 CAUSE: 619a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].620b.The password entered is a keyword that Oracle does not recommend to be used as password621 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.622Prepare for db operation62310% complete624Copying database files62540% complete626Creating and starting Oracle instance62742% complete62846% complete62950% complete63054% complete63160% complete632Completing Database Creation63366% complete63469% complete63570% complete636Executing Post Configuration Actions637100% complete638Database creation complete. For details check the logfiles at:639 /u01/app/oracle/cfgtoollogs/dbca/orcl.640Database Information:641Global Database Name:orcl642System Identifier(SID):orcl643Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.644645#==============================================================# 646创建 PDB 数据库 647#==============================================================# 648649正在创建 PDB：pdb01 650651652 CON_ID CON_NAME OPEN MODE RESTRICTED653---------- ------------------------------ ---------- ----------654 2 PDB$SEED READ ONLY NO655 3 PDB01 READ WRITE NO656657#==============================================================# 658配置 Oracle 数据库控制文件复用 659#==============================================================# 660661662数据库控制文件： 663664665NAME666----------------------------------------------------------------------------------------------------667/oradata/ORCL/control01.ctl668/oradata/ORCL/control02.ctl669670#==============================================================# 671配置在线重做日志 672#==============================================================# 673674675 THREAD# GROUP# MEMBER size(M)676---------- ---------- -------------------------------------------------------------------------------- ----------677 1 1 /oradata/ORCL/redo01.log 1024678 1 2 /oradata/ORCL/redo02.log 1024679 1 3 /oradata/ORCL/redo03.log 1024680 1 4 /oradata/ORCL/redo04.log 1024681 1 5 /oradata/ORCL/redo05.log 1024682 1 6 /oradata/ORCL/redo06.log 1024683 1 7 /oradata/ORCL/redo07.log 1024684 1 8 /oradata/ORCL/redo08.log 1024685686#==============================================================# 687配置 Oracle 数据库开机自启 688#==============================================================# 689690数据库开机自启配置： 691692touch /var/lock/subsys/local693su oracle -lc "/u01/app/oracle/product/23.5.0/db/bin/lsnrctl start"694su oracle -lc "/u01/app/oracle/product/23.5.0/db/bin/dbstart"695696#==============================================================# 697配置 RMAN 备份任务 698#==============================================================# 699700# OracleBegin70100 02 * * * /home/oracle/scripts/del_arch_orcl.sh702#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0_orcl.sh703#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1_orcl.sh704705#==============================================================# 706优化数据库参数 707#==============================================================# 708709数据库参数： 710711712NAME SID SPVALUE VALUE713-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------714_b_tree_bitmap_plans * FALSE FALSE715_datafile_write_errors_crash_instance * FALSE FALSE716_exadata_feature_on * true TRUE717audit_trail * NONE NONE718compatible * 23.6.0 23.6.0719control_file_record_keep_time * 31 31720db_block_size * 8192 8192721db_create_file_dest * /oradata /oradata722db_file_multiblock_read_count * 128723db_files * 5000 200724db_name * orcl orcl725db_writer_processes * 1726deferred_segment_creation * FALSE FALSE727diagnostic_dest * /u01/app/oracle /u01/app/oracle728dispatchers * (PROTOCOL=TCP) (SERVICE=orclXDB) (PROTOCOL=TCP) (SERVICE=orclXDB)729enable_pluggable_database * true TRUE730event * 10949 trace name context forever,level 1731event * 28401 trace name context forever,level 1732fast_start_parallel_rollback * LOW733log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog734log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf735max_dump_file_size * 1G736max_string_size * STANDARD737nls_language * AMERICAN AMERICAN738nls_territory * AMERICA AMERICA739open_cursors * 1000 300740optimizer_adaptive_plans * TRUE741optimizer_adaptive_statistics * FALSE742optimizer_index_caching * 0743optimizer_mode * ALL_ROWS744parallel_force_local * FALSE745parallel_max_servers * 64 64746pga_aggregate_target * 1330642944 1664090112747processes * 2000 640748remote_login_passwordfile * EXCLUSIVE EXCLUSIVE749session_cached_cursors * 300 50750sessions * 984751sga_max_size * 5322571776 4999610368752sga_target * 5322571776 4999610368753spfile * /u01/app/oracle/product/23.5.0/db/dbs/spfileorcl.ora754statistics_level * TYPICAL755undo_retention * 10800 900756757#==============================================================# 758配置 glogin.sql 759#==============================================================# 760761define _editor=vi762set serveroutput on size 1000000763set trimspool on764set long 5000765set linesize 100766set pagesize 9999767column plan_plus_exp format a80768set sqlprompt '&_user.@&_connect_identifier. SQL> '有心人可以根据我的安装日志就可以完成手动静默安装 Oracle 23ai 啦！
其实 Oracle 23ai RAC 一键安装我已经测试完了，但是没时间整理文章，等我有时间整理好了就发出来！886~