在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 麒麟 V10 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellinstall
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 麒麟 V10 一键安装 Oracle 12CR2（220118）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
✨ 偷懒可以直接下载本文安装包合集：麒麟 V10 安装 Oracle Oracle 12CR2（220118）单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@kylin soft]# cat /etc/os-release 3NAME="Kylin Linux Advanced Server"4VERSION="V10 (Lance)"5ID="kylin"6VERSION_ID="V10"7PRETTY_NAME="Kylin Linux Advanced Server V10 (Lance)"8ANSI_COLOR="0;31"910# 网络信息11[root@kylin soft]# ip a122: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 100013 link/ether 00:0c:29:62:a0:e5 brd ff:ff:ff:ff:ff:ff14 inet 192.168.6.222/24 brd 192.168.6.255 scope global noprefixroute ens3315 valid_lft forever preferred_lft forever16 inet6 fe80::735:5307:2e5e:803c/64 scope link noprefixroute 17 valid_lft forever preferred_lft forever1819# 挂载本地 ISO 镜像20[root@kylin soft]# mount | grep iso9660 | grep -v "/run/media"21/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048)22[root@kylin soft]# df -h|grep /mnt23/dev/sr0 4.3G 4.3G 0 100% /mnt2425# 安装包存放在 /soft 目录下26[root@kylin ~]# cd /soft/27[root@kylin soft]# ll28-rwx------ 1 root root 3453696911 2月 26 14:04 LINUX.X64_122010_db_home.zip29-rwxr-xr-x 1 root root 169044 2月 26 14:03 OracleShellInstall30-rwxr-xr-x 1 root root 138022236 2月 26 14:03 p33561275_122010_Linux-x86-64.zip31-rwx------ 1 root root 1020001457 2月 26 14:04 p33587128_122010_Linux-x86-64.zip32-rwx------ 1 root root 124109254 2月 26 14:03 p6880880_122010_Linux-x86-64.zip33-rwxr-xr-x 1 root root 321590 2月 26 13:31 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n kylin `# 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[server]24name=server25baseurl=file:///mnt26enabled=127gpgcheck=02829#==============================================================# 30禁用防火墙 31#==============================================================# 3233● firewalld.service - firewalld - dynamic firewall daemon34 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)35 Active: inactive (dead)36 Docs: man:firewalld(1)37382月 26 13:11:07 kylin systemd[1]: Starting firewalld - dynamic firewall daemon...392月 26 13:11:09 kylin systemd[1]: Started firewalld - dynamic firewall daemon.402月 26 14:08:40 kylin systemd[1]: Stopping firewalld - dynamic firewall daemon...412月 26 14:08:41 kylin systemd[1]: firewalld.service: Succeeded.422月 26 14:08:41 kylin systemd[1]: Stopped firewalld - dynamic firewall daemon.4344#==============================================================# 45禁用 SELinux 46#==============================================================# 4748SELinux status: disabled4950#==============================================================# 51配置 nsysctl.conf 52#==============================================================# 5354NOZEROCONF=yes5556#==============================================================# 57YUM 静默安装依赖包 58#==============================================================# 5960bc-1.07.1-11.ky10.x86_6461binutils-2.34-19.p01.ky10.x86_6462未安装软件包 compat-libcap1 63gcc-7.3.0-20220207.45.ky10.x86_6464gcc-c++-7.3.0-20220207.45.ky10.x86_6465未安装软件包 elfutils-libelf 66未安装软件包 elfutils-libelf-devel 67glibc-2.28-88.p06.ky10.x86_6468glibc-devel-2.28-88.p06.ky10.x86_6469libaio-0.3.112-1.p01.ky10.x86_6470libaio-devel-0.3.112-1.p01.ky10.x86_6471libgcc-7.3.0-20220207.45.ky10.x86_6472libstdc++-7.3.0-20220207.45.ky10.x86_6473libstdc++-devel-7.3.0-20220207.45.ky10.x86_6474libxcb-1.14-1.ky10.x86_6475libX11-1.6.9-5.ky10.x86_6476libXau-1.0.9-2.ky10.x86_6477libXi-1.7.10-1.ky10.x86_6478libXrender-0.9.10-10.ky10.x86_6479make-4.3-1.ky10.x86_6480net-tools-2.0-0.54.ky10.x86_6481smartmontools-7.1-1.ky10.x86_6482sysstat-12.2.1-1.p00.ky10.x86_6483e2fsprogs-1.45.6-8.ky10.x86_6484未安装软件包 e2fsprogs-libs 85unzip-6.0-47.ky10.x86_6486openssh-clients-8.2p1-16.p04.ky10.x86_6487readline-8.0-3.ky10.x86_6488readline-devel-8.0-3.ky10.x86_6489psmisc-23.3-2.ky10.x86_6490ksh-2020.0.0-4.ky10.x86_6491nfs-utils-2.5.1-5.ky10.x86_6492tar-1.32-2.ky10.x86_6493未安装软件包 device-mapper-multipath 94avahi-0.8-8.ky10.x86_6495ntp-4.2.8p14-5.ky10.x86_6496chrony-3.5-3.p01.ky10.x86_6497libXtst-1.2.3-10.ky10.x86_6498libXrender-devel-0.9.10-10.ky10.x86_6499fontconfig-devel-2.13.92-1.ky10.x86_64100policycoreutils-3.1-7.p01.ky10.x86_64101未安装软件包 policycoreutils-python 102未安装软件包 librdmacm 103未安装软件包 libnsl* 104未安装软件包 libibverbs 105未安装软件包 compat-openssl10 106policycoreutils-python-utils-3.1-7.p01.ky10.noarch107未安装软件包 elfutils* 108glibc-2.28-88.p06.ky10.x86_64109110#==============================================================# 111配置主机名 112#==============================================================# 113114kylin115116#==============================================================# 117配置 /etc/hosts 文件 118#==============================================================# 119120127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4121::1 localhost localhost.localdomain localhost6 localhost6.localdomain6122192.168.6.222 kylin123124#==============================================================# 125创建用户和组 126#==============================================================# 127128oracle 用户： 129130用户id=54321(oracle) 组id=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)131132133#==============================================================# 134配置 Avahi-daemon 服务 135#==============================================================# 136137● avahi-daemon.service - Avahi mDNS/DNS-SD Stack138 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)139 Active: inactive (dead)140141#==============================================================# 142配置透明大页 && NUMA && 磁盘 IO 调度器 143#==============================================================# 144145args="ro resume=/dev/mapper/klas-swap rd.lvm.lv=klas/root rd.lvm.lv=klas/swap rhgb quiet crashkernel=1024M,high audit=0 numa=off transparent_hugepage=never elevator=deadline"146-resume=/dev/mapper/klas-swap147-args="ro148args="ro resume=/dev/mapper/klas-swap rd.lvm.lv=klas/root rd.lvm.lv=klas/swap rhgb quiet crashkernel=1024M,high audit=0 numa=off transparent_hugepage=never elevator=deadline"149-audit=0150-crashkernel=1024M,high151152#==============================================================# 153配置 sysctl.conf 154#==============================================================# 155156kernel.sysrq = 0157net.ipv4.ip_forward = 0158net.ipv4.conf.all.send_redirects = 0159net.ipv4.conf.default.send_redirects = 0160net.ipv4.conf.all.accept_source_route = 0161net.ipv4.conf.default.accept_source_route = 0162net.ipv4.conf.all.accept_redirects = 0163net.ipv4.conf.default.accept_redirects = 0164net.ipv4.conf.all.secure_redirects = 0165net.ipv4.conf.default.secure_redirects = 0166net.ipv4.icmp_echo_ignore_broadcasts = 1167net.ipv4.icmp_ignore_bogus_error_responses = 1168net.ipv4.conf.all.rp_filter = 1169net.ipv4.conf.default.rp_filter = 1170net.ipv4.tcp_syncookies = 1171kernel.dmesg_restrict = 1172net.ipv6.conf.all.accept_redirects = 0173net.ipv6.conf.default.accept_redirects = 0174fs.aio-max-nr = 1048576175fs.file-max = 6815744176kernel.shmall = 2097152177kernel.shmmax = 7010422783178kernel.shmmni = 4096179kernel.sem = 250 32000 100 128180net.ipv4.ip_local_port_range = 9000 65500181net.core.rmem_default = 262144182net.core.rmem_max = 4194304183net.core.wmem_default = 262144184net.core.wmem_max = 1048576185vm.min_free_kbytes = 27384186net.ipv4.conf.ens33.rp_filter = 1187vm.swappiness = 10188kernel.panic_on_oops = 1189kernel.randomize_va_space = 2190kernel.numa_balancing = 0191192#==============================================================# 193配置 RemoveIPC 194#==============================================================# 195196[Login]197RemoveIPC=no198199#==============================================================# 200配置 /etc/security/limits.conf 和 /etc/pam.d/login 201#==============================================================# 202203查看 /etc/security/limits.conf： 204205oracle soft nofile 1024206oracle hard nofile 65536207oracle soft stack 10240208oracle hard stack 32768209oracle soft nproc 2047210oracle hard nproc 16384211oracle hard memlock unlimited212oracle soft memlock unlimited213214查看 /etc/pam.d/login 文件： 215216auth substack system-auth217auth include postlogin218account required pam_nologin.so219account include system-auth220password include system-auth221session required pam_selinux.so close222session required pam_loginuid.so223session required pam_selinux.so open224session required pam_namespace.so225session optional pam_keyinit.so force revoke226session include system-auth227session include postlogin228-session optional pam_ck_connector.so229session required pam_limits.so230session required /lib64/security/pam_limits.so231232#==============================================================# 233配置 /dev/shm 234#==============================================================# 235236/dev/mapper/klas-root / xfs defaults 0 0237UUID=c8e47a65-11c4-4e4e-84ce-95f9f618be7e /boot xfs defaults 0 0238/dev/mapper/klas-swap none swap defaults 0 0239tmpfs /dev/shm tmpfs size=6846116k 0 0240241#==============================================================# 242安装 rlwrap 插件 243#==============================================================# 244245成功安装 rlwrap： rlwrap 0.44 246247#==============================================================# 248Root 用户环境变量 249#==============================================================# 250251if [ -f ~/.bashrc ]; then252 . ~/.bashrc253fi254PATH=$PATH:$HOME/bin255export PATH256alias so='su - oracle'257export PS1="[`whoami`@`hostname`:"'$PWD]$ '258259#==============================================================# 260Oracle 用户环境变量 261#==============================================================# 262263[ -f ~/.bashrc ] && . ~/.bashrc264umask 022265export TMP=/tmp266export TMPDIR=$TMP267export NLS_LANG=AMERICAN_AMERICA.AL32UTF8268export ORACLE_BASE=/u01/app/oracle269export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db270export ORACLE_TERM=xterm271export TNS_ADMIN=$ORACLE_HOME/network/admin272export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib273export ORACLE_SID=lucifer274export PATH=/usr/sbin:$PATH275export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH276export PERL5LIB=$ORACLE_HOME/perl/lib277alias sas='sqlplus / as sysdba'278alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'279alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'280alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'281export PS1="[`whoami`@`hostname`:"'$PWD]$ '282export CV_ASSUME_DISTID=OL7283alias sqlplus='rlwrap sqlplus'284alias rman='rlwrap rman'285alias adrci='rlwrap adrci'286287#==============================================================# 288静默解压 Oracle 软件包 289#==============================================================# 290291正在静默解压缩 Oracle 软件包，请稍等： 292293.---- -. -. . . . .294( .',----- - - ' ' ' __295 \_/ ;--:- __--------------------___ ____=========_||___296__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|297c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |298,_\___________'_|,L______],|______________________|_i,!________________!_i299/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)300""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""301302静默解压 Oracle 软件安装包： /soft/LINUX.X64_122010_db_home.zip 303304静默解压 Oracle 软件补丁包： /soft/p33587128*.zip 305306静默解压 OJVM 软件补丁包： /soft/p33561275*.zip 307308#==============================================================# 309Oracle 安装静默文件 310#==============================================================# 311312oracle.install.option=INSTALL_DB_SWONLY313UNIX_GROUP_NAME=oinstall314INVENTORY_LOCATION=/u01/app/oraInventory315ORACLE_BASE=/u01/app/oracle316oracle.install.db.InstallEdition=EE317oracle.install.db.DBA_GROUP=dba318oracle.install.db.OPER_GROUP=oper319oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0320SELECTED_LANGUAGES=en,zh_CN321ORACLE_HOME=/u01/app/oracle/product/12.2.0/db322oracle.install.db.OSBACKUPDBA_GROUP=backupdba323oracle.install.db.OSDGDBA_GROUP=dgdba324oracle.install.db.OSKMDBA_GROUP=kmdba325oracle.install.db.OSRACDBA_GROUP=racdba326327#==============================================================# 328静默安装数据库软件 329#==============================================================# 330331Starting Oracle Universal Installer...332333Checking Temp space: must be greater than 500 MB. Actual 3342 MB Passed334Checking swap space: must be greater than 150 MB. Actual 8180 MB Passed335Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-02-26_02-10-41PM. Please wait ...You can find the log of this install session at:336 /u01/app/oraInventory/logs/installActions2024-02-26_02-10-41PM.log337338Prepare in progress.339.................................................. 8% Done.340341Prepare successful.342343Copy files in progress.344.................................................. 17% Done.345.................................................. 22% Done.346.................................................. 27% Done.347.................................................. 32% Done.348.................................................. 40% Done.349.................................................. 45% Done.350.................................................. 50% Done.351.................................................. 55% Done.352.................................................. 60% Done.353.................................................. 65% Done.354.................................................. 70% Done.355.................................................. 75% Done.356.................................................. 80% Done.357....................358Copy files successful.359360Link binaries in progress.361..........362Link binaries successful.363364Setup files in progress.365..............................366Setup files successful.367368Setup Inventory in progress.369370Setup Inventory successful.371372Finish Setup successful.373The installation of Oracle Database 12c was successful.374Please check '/u01/app/oraInventory/logs/silentInstall2024-02-26_02-10-41PM.log' for more details.375376Setup Oracle Base in progress.377378Setup Oracle Base successful.379.................................................. 95% Done.380381As a root user, execute the following script(s):382 1. /u01/app/oraInventory/orainstRoot.sh383 2. /u01/app/oracle/product/12.2.0/db/root.sh384385386387.................................................. 100% Done.388Successfully Setup Software.389390#==============================================================# 391执行 root 脚本 392#==============================================================# 393394Changing permissions of /u01/app/oraInventory.395Adding read,write permissions for group.396Removing read,write,execute permissions for world.397398Changing groupname of /u01/app/oraInventory to oinstall.399The execution of the script is complete.400Check /u01/app/oracle/product/12.2.0/db/install/root_kylin_2024-02-26_14-16-02-420970283.log for the output of root script401402#==============================================================# 403Oracle 软件安装补丁 404#==============================================================# 405406Oracle Interim Patch Installer version 12.2.0.1.30407Copyright (c) 2024, Oracle Corporation. All rights reserved.408409PREREQ session410411Oracle Home : /u01/app/oracle/product/12.2.0/db412Central Inventory : /u01/app/oraInventory413 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc414OPatch version : 12.2.0.1.30415OUI version : 12.2.0.1.4416Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-16-07PM_1.log417418Invoking prereq "checkconflictagainstohwithdetail"419420Prereq "checkConflictAgainstOHWithDetail" passed.421422OPatch succeeded.423Oracle Interim Patch Installer version 12.2.0.1.30424Copyright (c) 2024, Oracle Corporation. All rights reserved.425426427Oracle Home : /u01/app/oracle/product/12.2.0/db428Central Inventory : /u01/app/oraInventory429 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc430OPatch version : 12.2.0.1.30431OUI version : 12.2.0.1.4432Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-16-10PM_1.log433434Verifying environment and performing prerequisite checks...435OPatch continues with these patches: 33587128 436437Do you want to proceed? [y|n]438Y (auto-answered by -silent)439User Responded with: Y440All checks passed.441442Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.443(Oracle Home = '/u01/app/oracle/product/12.2.0/db')444445446Is the local system ready for patching? [y|n]447Y (auto-answered by -silent)448User Responded with: Y449Backing up files...450Applying interim patch '33587128' to OH '/u01/app/oracle/product/12.2.0/db'451ApplySession: 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.452453Patching component oracle.rdbms.util, 12.2.0.1.0...454455Patching component oracle.rdbms, 12.2.0.1.0...456457Patching component oracle.network.rsf, 12.2.0.1.0...458459Patching component oracle.rdbms.rsf, 12.2.0.1.0...460461Patching component oracle.ctx, 12.2.0.1.0...462463Patching component oracle.has.common.cvu, 12.2.0.1.0...464465Patching component oracle.ldap.owm, 12.2.0.1.0...466467Patching component oracle.ldap.rsf, 12.2.0.1.0...468469Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...470471Patching component oracle.oracore.rsf, 12.2.0.1.0...472473Patching component oracle.oraolap, 12.2.0.1.0...474475Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...476477Patching component oracle.rdbms.deconfig, 12.2.0.1.0...478479Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...480481Patching component oracle.sdo, 12.2.0.1.0...482483Patching component oracle.sdo.locator, 12.2.0.1.0...484485Patching component oracle.sdo.locator.jrf, 12.2.0.1.0...486487Patching component oracle.tfa, 12.2.0.1.0...488489Patching component oracle.ctx.rsf, 12.2.0.1.0...490491Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...492493Patching component oracle.rdbms.install.common, 12.2.0.1.0...494495Patching component oracle.assistants.deconfig, 12.2.0.1.0...496497Patching component oracle.ons.ic, 12.2.0.1.0...498499Patching component oracle.rdbms.rman, 12.2.0.1.0...500501Patching component oracle.precomp.rsf, 12.2.0.1.0...502503Patching component oracle.install.deinstalltool, 12.2.0.1.0...504505Patching component oracle.assistants.acf, 12.2.0.1.0...506507Patching component oracle.rdbms.oci, 12.2.0.1.0...508509Patching component oracle.sqlplus.ic, 12.2.0.1.0...510511Patching component oracle.xdk.parser.java, 12.2.0.1.0...512513Patching component oracle.dbtoolslistener, 12.2.0.1.0...514515Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...516517Patching component oracle.rdbms.dv, 12.2.0.1.0...518519Patching component oracle.rdbms.lbac, 12.2.0.1.0...520521Patching component oracle.ons, 12.2.0.1.0...522523Patching component oracle.ldap.client, 12.2.0.1.0...524525Patching component oracle.xdk, 12.2.0.1.0...526527Patching component oracle.xdk.rsf, 12.2.0.1.0...528529Patching component oracle.sqlplus, 12.2.0.1.0...530531Patching component oracle.assistants.server, 12.2.0.1.0...532533Patching component oracle.rdbms.crs, 12.2.0.1.0...534535Patching component oracle.precomp.common, 12.2.0.1.0...536537Patching component oracle.precomp.lang, 12.2.0.1.0...538539Patching component oracle.jdk, 1.8.0.91.0...540541OPatch found the word "error" in the stderr of the make command.542Please look at this stderr. You can re-run this make command.543Stderr output:544chmod: changing permissions of '/u01/app/oracle/product/12.2.0/db/bin/extjobO': Operation not permitted545make: [ins_rdbms.mk:533: iextjob] Error 1 (ignored)546547548Patch 33587128 successfully applied.549OPatch Session completed with warnings.550Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-16-10PM_1.log551552OPatch completed with warnings.553554#==============================================================# 555OJVM 补丁安装 556#==============================================================# 557558Oracle Interim Patch Installer version 12.2.0.1.30559Copyright (c) 2024, Oracle Corporation. All rights reserved.560561PREREQ session562563Oracle Home : /u01/app/oracle/product/12.2.0/db564Central Inventory : /u01/app/oraInventory565 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc566OPatch version : 12.2.0.1.30567OUI version : 12.2.0.1.4568Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-21-40PM_1.log569570Invoking prereq "checkconflictagainstohwithdetail"571572Prereq "checkConflictAgainstOHWithDetail" passed.573574OPatch succeeded.575Oracle Interim Patch Installer version 12.2.0.1.30576Copyright (c) 2024, Oracle Corporation. All rights reserved.577578579Oracle Home : /u01/app/oracle/product/12.2.0/db580Central Inventory : /u01/app/oraInventory581 from : /u01/app/oracle/product/12.2.0/db/oraInst.loc582OPatch version : 12.2.0.1.30583OUI version : 12.2.0.1.4584Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-21-42PM_1.log585586Verifying environment and performing prerequisite checks...587OPatch continues with these patches: 33561275 588589Do you want to proceed? [y|n]590Y (auto-answered by -silent)591User Responded with: Y592All checks passed.593594Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.595(Oracle Home = '/u01/app/oracle/product/12.2.0/db')596597598Is the local system ready for patching? [y|n]599Y (auto-answered by -silent)600User Responded with: Y601Backing up files...602Applying interim patch '33561275' to OH '/u01/app/oracle/product/12.2.0/db'603604Patching component oracle.javavm.server, 12.2.0.1.0...605606Patching component oracle.javavm.server.core, 12.2.0.1.0...607608Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...609610Patching component oracle.javavm.client, 12.2.0.1.0...611612Patching component oracle.rdbms, 12.2.0.1.0...613614Patching component oracle.dbjava.jdbc, 12.2.0.1.0...615616Patching component oracle.dbjava.ic, 12.2.0.1.0...617Patch 33561275 successfully applied.618Log file location: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-21-42PM_1.log619620OPatch succeeded.621622#==============================================================# 623Oracle 软件版本 624#==============================================================# 625626627SQL*Plus: Release 12.2.0.1.0 Production628629630#==============================================================# 631Oracle 补丁信息 632#==============================================================# 63363433561275;OJVM RELEASE UPDATE 12.2.0.1.220118 (33561275)63533587128;Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)636637OPatch succeeded.638639640#==============================================================# 641配置监听 642#==============================================================# 643644645Parsing command line arguments:646 Parameter "silent" = true647 Parameter "responsefile" = /u01/app/oracle/product/12.2.0/db/assistants/netca/netca.rsp648Done parsing command line arguments.649Oracle Net Services Configuration:650Profile configuration complete.651Oracle Net Listener Startup:652 Running Listener Control: 653 /u01/app/oracle/product/12.2.0/db/bin/lsnrctl start LISTENER654 Listener Control complete.655 Listener started successfully.656Listener configuration complete.657Oracle Net Services configuration successful. The exit code is 0658659检查监听状态： 660661662LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 26-FEB-2024 14:22:43663664Copyright (c) 1991, 2016, Oracle. All rights reserved.665666Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kylin)(PORT=1521)))667STATUS of the LISTENER668------------------------669Alias LISTENER670Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production671Start Date 26-FEB-2024 14:22:42672Uptime 0 days 0 hr. 0 min. 0 sec673Trace Level off674Security ON: Local OS Authentication675SNMP OFF676Listener Parameter File /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora677Listener Log File /u01/app/oracle/diag/tnslsnr/kylin/listener/alert/log.xml678Listening Endpoints Summary...679 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kylin)(PORT=1521)))680 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))681The listener supports no services682The command completed successfully683684#==============================================================# 685静默建库命令 686#==============================================================# 687688dbca -silent -createDatabase \689-ignorePrereqFailure \690-templateName General_Purpose.dbc \691-responseFile NO_VALUE \692-gdbName lucifer \693-sid lucifer \694-sysPassword oracle \695-systemPassword oracle \696-redoLogFileSize 100 \697-datafileDestination /oradata \698-storageType FS \699-enableArchive true \700-archiveLogDest /oradata \701-databaseConfigType SINGLE \702-characterset AL32UTF8 \703-nationalCharacterSet AL16UTF16 \704-emConfiguration NONE \705-automaticMemoryManagement false \706-totalMemory 3342 \707-databaseType OLTP \708-createAsContainerDatabase false 709710#==============================================================# 711创建数据库 712#==============================================================# 713714[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.715 CAUSE: 716a. 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].717b.The password entered is a keyword that Oracle does not recommend to be used as password718 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.719[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.720 CAUSE: 721a. 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].722b.The password entered is a keyword that Oracle does not recommend to be used as password723 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.724Copying database files7251% complete7262% complete72718% complete72833% complete729Creating and starting Oracle instance73035% complete73140% complete73244% complete73349% complete73450% complete73553% complete73655% complete737Completing Database Creation73856% complete73957% complete74058% complete74162% complete74265% complete74366% complete744Executing Post Configuration Actions745100% complete746Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.747748#==============================================================# 749配置在线重做日志 750#==============================================================# 751752数据库在线重做日志文件： 753754755 THREAD# GROUP# MEMBER size(M)756---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------757 1 1 /oradata/lucifer/redo01.log 100758 1 2 /oradata/lucifer/redo02.log 100759 1 3 /oradata/lucifer/redo03.log 100760 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_lxrd527l_.log 100761 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_lxrd529w_.log 100762 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_lxrd52d9_.log 100763 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_lxrd52gd_.log 100764 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_lxrd52ld_.log 100765766#==============================================================# 767配置 RMAN 备份任务 768#==============================================================# 769770## OracleBegin77100 02 * * * /home/oracle/scripts/del_arch.sh772#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh773#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh774775#==============================================================# 776配置 glogin.sql 777#==============================================================# 778779define _editor=vi780set serveroutput on size 1000000781set pagesize 9999782set long 99999783set trimspool on784col name format a80785set termout off786define gname=idle787column global_name new_value gname788select 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 );789ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';790set sqlprompt '&gname _DATE> '791set termout on792793#==============================================================# 794优化数据库参数 795#==============================================================# 796797数据库参数： 798799800NAME SID SPVALUE VALUE801-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------802_b_tree_bitmap_plans * FALSE FALSE803_datafile_write_errors_crash_instance * FALSE FALSE804audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump805audit_trail * NONE DB806compatible * 12.2.0 12.2.0807control_file_record_keep_time * 31 31808db_block_size * 8192 8192809db_create_file_dest * /oradata /oradata810db_file_multiblock_read_count * 128811db_files * 5000 200812db_name * lucifer lucifer813db_writer_processes * 1814deferred_segment_creation * FALSE FALSE815diagnostic_dest * /u01/app/oracle /u01/app/oracle816dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)817event * 10949 trace name context forever,level 1818event * 28401 trace name context forever,level 1819fast_start_parallel_rollback * LOW820log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog821log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf822max_dump_file_size * unlimited823max_string_size * STANDARD824nls_language * AMERICAN AMERICAN825nls_territory * AMERICA AMERICA826open_cursors * 1000 300827optimizer_adaptive_plans * TRUE828optimizer_adaptive_statistics * FALSE829optimizer_index_caching * 0830optimizer_mode * ALL_ROWS831parallel_force_local * FALSE832parallel_max_servers * 64 64833pga_aggregate_target * 1120927744 701497344834processes * 2000 640835remote_login_passwordfile * EXCLUSIVE EXCLUSIVE836session_cached_cursors * 300 50837sessions * 984838sga_max_size * 4485808128 2818572288839sga_target * 4485808128 2818572288840spfile * /u01/app/oracle/product/12.2.0/db/dbs/spfilelucifer.ora841statistics_level * TYPICAL842undo_retention * 10800 900843844恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y