在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 龙蜥 Anolis OS 8.8 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oraclesh
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 龙蜥 Anolis OS 8.8 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：龙蜥 Anolis OS 8.8 一键安装 Oracle 12CR2（220118）单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@anolis8 soft]# cat /etc/anolis-release3Anolis OS release 8.845# 网络信息6[root@anolis8 soft]# ip a72: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 10008 link/ether 00:0c:29:c3:5e:e1 brd ff:ff:ff:ff:ff:ff9 altname enp2s110 inet 192.168.6.137/24 brd 192.168.6.255 scope global noprefixroute ens3311 valid_lft forever preferred_lft forever12 inet6 fe80::20c:29ff:fec3:5ee1/64 scope link noprefixroute 13 valid_lft forever preferred_lft forever1415# 挂载本地 ISO 镜像16[root@anolis8 soft]# mount | grep iso | grep -v "/run/media"17/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)18[root@anolis8 soft]# df -h|grep /mnt19/dev/sr0 15G 15G 0 100% /mnt2021# 安装包存放在 /soft 目录下22[root@anolis8 soft]# ll23-rwx------ 1 root root 3453696911 Mar 27 12:34 LINUX.X64_122010_db_home.zip24-rwxr-xr-x 1 root root 166855 Mar 27 12:33 OracleShellInstall25-rwx------ 1 root root 138022236 Mar 27 12:39 p33561275_122010_Linux-x86-64.zip26-rwx------ 1 root root 1020001457 Mar 27 12:34 p33587128_122010_Linux-x86-64.zip27-rwx------ 1 root root 124109254 Mar 27 12:34 p6880880_122010_Linux-x86-64.zip28-rwx------ 1 root root 321590 Mar 27 12:39 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n anolis8 `# 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#==============================================================# 2223[BaseOS]24name=BaseOS25baseurl=file:///mnt/BaseOS26enabled=127gpgcheck=028[AppStream]29name=AppStream30baseurl=file:///mnt/AppStream31enabled=132gpgcheck=03334#==============================================================# 35禁用防火墙 36#==============================================================# 3738● firewalld.service - firewalld - dynamic firewall daemon39 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)40 Active: inactive (dead) since Wed 2024-03-27 13:31:31 CST; 76ms ago41 Docs: man:firewalld(1)42 Process: 1061 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)43 Main PID: 1061 (code=exited, status=0/SUCCESS)4445Mar 25 11:12:31 anolis8 systemd[1]: Starting firewalld - dynamic firewall daemon...46Mar 25 11:12:33 anolis8 systemd[1]: Started firewalld - dynamic firewall daemon.47Mar 25 11:12:33 anolis8 firewalld[1061]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.48Mar 27 13:31:30 anolis8 systemd[1]: Stopping firewalld - dynamic firewall daemon...49Mar 27 13:31:31 anolis8 systemd[1]: firewalld.service: Succeeded.50Mar 27 13:31:31 anolis8 systemd[1]: Stopped firewalld - dynamic firewall daemon.5152#==============================================================# 53禁用 SELinux 54#==============================================================# 5556SELinux status: disabled5758#==============================================================# 59配置 nsysctl.conf 60#==============================================================# 6162NOZEROCONF=yes6364#==============================================================# 65YUM 静默安装依赖包 66#==============================================================# 6768bc-1.07.1-5.0.1.an8.x86_6469binutils-2.30-117.0.1.an8.x86_6470package compat-libcap1 is not installed71gcc-8.5.0-10.1.0.3.an8.x86_6472gcc-c++-8.5.0-10.1.0.3.an8.x86_6473elfutils-libelf-0.187-4.0.1.an8.x86_6474elfutils-libelf-devel-0.187-4.0.1.an8.x86_6475glibc-2.28-189.5.0.2.an8_6.x86_6476glibc-devel-2.28-189.5.0.2.an8_6.x86_6477libaio-0.3.112-1.0.1.an8.x86_6478libaio-devel-0.3.112-1.0.1.an8.x86_6479libgcc-8.5.0-10.1.0.3.an8.x86_6480libstdc++-8.5.0-10.1.0.3.an8.x86_6481libstdc++-devel-8.5.0-10.1.0.3.an8.x86_6482libxcb-1.13.1-1.el8.x86_6483libX11-1.7.0-7.an8.x86_6484libXau-1.0.9-8.an8.x86_6485libXi-1.7.10-1.an8.x86_6486libXrender-0.9.10-7.el8.x86_6487make-4.2.1-11.0.1.an8.x86_6488net-tools-2.0-0.52.20160912git.an8.x86_6489smartmontools-7.1-1.0.2.an8.x86_6490sysstat-11.7.3-7.0.1.an8.x86_6491e2fsprogs-1.46.0-1.0.1.an8.x86_6492e2fsprogs-libs-1.46.0-1.0.1.an8.x86_6493unzip-6.0-46.0.1.an8.x86_6494openssh-clients-8.0p1-13.0.1.an8.x86_6495readline-7.0-10.0.1.an8.x86_6496readline-devel-7.0-10.0.1.an8.x86_6497psmisc-23.1-5.0.1.an8.x86_6498ksh-20120801-257.0.1.an8.x86_6499nfs-utils-2.3.3-51.0.3.an8.x86_64100tar-1.30-6.0.1.an8.x86_64101device-mapper-multipath-0.8.4-28.0.1.an8_6.2.x86_64102avahi-0.7-20.an8.x86_64103package ntp is not installed104chrony-4.2-1.0.1.an8.x86_64105libXtst-1.2.3-7.el8.x86_64106libXrender-devel-0.9.10-7.el8.x86_64107fontconfig-devel-2.13.1-4.an8.x86_64108policycoreutils-2.9-20.an8.x86_64109package policycoreutils-python is not installed110librdmacm-37.2-1.0.3.an8.x86_64111package libnsl* is not installed112libibverbs-37.2-1.0.3.an8.x86_64113compat-openssl10-1.0.2o-4.0.1.an8_6.x86_64114policycoreutils-python-utils-2.9-20.an8.noarch115package elfutils* is not installed116glibc-2.28-189.5.0.2.an8_6.x86_64117118#==============================================================# 119配置主机名 120#==============================================================# 121122anolis8123124#==============================================================# 125配置 /etc/hosts 文件 126#==============================================================# 127128127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4129::1 localhost localhost.localdomain localhost6 localhost6.localdomain6130192.168.6.137 anolis8131132#==============================================================# 133创建用户和组 134#==============================================================# 135136oracle 用户： 137138uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)139140141#==============================================================# 142配置 Avahi-daemon 服务 143#==============================================================# 144145● avahi-daemon.service - Avahi mDNS/DNS-SD Stack146 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)147 Active: inactive (dead)148149Mar 27 13:32:48 anolis8 avahi-daemon[910]: Files changed, reloading.150Mar 27 13:32:48 anolis8 avahi-daemon[910]: No service file found in /etc/avahi/services.151Mar 27 13:32:49 anolis8 avahi-daemon[910]: Got SIGTERM, quitting.152Mar 27 13:32:49 anolis8 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...153Mar 27 13:32:49 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.154Mar 27 13:32:49 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface ens33.IPv6 with address fe80::20c:29ff:fec3:5ee1.155Mar 27 13:32:49 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface ens33.IPv4 with address 192.168.6.137.156Mar 27 13:32:49 anolis8 avahi-daemon[910]: avahi-daemon 0.7 exiting.157Mar 27 13:32:49 anolis8 systemd[1]: avahi-daemon.service: Succeeded.158Mar 27 13:32:49 anolis8 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.159160#==============================================================# 161配置透明大页 && NUMA && 磁盘 IO 调度器 162#==============================================================# 163164args="ro resume=/dev/mapper/ao-swap rd.lvm.lv=ao/root rd.lvm.lv=ao/swap rhgb quiet $tuned_params cgroup.memory=nokmem crashkernel=0M-2G:0M,2G-8G:192M,8G-:256M numa=off transparent_hugepage=never elevator=deadline"165-resume=/dev/mapper/ao-swap166-args="ro167args="ro resume=/dev/mapper/ao-swap rd.lvm.lv=ao/root rd.lvm.lv=ao/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"168-elevator=deadline"169-transparent_hugepage=never170171#==============================================================# 172配置 sysctl.conf 173#==============================================================# 174175fs.aio-max-nr = 1048576176fs.file-max = 6815744177kernel.shmall = 2097152178kernel.shmmax = 8126386175179kernel.shmmni = 4096180kernel.sem = 250 32000 100 128181net.ipv4.ip_local_port_range = 9000 65500182net.core.rmem_default = 262144183net.core.rmem_max = 4194304184net.core.wmem_default = 262144185net.core.wmem_max = 1048576186vm.min_free_kbytes = 31743187net.ipv4.conf.ens33.rp_filter = 1188vm.swappiness = 10189kernel.panic_on_oops = 1190kernel.randomize_va_space = 2191kernel.numa_balancing = 0192193#==============================================================# 194配置 RemoveIPC 195#==============================================================# 196197[Login]198RemoveIPC=no199200#==============================================================# 201配置 /etc/security/limits.conf 和 /etc/pam.d/login 202#==============================================================# 203204查看 /etc/security/limits.conf： 205206oracle soft nofile 1024207oracle hard nofile 65536208oracle soft stack 10240209oracle hard stack 32768210oracle soft nproc 2047211oracle hard nproc 16384212oracle hard memlock unlimited213oracle soft memlock unlimited214215查看 /etc/pam.d/login 文件： 216217auth substack system-auth218auth include postlogin219account required pam_nologin.so220account include system-auth221password include system-auth222session required pam_selinux.so close223session required pam_loginuid.so224session optional pam_console.so225session required pam_selinux.so open226session required pam_namespace.so227session optional pam_keyinit.so force revoke228session include system-auth229session include postlogin230-session optional pam_ck_connector.so231session required pam_limits.so232session required /lib64/security/pam_limits.so233234#==============================================================# 235配置 /dev/shm 236#==============================================================# 237238/dev/mapper/ao-root / xfs defaults 0 0239UUID=5b4f444b-7f7f-4cf1-9e1b-474e447b8075 /boot xfs defaults 0 0240/dev/mapper/ao-swap none swap defaults 0 0241tmpfs /dev/shm tmpfs size=7935924k 0 0242243#==============================================================# 244安装 rlwrap 插件 245#==============================================================# 246247成功安装 rlwrap： rlwrap 0.44 248249#==============================================================# 250Root 用户环境变量 251#==============================================================# 252253if [ -f ~/.bashrc ]; then254 . ~/.bashrc255fi256PATH=$PATH:$HOME/bin257export PATH258alias so='su - oracle'259export PS1="[`whoami`@`hostname`:"'$PWD]$ '260261#==============================================================# 262Oracle 用户环境变量 263#==============================================================# 264265if [ -f ~/.bashrc ]; then266 . ~/.bashrc267fi268umask 022269export TMP=/tmp270export TMPDIR=$TMP271export NLS_LANG=AMERICAN_AMERICA.AL32UTF8272export ORACLE_BASE=/u01/app/oracle273export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db274export ORACLE_TERM=xterm275export TNS_ADMIN=$ORACLE_HOME/network/admin276export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib277export ORACLE_SID=lucifer278export PATH=/usr/sbin:$PATH279export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH280export PERL5LIB=$ORACLE_HOME/perl/lib281alias sas='sqlplus / as sysdba'282alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'283alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'284alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'285export PS1="[`whoami`@`hostname`:"'$PWD]$ '286export CV_ASSUME_DISTID=OL7287alias sqlplus='rlwrap sqlplus'288alias rman='rlwrap rman'289alias adrci='rlwrap adrci'290291#==============================================================# 292静默解压 Oracle 软件包 293#==============================================================# 294295正在静默解压缩 Oracle 软件包，请稍等： 296297.---- -. -. . . . .298( .',----- - - ' ' ' __299 \_/ ;--:- __--------------------___ ____=========_||___300__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|301c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |302,_\___________'_|,L______],|______________________|_i,!________________!_i303/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)304""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""305306静默解压 Oracle 软件安装包： /soft/LINUX.X64_122010_db_home.zip 307308静默解压 Oracle 软件补丁包： /soft/p33587128*.zip 309310静默解压 OJVM 软件补丁包： /soft/p33561275*.zip 311312#==============================================================# 313Oracle 安装静默文件 314#==============================================================# 315316oracle.install.option=INSTALL_DB_SWONLY317UNIX_GROUP_NAME=oinstall318INVENTORY_LOCATION=/u01/app/oraInventory319ORACLE_BASE=/u01/app/oracle320oracle.install.db.InstallEdition=EE321oracle.install.db.DBA_GROUP=dba322oracle.install.db.OPER_GROUP=oper323oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0324SELECTED_LANGUAGES=en,zh_CN325ORACLE_HOME=/u01/app/oracle/product/12.2.0/db326oracle.install.db.OSBACKUPDBA_GROUP=backupdba327oracle.install.db.OSDGDBA_GROUP=dgdba328oracle.install.db.OSKMDBA_GROUP=kmdba329oracle.install.db.OSRACDBA_GROUP=racdba330331#==============================================================# 332静默安装数据库软件 333#==============================================================# 334335Starting Oracle Universal Installer...336337Checking Temp space: must be greater than 500 MB. Actual 76481 MB Passed338Checking swap space: must be greater than 150 MB. Actual 8187 MB Passed339Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-03-27_01-34-33PM. Please wait ...You can find the log of this install session at:340 /u01/app/oraInventory/logs/installActions2024-03-27_01-34-33PM.log341342Prepare in progress.343.................................................. 8% Done.344345Prepare successful.346347Copy files in progress.348.................................................. 17% Done.349.................................................. 22% Done.350.................................................. 27% Done.351.................................................. 32% Done.352.................................................. 40% Done.353.................................................. 45% Done.354.................................................. 50% Done.355.................................................. 55% Done.356.................................................. 60% Done.357.................................................. 65% Done.358.................................................. 70% Done.359.................................................. 75% Done.360.................................................. 80% Done.361....................362Copy files successful.363364Link binaries in progress.365..........366Link binaries successful.367368Setup files in progress.369..............................370Setup files successful.371372Setup Inventory in progress.373374Setup Inventory successful.375376Finish Setup successful.377The installation of Oracle Database 12c was successful.378Please check '/u01/app/oraInventory/logs/silentInstall2024-03-27_01-34-33PM.log' for more details.379380Setup Oracle Base in progress.381382Setup Oracle Base successful.383.................................................. 95% Done.384385As a root user, execute the following script(s):386 1. /u01/app/oraInventory/orainstRoot.sh387 2. /u01/app/oracle/product/12.2.0/db/root.sh388389390391.................................................. 100% Done.392Successfully Setup Software.393394#==============================================================# 395执行 root 脚本 396#==============================================================# 397398Changing permissions of /u01/app/oraInventory.399Adding read,write permissions for group.400Removing read,write,execute permissions for world.401402Changing groupname of /u01/app/oraInventory to oinstall.403The execution of the script is complete.404Check /u01/app/oracle/product/12.2.0/db/install/root_anolis8_2024-03-27_13-42-38-709700253.log for the output of root script405406#==============================================================# 407Oracle 软件安装补丁 408#==============================================================# 409410Oracle Interim Patch Installer version 12.2.0.1.30411Copyright (c) 2024, Oracle Corporation. All rights reserved.412413PREREQ session414415Oracle Home : /u01/app/oracle/product/12.2.0/db416Central Inventory : /u01/app/oraInventory417 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc418OPatch version : 12.2.0.1.30419OUI version : 12.2.0.1.4420Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-43-23PM_1.log421422Invoking prereq "checkconflictagainstohwithdetail"423424Prereq "checkConflictAgainstOHWithDetail" passed.425426OPatch succeeded.427Oracle Interim Patch Installer version 12.2.0.1.30428Copyright (c) 2024, Oracle Corporation. All rights reserved.429430431Oracle Home : /u01/app/oracle/product/12.2.0/db432Central Inventory : /u01/app/oraInventory433 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc434OPatch version : 12.2.0.1.30435OUI version : 12.2.0.1.4436Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-43-27PM_1.log437438Verifying environment and performing prerequisite checks...439OPatch continues with these patches: 33587128 440441Do you want to proceed? [y|n]442Y (auto-answered by -silent)443User Responded with: Y444All checks passed.445446Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.447(Oracle Home = '/u01/app/oracle/product/12.2.0/db')448449450Is the local system ready for patching? [y|n]451Y (auto-answered by -silent)452User Responded with: Y453Backing up files...454Applying interim patch '33587128' to OH '/u01/app/oracle/product/12.2.0/db'455ApplySession: 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.456457Patching component oracle.rdbms.util, 12.2.0.1.0...458459Patching component oracle.rdbms, 12.2.0.1.0...460461Patching component oracle.network.rsf, 12.2.0.1.0...462463Patching component oracle.rdbms.rsf, 12.2.0.1.0...464465Patching component oracle.ctx, 12.2.0.1.0...466467Patching component oracle.has.common.cvu, 12.2.0.1.0...468469Patching component oracle.ldap.owm, 12.2.0.1.0...470471Patching component oracle.ldap.rsf, 12.2.0.1.0...472473Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...474475Patching component oracle.oracore.rsf, 12.2.0.1.0...476477Patching component oracle.oraolap, 12.2.0.1.0...478479Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...480481Patching component oracle.rdbms.deconfig, 12.2.0.1.0...482483Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...484485Patching component oracle.sdo, 12.2.0.1.0...486487Patching component oracle.sdo.locator, 12.2.0.1.0...488489Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...490491Patching component oracle.tfa, 12.2.0.1.0...492493Patching component oracle.ctx.rsf, 12.2.0.1.0...494495Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...496497Patching component oracle.rdbms.install.common, 12.2.0.1.0...498499Patching component oracle.assistants.deconfig, 12.2.0.1.0...500501Patching component oracle.ons.ic, 12.2.0.1.0...502503Patching component oracle.rdbms.rman, 12.2.0.1.0...504505Patching component oracle.precomp.rsf, 12.2.0.1.0...506507Patching component oracle.install.deinstalltool, 12.2.0.1.0...508509Patching component oracle.assistants.acf, 12.2.0.1.0...510511Patching component oracle.rdbms.oci, 12.2.0.1.0...512513Patching component oracle.sqlplus.ic, 12.2.0.1.0...514515Patching component oracle.xdk.parser.java, 12.2.0.1.0...516517Patching component oracle.dbtoolslistener, 12.2.0.1.0...518519Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...520521Patching component oracle.rdbms.dv, 12.2.0.1.0...522523Patching component oracle.rdbms.lbac, 12.2.0.1.0...524525Patching component oracle.ons, 12.2.0.1.0...526527Patching component oracle.ldap.client, 12.2.0.1.0...528529Patching component oracle.xdk, 12.2.0.1.0...530531Patching component oracle.xdk.rsf, 12.2.0.1.0...532533Patching component oracle.sqlplus, 12.2.0.1.0...534535Patching component oracle.assistants.server, 12.2.0.1.0...536537Patching component oracle.rdbms.crs, 12.2.0.1.0...538539Patching component oracle.precomp.common, 12.2.0.1.0...540541Patching component oracle.precomp.lang, 12.2.0.1.0...542543Patching component oracle.jdk, 1.8.0.91.0...544545OPatch found the word "error" in the stderr of the make command.546Please look at this stderr. You can re-run this make command.547Stderr output:548chmod: changing permissions of '/u01/app/oracle/product/12.2.0/db/bin/extjobO': Operation not permitted549make: [ins_rdbms.mk:533: iextjob] Error 1 (ignored)550551552Patch 33587128 successfully applied.553OPatch Session completed with warnings.554Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-43-27PM_1.log555556OPatch completed with warnings.557558#==============================================================# 559OJVM 补丁安装 560#==============================================================# 561562Oracle Interim Patch Installer version 12.2.0.1.30563Copyright (c) 2024, Oracle Corporation. All rights reserved.564565PREREQ session566567Oracle Home : /u01/app/oracle/product/12.2.0/db568Central Inventory : /u01/app/oraInventory569 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc570OPatch version : 12.2.0.1.30571OUI version : 12.2.0.1.4572Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-53-23PM_1.log573574Invoking prereq "checkconflictagainstohwithdetail"575576Prereq "checkConflictAgainstOHWithDetail" passed.577578OPatch succeeded.579Oracle Interim Patch Installer version 12.2.0.1.30580Copyright (c) 2024, Oracle Corporation. All rights reserved.581582583Oracle Home : /u01/app/oracle/product/12.2.0/db584Central Inventory : /u01/app/oraInventory585 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc586OPatch version : 12.2.0.1.30587OUI version : 12.2.0.1.4588Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-53-26PM_1.log589590Verifying environment and performing prerequisite checks...591OPatch continues with these patches: 33561275 592593Do you want to proceed? [y|n]594Y (auto-answered by -silent)595User Responded with: Y596All checks passed.597598Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.599(Oracle Home = '/u01/app/oracle/product/12.2.0/db')600601602Is the local system ready for patching? [y|n]603Y (auto-answered by -silent)604User Responded with: Y605Backing up files...606Applying interim patch '33561275' to OH '/u01/app/oracle/product/12.2.0/db'607608Patching component oracle.javavm.server, 12.2.0.1.0...609610Patching component oracle.javavm.server.core, 12.2.0.1.0...611612Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...613614Patching component oracle.javavm.client, 12.2.0.1.0...615616Patching component oracle.rdbms, 12.2.0.1.0...617618Patching component oracle.dbjava.jdbc, 12.2.0.1.0...619620Patching component oracle.dbjava.ic, 12.2.0.1.0...621Patch 33561275 successfully applied.622Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-03-27_13-53-26PM_1.log623624OPatch succeeded.625626#==============================================================# 627Oracle 软件版本 628#==============================================================# 629630631SQL*Plus: Release 12.2.0.1.0 Production632633634#==============================================================# 635Oracle 补丁信息 636#==============================================================# 63763833561275;OJVM RELEASE UPDATE 12.2.0.1.220118 (33561275)63933587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)640641OPatch succeeded.642643644#==============================================================# 645配置监听 646#==============================================================# 647648649Parsing command line arguments:650 Parameter "silent" = true651 Parameter "responsefile" = /u01/app/oracle/product/12.2.0/db/assistants/netca/netca.rsp652Done parsing command line arguments.653Oracle Net Services Configuration:654Profile configuration complete.655Oracle Net Listener Startup:656 Running Listener Control: 657 /u01/app/oracle/product/12.2.0/db/bin/lsnrctl start LISTENER658 Listener Control complete.659 Listener started successfully.660Listener configuration complete.661Oracle Net Services configuration successful. The exit code is 0662663检查监听状态： 664665666LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 27-MAR-2024 13:55:09667668Copyright (c) 1991, 2016, Oracle. All rights reserved.669670Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anolis8)(PORT=1521)))671STATUS of the LISTENER672------------------------673Alias LISTENER674Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production675Start Date 27-MAR-2024 13:54:59676Uptime 0 days 0 hr. 0 min. 10 sec677Trace Level off678Security ON: Local OS Authentication679SNMP OFF680Listener Parameter File /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora681Listener Log File /u01/app/oracle/diag/tnslsnr/anolis8/listener/alert/log.xml682Listening Endpoints Summary...683 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anolis8)(PORT=1521)))684 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))685The listener supports no services686The command completed successfully687688#==============================================================# 689静默建库命令 690#==============================================================# 691692dbca -silent -createDatabase \693-ignorePrereqFailure \694-templateName General_Purpose.dbc \695-responseFile NO_VALUE \696-gdbName lucifer \697-sid lucifer \698-sysPassword oracle \699-systemPassword oracle \700-redoLogFileSize 100 \701-datafileDestination /oradata \702-storageType FS \703-enableArchive true \704-archiveLogDest /oradata \705-databaseConfigType SINGLE \706-characterset AL32UTF8 \707-nationalCharacterSet AL16UTF16 \708-emConfiguration NONE \709-automaticMemoryManagement false \710-totalMemory 3874 \711-databaseType OLTP \712-createAsContainerDatabase false 713714#==============================================================# 715创建数据库 716#==============================================================# 717718[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.719 CAUSE: 720a. 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].721b.The password entered is a keyword that Oracle does not recommend to be used as password722 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.723[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.724 CAUSE: 725a. 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].726b.The password entered is a keyword that Oracle does not recommend to be used as password727 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.728Copying database files7291% complete7302% complete73118% complete73233% complete733Creating and starting Oracle instance73435% complete73540% complete73644% complete73749% complete73850% complete73953% complete74055% complete741Completing Database Creation74256% complete74357% complete74458% complete74562% complete74665% complete74766% complete748Executing Post Configuration Actions749100% complete750Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.751752#==============================================================# 753配置在线重做日志 754#==============================================================# 755756数据库在线重做日志文件： 757758759 THREAD# GROUP# MEMBER size(M)760---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------761 1 1 /oradata/lucifer/redo01.log 100762 1 2 /oradata/lucifer/redo02.log 100763 1 3 /oradata/lucifer/redo03.log 100764 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m07fynlc_.log 100765 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m07fyo10_.log 100766 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m07fyo4z_.log 100767 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m07fyo8g_.log 100768 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m07fyofd_.log 100769770#==============================================================# 771配置 RMAN 备份任务 772#==============================================================# 773774## OracleBegin77500 02 * * * /home/oracle/scripts/del_arch.sh776#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh777#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh778779#==============================================================# 780配置 glogin.sql 781#==============================================================# 782783define _editor=vi784set serveroutput on size 1000000785set pagesize 9999786set long 99999787set trimspool on788col name format a80789set termout off790define gname=idle791column global_name new_value gname792select 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 );793ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';794set sqlprompt '&gname _DATE> '795set termout on796797#==============================================================# 798优化数据库参数 799#==============================================================# 800801数据库参数： 802803804NAME SID SPVALUE VALUE805-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------806_b_tree_bitmap_plans * FALSE FALSE807_datafile_write_errors_crash_instance * FALSE FALSE808audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump809audit_trail * NONE DB810compatible * 12.2.0 12.2.0811control_file_record_keep_time * 31 31812db_block_size * 8192 8192813db_create_file_dest * /oradata /oradata814db_file_multiblock_read_count * 128815db_files * 5000 200816db_name * lucifer lucifer817db_writer_processes * 1818deferred_segment_creation * FALSE FALSE819diagnostic_dest * /u01/app/oracle /u01/app/oracle820dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)821event * 10949 trace name context forever,level 1822event * 28401 trace name context forever,level 1823fast_start_parallel_rollback * LOW824log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog825log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf826max_dump_file_size * unlimited827max_string_size * STANDARD828nls_language * AMERICAN AMERICAN829nls_territory * AMERICA AMERICA830open_cursors * 1000 300831optimizer_adaptive_plans * TRUE832optimizer_adaptive_statistics * FALSE833optimizer_index_caching * 0834optimizer_mode * ALL_ROWS835parallel_force_local * FALSE836parallel_max_servers * 64 64837pga_aggregate_target * 1299185664 812646400838processes * 2000 640839remote_login_passwordfile * EXCLUSIVE EXCLUSIVE840session_cached_cursors * 300 50841sessions * 984842sga_max_size * 5199888384 3254779904843sga_target * 5199888384 3254779904844spfile * /u01/app/oracle/product/12.2.0/db/dbs/spfilelucifer.ora845statistics_level * TYPICAL846undo_retention * 10800 900847848恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y