在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 Redhat 8.4 一键安装 Oracle 11GR2 单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellinstall.co
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 Redhat 8.4 一键安装 Oracle 11GR2 单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
所需安装包我已经打包上传至：Linux 8 安装 Oracle 11GR2 单机版所需软件包集合（PSU+OPatch+OneoffPatch）
1# 主机版本2[root@lucifer ~]# cat /etc/redhat-release3Red Hat Enterprise Linux release 8.4 (Ootpa)45# 网络信息6[root@lucifer ~]# ip a72: enp0s5: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 10008 link/ether 00:1c:42:bd:df:2a brd ff:ff:ff:ff:ff:ff9 inet 10.211.55.200/24 brd 10.211.55.255 scope global noprefixroute enp0s510 valid_lft forever preferred_lft forever11 inet6 fdb2:2c26:f4e4:0:21c:42ff:febd:df2a/64 scope global dynamic noprefixroute12 valid_lft 2591964sec preferred_lft 604764sec13 inet6 fe80::21c:42ff:febd:df2a/64 scope link noprefixroute14 valid_lft forever preferred_lft forever1516# 挂载本地 ISO 镜像17[root@lucifer ~]# mount | grep iso | grep -v "/run/media"18/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,uid=0,gid=0,dmode=500,fmode=400)19[root@lucifer ~]# df -h|grep /mnt20/dev/sr0 9.5G 9.5G 0 100% /mnt2122# 安装包存放在 /soft 目录下23[root@lucifer ~]# cd /soft/24[root@lucifer soft]# ll25total 305722826-rwxr-xr-x. 1 root root 147314 Feb 27 10:39 OracleShellInstall27-rw-r--r--. 1 root root 1395582860 Feb 27 10:39 p13390677_112040_Linux-x86-64_1of7.zip28-rw-r--r--. 1 root root 1151304589 Feb 27 10:40 p13390677_112040_Linux-x86-64_2of7.zip29-rw-r--r--. 1 root root 457726607 Feb 27 10:40 p33477185_112040_Linux-x86-64.zip30-rw-r--r--. 1 root root 8684 Feb 27 10:40 p33991024_11204220118_Generic.zip31-rwxr-xr-x. 1 root root 125534784 Feb 27 10:39 p6880880_112000_Linux-x86-64.zip默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf enp0s5 `# local ip ifname`\3-n lucifer `# hostname`\4-op oracle `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o oradb `# dbname`\8-dp oracle `# sys/system password`\9-ds AL32UTF8 `# database character`\10-ns AL16UTF16 `# national character`\11-redo 100 `# redo size`\12-opa 33477185 `# oracle PSU/RU`\13-opd Y `# optimize db`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
1[root@lucifer soft]# ./OracleShellInstall -lf enp0s5 `# local ip ifname`\2> -n lucifer `# hostname`\3> -op oracle `# oracle password`\4> -d /u01 `# software base dir`\5> -ord /oradata `# data dir`\6-dp oracle `# sys/system password`\7-ds AL32UTF8 `# database character`\8-ns AL16UTF16 `# national character`\9-redo 100 `# redo size`\10-opa 33477185 `# oracle PSU/RU`\11-opd Y `# optimize db`> -o oradb `# dbname`\12> -dp oracle `# sys/system password`\13> -ds AL32UTF8 `# database character`\14> -ns AL16UTF16 `# national character`\15> -redo 100 `# redo size`\16> -opa 33477185 `# oracle PSU/RU`\17> -opd Y `# optimize db`1819请选择安装模式 [单机(si)/集群(rac)] :20si2122数据库安装模式: single232425请选择数据库版本 [11/12/19/21] :26112728数据库版本: 11293031#==============================================================#32配置本地 YUM 源33#==============================================================#3435[BaseOS]36name=BaseOS37baseurl=file:///mnt/BaseOS38enabled=139gpgcheck=040[AppStream]41name=AppStream42baseurl=file:///mnt/AppStream43enabled=144gpgcheck=0454647#==============================================================#48禁用防火墙49#==============================================================#5051● firewalld.service - firewalld - dynamic firewall daemon52 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)53 Active: inactive (dead)54 Docs: man:firewalld(1)5556Feb 27 10:22:31 lucifer systemd[1]: Starting firewalld - dynamic firewall daemon...57Feb 27 10:22:32 lucifer systemd[1]: Started firewalld - dynamic firewall daemon.58Feb 27 10:22:33 lucifer firewalld[973]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.59Feb 27 11:00:48 lucifer systemd[1]: Stopping firewalld - dynamic firewall daemon...60Feb 27 11:00:48 lucifer systemd[1]: firewalld.service: Succeeded.61Feb 27 11:00:48 lucifer systemd[1]: Stopped firewalld - dynamic firewall daemon.6263#==============================================================#64禁用 SELinux65#==============================================================#6667SELINUX=disabled68SELINUXTYPE=targeted6970#==============================================================#71YUM 静默安装依赖包72#==============================================================#7374warning: rpmdb: BDB2053 Freeing read locks for locker 0xae: 1765/14005432455980875warning: rpmdb: BDB2053 Freeing read locks for locker 0xb0: 1765/14005432455980876bc-1.07.1-5.el8.x86_6477binutils-2.30-93.el8.x86_6478package compat-libcap1 is not installed79package compat-libstdc++-33 is not installed80gcc-8.4.1-1.el8.x86_6481gcc-c++-8.4.1-1.el8.x86_6482elfutils-libelf-0.182-3.el8.x86_6483elfutils-libelf-devel-0.182-3.el8.x86_6484glibc-2.28-151.el8.x86_6485glibc-devel-2.28-151.el8.x86_6486libaio-0.3.112-1.el8.x86_6487libaio-devel-0.3.112-1.el8.x86_6488libgcc-8.4.1-1.el8.x86_6489libstdc++-8.4.1-1.el8.x86_6490libstdc++-devel-8.4.1-1.el8.x86_6491libxcb-1.13.1-1.el8.x86_6492libX11-1.6.8-4.el8.x86_6493libXau-1.0.9-3.el8.x86_6494libXi-1.7.10-1.el8.x86_6495libXrender-0.9.10-7.el8.x86_6496make-4.2.1-10.el8.x86_6497net-tools-2.0-0.52.20160912git.el8.x86_6498smartmontools-7.1-1.el8.x86_6499sysstat-11.7.3-5.el8.x86_64100e2fsprogs-1.45.6-1.el8.x86_64101e2fsprogs-libs-1.45.6-1.el8.x86_64102unzip-6.0-44.el8.x86_64103openssh-clients-8.0p1-5.el8.x86_64104readline-7.0-10.el8.x86_64105readline-devel-7.0-10.el8.x86_64106psmisc-23.1-5.el8.x86_64107ksh-20120801-254.el8.x86_64108nfs-utils-2.3.3-41.el8.x86_64109tar-1.30-5.el8.x86_64110device-mapper-multipath-0.8.4-10.el8.x86_64111avahi-0.7-20.el8.x86_64112package ntp is not installed113chrony-3.5-2.el8.x86_64114libXtst-1.2.3-7.el8.x86_64115libXrender-devel-0.9.10-7.el8.x86_64116fontconfig-devel-2.13.1-3.el8.x86_64117policycoreutils-2.9-14.el8.x86_64118package policycoreutils-python is not installed119policycoreutils-python-utils-2.9-14.el8.noarch120librdmacm-32.0-4.el8.x86_64121package libnsl* is not installed122libibverbs-32.0-4.el8.x86_64123package compat-openssl10) is not installed124125#==============================================================#126配置主机名127#==============================================================#128129lucifer130131#==============================================================#132配置 /etc/hosts 文件133#==============================================================#134135127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4136::1 localhost localhost.localdomain localhost6 localhost6.localdomain6137138## OracleBegin139## Public IP14010.211.55.200 lucifer141142#==============================================================#143创建用户和组144#==============================================================#145146oracle 用户：147148uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)149150151#==============================================================#152配置 Avahi-daemon 服务153#==============================================================#154155● avahi-daemon.service - Avahi mDNS/DNS-SD Stack156 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)157 Active: inactive (dead)158159Feb 27 10:22:36 lucifer avahi-daemon[923]: Registering new address record for fdb2:2c26:f4e4:0:21c:42ff:febd:df2a on enp0s5.*.160Feb 27 10:22:36 lucifer avahi-daemon[923]: Withdrawing address record for fe80::21c:42ff:febd:df2a on enp0s5.161Feb 27 11:01:38 lucifer systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...162Feb 27 11:01:38 lucifer avahi-daemon[923]: Got SIGTERM, quitting.163Feb 27 11:01:38 lucifer avahi-daemon[923]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.164Feb 27 11:01:38 lucifer avahi-daemon[923]: Leaving mDNS multicast group on interface enp0s5.IPv6 with address fdb2:2c26:f4e4:0:21c:42ff:febd:df2a.165Feb 27 11:01:38 lucifer avahi-daemon[923]: Leaving mDNS multicast group on interface enp0s5.IPv4 with address 10.211.55.200.166Feb 27 11:01:38 lucifer avahi-daemon[923]: avahi-daemon 0.7 exiting.167Feb 27 11:01:38 lucifer systemd[1]: avahi-daemon.service: Succeeded.168Feb 27 11:01:38 lucifer systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.169170#==============================================================#171配置透明大页 && NUMA && 磁盘 IO 调度器172#==============================================================#173174args="ro resume=/dev/mapper/rhel-swap rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline $tuned_params"175-resume=/dev/mapper/rhel-swap176-args="ro177args="ro resume=/dev/mapper/rhel-swap rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"178-elevator=deadline"179-transparent_hugepage=never180181#==============================================================#182配置 sysctl.conf183#==============================================================#184185fs.aio-max-nr = 1048576186fs.file-max = 6815744187kernel.shmall = 2097152188kernel.shmmax = 8341315583189kernel.shmmni = 4096190kernel.sem = 250 32000 100 128191net.ipv4.ip_local_port_range = 9000 65500192net.core.rmem_default = 262144193net.core.rmem_max = 4194304194net.core.wmem_default = 262144195net.core.wmem_max = 1048576196vm.min_free_kbytes = 32583197net.ipv4.conf.enp0s5.rp_filter = 1198kernel.numa_balancing = 0199200#==============================================================#201配置 nsysctl.conf202#==============================================================#203204NOZEROCONF=yes205206#==============================================================#207配置 RemoveIPC208#==============================================================#209210[Login]211RemoveIPC=no212213#==============================================================#214配置 /etc/security/limits.conf 和 /etc/pam.d/login215#==============================================================#216217查看 /etc/security/limits.conf218219oracle soft nofile 1024220oracle hard nofile 65536221oracle soft stack 10240222oracle hard stack 32768223oracle soft nproc 2047224oracle hard nproc 16384225oracle hard memlock unlimited226oracle soft memlock unlimited227228查看 /etc/pam.d/login 文件229230auth substack system-auth231auth include postlogin232account required pam_nologin.so233account include system-auth234password include system-auth235session required pam_selinux.so close236session required pam_loginuid.so237session optional pam_console.so238session required pam_selinux.so open239session required pam_namespace.so240session optional pam_keyinit.so force revoke241session include system-auth242session include postlogin243-session optional pam_ck_connector.so244session required pam_limits.so245session required /lib64/security/pam_limits.so246247#==============================================================#248配置 /dev/shm249#==============================================================#250251/dev/mapper/rhel-root / xfs defaults 0 0252UUID=0c121be3-34c3-4736-a637-2264c24706a7 /boot xfs defaults 0 0253/dev/mapper/rhel-swap none swap defaults 0 0254tmpfs /dev/shm tmpfs size=8145816k 0 0255256#==============================================================#257安装 rlwrap258#==============================================================#259260261成功安装 rlwrap： rlwrap 0.42262263#==============================================================#264Root 用户环境变量265#==============================================================#266267if [ -f ~/.bashrc ]; then268 . ~/.bashrc269fi270PATH=$PATH:$HOME/bin271export PATH272alias so='su - oracle'273export PS1="[`whoami`@`hostname`:"'\w]# '274275#==============================================================#276Oracle 用户环境变量277#==============================================================#278279if [ -f ~/.bashrc ]; then280 . ~/.bashrc281fi282umask 022283export TMP=/tmp284export TMPDIR=$TMP285export NLS_LANG=AMERICAN_AMERICA.AL32UTF8286export ORACLE_BASE=/u01/app/oracle287export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db288export ORACLE_TERM=xterm289export TNS_ADMIN=$ORACLE_HOME/network/admin290export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib291export ORACLE_SID=oradb292export PATH=/usr/sbin:$PATH293export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH294export PERL5LIB=$ORACLE_HOME/perl/lib295alias sas='sqlplus / as sysdba'296alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'297alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'298alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'299export PS1="[`whoami`@`hostname`:"'\w]$ '300export CV_ASSUME_DISTID=OL7301alias sqlplus='rlwrap sqlplus'302alias rman='rlwrap rman'303alias adrci='rlwrap adrci'304305#==============================================================#306静默解压 Oracle 软件包307#==============================================================#308309正在静默解压缩 Oracle 软件包，请稍等：310.---- -. -. . . . .311( .',----- - - ' ' ' __312 \_/ ;--:- __--------------------___ ____=========_||___313__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|314c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |315,_\___________'_|,L______],|______________________|_i,!________________!_i316/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)317""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""318319静默解压 Oracle 软件安装包： /soft/p13390677_112040_Linux-x86-64_1of7.zip,/soft/p13390677_112040_Linux-x86-64_2of7.zip320静默解压 Oracle 软件补丁包：/soft/p33477185_112040_Linux-x86-64.zip321322静默解压 Oracle 软件补丁包：p33991024_11204220118_Generic.zip323324325#==============================================================#326Oracle 安装静默文件327#==============================================================#328329oracle.install.option=INSTALL_DB_SWONLY330UNIX_GROUP_NAME=oinstall331INVENTORY_LOCATION=/u01/app/oraInventory332ORACLE_BASE=/u01/app/oracle333oracle.install.db.InstallEdition=EE334oracle.install.db.DBA_GROUP=dba335oracle.install.db.OPER_GROUP=oper336oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0337SELECTED_LANGUAGES=en,zh_CN338ORACLE_HOME=/u01/app/oracle/product/11.2.0/db339DECLINE_SECURITY_UPDATES=true340oracle.installer.autoupdates.option=SKIP_UPDATES341342#==============================================================#343静默安装数据库软件344#==============================================================#345346Starting Oracle Universal Installer...347348Checking Temp space: must be greater than 120 MB. Actual 44363 MB Passed349Checking swap space: must be greater than 150 MB. Actual 8187 MB Passed350Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-02-27_11-02-50AM. Please wait ...You can find the log of this install session at:351 /u01/app/oraInventory/logs/installActions2023-02-27_11-02-50AM.log352353Prepare in progress.354.................................................. 9% Done.355356Prepare successful.357358Copy files in progress.359.................................................. 14% Done.360.................................................. 20% Done.361.................................................. 26% Done.362.................................................. 31% Done.363.................................................. 36% Done.364.................................................. 41% Done.365.................................................. 47% Done.366.................................................. 52% Done.367.................................................. 57% Done.368.................................................. 63% Done.369.................................................. 68% Done.370.................................................. 73% Done.371.................................................. 78% Done.372.................................................. 83% Done.373..............................374Copy files successful.375376Link binaries in progress.377..........378Link binaries successful.379380Setup files in progress.381.................................................. 88% Done.382.................................................. 94% Done.383384Setup files successful.385The installation of Oracle Database 11g was successful.386Please check '/u01/app/oraInventory/logs/silentInstall2023-02-27_11-02-50AM.log' for more details.387388Execute Root Scripts in progress.389390As a root user, execute the following script(s):391 1. /u01/app/oraInventory/orainstRoot.sh392 2. /u01/app/oracle/product/11.2.0/db/root.sh393394395.................................................. 100% Done.396397Execute Root Scripts successful.398Successfully Setup Software.399400#==============================================================#401执行 root 脚本402#==============================================================#403404Changing permissions of /u01/app/oraInventory.405Adding read,write permissions for group.406Removing read,write,execute permissions for world.407408Changing groupname of /u01/app/oraInventory to oinstall.409The execution of the script is complete.410Check /u01/app/oracle/product/11.2.0/db/install/root_lucifer_2023-02-27_11-04-41.log for the output of root script411412#==============================================================#413Oracle 软件安装补丁414#==============================================================#415416Oracle Interim Patch Installer version 11.2.0.3.41417Copyright (c) 2023, Oracle Corporation. All rights reserved.418419420Oracle Home : /u01/app/oracle/product/11.2.0/db421Central Inventory : /u01/app/oraInventory422 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc423OPatch version : 11.2.0.3.41424OUI version : 11.2.0.4.0425Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-02-27_11-04-44AM_1.log426427Verifying environment and performing prerequisite checks...428OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168 26925576 27338049 27734982 28204707 28729262 29141056 29497421 29913194 30298532 30670774 31103343 31537677 31983472 32328626 32758711 33128584 33477185429430Do you want to proceed? [y|n]431Y (auto-answered by -silent)432User Responded with: Y433All checks passed.434435Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.436(Oracle Home = '/u01/app/oracle/product/11.2.0/db')437438439Is the local system ready for patching? [y|n]440Y (auto-answered by -silent)441User Responded with: Y442Backing up files...443Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db'444445Patching component oracle.rdbms, 11.2.0.4.0...446447Patching component oracle.rdbms.rsf, 11.2.0.4.0...448449Patching component oracle.sdo, 11.2.0.4.0...450451Patching component oracle.sysman.agent, 10.2.0.4.5...452453Patching component oracle.xdk, 11.2.0.4.0...454455Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...456457Patching component oracle.sdo.locator, 11.2.0.4.0...458459Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...460461Patching component oracle.xdk.rsf, 11.2.0.4.0...462463Patching component oracle.rdbms.rman, 11.2.0.4.0...464Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db'465466Patching component oracle.rdbms, 11.2.0.4.0...467468Patching component oracle.rdbms.rsf, 11.2.0.4.0...469470Patching component oracle.ldap.rsf, 11.2.0.4.0...471472Patching component oracle.rdbms.crs, 11.2.0.4.0...473474Patching component oracle.precomp.common, 11.2.0.4.0...475476Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...477478Patching component oracle.rdbms.deconfig, 11.2.0.4.0...479480Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...481482Patching component oracle.rdbms.rman, 11.2.0.4.0...483Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db'484485Patching component oracle.rdbms.rsf, 11.2.0.4.0...486487Patching component oracle.rdbms, 11.2.0.4.0...488489Patching component oracle.precomp.common, 11.2.0.4.0...490491Patching component oracle.rdbms.rman, 11.2.0.4.0...492493Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...494495Patching component oracle.rdbms.deconfig, 11.2.0.4.0...496Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db'497498Patching component oracle.precomp.common, 11.2.0.4.0...499500Patching component oracle.sysman.console.db, 11.2.0.4.0...501502Patching component oracle.rdbms.rsf, 11.2.0.4.0...503504Patching component oracle.rdbms.rman, 11.2.0.4.0...505506Patching component oracle.rdbms, 11.2.0.4.0...507508Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...509510Patching component oracle.ordim.client, 11.2.0.4.0...511512Patching component oracle.ordim.jai, 11.2.0.4.0...513Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db'514ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.515516Patching component oracle.precomp.common, 11.2.0.4.0...517518Patching component oracle.ovm, 11.2.0.4.0...519520Patching component oracle.xdk, 11.2.0.4.0...521522Patching component oracle.rdbms.util, 11.2.0.4.0...523524Patching component oracle.rdbms, 11.2.0.4.0...525526Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...527528Patching component oracle.xdk.parser.java, 11.2.0.4.0...529530Patching component oracle.oraolap, 11.2.0.4.0...531532Patching component oracle.rdbms.rsf, 11.2.0.4.0...533534Patching component oracle.xdk.rsf, 11.2.0.4.0...535536Patching component oracle.rdbms.rman, 11.2.0.4.0...537538Patching component oracle.rdbms.deconfig, 11.2.0.4.0...539Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db'540541Patching component oracle.rdbms.dv, 11.2.0.4.0...542543Patching component oracle.rdbms.oci, 11.2.0.4.0...544545Patching component oracle.precomp.common, 11.2.0.4.0...546547Patching component oracle.sysman.agent, 10.2.0.4.5...548549Patching component oracle.xdk, 11.2.0.4.0...550551Patching component oracle.sysman.common, 10.2.0.4.5...552553Patching component oracle.rdbms, 11.2.0.4.0...554555Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...556557Patching component oracle.xdk.parser.java, 11.2.0.4.0...558559Patching component oracle.sysman.console.db, 11.2.0.4.0...560561Patching component oracle.xdk.rsf, 11.2.0.4.0...562563Patching component oracle.rdbms.rsf, 11.2.0.4.0...564565Patching component oracle.sysman.common.core, 10.2.0.4.5...566567Patching component oracle.rdbms.rman, 11.2.0.4.0...568569Patching component oracle.rdbms.deconfig, 11.2.0.4.0...570Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db'571572Patching component oracle.sysman.console.db, 11.2.0.4.0...573574Patching component oracle.rdbms, 11.2.0.4.0...575576Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...577578Patching component oracle.rdbms.rsf, 11.2.0.4.0...579Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db'580581Patching component oracle.sysman.agent, 10.2.0.4.5...582583Patching component oracle.rdbms.rsf, 11.2.0.4.0...584585Patching component oracle.rdbms.rman, 11.2.0.4.0...586587Patching component oracle.rdbms, 11.2.0.4.0...588Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db'589ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.590591Patching component oracle.sysman.agent, 10.2.0.4.5...592593Patching component oracle.ovm, 11.2.0.4.0...594595Patching component oracle.xdk, 11.2.0.4.0...596597Patching component oracle.rdbms, 11.2.0.4.0...598599Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...600601Patching component oracle.xdk.parser.java, 11.2.0.4.0...602603Patching component oracle.sysman.console.db, 11.2.0.4.0...604605Patching component oracle.xdk.rsf, 11.2.0.4.0...606607Patching component oracle.rdbms.rsf, 11.2.0.4.0...608609Patching component oracle.sysman.oms.core, 10.2.0.4.5...610Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db'611ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.612613Patching component oracle.precomp.common, 11.2.0.4.0...614615Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...616617Patching component oracle.rdbms.olap, 11.2.0.4.0...618619Patching component oracle.oraolap, 11.2.0.4.0...620621Patching component oracle.rdbms.rsf, 11.2.0.4.0...622623Patching component oracle.rdbms.rman, 11.2.0.4.0...624625Patching component oracle.rdbms, 11.2.0.4.0...626627Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...628Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db'629630Patching component oracle.rdbms.dv, 11.2.0.4.0...631632Patching component oracle.rdbms, 11.2.0.4.0...633634Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...635636Patching component oracle.rdbms.rsf, 11.2.0.4.0...637Applying sub-patch '24006111' to OH '/u01/app/oracle/product/11.2.0/db'638639Patching component oracle.sqlplus.ic, 11.2.0.4.0...640641Patching component oracle.sqlplus, 11.2.0.4.0...642643Patching component oracle.rdbms.rsf, 11.2.0.4.0...644645Patching component oracle.rdbms, 11.2.0.4.0...646647Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...648Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db'649650Patching component oracle.precomp.common, 11.2.0.4.0...651652Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...653654Patching component oracle.sqlplus.ic, 11.2.0.4.0...655656Patching component oracle.sqlplus, 11.2.0.4.0...657658Patching component oracle.rdbms.rsf, 11.2.0.4.0...659660Patching component oracle.rdbms, 11.2.0.4.0...661662Patching component oracle.rdbms.util, 11.2.0.4.0...663664Patching component oracle.ordim.client, 11.2.0.4.0...665666Patching component oracle.ordim.jai, 11.2.0.4.0...667668Patching component oracle.ordim.server, 11.2.0.4.0...669Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db'670ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.671672Patching component oracle.ldap.rsf, 11.2.0.4.0...673674Patching component oracle.oracore.rsf, 11.2.0.4.0...675676Patching component oracle.rdbms, 11.2.0.4.0...677678Patching component oracle.rdbms.rsf, 11.2.0.4.0...679680Patching component oracle.rdbms.rman, 11.2.0.4.0...681Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db'682683Patching component oracle.oracore.rsf, 11.2.0.4.0...684685Patching component oracle.rdbms, 11.2.0.4.0...686Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db'687ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.688689Patching component oracle.network.rsf, 11.2.0.4.0...690691Patching component oracle.ldap.client, 11.2.0.4.0...692693Patching component oracle.sysman.agent, 10.2.0.4.5...694695Patching component oracle.xdk, 11.2.0.4.0...696697Patching component oracle.rdbms, 11.2.0.4.0...698699Patching component oracle.network.listener, 11.2.0.4.0...700701Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...702703Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...704705Patching component oracle.xdk.parser.java, 11.2.0.4.0...706707Patching component oracle.xdk.rsf, 11.2.0.4.0...708709Patching component oracle.rdbms.rsf, 11.2.0.4.0...710711Patching component oracle.rdbms.rman, 11.2.0.4.0...712Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db'713714Patching component oracle.rdbms, 11.2.0.4.0...715716Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...717718Patching component oracle.rdbms.rman, 11.2.0.4.0...719720Patching component oracle.rdbms.rsf, 11.2.0.4.0...721Applying sub-patch '27338049' to OH '/u01/app/oracle/product/11.2.0/db'722723Patching component oracle.assistants.server, 11.2.0.4.0...724725Patching component oracle.rdbms.rsf, 11.2.0.4.0...726727Patching component oracle.rdbms, 11.2.0.4.0...728729Patching component oracle.rdbms.rman, 11.2.0.4.0...730731Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...732Applying sub-patch '27734982' to OH '/u01/app/oracle/product/11.2.0/db'733734Patching component oracle.ctx, 11.2.0.4.0...735736Patching component oracle.rdbms.rsf, 11.2.0.4.0...737738Patching component oracle.ctx.rsf, 11.2.0.4.0...739740Patching component oracle.rdbms, 11.2.0.4.0...741742Patching component oracle.rdbms.rman, 11.2.0.4.0...743Applying sub-patch '28204707' to OH '/u01/app/oracle/product/11.2.0/db'744Applying changes to emctl script on the home: /u01/app/oracle/product/11.2.0/db ...745746Patching component oracle.rdbms, 11.2.0.4.0...747748Patching component oracle.oracore.rsf, 11.2.0.4.0...749750Patching component oracle.rdbms.rsf, 11.2.0.4.0...751752Patching component oracle.ldap.rsf, 11.2.0.4.0...753754Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...755756Patching component oracle.network.rsf, 11.2.0.4.0...757758Patching component oracle.sysman.agent, 10.2.0.4.5...759760Patching component oracle.sysman.console.db, 11.2.0.4.0...761762Patching component oracle.ldap.security.osdt, 11.2.0.4.0...763764Patching component oracle.ldap.owm, 11.2.0.4.0...765766Patching component oracle.sqlplus.rsf, 11.2.0.4.0...767768Patching component oracle.ctx, 11.2.0.4.0...769Applying sub-patch '28729262' to OH '/u01/app/oracle/product/11.2.0/db'770INFO: Script isn't applicable to this port!771772Patching component oracle.rdbms, 11.2.0.4.0...773774Patching component oracle.rdbms.rsf, 11.2.0.4.0...775776Patching component oracle.rdbms.util, 11.2.0.4.0...777778Patching component oracle.ldap.rsf, 11.2.0.4.0...779780Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...781782Patching component oracle.network.rsf, 11.2.0.4.0...783784Patching component oracle.rdbms.rman, 11.2.0.4.0...785786Patching component oracle.ctx, 11.2.0.4.0...787Applying sub-patch '29141056' to OH '/u01/app/oracle/product/11.2.0/db'788789Patching component oracle.rdbms, 11.2.0.4.0...790791Patching component oracle.rdbms.rman, 11.2.0.4.0...792793Patching component oracle.oracore.rsf, 11.2.0.4.0...794795Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...796797Patching component oracle.rdbms.rsf, 11.2.0.4.0...798Applying sub-patch '29497421' to OH '/u01/app/oracle/product/11.2.0/db'799800Patching component oracle.rdbms, 11.2.0.4.0...801802Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...803804Patching component oracle.rdbms.rman, 11.2.0.4.0...805806Patching component oracle.rdbms.rsf, 11.2.0.4.0...807808Patching component oracle.ldap.rsf, 11.2.0.4.0...809810Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...811812Patching component oracle.oracore.rsf, 11.2.0.4.0...813814Patching component oracle.ctx, 11.2.0.4.0...815Applying sub-patch '29913194' to OH '/u01/app/oracle/product/11.2.0/db'816817Patching component oracle.rdbms, 11.2.0.4.0...818819Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...820821Patching component oracle.rdbms.rsf, 11.2.0.4.0...822823Patching component oracle.network.rsf, 11.2.0.4.0...824825Patching component oracle.ldap.rsf, 11.2.0.4.0...826827Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...828829Patching component oracle.rdbms.util, 11.2.0.4.0...830Applying sub-patch '30298532' to OH '/u01/app/oracle/product/11.2.0/db'831ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 11.2.0.4.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.832833Patching component oracle.rdbms.rsf, 11.2.0.4.0...834835Patching component oracle.rdbms, 11.2.0.4.0...836837Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...838839Patching component oracle.rdbms.hsodbc, 11.2.0.4.0...840841Patching component oracle.ldap.rsf, 11.2.0.4.0...842843Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...844Applying sub-patch '30670774' to OH '/u01/app/oracle/product/11.2.0/db'845846Patching component oracle.rdbms.rsf, 11.2.0.4.0...847848Patching component oracle.rdbms, 11.2.0.4.0...849850Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...851852Patching component oracle.network.rsf, 11.2.0.4.0...853854Patching component oracle.ldap.rsf, 11.2.0.4.0...855856Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...857858Patching component oracle.swd.oui, 11.2.0.4.0...859860Patching component oracle.ctx, 11.2.0.4.0...861Applying sub-patch '31103343' to OH '/u01/app/oracle/product/11.2.0/db'862863Patching component oracle.rdbms, 11.2.0.4.0...864865Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...866867Patching component oracle.rdbms.rsf, 11.2.0.4.0...868Applying sub-patch '31537677' to OH '/u01/app/oracle/product/11.2.0/db'869870Patching component oracle.rdbms, 11.2.0.4.0...871872Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...873874Patching component oracle.rdbms.rsf, 11.2.0.4.0...875876Patching component oracle.rdbms.dv, 11.2.0.4.0...877878Patching component oracle.rdbms.rman, 11.2.0.4.0...879880Patching component oracle.ldap.rsf, 11.2.0.4.0...881882Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...883884Patching component oracle.oracore.rsf, 11.2.0.4.0...885886Patching component oracle.rdbms.util, 11.2.0.4.0...887888Patching component oracle.dbdev, 11.2.0.4.0...889890Patching component oracle.ctx, 11.2.0.4.0...891892Patching component oracle.buildtools.rsf, 11.2.0.4.0...893Applying sub-patch '31983472' to OH '/u01/app/oracle/product/11.2.0/db'894895Patching component oracle.rdbms, 11.2.0.4.0...896897Patching component oracle.ctx, 11.2.0.4.0...898Applying sub-patch '32328626' to OH '/u01/app/oracle/product/11.2.0/db'899900Patching component oracle.rdbms, 11.2.0.4.0...901902Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...903904Patching component oracle.rdbms.rsf, 11.2.0.4.0...905906Patching component oracle.rdbms.dv, 11.2.0.4.0...907908Patching component oracle.rdbms.rman, 11.2.0.4.0...909910Patching component oracle.ldap.rsf, 11.2.0.4.0...911912Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...913Applying sub-patch '32758711' to OH '/u01/app/oracle/product/11.2.0/db'914915Patching component oracle.rdbms, 11.2.0.4.0...916917Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...918919Patching component oracle.ctx, 11.2.0.4.0...920921Patching component oracle.network.rsf, 11.2.0.4.0...922Applying sub-patch '33128584' to OH '/u01/app/oracle/product/11.2.0/db'923924Patching component oracle.rdbms, 11.2.0.4.0...925926Patching component oracle.rdbms.rsf, 11.2.0.4.0...927928Patching component oracle.ctx, 11.2.0.4.0...929Applying sub-patch '33477185' to OH '/u01/app/oracle/product/11.2.0/db'930931Patching component oracle.rdbms, 11.2.0.4.0...932933Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...934935Patching component oracle.rdbms.rsf, 11.2.0.4.0...936937Patching component oracle.network.rsf, 11.2.0.4.0...938939Patching component oracle.rdbms.dv, 11.2.0.4.0...940Composite patch 33477185 successfully applied.941Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-02-27_11-04-44AM_1.log942943OPatch succeeded.944945#==============================================================#946Oracle 软件安装补丁 33991024947#==============================================================#948949Oracle Interim Patch Installer version 11.2.0.3.41950Copyright (c) 2023, Oracle Corporation. All rights reserved.951952953Oracle Home : /u01/app/oracle/product/11.2.0/db954Central Inventory : /u01/app/oraInventory955 from : /u01/app/oracle/product/11.2.0/db/oraInst.loc956OPatch version : 11.2.0.3.41957OUI version : 11.2.0.4.0958Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-02-27_11-06-58AM_1.log959960Verifying environment and performing prerequisite checks...961OPatch continues with these patches: 33991024962963Do you want to proceed? [y|n]964Y (auto-answered by -silent)965User Responded with: Y966All checks passed.967968Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.969(Oracle Home = '/u01/app/oracle/product/11.2.0/db')970971972Is the local system ready for patching? [y|n]973Y (auto-answered by -silent)974User Responded with: Y975Backing up files...976Applying interim patch '33991024' to OH '/u01/app/oracle/product/11.2.0/db'977978Patching component oracle.rdbms.rsf, 11.2.0.4.0...979980Patching component oracle.buildtools.rsf, 11.2.0.4.0...981982Patching component oracle.has.db, 11.2.0.4.0...983Patch 33991024 successfully applied.984Log file location: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2023-02-27_11-06-58AM_1.log985986OPatch succeeded.987988#==============================================================#989Oracle 执行 relink990#==============================================================#991992writing relink log to: /u01/app/oracle/product/11.2.0/db/install/relink.log993994#==============================================================#995Oracle 软件版本996#==============================================================#997998999SQL*Plus: Release 11.2.0.4.0 Production100010011002#==============================================================#1003OPatch 补丁信息1004#==============================================================#1005100633991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2100733477185;Database Patch Set Update : 11.2.0.4.220118 (33477185)10081009OPatch succeeded.101010111012#==============================================================#1013配置监听1014#==============================================================#101510161017Parsing command line arguments:1018 Parameter "silent" = true1019 Parameter "responsefile" = /u01/app/oracle/product/11.2.0/db/assistants/netca/netca.rsp1020Done parsing command line arguments.1021Oracle Net Services Configuration:1022Profile configuration complete.1023Oracle Net Listener Startup:1024 Running Listener Control:1025 /u01/app/oracle/product/11.2.0/db/bin/lsnrctl start LISTENER1026 Listener Control complete.1027 Listener started successfully.1028Listener configuration complete.1029Oracle Net Services configuration successful. The exit code is 010301031检查监听状态：103210331034LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 27-FEB-2023 11:07:3510351036Copyright (c) 1991, 2013, Oracle. All rights reserved.10371038Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))1039STATUS of the LISTENER1040------------------------1041Alias LISTENER1042Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production1043Start Date 27-FEB-2023 11:07:341044Uptime 0 days 0 hr. 0 min. 0 sec1045Trace Level off1046Security ON: Local OS Authentication1047SNMP OFF1048Listener Parameter File /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora1049Listener Log File /u01/app/oracle/diag/tnslsnr/lucifer/listener/alert/log.xml1050Listening Endpoints Summary...1051 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))1052 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lucifer)(PORT=1521)))1053The listener supports no services1054The command completed successfully10551056#==============================================================#1057创建数据库1058#==============================================================#10591060Copying database files10611% complete10623% complete106311% complete106418% complete106537% complete1066Creating and starting Oracle instance106740% complete106845% complete106950% complete107055% complete107156% complete107260% complete107362% complete1074Completing Database Creation107566% complete107670% complete107773% complete107874% complete107975% complete108076% complete108177% complete108278% complete108379% complete108480% complete108592% complete1086100% complete1087Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oradb/oradb.log" for further details.10881089#==============================================================#1090配置在线重做日志1091#==============================================================#10921093数据库在线重做日志文件：109410951096 THREAD# GROUP# MEMBER size(M)1097---------- ---------- ------------------------------------------------------------ ----------1098 1 3 /oradata/oradb/redo03.log 1001099 1 2 /oradata/oradb/redo02.log 1001100 1 1 /oradata/oradb/redo01.log 1001101 1 11 /oradata/ORADB/onlinelog/o1_mf_11_kzr7rf8s_.log 1001102 1 11 /u01/app/oracle/fast_recovery_area/ORADB/onlinelog/o1_mf_11_ 1001103 kzr7rfc6_.log11041105 1 12 /oradata/ORADB/onlinelog/o1_mf_12_kzr7rffh_.log 1001106 1 15 /u01/app/oracle/fast_recovery_area/ORADB/onlinelog/o1_mf_15_ 1001107 kzr7rgfk_.log11081109 1 13 /oradata/ORADB/onlinelog/o1_mf_13_kzr7rflm_.log 1001110 1 13 /u01/app/oracle/fast_recovery_area/ORADB/onlinelog/o1_mf_13_ 1001111 kzr7rfo2_.log11121113 1 14 /oradata/ORADB/onlinelog/o1_mf_14_kzr7rfqx_.log 1001114 1 14 /u01/app/oracle/fast_recovery_area/ORADB/onlinelog/o1_mf_14_ 1001115 kzr7rfw9_.log11161117 1 15 /oradata/ORADB/onlinelog/o1_mf_15_kzr7rfyv_.log 1001118 1 12 /u01/app/oracle/fast_recovery_area/ORADB/onlinelog/o1_mf_12_ 1001119 kzr7rfjb_.log112011211122#==============================================================#1123配置 RMAN 备份任务1124#==============================================================#11251126## OracleBegin112700 02 * * * /home/oracle/scripts/del_arch.sh1128#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh1129#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh11301131#==============================================================#1132配置 glogin.sql1133#==============================================================#11341135define _editor=vi1136set serveroutput on size 10000001137set pagesize 99991138set long 999991139set trimspool on1140col name format a801141set termout off1142col global_name new_value gname1143define gname=idle1144select 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 );1145ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';1146set sqlprompt '&gname _DATE> '1147set termout on11481149#==============================================================#1150优化数据库参数1151#==============================================================#11521153数据库参数：115411551156NAME SID SPVALUE VALUE1157-------------------------------------------------- ---------- -------------------------------------------------- --------------------------------------------------1158_b_tree_bitmap_plans * FALSE FALSE1159_datafile_write_errors_crash_instance * FALSE FALSE1160audit_file_dest * /u01/app/oracle/admin/oradb/adump /u01/app/oracle/admin/oradb/adump1161audit_trail * NONE DB1162compatible * 11.2.0.4.0 11.2.0.4.01163control_file_record_keep_time * 31 311164db_block_size * 8192 81921165db_create_file_dest * /oradata /oradata1166db_file_multiblock_read_count * 1281167db_files * 5000 2001168db_name * oradb oradb1169db_recovery_file_dest * /u01/app/oracle/fast_recovery_area /u01/app/oracle/fast_recovery_area1170db_recovery_file_dest_size * 4857004032 48570040321171db_writer_processes * 11172deferred_segment_creation * FALSE FALSE1173diagnostic_dest * /u01/app/oracle /u01/app/oracle1174dispatchers * (PROTOCOL=TCP) (SERVICE=oradbXDB) (PROTOCOL=TCP) (SERVICE=oradbXDB)1175enable_ddl_logging * TRUE FALSE1176event * 10949 trace name context forever,level 11177event * 28401 trace name context forever,level 11178fast_start_parallel_rollback * LOW1179log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog1180log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf1181max_dump_file_size * unlimited1182open_cursors * 1000 3001183optimizer_index_caching * 01184optimizer_mode * ALL_ROWS1185parallel_force_local * FALSE1186parallel_max_servers * 64 641187pga_aggregate_target * 1333788672 13337886721188processes * 2000 1501189remote_login_passwordfile * EXCLUSIVE EXCLUSIVE1190resource_limit * TRUE FALSE1191resource_manager_plan * force:1192sec_case_sensitive_logon * FALSE TRUE1193session_cached_cursors * 300 501194sessions * 2481195sga_max_size * 5338300416 53519319041196sga_target * 5338300416 53519319041197spfile * /u01/app/oracle/product/11.2.0/db/dbs/spfileoradb.1198 ora11991200statistics_level * TYPICAL1201undo_retention * 10800 90012021203恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N]1204y1205正在重启 ......默认使用专业版脚本。脚本下载：ora100.com/shell-install
重启数据库后，连接数据库：
1[root@lucifer:~]# so2[oracle@lucifer:~]$ sas34SQL*Plus: Release 11.2.0.4.0 Production on Mon May 8 10:26:22 202356Copyright (c) 1982, 2013, Oracle. All rights reserved.789Connected to:10Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production11With the Partitioning, OLAP, Data Mining and Real Application Testing options1213sys@ORADB 2023-05-08 10:26:22> show parameter name1415NAME TYPE VALUE16------------------------------------ ----------- ------------------------------17cell_offloadgroup_name string18db_file_name_convert string19db_name string oradb20db_unique_name string oradb21global_names boolean FALSE22instance_name string oradb23lock_name_space string24log_file_name_convert string25processor_group_name string26service_names string oradb27sys@ORADB 2023-05-08 10:26:27> select instance_name,status from v$instance;2829INSTANCE_NAME STATUS30---------------- ------------31oradb OPEN查看补丁版本：
1[oracle@lucifer:~]$ opatch lspatches233991024;11204CERT ON OL8: LINKING ERRORS DURING 11204 FOR DB INSTALL ON OL8.2333477185;Database Patch Set Update : 11.2.0.4.220118 (33477185)45OPatch succeeded.