在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 Redhat 9.3 一键安装 Oracle 19C 19.21 单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellinstal
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 Redhat 9.3 一键安装 Oracle 19C 19.21 单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
1# 主机版本2[root@rhel9:/root]$ cat /etc/redhat-release 3Red Hat Enterprise Linux release 9.3 (Plow)45# 网络信息6[root@rhel9:/root]$ ip a72: ens192: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 10008 link/ether 00:0c:29:54:f6:b8 brd ff:ff:ff:ff:ff:ff9 altname enp11s010 inet 192.168.6.155/24 brd 192.168.6.255 scope global noprefixroute ens19211 valid_lft forever preferred_lft forever12 inet6 fe80::20c:29ff:fe54:f6b8/64 scope link noprefixroute 13 valid_lft forever preferred_lft forever1415# 挂载本地 ISO 镜像16[root@rhel9:/root]$ mount | grep iso | grep -v "/run/media"17/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048)18[root@rhel9:/root]$ df -h|grep /mnt19/dev/sr0 9.9G 9.9G 0 100% /mnt2021# 安装包存放在 /soft 目录下22[root@lucifer ~]# cd /soft/23[root@rhel9:/soft]$ ll24-rwx------. 1 oracle oinstall 3059705302 Nov 9 11:33 LINUX.X64_193000_db_home.zip25-rwxr-xr-x. 1 oracle oinstall 162550 Nov 9 13:16 OracleShellInstall26-rwxr-xr-x. 1 oracle oinstall 1815725977 Nov 9 11:31 p35643107_190000_Linux-x86-64.zip27-rwxr-xr-x. 1 oracle oinstall 127350205 Nov 9 11:31 p35648110_190000_Linux-x86-64.zip28-rwxr-xr-x. 1 oracle oinstall 127774864 Nov 9 11:31 p6880880_190000_Linux-x86-64.zip默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens192 `# local ip ifname`\3-n rhel9 `# 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-pdb lucifer `# pdb name`\12-redo 200 `# redo size`\13-opa 35643107 `# oracle PSU/RU`\14-jpa 35648110 `# OJVM PSU/RU`\15-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] : 191617数据库版本: 19 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; preset: enabled)40 Active: inactive (dead)41 Docs: man:firewalld(1)4243Nov 09 11:27:14 rhel9 systemd[1]: Starting firewalld - dynamic firewall daemon...44Nov 09 11:27:16 rhel9 systemd[1]: Started firewalld - dynamic firewall daemon.45Nov 09 13:17:22 rhel9 systemd[1]: Stopping firewalld - dynamic firewall daemon...46Nov 09 13:17:23 rhel9 systemd[1]: firewalld.service: Deactivated successfully.47Nov 09 13:17:23 rhel9 systemd[1]: Stopped firewalld - dynamic firewall daemon.4849#==============================================================# 50禁用 SELinux 51#==============================================================# 5253SELinux status: enabled54SELinuxfs mount: /sys/fs/selinux55SELinux root directory: /etc/selinux56Loaded policy name: targeted57Current mode: permissive58Mode from config file: disabled59Policy MLS status: enabled60Policy deny_unknown status: allowed61Memory protection checking: actual (secure)62Max kernel policy version: 336364#==============================================================# 65YUM 静默安装依赖包 66#==============================================================# 6768bc-1.07.1-14.el9.x86_6469binutils-2.35.2-42.el9.x86_6470package compat-libcap1 is not installed71gcc-11.4.1-2.1.el9.x86_6472gcc-c++-11.4.1-2.1.el9.x86_6473elfutils-libelf-0.189-3.el9.x86_6474elfutils-libelf-devel-0.189-3.el9.x86_6475glibc-2.34-83.el9_3.7.x86_6476glibc-devel-2.34-83.el9_3.7.x86_6477libaio-0.3.111-13.el9.x86_6478libaio-devel-0.3.111-13.el9.x86_6479libgcc-11.4.1-2.1.el9.x86_6480libstdc++-11.4.1-2.1.el9.x86_6481libstdc++-devel-11.4.1-2.1.el9.x86_6482libxcb-1.13.1-9.el9.x86_6483libX11-1.7.0-8.el9.x86_6484libXau-1.0.9-8.el9.x86_6485libXi-1.7.10-8.el9.x86_6486libXrender-0.9.10-16.el9.x86_6487make-4.3-7.el9.x86_6488net-tools-2.0-0.62.20160912git.el9.x86_6489smartmontools-7.2-7.el9.x86_6490sysstat-12.5.4-7.el9.x86_6491e2fsprogs-1.46.5-3.el9.x86_6492e2fsprogs-libs-1.46.5-3.el9.x86_6493unzip-6.0-56.el9.x86_6494openssh-clients-8.7p1-34.el9.x86_6495readline-8.1-4.el9.x86_6496readline-devel-8.1-4.el9.x86_6497psmisc-23.4-3.el9.x86_6498ksh-1.0.0~beta.1-3.el9.x86_6499nfs-utils-2.5.4-20.el9.x86_64100tar-1.34-6.el9_1.x86_64101device-mapper-multipath-0.8.7-22.el9.x86_64102avahi-0.8-15.el9.x86_64103package ntp is not installed104chrony-4.3-1.el9.x86_64105libXtst-1.2.3-16.el9.x86_64106libXrender-devel-0.9.10-16.el9.x86_64107fontconfig-devel-2.14.0-2.el9_1.x86_64108policycoreutils-3.5-2.el9.x86_64109package policycoreutils-python is not installed110librdmacm-46.0-1.el9.x86_64111package libnsl* is not installed112libibverbs-46.0-1.el9.x86_64113package compat-openssl10 is not installed114policycoreutils-python-utils-3.5-2.el9.noarch115116#==============================================================# 117配置主机名 118#==============================================================# 119120rhel9121122#==============================================================# 123配置 /etc/hosts 文件 124#==============================================================# 125126127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4127::1 localhost localhost.localdomain localhost6 localhost6.localdomain6128129## OracleBegin130## Public IP131192.168.6.155 rhel9132133#==============================================================# 134创建用户和组 135#==============================================================# 136137oracle 用户： 138139uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)140141142#==============================================================# 143配置 Avahi-daemon 服务 144#==============================================================# 145146○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack147 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; preset: enabled)148 Active: inactive (dead)149TriggeredBy: ○ avahi-daemon.socket150151Nov 09 11:27:17 rhel9 avahi-daemon[958]: Registering new address record for fe80::20c:29ff:fe54:f6b8 on ens192.*.152Nov 09 13:18:36 rhel9 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...153Nov 09 13:18:36 rhel9 avahi-daemon[958]: Got SIGTERM, quitting.154Nov 09 13:18:36 rhel9 avahi-daemon[958]: Leaving mDNS multicast group on interface ens192.IPv6 with address fe80::20c:29ff:fe54:f6b8.155Nov 09 13:18:36 rhel9 avahi-daemon[958]: Leaving mDNS multicast group on interface ens192.IPv4 with address 192.168.6.155.156Nov 09 13:18:36 rhel9 avahi-daemon[958]: Leaving mDNS multicast group on interface lo.IPv6 with address ::1.157Nov 09 13:18:36 rhel9 avahi-daemon[958]: Leaving mDNS multicast group on interface lo.IPv4 with address 127.0.0.1.158Nov 09 13:18:36 rhel9 avahi-daemon[958]: avahi-daemon 0.8 exiting.159Nov 09 13:18:36 rhel9 systemd[1]: avahi-daemon.service: Deactivated successfully.160Nov 09 13:18:36 rhel9 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.161162#==============================================================# 163配置透明大页 && NUMA && 磁盘 IO 调度器 164#==============================================================# 165166args="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"167-resume=/dev/mapper/rhel-swap168-args="ro169args="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"170-elevator=deadline"171-transparent_hugepage=never172173#==============================================================# 174配置 sysctl.conf 175#==============================================================# 176177fs.aio-max-nr = 1048576178fs.file-max = 6815744179kernel.shmall = 4090819180kernel.shmmax = 16755998719181kernel.shmmni = 4096182kernel.sem = 250 32000 100 128183net.ipv4.ip_local_port_range = 9000 65500184net.core.rmem_default = 262144185net.core.rmem_max = 4194304186net.core.wmem_default = 262144187net.core.wmem_max = 1048576188vm.min_free_kbytes = 65453189net.ipv4.conf.ens192.rp_filter = 1190vm.swappiness = 10191kernel.panic_on_oops = 1192kernel.randomize_va_space = 2193kernel.numa_balancing = 0194195#==============================================================# 196配置 RemoveIPC 197#==============================================================# 198199[Login]200RemoveIPC=no201202#==============================================================# 203配置 /etc/security/limits.conf 和 /etc/pam.d/login 204#==============================================================# 205206查看 /etc/security/limits.conf： 207208oracle soft nofile 1024209oracle hard nofile 65536210oracle soft stack 10240211oracle hard stack 32768212oracle soft nproc 2047213oracle hard nproc 16384214oracle hard memlock unlimited215oracle soft memlock unlimited216217查看 /etc/pam.d/login 文件： 218219auth substack system-auth220auth include postlogin221account required pam_nologin.so222account include system-auth223password include system-auth224session required pam_selinux.so close225session required pam_loginuid.so226session required pam_selinux.so open227session required pam_namespace.so228session optional pam_keyinit.so force revoke229session include system-auth230session include postlogin231-session optional pam_ck_connector.so232session required pam_limits.so233session required /lib64/security/pam_limits.so234235#==============================================================# 236配置 /dev/shm 237#==============================================================# 238239/dev/mapper/rhel-root / xfs defaults 0 0240UUID=1e070be2-6168-4b31-b206-56fd68e17cf9 /boot xfs defaults 0 0241UUID=E354-7851 /boot/efi vfat umask=0077,shortname=winnt 0 2242/dev/mapper/rhel-swap none swap defaults 0 0243tmpfs /dev/shm tmpfs size=16363280k 0 0244245#==============================================================# 246Root 用户环境变量 247#==============================================================# 248249if [ -f ~/.bashrc ]; then250 . ~/.bashrc251fi252alias so='su - oracle'253export PS1="[`whoami`@`hostname`:"'$PWD]$ '254255#==============================================================# 256Oracle 用户环境变量 257#==============================================================# 258259if [ -f ~/.bashrc ]; then260 . ~/.bashrc261fi262umask 022263export TMP=/tmp264export TMPDIR=$TMP265export NLS_LANG=AMERICAN_AMERICA.AL32UTF8266export ORACLE_BASE=/u01/app/oracle267export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db268export ORACLE_TERM=xterm269export TNS_ADMIN=$ORACLE_HOME/network/admin270export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib271export ORACLE_SID=oradb272export PATH=/usr/sbin:$PATH273export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH274export PERL5LIB=$ORACLE_HOME/perl/lib275alias sas='sqlplus / as sysdba'276alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'277alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'278alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'279export PS1="[`whoami`@`hostname`:"'$PWD]$ '280export CV_ASSUME_DISTID=OL7281stty erase ^H282283#==============================================================# 284静默解压 Oracle 软件包 285#==============================================================# 286287正在静默解压缩 Oracle 软件包，请稍等： 288289.---- -. -. . . . .290( .',----- - - ' ' ' __291 \_/ ;--:- __--------------------___ ____=========_||___292__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|293c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |294,_\___________'_|,L______],|______________________|_i,!________________!_i295/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)296""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""297298299静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 300301静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 302303静默解压 OJVM 软件补丁包： /soft/p35648110*.zip 304305#==============================================================# 306Oracle 安装静默文件 307#==============================================================# 308309oracle.install.option=INSTALL_DB_SWONLY310UNIX_GROUP_NAME=oinstall311INVENTORY_LOCATION=/u01/app/oraInventory312ORACLE_BASE=/u01/app/oracle313oracle.install.db.InstallEdition=EE314oracle.install.db.DBA_GROUP=dba315oracle.install.db.OPER_GROUP=oper316oracle.install.db.OSBACKUPDBA_GROUP=backupdba317oracle.install.db.OSDGDBA_GROUP=dgdba318oracle.install.db.OSKMDBA_GROUP=kmdba319oracle.install.db.OSRACDBA_GROUP=racdba320oracle.install.db.rootconfig.executeRootScript=false321oracle.install.db.rootconfig.configMethod=322oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0323324#==============================================================# 325静默安装数据库软件 326#==============================================================# 327328Preparing the home to patch...329Applying the patch /soft/35643107...330Successfully applied the patch.331The log can be found at: /tmp/InstallActions2023-11-09_01-19-57PM/installerPatchActions_2023-11-09_01-19-57PM.log332Launching Oracle Database Setup Wizard...333334[WARNING] [INS-13014] Target environment does not meet some optional requirements.335 CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2023-11-09_01-19-57PM.log336 ACTION: Identify the list of failed prerequisite checks from the log: installActions2023-11-09_01-19-57PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.337The response file for this session can be found at:338 /u01/app/oracle/product/19.3.0/db/install/response/db_2023-11-09_01-19-57PM.rsp339340You can find the log of this install session at:341 /tmp/InstallActions2023-11-09_01-19-57PM/installActions2023-11-09_01-19-57PM.log342343As a root user, execute the following script(s):344 1. /u01/app/oraInventory/orainstRoot.sh345 2. /u01/app/oracle/product/19.3.0/db/root.sh346347Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 348[rhel9]349Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 350[rhel9]351352353Successfully Setup Software with warning(s).354Moved the install session logs to:355 /u01/app/oraInventory/logs/InstallActions2023-11-09_01-19-57PM356357#==============================================================# 358执行 root 脚本 359#==============================================================# 360361Changing permissions of /u01/app/oraInventory.362Adding read,write permissions for group.363Removing read,write,execute permissions for world.364365Changing groupname of /u01/app/oraInventory to oinstall.366The execution of the script is complete.367Check /u01/app/oracle/product/19.3.0/db/install/root_rhel9_2023-11-09_13-38-03-210893122.log for the output of root script368369#==============================================================# 370OJVM 补丁安装 371#==============================================================# 372373stty: 'standard input': Inappropriate ioctl for device374Oracle Interim Patch Installer version 12.2.0.1.40375Copyright (c) 2023, Oracle Corporation. All rights reserved.376377PREREQ session378379Oracle Home : /u01/app/oracle/product/19.3.0/db380Central Inventory : /u01/app/oraInventory381 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc382OPatch version : 12.2.0.1.40383OUI version : 12.2.0.7.0384Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2023-11-09_13-38-06PM_1.log385386Invoking prereq "checkconflictagainstohwithdetail"387388Prereq "checkConflictAgainstOHWithDetail" passed.389390OPatch succeeded.391Oracle Interim Patch Installer version 12.2.0.1.40392Copyright (c) 2023, Oracle Corporation. All rights reserved.393394395Oracle Home : /u01/app/oracle/product/19.3.0/db396Central Inventory : /u01/app/oraInventory397 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc398OPatch version : 12.2.0.1.40399OUI version : 12.2.0.7.0400Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2023-11-09_13-38-22PM_1.log401402Verifying environment and performing prerequisite checks...403OPatch continues with these patches: 35648110 404405Do you want to proceed? [y|n]406Y (auto-answered by -silent)407User Responded with: Y408All checks passed.409410Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.411(Oracle Home = '/u01/app/oracle/product/19.3.0/db')412413414Is the local system ready for patching? [y|n]415Y (auto-answered by -silent)416User Responded with: Y417Backing up files...418Applying interim patch '35648110' to OH '/u01/app/oracle/product/19.3.0/db'419420Patching component oracle.javavm.server, 19.0.0.0.0...421422Patching component oracle.javavm.server.core, 19.0.0.0.0...423424Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...425426Patching component oracle.rdbms, 19.0.0.0.0...427428Patching component oracle.javavm.client, 19.0.0.0.0...429Patch 35648110 successfully applied.430Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2023-11-09_13-38-22PM_1.log431432OPatch succeeded.433434#==============================================================# 435Oracle 软件版本 436#==============================================================# 437438439SQL*Plus: Release 19.0.0.0.0 - Production440Version 19.21.0.0.0441442443#==============================================================# 444Oracle 补丁信息 445#==============================================================# 44644735648110;OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)44835643107;Database Release Update : 19.21.0.0.231017 (35643107)44929585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)450451OPatch succeeded.452453454#==============================================================# 455配置监听 456#==============================================================# 457458459Parsing command line arguments:460 Parameter "silent" = true461 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp462Done parsing command line arguments.463Oracle Net Services Configuration:464Profile configuration complete.465Oracle Net Listener Startup:466 Running Listener Control: 467 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER468 Listener Control complete.469 Listener started successfully.470Listener configuration complete.471Oracle Net Services configuration successful. The exit code is 0472473检查监听状态： 474475476LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-NOV-2023 13:40:31477478Copyright (c) 1991, 2023, Oracle. All rights reserved.479480Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel9)(PORT=1521)))481STATUS of the LISTENER482------------------------483Alias LISTENER484Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production485Start Date 09-NOV-2023 13:40:30486Uptime 0 days 0 hr. 0 min. 0 sec487Trace Level off488Security ON: Local OS Authentication489SNMP OFF490Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora491Listener Log File /u01/app/oracle/diag/tnslsnr/rhel9/listener/alert/log.xml492Listening Endpoints Summary...493 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel9)(PORT=1521)))494 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))495The listener supports no services496The command completed successfully497498#==============================================================# 499静默建库命令 500#==============================================================# 501502dbca -silent -createDatabase \503-ignorePrereqFailure \504-templateName General_Purpose.dbc \505-responseFile NO_VALUE \506-gdbName oradb \507-sid oradb \508-sysPassword oracle \509-systemPassword oracle \510-redoLogFileSize 200 \511-datafileDestination /oradata \512-storageType FS \513-enableArchive true \514-archiveLogDest /oradata \515-databaseConfigType SINGLE \516-characterset AL32UTF8 \517-nationalCharacterSet AL16UTF16 \518-emConfiguration NONE \519-automaticMemoryManagement false \520-totalMemory 7989 \521-databaseType OLTP \522-createAsContainerDatabase true 523524#==============================================================# 525创建数据库 526#==============================================================# 527528[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.529 CAUSE: 530a. 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].531b.The password entered is a keyword that Oracle does not recommend to be used as password532 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.533[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.534 CAUSE: 535a. 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].536b.The password entered is a keyword that Oracle does not recommend to be used as password537 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.538Prepare for db operation53910% complete540Copying database files54140% complete542Creating and starting Oracle instance54342% complete54446% complete54552% complete54656% complete54760% complete548Completing Database Creation54966% complete 55069% complete55170% complete552Executing Post Configuration Actions553100% complete554Database creation complete. For details check the logfiles at:555 /u01/app/oracle/cfgtoollogs/dbca/oradb.556Database Information:557Global Database Name:oradb558System Identifier(SID):oradb559Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oradb/oradb.log" for further details.560stty: 'standard input': Inappropriate ioctl for device561562#==============================================================# 563创建 PDB 数据库 564#==============================================================# 565566正在创建 PDB：lucifer 567568stty: 'standard input': Inappropriate ioctl for device569stty: 'standard input': Inappropriate ioctl for device570571 CON_ID CON_NAME OPEN MODE RESTRICTED572---------- ------------------------------ ---------- ----------573 2 PDB$SEED READ ONLY NO574 3 LUCIFER READ WRITE NO575576#==============================================================# 577配置在线重做日志 578#==============================================================# 579580stty: 'standard input': Inappropriate ioctl for device581数据库在线重做日志文件： 582583stty: 'standard input': Inappropriate ioctl for device584585 THREAD# GROUP# MEMBER size(M)586---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------587 1 1 /oradata/ORADB/redo01.log 200588 1 2 /oradata/ORADB/redo02.log 200589 1 3 /oradata/ORADB/redo03.log 200590 1 11 /oradata/ORADB/onlinelog/o1_mf_11_lnryoff2_.log 200591 1 12 /oradata/ORADB/onlinelog/o1_mf_12_lnryofjv_.log 200592 1 13 /oradata/ORADB/onlinelog/o1_mf_13_lnryofpv_.log 200593 1 14 /oradata/ORADB/onlinelog/o1_mf_14_lnryofw2_.log 200594 1 15 /oradata/ORADB/onlinelog/o1_mf_15_lnryohcg_.log 200595596#==============================================================# 597配置 RMAN 备份任务 598#==============================================================# 599600## OracleBegin60100 02 * * * /home/oracle/scripts/del_arch.sh602#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh603#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh604605#==============================================================# 606配置 glogin.sql 607#==============================================================# 608609define _editor=vi610set serveroutput on size 1000000611set pagesize 9999612set long 99999613set trimspool on614col name format a80615set termout off616define gname=idle617column global_name new_value gname618select 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 );619ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';620set sqlprompt '&gname _DATE> '621set termout on622623#==============================================================# 624优化数据库参数 625#==============================================================# 626627stty: 'standard input': Inappropriate ioctl for device628数据库参数： 629630stty: 'standard input': Inappropriate ioctl for device631632NAME SID SPVALUE VALUE633-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------634_b_tree_bitmap_plans * FALSE FALSE635_datafile_write_errors_crash_instance * FALSE FALSE636audit_file_dest * /u01/app/oracle/admin/oradb/adump /u01/app/oracle/admin/oradb/adump637audit_trail * NONE DB638compatible * 19.0.0 19.0.0639control_file_record_keep_time * 31 31640db_block_size * 8192 8192641db_create_file_dest * /oradata /oradata642db_file_multiblock_read_count * 128643db_files * 5000 200644db_name * oradb oradb645db_writer_processes * 1646deferred_segment_creation * FALSE FALSE647diagnostic_dest * /u01/app/oracle /u01/app/oracle648dispatchers * (PROTOCOL=TCP) (SERVICE=oradbXDB) (PROTOCOL=TCP) (SERVICE=oradbXDB)649enable_pluggable_database * true TRUE650event * 10949 trace name context forever,level 1651event * 28401 trace name context forever,level 1652fast_start_parallel_rollback * LOW653log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog654log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf655max_dump_file_size * unlimited656max_string_size * STANDARD657nls_language * AMERICAN AMERICAN658nls_territory * AMERICA AMERICA659open_cursors * 1000 300660optimizer_adaptive_plans * TRUE661optimizer_adaptive_statistics * FALSE662optimizer_index_caching * 0663optimizer_mode * ALL_ROWS664parallel_force_local * FALSE665parallel_max_servers * 64 64666pga_aggregate_target * 2680160256 1675624448667processes * 2000 640668remote_login_passwordfile * EXCLUSIVE EXCLUSIVE669session_cached_cursors * 300 50670sessions * 984671sga_max_size * 10723786752 6710886400672sga_target * 10723786752 6710886400673spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfileoradb.ora674statistics_level * TYPICAL675undo_retention * 10800 900676677恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y678679正在重启 ......重启数据库后，连接数据库：
1[oracle@rhel9:/home/oracle]$ sas23SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 9 14:24:51 20234Version 19.21.0.0.056Copyright (c) 1982, 2022, Oracle. All rights reserved.789Connected to:10Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production11Version 19.21.0.0.01213sys@ORADB 2023-11-09 14:24:51> show parameter name1415NAME TYPE VALUE16------------------------------------ ----------- ------------------------------17cdb_cluster_name string18cell_offloadgroup_name string19db_file_name_convert string20db_name string oradb21db_unique_name string oradb22global_names boolean FALSE23instance_name string oradb24lock_name_space string25log_file_name_convert string26pdb_file_name_convert string27processor_group_name string28service_names string oradb29sys@ORADB 2023-11-09 14:24:58> show pdbs3031 CON_ID CON_NAME OPEN MODE RESTRICTED32---------- ------------------------------ ---------- ----------33 2 PDB$SEED READ ONLY NO34 3 LUCIFER READ WRITE NO查看补丁版本：
1[oracle@rhel9:/home/oracle]$ opatch lspatches235648110;OJVM RELEASE UPDATE: 19.21.0.0.231017 (35648110)335643107;Database Release Update : 19.21.0.0.231017 (35643107)429585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)56OPatch succeeded.