在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 SUSE 15 SP5 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellin
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 SUSE 15 SP5 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：SUSE 15 SP5 一键安装 Oracle 12CR2（220118）单机版安装包合集（包含补丁！！！）
1# 主机版本2suse15:/soft # cat /etc/os-release 3NAME="SLES"4VERSION="15-SP5"5VERSION_ID="15.5"6PRETTY_NAME="SUSE Linux Enterprise Server 15 SP5"7ID="sles"8ID_LIKE="suse"9ANSI_COLOR="0;32"10CPE_NAME="cpe:/o:suse:sles:15:sp5"11DOCUMENTATION_URL="https://documentation.suse.com/"1213# 网络信息14suse15:/soft # ip a152: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 100016 link/ether 00:0c:29:4e:7a:77 brd ff:ff:ff:ff:ff:ff17 altname enp11s018 altname ens19219 inet 192.168.6.138/24 brd 192.168.6.255 scope global eth020 valid_lft forever preferred_lft forever21 inet6 fe80::20c:29ff:fe4e:7a77/64 scope link 22 valid_lft forever preferred_lft forever2324# 挂载本地 ISO 镜像25suse15:/soft # mount | grep iso9660 | grep -v "/run/media"26/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)27suse15:/soft # df -h|grep /mnt28/dev/sr0 14G 14G 0 100% /mnt2930# 安装包存放在 /soft 目录下31suse15:/soft # ll32-rwx------ 1 root root 3453696911 Mar 27 13:38 LINUX.X64_122010_db_home.zip33-rwxr-xr-x 1 root root 166840 Mar 27 13:37 OracleShellInstall34-rwxr-xr-x 1 root root 138022236 Mar 27 13:37 p33561275_122010_Linux-x86-64.zip35-rwx------ 1 root root 1020001457 Mar 27 13:38 p33587128_122010_Linux-x86-64.zip36-rwx------ 1 root root 124109254 Mar 27 13:37 p6880880_122010_Linux-x86-64.zip37-rwx------ 1 root root 321590 Mar 26 10:35 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf eth0 `# local ip ifname`\3-n suse15 `# hostname`\4-op oracle `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o lucifer `# dbname`\8-dp oracle `# sys/system password`\9-ds AL32UTF8 `# database character`\10-ns AL16UTF16 `# national character`\11-redo 100 `# redo size`\12-opa 33587128 `# oracle PSU/RU`\13-jpa 33561275 `# OJVM PSU/RU`\14-opd Y `# optimize db`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
1 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██2 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██3 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██4░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██5░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██6░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██7 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███8 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 91011请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : si1213数据库安装模式: single 1415请选择数据库版本 [11/12/19/21] : 121617数据库版本: 12 1819#==============================================================# 20配置本地 YUM 源 21#==============================================================# 2223Adding repository 'sles' [...done]24Repository 'sles' successfully added2526URI : dir:/mnt/Module-Basesystem27Enabled : Yes28GPG Check : Yes29Autorefresh : Yes30Priority : 99 (default priority)3132Repository priorities are without effect. All enabled repositories share the same priority.33Adding repository 'sles-Legacy' [...done]34Repository 'sles-Legacy' successfully added3536URI : dir:/mnt/Module-Legacy37Enabled : Yes38GPG Check : Yes39Autorefresh : Yes40Priority : 99 (default priority)4142Repository priorities are without effect. All enabled repositories share the same priority.43Adding repository 'sles-Tools' [...done]44Repository 'sles-Tools' successfully added4546URI : dir:/mnt/Module-Development-Tools47Enabled : Yes48GPG Check : Yes49Autorefresh : Yes50Priority : 99 (default priority)5152Repository priorities are without effect. All enabled repositories share the same priority.5354#==============================================================# 55禁用防火墙 56#==============================================================# 5758○ firewalld.service - firewalld - dynamic firewall daemon59 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: disabled)60 Active: inactive (dead)61 Docs: man:firewalld(1)6263Mar 25 16:02:33 localhost systemd[1]: Starting firewalld - dynamic firewall daemon...64Mar 25 16:02:37 localhost systemd[1]: Started firewalld - dynamic firewall daemon.65Mar 27 13:41:21 suse15 systemd[1]: Stopping firewalld - dynamic firewall daemon...66Mar 27 13:41:22 suse15 systemd[1]: firewalld.service: Deactivated successfully.67Mar 27 13:41:22 suse15 systemd[1]: Stopped firewalld - dynamic firewall daemon.6869#==============================================================# 70YUM 静默安装依赖包 71#==============================================================# 7273bc-1.07.1-11.37.x86_6474binutils-2.39-150100.7.40.1.x86_6475package compat-libcap1 is not installed76gcc-7-3.9.1.x86_6477gcc-c++-7-3.9.1.x86_6478package elfutils-libelf is not installed79package elfutils-libelf-devel is not installed80glibc-2.31-150300.46.1.x86_6481glibc-devel-2.31-150300.46.1.x86_6482package libaio is not installed83libaio-devel-0.3.109-1.25.x86_6484package libgcc is not installed85package libstdc++ is not installed86libstdc++-devel-7-3.9.1.x86_6487package libxcb is not installed88package libX11 is not installed89package libXau is not installed90package libXi is not installed91package libXrender is not installed92make-4.2.1-7.3.2.x86_6493net-tools-2.0+git20170221.479bb4a-3.11.x86_6494smartmontools-7.2-150300.8.8.1.x86_6495sysstat-12.0.2-3.33.1.x86_6496e2fsprogs-1.46.4-150400.3.3.1.x86_6497package e2fsprogs-libs is not installed98unzip-6.00-150000.4.11.1.x86_6499openssh-clients-8.4p1-150300.3.18.2.x86_64100package readline is not installed101readline-devel-7.0-150400.25.22.x86_64102psmisc-23.0-150000.6.22.1.x86_64103package ksh is not installed104package nfs-utils is not installed105tar-1.34-150000.3.31.1.x86_64106package device-mapper-multipath is not installed107avahi-0.8-150400.7.3.1.x86_64108ntp-4.2.8p15-150000.4.22.1.x86_64109chrony-4.1-150400.19.4.x86_64110package libXtst is not installed111libXrender-devel-0.9.10-1.30.x86_64112fontconfig-devel-2.13.1-150400.1.4.x86_64113policycoreutils-3.1-150400.1.5.x86_64114package policycoreutils-python is not installed115insserv-compat-0.1-4.6.1.noarch116libXext-devel-1.3.3-1.30.x86_64117libXi-devel-1.7.9-3.2.1.x86_64118libcap-ng-utils-0.7.9-4.37.x86_64119libcap-progs-2.63-150400.1.7.x86_64120libcap1-1.97-1.15.x86_64121libpcap1-1.10.1-150400.1.7.x86_64122libpcre16-0-8.45-150000.20.13.1.x86_64123pixz-1.0.6-1.13.x86_64124rdma-core-devel-42.0-150500.1.3.x86_64125xorg-x11-libs-7.6.1-1.16.noarch126compat-libpthread-nonshared-0-150300.3.6.1.x86_64127package librdmacm is not installed128package libnsl* is not installed129libibverbs-42.0-150500.1.3.x86_64130package compat-openssl10 is not installed131policycoreutils-python-utils-3.1-150400.1.5.noarch132package elfutils* is not installed133glibc-2.31-150300.46.1.x86_64134135#==============================================================# 136配置主机名 137#==============================================================# 138139suse15140141#==============================================================# 142配置 /etc/hosts 文件 143#==============================================================# 144145127.0.0.1 localhost146::1 localhost ipv6-localhost ipv6-loopback147fe00::0 ipv6-localnet148ff00::0 ipv6-mcastprefix149ff02::1 ipv6-allnodes150ff02::2 ipv6-allrouters151ff02::3 ipv6-allhosts152192.168.6.138 suse15153154#==============================================================# 155创建用户和组 156#==============================================================# 157158oracle 用户： 159160uid=54321(oracle) gid=54321(oinstall) groups=54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54321(oinstall)161162163#==============================================================# 164配置 Avahi-daemon 服务 165#==============================================================# 166167○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack168 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)169 Active: inactive (dead)170TriggeredBy: ○ avahi-daemon.socket171172#==============================================================# 173配置透明大页 && NUMA && 磁盘 IO 调度器 174#==============================================================# 175176Generating grub configuration file ...177Found theme: /boot/grub2/themes/SLE/theme.txt178Found linux image: /boot/vmlinuz-5.14.21-150500.53-default179Found initrd image: /boot/initrd-5.14.21-150500.53-default180Adding boot menu entry for UEFI Firmware Settings ...181done182183#==============================================================# 184配置 sysctl.conf 185#==============================================================# 186187fs.aio-max-nr = 1048576188fs.file-max = 6815744189kernel.shmall = 2097152190kernel.shmmax = 8332693503191kernel.shmmni = 4096192kernel.sem = 250 32000 100 128193net.ipv4.ip_local_port_range = 9000 65500194net.core.rmem_default = 262144195net.core.rmem_max = 4194304196net.core.wmem_default = 262144197net.core.wmem_max = 1048576198vm.min_free_kbytes = 32549199net.ipv4.conf.eth0.rp_filter = 1200vm.swappiness = 10201kernel.panic_on_oops = 1202kernel.randomize_va_space = 2203kernel.numa_balancing = 0204205#==============================================================# 206配置 RemoveIPC 207#==============================================================# 208209[Login]210211#==============================================================# 212配置 /etc/security/limits.conf 和 /etc/pam.d/login 213#==============================================================# 214215查看 /etc/security/limits.conf： 216217oracle soft nofile 1024218oracle hard nofile 65536219oracle soft stack 10240220oracle hard stack 32768221oracle soft nproc 2047222oracle hard nproc 16384223oracle hard memlock unlimited224oracle soft memlock unlimited225226查看 /etc/pam.d/login 文件： 227228auth requisite pam_nologin.so229auth include common-auth230account include common-account231password include common-password232session required pam_loginuid.so233session optional pam_keyinit.so force revoke234session include common-session235session optional pam_mail.so standard236session required pam_limits.so237session required /lib64/security/pam_limits.so238239#==============================================================# 240配置 /dev/shm 241#==============================================================# 242243/dev/rootgv/rootlv / xfs defaults 0 0244UUID=e16e4a70-ce93-4f3e-9103-7b9243fcabcc /boot xfs defaults 0 0245UUID=CBDD-C51E /boot/efi vfat utf8 0 2246/dev/rootgv/swaplv swap swap defaults 0 0247tmpfs /dev/shm tmpfs size=8137396k 0 0248249#==============================================================# 250安装 rlwrap 插件 251#==============================================================# 252253成功安装 rlwrap： rlwrap 0.44 254255#==============================================================# 256Root 用户环境变量 257#==============================================================# 258259alias so='su - oracle'260export PS1="[`whoami`@`hostname`:"'$PWD]$ '261262#==============================================================# 263Oracle 用户环境变量 264#==============================================================# 265266umask 022267export TMP=/tmp268export TMPDIR=$TMP269export NLS_LANG=AMERICAN_AMERICA.AL32UTF8270export ORACLE_BASE=/u01/app/oracle271export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db272export ORACLE_TERM=xterm273export TNS_ADMIN=$ORACLE_HOME/network/admin274export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib275export ORACLE_SID=lucifer276export PATH=/usr/sbin:$PATH277export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH278export PERL5LIB=$ORACLE_HOME/perl/lib279alias sas='sqlplus / as sysdba'280alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'281alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'282alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'283export PS1="[`whoami`@`hostname`:"'$PWD]$ '284export CV_ASSUME_DISTID=OL7285alias sqlplus='rlwrap sqlplus'286alias rman='rlwrap rman'287alias adrci='rlwrap adrci'288289#==============================================================# 290静默解压 Oracle 软件包 291#==============================================================# 292293正在静默解压缩 Oracle 软件包，请稍等： 294295.---- -. -. . . . .296( .',----- - - ' ' ' __297 \_/ ;--:- __--------------------___ ____=========_||___298__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|299c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |300,_\___________'_|,L______],|______________________|_i,!________________!_i301/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)302""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""303304静默解压 Oracle 软件安装包： /soft/LINUX.X64_122010_db_home.zip 305306静默解压 Oracle 软件补丁包： /soft/p33587128*.zip 307308静默解压 OJVM 软件补丁包： /soft/p33561275*.zip 309310#==============================================================# 311Oracle 安装静默文件 312#==============================================================# 313314oracle.install.option=INSTALL_DB_SWONLY315UNIX_GROUP_NAME=oinstall316INVENTORY_LOCATION=/u01/app/oraInventory317ORACLE_BASE=/u01/app/oracle318oracle.install.db.InstallEdition=EE319oracle.install.db.DBA_GROUP=dba320oracle.install.db.OPER_GROUP=oper321oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0322SELECTED_LANGUAGES=en,zh_CN323ORACLE_HOME=/u01/app/oracle/product/12.2.0/db324oracle.install.db.OSBACKUPDBA_GROUP=backupdba325oracle.install.db.OSDGDBA_GROUP=dgdba326oracle.install.db.OSKMDBA_GROUP=kmdba327oracle.install.db.OSRACDBA_GROUP=racdba328329#==============================================================# 330静默安装数据库软件 331#==============================================================# 332333Starting Oracle Universal Installer...334335Checking Temp space: must be greater than 500 MB. Actual 77573 MB Passed336Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed337Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-27_01-46-17PM. Please wait ...You can find the log of this install session at:338 /u01/app/oraInventory/logs/installActions2024-03-27_01-46-17PM.log339340Prepare in progress.341.................................................. 8% Done.342343Prepare successful.344345Copy files in progress.346.................................................. 17% Done.347.................................................. 22% Done.348.................................................. 27% Done.349.................................................. 32% Done.350.................................................. 40% Done.351.................................................. 45% Done.352.................................................. 50% Done.353.................................................. 55% Done.354.................................................. 60% Done.355.................................................. 65% Done.356.................................................. 70% Done.357.................................................. 75% Done.358.................................................. 80% Done.359....................360Copy files successful.361362Link binaries in progress.363..........364Link binaries successful.365366Setup files in progress.367..............................368Setup files successful.369370Setup Inventory in progress.371372Setup Inventory successful.373374Finish Setup successful.375The installation of Oracle Database 12c was successful.376Please check '/u01/app/oraInventory/logs/silentInstall2024-03-27_01-46-17PM.log' for more details.377378Setup Oracle Base in progress.379380Setup Oracle Base successful.381.................................................. 95% Done.382383As a root user, execute the following script(s):384 1. /u01/app/oraInventory/orainstRoot.sh385 2. /u01/app/oracle/product/12.2.0/db/root.sh386387388389.................................................. 100% Done.390Successfully Setup Software.391392#==============================================================# 393执行 root 脚本 394#==============================================================# 395396Changing permissions of /u01/app/oraInventory.397Adding read,write permissions for group.398Removing read,write,execute permissions for world.399400Changing groupname of /u01/app/oraInventory to oinstall.401The execution of the script is complete.402Check /u01/app/oracle/product/12.2.0/db/install/root_suse15_2024-03-27_13-54-58-046457064.log for the output of root script403404#==============================================================# 405Oracle 软件安装补丁 406#==============================================================# 407408Oracle Interim Patch Installer version 12.2.0.1.30409Copyright (c) 2024, Oracle Corporation. All rights reserved.410411PREREQ session412413Oracle Home : /u01/app/oracle/product/12.2.0/db414Central Inventory : /u01/app/oraInventory415 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc416OPatch version : 12.2.0.1.30417OUI version : 12.2.0.1.4418Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-55-05PM_1.log419420Invoking prereq "checkconflictagainstohwithdetail"421422Prereq "checkConflictAgainstOHWithDetail" passed.423424OPatch succeeded.425Oracle Interim Patch Installer version 12.2.0.1.30426Copyright (c) 2024, Oracle Corporation. All rights reserved.427428429Oracle Home : /u01/app/oracle/product/12.2.0/db430Central Inventory : /u01/app/oraInventory431 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc432OPatch version : 12.2.0.1.30433OUI version : 12.2.0.1.4434Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-55-07PM_1.log435436Verifying environment and performing prerequisite checks...437OPatch continues with these patches: 33587128 438439Do you want to proceed? [y|n]440Y (auto-answered by -silent)441User Responded with: Y442All checks passed.443444Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.445(Oracle Home = '/u01/app/oracle/product/12.2.0/db')446447448Is the local system ready for patching? [y|n]449Y (auto-answered by -silent)450User Responded with: Y451Backing up files...452Applying interim patch '33587128' to OH '/u01/app/oracle/product/12.2.0/db'453ApplySession: Optional component(s) [ oracle.swd, 12.2.0.1.0 ] , [ oracle.swd.oui, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] , [ oracle.network.gsm, 12.2.0.1.0 ] , [ oracle.rdbms.drdaas, 12.2.0.1.0 ] , [ oracle.ons.cclient, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.ons.eons.bwcompat, 12.2.0.1.0 ] , [ oracle.oid.client, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.454455Patching component oracle.rdbms.util, 12.2.0.1.0...456457Patching component oracle.rdbms, 12.2.0.1.0...458459Patching component oracle.network.rsf, 12.2.0.1.0...460461Patching component oracle.rdbms.rsf, 12.2.0.1.0...462463Patching component oracle.ctx, 12.2.0.1.0...464465Patching component oracle.has.common.cvu, 12.2.0.1.0...466467Patching component oracle.ldap.owm, 12.2.0.1.0...468469Patching component oracle.ldap.rsf, 12.2.0.1.0...470471Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...472473Patching component oracle.oracore.rsf, 12.2.0.1.0...474475Patching component oracle.oraolap, 12.2.0.1.0...476477Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...478479Patching component oracle.rdbms.deconfig, 12.2.0.1.0...480481Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...482483Patching component oracle.sdo, 12.2.0.1.0...484485Patching component oracle.sdo.locator, 12.2.0.1.0...486487Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...488489Patching component oracle.tfa, 12.2.0.1.0...490491Patching component oracle.ctx.rsf, 12.2.0.1.0...492493Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...494495Patching component oracle.rdbms.install.common, 12.2.0.1.0...496497Patching component oracle.assistants.deconfig, 12.2.0.1.0...498499Patching component oracle.ons.ic, 12.2.0.1.0...500501Patching component oracle.rdbms.rman, 12.2.0.1.0...502503Patching component oracle.precomp.rsf, 12.2.0.1.0...504505Patching component oracle.install.deinstalltool, 12.2.0.1.0...506507Patching component oracle.assistants.acf, 12.2.0.1.0...508509Patching component oracle.rdbms.oci, 12.2.0.1.0...510511Patching component oracle.sqlplus.ic, 12.2.0.1.0...512513Patching component oracle.xdk.parser.java, 12.2.0.1.0...514515Patching component oracle.dbtoolslistener, 12.2.0.1.0...516517Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...518519Patching component oracle.rdbms.dv, 12.2.0.1.0...520521Patching component oracle.rdbms.lbac, 12.2.0.1.0...522523Patching component oracle.ons, 12.2.0.1.0...524525Patching component oracle.ldap.client, 12.2.0.1.0...526527Patching component oracle.xdk, 12.2.0.1.0...528529Patching component oracle.xdk.rsf, 12.2.0.1.0...530531Patching component oracle.sqlplus, 12.2.0.1.0...532533Patching component oracle.assistants.server, 12.2.0.1.0...534535Patching component oracle.rdbms.crs, 12.2.0.1.0...536537Patching component oracle.precomp.common, 12.2.0.1.0...538539Patching component oracle.precomp.lang, 12.2.0.1.0...540541Patching component oracle.jdk, 1.8.0.91.0...542543OPatch found the word "error" in the stderr of the make command.544Please look at this stderr. You can re-run this make command.545Stderr output:546chmod: changing permissions of '/u01/app/oracle/product/12.2.0/db/bin/extjobO': Operation not permitted547make: [ins_rdbms.mk:533: iextjob] Error 1 (ignored)548549550Patch 33587128 successfully applied.551OPatch Session completed with warnings.552Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-55-07PM_1.log553554OPatch completed with warnings.555556#==============================================================# 557OJVM 补丁安装 558#==============================================================# 559560Oracle Interim Patch Installer version 12.2.0.1.30561Copyright (c) 2024, Oracle Corporation. All rights reserved.562563PREREQ session564565Oracle Home : /u01/app/oracle/product/12.2.0/db566Central Inventory : /u01/app/oraInventory567 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc568OPatch version : 12.2.0.1.30569OUI version : 12.2.0.1.4570Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_14-02-48PM_1.log571572Invoking prereq "checkconflictagainstohwithdetail"573574Prereq "checkConflictAgainstOHWithDetail" passed.575576OPatch succeeded.577Oracle Interim Patch Installer version 12.2.0.1.30578Copyright (c) 2024, Oracle Corporation. All rights reserved.579580581Oracle Home : /u01/app/oracle/product/12.2.0/db582Central Inventory : /u01/app/oraInventory583 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc584OPatch version : 12.2.0.1.30585OUI version : 12.2.0.1.4586Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_14-02-50PM_1.log587588Verifying environment and performing prerequisite checks...589OPatch continues with these patches: 33561275 590591Do you want to proceed? [y|n]592Y (auto-answered by -silent)593User Responded with: Y594All checks passed.595596Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.597(Oracle Home = '/u01/app/oracle/product/12.2.0/db')598599600Is the local system ready for patching? [y|n]601Y (auto-answered by -silent)602User Responded with: Y603Backing up files...604Applying interim patch '33561275' to OH '/u01/app/oracle/product/12.2.0/db'605606Patching component oracle.javavm.server, 12.2.0.1.0...607608Patching component oracle.javavm.server.core, 12.2.0.1.0...609610Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...611612Patching component oracle.javavm.client, 12.2.0.1.0...613614Patching component oracle.rdbms, 12.2.0.1.0...615616Patching component oracle.dbjava.jdbc, 12.2.0.1.0...617618Patching component oracle.dbjava.ic, 12.2.0.1.0...619Patch 33561275 successfully applied.620Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_14-02-50PM_1.log621622OPatch succeeded.623624#==============================================================# 625Oracle 软件版本 626#==============================================================# 627628629SQL*Plus: Release 12.2.0.1.0 Production630631632#==============================================================# 633Oracle 补丁信息 634#==============================================================# 63563633561275;OJVM RELEASE UPDATE 12.2.0.1.220118 (33561275)63733587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)638639OPatch succeeded.640641642#==============================================================# 643配置监听 644#==============================================================# 645646647Parsing command line arguments:648 Parameter "silent" = true649 Parameter "responsefile" = /u01/app/oracle/product/12.2.0/db/assistants/netca/netca.rsp650Done parsing command line arguments.651Oracle Net Services Configuration:652Profile configuration complete.653Oracle Net Listener Startup:654 Running Listener Control: 655 /u01/app/oracle/product/12.2.0/db/bin/lsnrctl start LISTENER656 Listener Control complete.657 Listener started successfully.658Listener configuration complete.659Oracle Net Services configuration successful. The exit code is 0660661检查监听状态： 662663664LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-MAR-2024 14:04:14665666Copyright (c) 1991, 2016, Oracle. All rights reserved.667668Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=suse15)(PORT=1521)))669STATUS of the LISTENER670------------------------671Alias LISTENER672Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production673Start Date 27-MAR-2024 14:04:14674Uptime 0 days 0 hr. 0 min. 0 sec675Trace Level off676Security ON: Local OS Authentication677SNMP OFF678Listener Parameter File /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora679Listener Log File /u01/app/oracle/diag/tnslsnr/suse15/listener/alert/log.xml680Listening Endpoints Summary...681 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=suse15)(PORT=1521)))682 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))683The listener supports no services684The command completed successfully685686#==============================================================# 687静默建库命令 688#==============================================================# 689690dbca -silent -createDatabase \691-ignorePrereqFailure \692-templateName General_Purpose.dbc \693-responseFile NO_VALUE \694-gdbName lucifer \695-sid lucifer \696-sysPassword oracle \697-systemPassword oracle \698-redoLogFileSize 100 \699-datafileDestination /oradata \700-storageType FS \701-enableArchive true \702-archiveLogDest /oradata \703-databaseConfigType SINGLE \704-characterset AL32UTF8 \705-nationalCharacterSet AL16UTF16 \706-emConfiguration NONE \707-automaticMemoryManagement false \708-totalMemory 3973 \709-databaseType OLTP \710-createAsContainerDatabase false 711712#==============================================================# 713创建数据库 714#==============================================================# 715716[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.717 CAUSE: 718a. 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].719b.The password entered is a keyword that Oracle does not recommend to be used as password720 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.721[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.722 CAUSE: 723a. 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].724b.The password entered is a keyword that Oracle does not recommend to be used as password725 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.726Copying database files7271% complete7282% complete72918% complete73033% complete731Creating and starting Oracle instance73235% complete73340% complete73444% complete73549% complete73650% complete73753% complete73855% complete739Completing Database Creation74056% complete74157% complete74258% complete74362% complete74465% complete74566% complete746Executing Post Configuration Actions747100% complete748Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.749750#==============================================================# 751配置在线重做日志 752#==============================================================# 753754数据库在线重做日志文件： 755756757 THREAD# GROUP# MEMBER size(M)758---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------759 1 1 /oradata/lucifer/redo01.log 100760 1 2 /oradata/lucifer/redo02.log 100761 1 3 /oradata/lucifer/redo03.log 100762 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m07gbjnj_.log 100763 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m07gbjr3_.log 100764 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m07gbjv4_.log 100765 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m07gbjyr_.log 100766 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m07gbk4n_.log 100767768#==============================================================# 769配置 RMAN 备份任务 770#==============================================================# 771772## OracleBegin77300 02 * * * /home/oracle/scripts/del_arch.sh774#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh775#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh776777#==============================================================# 778配置 glogin.sql 779#==============================================================# 780781define _editor=vi782set serveroutput on size 1000000783set pagesize 9999784set long 99999785set trimspool on786col name format a80787set termout off788define gname=idle789column global_name new_value gname790select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, length(global_name), dot-1) ) global_name from (select global_name, instr(global_name,'.') dot from global_name );791ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';792set sqlprompt '&gname _DATE> '793set termout on794795#==============================================================# 796优化数据库参数 797#==============================================================# 798799数据库参数： 800801802NAME SID SPVALUE VALUE803-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------804_b_tree_bitmap_plans * FALSE FALSE805_datafile_write_errors_crash_instance * FALSE FALSE806audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump807audit_trail * NONE DB808compatible * 12.2.0 12.2.0809control_file_record_keep_time * 31 31810db_block_size * 8192 8192811db_create_file_dest * /oradata /oradata812db_file_multiblock_read_count * 128813db_files * 5000 200814db_name * lucifer lucifer815db_writer_processes * 1816deferred_segment_creation * FALSE FALSE817diagnostic_dest * /u01/app/oracle /u01/app/oracle818dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)819event * 10949 trace name context forever,level 1820event * 28401 trace name context forever,level 1821fast_start_parallel_rollback * LOW822log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog823log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf824max_dump_file_size * unlimited825max_string_size * STANDARD826nls_language * AMERICAN AMERICAN827nls_territory * AMERICA AMERICA828open_cursors * 1000 300829optimizer_adaptive_plans * TRUE830optimizer_adaptive_statistics * FALSE831optimizer_index_caching * 0832optimizer_mode * ALL_ROWS833parallel_force_local * FALSE834parallel_max_servers * 64 64835pga_aggregate_target * 1332740096 833617920836processes * 2000 640837remote_login_passwordfile * EXCLUSIVE EXCLUSIVE838session_cached_cursors * 300 50839sessions * 984840sga_max_size * 5332008960 3338665984841sga_target * 5332008960 3338665984842spfile * /u01/app/oracle/product/12.2.0/db/dbs/spfilelucifer.ora843statistics_level * TYPICAL844undo_retention * 10800 900845846恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y