在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 麒麟 V10 一键安装 Oracle 19C 19.22 单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshellinstall.co
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 麒麟 V10 一键安装 Oracle 19C 19.22 单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
1# 主机版本2[root@kylin soft]# cat /etc/kylin-release3Kylin Linux Advanced Server release V10 (Lance)45# 网络信息6[root@kylin soft]# ip a72: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 10008 link/ether 00:0c:29:62:a0:e5 brd ff:ff:ff:ff:ff:ff9 inet 192.168.6.222/24 brd 192.168.6.255 scope global noprefixroute ens3310 valid_lft forever preferred_lft forever11 inet6 fe80::735:5307:2e5e:803c/64 scope link noprefixroute 12 valid_lft forever preferred_lft forever1314# 挂载本地 ISO 镜像15[root@kylin soft]# mount | grep iso | grep -v "/run/media"16/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048)17[root@kylin soft]# df -h|grep /mnt18/dev/sr0 4.4G 4.4G 0 100% /mnt1920# 安装包存放在 /soft 目录下21[root@lucifer ~]# cd /soft/22[root@kylin soft]# ll23总用量 501302424-rwx------ 1 root root 3059705302 2月 26 13:35 LINUX.X64_193000_db_home.zip25-rwxr-xr-x 1 root root 162550 2月 26 13:31 OracleShellInstall26-rwx------ 1 root root 127451050 2月 26 13:38 p35926646_190000_Linux-x86-64.zip27-rwx------ 1 root root 1817908992 2月 26 13:38 p35943157_190000_Linux-x86-64.zip28-rwx------ 1 root root 127774864 2月 26 13:38 p6880880_190000_Linux-x86-64.zip29-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 welcome1 `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o lucifer `# dbname`\8-dp welcome1 `# sys/system password`\9-ds AL32UTF8 `# database character`\10-ns AL16UTF16 `# national character`\11-pdb luciferpdb `# pdb name`\12-redo 100 `# redo size`\13-opa 35943157 `# oracle PSU/RU`\14-jpa 35926646 `# OJVM PSU/RU`\15-opd Y `# optimize db`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
12 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██3 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██4 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██5░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██6░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██7░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██8 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███9 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 101112请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : si1314数据库安装模式: single 1516请选择数据库版本 [11/12/19/21] : 191718数据库版本: 19 1920#==============================================================# 21配置本地 YUM 源 22#==============================================================# 2324[server]25name=server26baseurl=file:///mnt27enabled=128gpgcheck=02930#==============================================================# 31禁用防火墙 32#==============================================================# 3334● firewalld.service - firewalld - dynamic firewall daemon35 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)36 Active: inactive (dead)37 Docs: man:firewalld(1)38392月 26 13:11:07 kylin systemd[1]: Starting firewalld - dynamic firewall daemon...402月 26 13:11:09 kylin systemd[1]: Started firewalld - dynamic firewall daemon.412月 26 13:44:03 kylin systemd[1]: Stopping firewalld - dynamic firewall daemon...422月 26 13:44:04 kylin systemd[1]: firewalld.service: Succeeded.432月 26 13:44:04 kylin systemd[1]: Stopped firewalld - dynamic firewall daemon.4445#==============================================================# 46禁用 SELinux 47#==============================================================# 4849SELinux status: disabled5051#==============================================================# 52YUM 静默安装依赖包 53#==============================================================# 5455bc-1.07.1-11.ky10.x86_6456binutils-2.34-19.p01.ky10.x86_6457未安装软件包 compat-libcap1 58gcc-7.3.0-20220207.45.ky10.x86_6459gcc-c++-7.3.0-20220207.45.ky10.x86_6460未安装软件包 elfutils-libelf 61未安装软件包 elfutils-libelf-devel 62glibc-2.28-88.p06.ky10.x86_6463glibc-devel-2.28-88.p06.ky10.x86_6464libaio-0.3.112-1.p01.ky10.x86_6465libaio-devel-0.3.112-1.p01.ky10.x86_6466libgcc-7.3.0-20220207.45.ky10.x86_6467libstdc++-7.3.0-20220207.45.ky10.x86_6468libstdc++-devel-7.3.0-20220207.45.ky10.x86_6469libxcb-1.14-1.ky10.x86_6470libX11-1.6.9-5.ky10.x86_6471libXau-1.0.9-2.ky10.x86_6472libXi-1.7.10-1.ky10.x86_6473libXrender-0.9.10-10.ky10.x86_6474make-4.3-1.ky10.x86_6475net-tools-2.0-0.54.ky10.x86_6476smartmontools-7.1-1.ky10.x86_6477sysstat-12.2.1-1.p00.ky10.x86_6478e2fsprogs-1.45.6-8.ky10.x86_6479未安装软件包 e2fsprogs-libs 80unzip-6.0-47.ky10.x86_6481openssh-clients-8.2p1-16.p04.ky10.x86_6482readline-8.0-3.ky10.x86_6483readline-devel-8.0-3.ky10.x86_6484psmisc-23.3-2.ky10.x86_6485ksh-2020.0.0-4.ky10.x86_6486nfs-utils-2.5.1-5.ky10.x86_6487tar-1.32-2.ky10.x86_6488未安装软件包 device-mapper-multipath 89avahi-0.8-8.ky10.x86_6490ntp-4.2.8p14-5.ky10.x86_6491chrony-3.5-3.p01.ky10.x86_6492libXtst-1.2.3-10.ky10.x86_6493libXrender-devel-0.9.10-10.ky10.x86_6494fontconfig-devel-2.13.92-1.ky10.x86_6495policycoreutils-3.1-7.p01.ky10.x86_6496未安装软件包 policycoreutils-python 97未安装软件包 librdmacm 98未安装软件包 libnsl* 99未安装软件包 libibverbs 100未安装软件包 compat-openssl10 101policycoreutils-python-utils-3.1-7.p01.ky10.noarch102103#==============================================================# 104配置主机名 105#==============================================================# 106107kylin108109#==============================================================# 110配置 /etc/hosts 文件 111#==============================================================# 112113127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4114::1 localhost localhost.localdomain localhost6 localhost6.localdomain6115116## OracleBegin117## Public IP118192.168.6.222 kylin119120#==============================================================# 121创建用户和组 122#==============================================================# 123124oracle 用户： 125126用户id=54321(oracle) 组id=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)127128129#==============================================================# 130配置 Avahi-daemon 服务 131#==============================================================# 132133● avahi-daemon.service - Avahi mDNS/DNS-SD Stack134 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)135 Active: inactive (dead)136137#==============================================================# 138配置透明大页 && NUMA && 磁盘 IO 调度器 139#==============================================================# 140141args="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"142-resume=/dev/mapper/klas-swap143-args="ro144args="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"145-audit=0146-crashkernel=1024M,high147148#==============================================================# 149配置 sysctl.conf 150#==============================================================# 151152kernel.sysrq = 0153net.ipv4.ip_forward = 0154net.ipv4.conf.all.send_redirects = 0155net.ipv4.conf.default.send_redirects = 0156net.ipv4.conf.all.accept_source_route = 0157net.ipv4.conf.default.accept_source_route = 0158net.ipv4.conf.all.accept_redirects = 0159net.ipv4.conf.default.accept_redirects = 0160net.ipv4.conf.all.secure_redirects = 0161net.ipv4.conf.default.secure_redirects = 0162net.ipv4.icmp_echo_ignore_broadcasts = 1163net.ipv4.icmp_ignore_bogus_error_responses = 1164net.ipv4.conf.all.rp_filter = 1165net.ipv4.conf.default.rp_filter = 1166net.ipv4.tcp_syncookies = 1167kernel.dmesg_restrict = 1168net.ipv6.conf.all.accept_redirects = 0169net.ipv6.conf.default.accept_redirects = 0170fs.aio-max-nr = 1048576171fs.file-max = 6815744172kernel.shmall = 2097152173kernel.shmmax = 7010422783174kernel.shmmni = 4096175kernel.sem = 250 32000 100 128176net.ipv4.ip_local_port_range = 9000 65500177net.core.rmem_default = 262144178net.core.rmem_max = 4194304179net.core.wmem_default = 262144180net.core.wmem_max = 1048576181vm.min_free_kbytes = 27384182net.ipv4.conf.ens33.rp_filter = 1183vm.swappiness = 10184kernel.panic_on_oops = 1185kernel.randomize_va_space = 2186kernel.numa_balancing = 0187188#==============================================================# 189配置 nsysctl.conf 190#==============================================================# 191192NOZEROCONF=yes193194#==============================================================# 195配置 RemoveIPC 196#==============================================================# 197198[Login]199RemoveIPC=no200201#==============================================================# 202配置 /etc/security/limits.conf 和 /etc/pam.d/login 203#==============================================================# 204205查看 /etc/security/limits.conf： 206207oracle soft nofile 1024208oracle hard nofile 65536209oracle soft stack 10240210oracle hard stack 32768211oracle soft nproc 2047212oracle hard nproc 16384213oracle hard memlock unlimited214oracle soft memlock unlimited215216查看 /etc/pam.d/login 文件： 217218auth substack system-auth219auth include postlogin220account required pam_nologin.so221account include system-auth222password include system-auth223session required pam_selinux.so close224session required pam_loginuid.so225session required pam_selinux.so open226session required pam_namespace.so227session optional pam_keyinit.so force revoke228session include system-auth229session include postlogin230-session optional pam_ck_connector.so231session required pam_limits.so232session required /lib64/security/pam_limits.so233234#==============================================================# 235配置 /dev/shm 236#==============================================================# 237238/dev/mapper/klas-root / xfs defaults 0 0239UUID=c8e47a65-11c4-4e4e-84ce-95f9f618be7e /boot xfs defaults 0 0240/dev/mapper/klas-swap none swap defaults 0 0241tmpfs /dev/shm tmpfs size=6846116k 0 0242243#==============================================================# 244安装 rlwrap 插件 245#==============================================================# 246247成功安装 rlwrap： rlwrap 0.44 248249#==============================================================# 250Root 用户环境变量 251#==============================================================# 252253if [ -f ~/.bashrc ]; then254 . ~/.bashrc255fi256PATH=$PATH:$HOME/bin257export PATH258alias so='su - oracle'259export PS1="[`whoami`@`hostname`:"'$PWD]$ '260261#==============================================================# 262Oracle 用户环境变量 263#==============================================================# 264265[ -f ~/.bashrc ] && . ~/.bashrc266umask 022267export TMP=/tmp268export TMPDIR=$TMP269export NLS_LANG=AMERICAN_AMERICA.AL32UTF8270export ORACLE_BASE=/u01/app/oracle271export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db272export ORACLE_TERM=xterm273export TNS_ADMIN=$ORACLE_HOME/network/admin274export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib275export ORACLE_SID=lucifer276export PATH=/usr/sbin:$PATH277export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH278export PERL5LIB=$ORACLE_HOME/perl/lib279alias sas='sqlplus / as sysdba'280alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'281alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'282alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'283export PS1="[`whoami`@`hostname`:"'$PWD]$ '284export CV_ASSUME_DISTID=OL7285alias sqlplus='rlwrap sqlplus'286alias rman='rlwrap rman'287alias adrci='rlwrap adrci'288289#==============================================================# 290静默解压 Oracle 软件包 291#==============================================================# 292293正在静默解压缩 Oracle 软件包，请稍等： 294295.---- -. -. . . . .296( .',----- - - ' ' ' __297 \_/ ;--:- __--------------------___ ____=========_||___298__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|299c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |300,_\___________'_|,L______],|______________________|_i,!________________!_i301/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)302""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""303304305静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 306307静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 308309静默解压 Oracle 软件补丁包： /soft/p35943157*.zip 310311静默解压 OJVM 软件补丁包： /soft/p35926646*.zip 312313#==============================================================# 314Oracle 安装静默文件 315#==============================================================# 316317oracle.install.option=INSTALL_DB_SWONLY318UNIX_GROUP_NAME=oinstall319INVENTORY_LOCATION=/u01/app/oraInventory320ORACLE_BASE=/u01/app/oracle321oracle.install.db.InstallEdition=EE322oracle.install.db.DBA_GROUP=dba323oracle.install.db.OPER_GROUP=oper324oracle.install.db.OSBACKUPDBA_GROUP=backupdba325oracle.install.db.OSDGDBA_GROUP=dgdba326oracle.install.db.OSKMDBA_GROUP=kmdba327oracle.install.db.OSRACDBA_GROUP=racdba328oracle.install.db.rootconfig.executeRootScript=false329oracle.install.db.rootconfig.configMethod=330oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0331332#==============================================================# 333静默安装数据库软件 334#==============================================================# 335336Preparing the home to patch...337Applying the patch /soft/35943157...338Successfully applied the patch.339The log can be found at: /tmp/InstallActions2024-02-26_01-47-12PM/installerPatchActions_2024-02-26_01-47-12PM.log340Launching Oracle Database Setup Wizard...341342[WARNING] [INS-13014] Target environment does not meet some optional requirements.343 CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2024-02-26_01-47-12PM.log344 ACTION: Identify the list of failed prerequisite checks from the log: installActions2024-02-26_01-47-12PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.345The response file for this session can be found at:346 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-02-26_01-47-12PM.rsp347348You can find the log of this install session at:349 /tmp/InstallActions2024-02-26_01-47-12PM/installActions2024-02-26_01-47-12PM.log350351As a root user, execute the following script(s):352 1. /u01/app/oraInventory/orainstRoot.sh353 2. /u01/app/oracle/product/19.3.0/db/root.sh354355Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 356[kylin]357Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 358[kylin]359360361Successfully Setup Software with warning(s).362Moved the install session logs to:363 /u01/app/oraInventory/logs/InstallActions2024-02-26_01-47-12PM364365#==============================================================# 366执行 root 脚本 367#==============================================================# 368369Changing permissions of /u01/app/oraInventory.370Adding read,write permissions for group.371Removing read,write,execute permissions for world.372373Changing groupname of /u01/app/oraInventory to oinstall.374The execution of the script is complete.375Check /u01/app/oracle/product/19.3.0/db/install/root_kylin_2024-02-26_14-07-58-770735988.log for the output of root script376377#==============================================================# 378OJVM 补丁安装 379#==============================================================# 380381Oracle Interim Patch Installer version 12.2.0.1.40382Copyright (c) 2024, Oracle Corporation. All rights reserved.383384PREREQ session385386Oracle Home : /u01/app/oracle/product/19.3.0/db387Central Inventory : /u01/app/oraInventory388 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc389OPatch version : 12.2.0.1.40390OUI version : 12.2.0.7.0391Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-08-02PM_1.log392393Invoking prereq "checkconflictagainstohwithdetail"394395Prereq "checkConflictAgainstOHWithDetail" passed.396397OPatch succeeded.398Oracle Interim Patch Installer version 12.2.0.1.40399Copyright (c) 2024, Oracle Corporation. All rights reserved.400401402Oracle Home : /u01/app/oracle/product/19.3.0/db403Central Inventory : /u01/app/oraInventory404 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc405OPatch version : 12.2.0.1.40406OUI version : 12.2.0.7.0407Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-08-17PM_1.log408409Verifying environment and performing prerequisite checks...410OPatch continues with these patches: 35926646 411412Do you want to proceed? [y|n]413Y (auto-answered by -silent)414User Responded with: Y415All checks passed.416417Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.418(Oracle Home = '/u01/app/oracle/product/19.3.0/db')419420421Is the local system ready for patching? [y|n]422Y (auto-answered by -silent)423User Responded with: Y424Backing up files...425Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'426427Patching component oracle.javavm.server, 19.0.0.0.0...428429Patching component oracle.javavm.server.core, 19.0.0.0.0...430431Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...432433Patching component oracle.rdbms, 19.0.0.0.0...434435Patching component oracle.javavm.client, 19.0.0.0.0...436Patch 35926646 successfully applied.437Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-02-26_14-08-17PM_1.log438439OPatch succeeded.440441#==============================================================# 442Oracle 软件版本 443#==============================================================# 444445446SQL*Plus: Release 19.0.0.0.0 - Production447Version 19.22.0.0.0448449450#==============================================================# 451Oracle 补丁信息 452#==============================================================# 45345435926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)45535943157;Database Release Update : 19.22.0.0.240116 (35943157)45629585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)457458OPatch succeeded.459460461#==============================================================# 462配置监听 463#==============================================================# 464465466Parsing command line arguments:467 Parameter "silent" = true468 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp469Done parsing command line arguments.470Oracle Net Services Configuration:471Profile configuration complete.472Oracle Net Listener Startup:473 Running Listener Control: 474 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER475 Listener Control complete.476 Listener started successfully.477Listener configuration complete.478Oracle Net Services configuration successful. The exit code is 0479480检查监听状态： 481482483LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-FEB-2024 14:10:17484485Copyright (c) 1991, 2023, Oracle. All rights reserved.486487Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kylin)(PORT=1521)))488STATUS of the LISTENER489------------------------490Alias LISTENER491Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production492Start Date 26-FEB-2024 14:10:16493Uptime 0 days 0 hr. 0 min. 0 sec494Trace Level off495Security ON: Local OS Authentication496SNMP OFF497Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora498Listener Log File /u01/app/oracle/diag/tnslsnr/kylin/listener/alert/log.xml499Listening Endpoints Summary...500 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kylin)(PORT=1521)))501 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))502The listener supports no services503The command completed successfully504505#==============================================================# 506静默建库命令 507#==============================================================# 508509dbca -silent -createDatabase \510-ignorePrereqFailure \511-templateName General_Purpose.dbc \512-responseFile NO_VALUE \513-gdbName lucifer \514-sid lucifer \515-sysPassword welcome1 \516-systemPassword welcome1 \517-redoLogFileSize 100 \518-datafileDestination /oradata \519-storageType FS \520-enableArchive true \521-archiveLogDest /oradata \522-databaseConfigType SINGLE \523-characterset AL32UTF8 \524-nationalCharacterSet AL16UTF16 \525-emConfiguration NONE \526-automaticMemoryManagement false \527-totalMemory 3342 \528-databaseType OLTP \529-createAsContainerDatabase true 530531#==============================================================# 532创建数据库 533#==============================================================# 534535[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.536 CAUSE: 537a. 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].538b.The password entered is a keyword that Oracle does not recommend to be used as password539 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.540[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.541 CAUSE: 542a. 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].543b.The password entered is a keyword that Oracle does not recommend to be used as password544 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.545Prepare for db operation54610% complete547Copying database files54840% complete549Creating and starting Oracle instance55042% complete55146% complete55252% complete55356% complete55460% complete555Completing Database Creation55666% complete55769% complete55870% complete559Executing Post Configuration Actions560100% complete561Database creation complete. For details check the logfiles at:562 /u01/app/oracle/cfgtoollogs/dbca/lucifer.563Database Information:564Global Database Name:lucifer565System Identifier(SID):lucifer566Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.567568#==============================================================# 569配置在线重做日志 570#==============================================================# 571572数据库在线重做日志文件： 573574575 THREAD# GROUP# MEMBER size(M)576---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------577 1 1 /oradata/LUCIFER/redo01.log 100578 1 2 /oradata/LUCIFER/redo02.log 100579 1 3 /oradata/LUCIFER/redo03.log 100580 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_lxrf77mc_.log 100581 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_lxrf77or_.log 100582 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_lxrf77qs_.log 100583 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_lxrf77t4_.log 100584 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_lxrf782d_.log 100585586#==============================================================# 587配置 RMAN 备份任务 588#==============================================================# 589590## OracleBegin59100 02 * * * /home/oracle/scripts/del_arch.sh592#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh593#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh594595#==============================================================# 596配置 glogin.sql 597#==============================================================# 598599define _editor=vi600set serveroutput on size 1000000601set pagesize 9999602set long 99999603set trimspool on604col name format a80605set termout off606define gname=idle607column global_name new_value gname608select 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 );609ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';610set sqlprompt '&gname _DATE> '611set termout on612613#==============================================================# 614优化数据库参数 615#==============================================================# 616617数据库参数： 618619620NAME SID SPVALUE VALUE621-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------622_b_tree_bitmap_plans * FALSE FALSE623_datafile_write_errors_crash_instance * FALSE FALSE624audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump625audit_trail * NONE DB626compatible * 19.0.0 19.0.0627control_file_record_keep_time * 31 31628db_block_size * 8192 8192629db_create_file_dest * /oradata /oradata630db_file_multiblock_read_count * 128631db_files * 5000 200632db_name * lucifer lucifer633db_writer_processes * 1634deferred_segment_creation * FALSE FALSE635diagnostic_dest * /u01/app/oracle /u01/app/oracle636dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)637enable_pluggable_database * true TRUE638event * 10949 trace name context forever,level 1639event * 28401 trace name context forever,level 1640fast_start_parallel_rollback * LOW641log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog642log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf643max_dump_file_size * unlimited644max_string_size * STANDARD645nls_language * AMERICAN AMERICAN646nls_territory * AMERICA AMERICA647open_cursors * 1000 300648optimizer_adaptive_plans * TRUE649optimizer_adaptive_statistics * FALSE650optimizer_index_caching * 0651optimizer_mode * ALL_ROWS652parallel_force_local * FALSE653parallel_max_servers * 64 64654pga_aggregate_target * 1120927744 701497344655processes * 2000 640656remote_login_passwordfile * EXCLUSIVE EXCLUSIVE657session_cached_cursors * 300 50658sessions * 984659sga_max_size * 4485808128 2818572288660sga_target * 4485808128 2818572288661spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora662statistics_level * TYPICAL663undo_retention * 10800 900664665恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N]重启数据库后，连接数据库：
1[oracle@kylin:/home/oracle]$ sas23SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 26 14:52:28 20244Version 19.22.0.0.056Copyright (c) 1982, 2023, Oracle. All rights reserved.789Connected to:10Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production11Version 19.22.0.0.01213sys@LUCIFER 2024-02-26 14:52:28> show parameter name1415NAME TYPE VALUE16------------------------------------ ----------- ------------------------------17cdb_cluster_name string18cell_offloadgroup_name string19db_file_name_convert string20db_name string lucifer21db_unique_name string lucifer22global_names boolean FALSE23instance_name string lucifer24lock_name_space string25log_file_name_convert string26pdb_file_name_convert string27processor_group_name string28service_names string lucifer查看补丁版本：
1[oracle@kylin:/home/oracle]$ opatch lspatches235926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)335943157;Database Release Update : 19.22.0.0.240116 (35943157)429585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)56OPatch succeeded.