在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 19C 单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshel
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 openEuler 22.03 LTS SP3 一键安装 Oracle 19C 单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：openEuler 22.03 LTS SP3 安装 Oracle 19C（19.22） 单机版安装包合集（包含补丁！！！）
加载 ISO 镜像进入安装流程：
安装前检查：
选择系统安装语言：中文
进入安装界面，选择配置安装目的地：
选择自定义配置：
点击自动创建分区：
删除 /home 分区目录：
调整 swap 大小与内存一致：
分配剩余空间给根目录：
配置完成，开始创建分区：
软件选择，安装模式选择服务器：
配置主机名和网络：
配置网卡自动连接：
配置网络 IPV4：
保存配置信息：
启用 root 用户，配置 root 密码：
创建用户 lucifer，配置密码：
正式开始安装系统：
安装完成，重启系统：
输入 root 账户密码进入系统：
openEuler 22.03 LTS SP3 默认没有图形化界面，openEuler 安装桌面环境图形化界面【ukui】：
1## 前提是需要联网，配置网络 yum 源2## 安装字体文件 3yum groupinstall fonts -y4## 设置默认桌面图形化界面5systemctl set-default graphical.target6## 安装UKUI的桌面图形环境7yum install ukui -y1# 主机版本2[root@openEuler soft]# cat /etc/openEuler-release 3openEuler release 22.03 (LTS-SP3)45# 网络信息6[root@openEuler 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:6b:8e:70 brd ff:ff:ff:ff:ff:ff9 inet 192.168.6.123/24 brd 192.168.6.255 scope global noprefixroute ens3310 valid_lft forever preferred_lft forever11 inet6 fe80::20c:29ff:fe6b:8e70/64 scope link noprefixroute 12 valid_lft forever preferred_lft forever1314# 挂载本地 ISO 镜像15[root@openEuler soft]# mount | grep iso | grep -v "/run/media"16/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)17[root@openEuler soft]# df -h|grep /mnt18/dev/sr0 18G 18G 0 100% /mnt1920# 安装包存放在 /soft 目录下21[root@openEuler ~]# cd /soft/22[root@openEuler soft]# ll23总用量 501303224-rwx------. 1 root root 3059705302 3月 18 09:51 LINUX.X64_193000_db_home.zip25-rwxr-xr-x. 1 root root 163165 3月 18 09:52 OracleShellInstall26-rwx------. 1 root root 127451050 3月 18 09:50 p35926646_190000_Linux-x86-64.zip27-rwx------. 1 root root 1817908992 3月 18 09:51 p35943157_190000_Linux-x86-64.zip28-rwx------. 1 root root 127774864 3月 18 09:50 p6880880_190000_Linux-x86-64.zip29-rwx------. 1 root root 321590 3月 18 09:51 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n openEuler `# 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-redo 100 `# redo size`\12-opa 35943157 `# oracle PSU/RU`\13-jpa 35926646 `# OJVM PSU/RU`\14-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[openEuler]25name=openEuler26baseurl=file:////mnt27enabled=128gpgcheck=129gpgkey=file:////mnt/RPM-GPG-KEY-openEuler3031#==============================================================# 32禁用防火墙 33#==============================================================# 3435○ firewalld.service - firewalld - dynamic firewall daemon36 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)37 Active: inactive (dead)38 Docs: man:firewalld(1)39403月 18 09:39:25 openEuler systemd[1]: Starting firewalld - dynamic firewall daemon...413月 18 09:39:26 openEuler systemd[1]: Started firewalld - dynamic firewall daemon.423月 18 11:04:06 openEuler systemd[1]: Stopping firewalld - dynamic firewall daemon...433月 18 11:04:07 openEuler systemd[1]: firewalld.service: Deactivated successfully.443月 18 11:04:07 openEuler systemd[1]: Stopped firewalld - dynamic firewall daemon.4546#==============================================================# 47禁用 SELinux 48#==============================================================# 4950SELinux status: enabled51SELinuxfs mount: /sys/fs/selinux52SELinux root directory: /etc/selinux53Loaded policy name: targeted54Current mode: permissive55Mode from config file: disabled56Policy MLS status: enabled57Policy deny_unknown status: allowed58Memory protection checking: actual (secure)59Max kernel policy version: 336061#==============================================================# 62YUM 静默安装依赖包 63#==============================================================# 6465bc-1.07.1-12.oe2203sp3.x86_6466binutils-2.37-24.oe2203sp3.x86_6467未安装软件包 compat-libcap1 68gcc-10.3.1-49.oe2203sp3.x86_6469gcc-c++-10.3.1-49.oe2203sp3.x86_6470未安装软件包 elfutils-libelf 71未安装软件包 elfutils-libelf-devel 72glibc-2.34-143.oe2203sp3.x86_6473glibc-devel-2.34-143.oe2203sp3.x86_6474libaio-0.3.113-9.oe2203sp3.x86_6475libaio-devel-0.3.113-9.oe2203sp3.x86_6476libgcc-10.3.1-49.oe2203sp3.x86_6477libstdc++-10.3.1-49.oe2203sp3.x86_6478libstdc++-devel-10.3.1-49.oe2203sp3.x86_6479libxcb-1.15-1.oe2203sp3.x86_6480libX11-1.7.2-8.oe2203sp3.x86_6481libXau-1.0.10-1.oe2203sp3.x86_6482libXi-1.8-2.oe2203sp3.x86_6483libXrender-0.9.10-12.oe2203sp3.x86_6484make-4.3-4.oe2203sp3.x86_6485net-tools-2.10-3.oe2203sp3.x86_6486smartmontools-7.2-2.oe2203sp3.x86_6487sysstat-12.5.4-9.oe2203sp3.x86_6488e2fsprogs-1.46.4-24.oe2203sp3.x86_6489未安装软件包 e2fsprogs-libs 90unzip-6.0-50.oe2203sp3.x86_6491openssh-clients-8.8p1-23.oe2203sp3.x86_6492readline-8.1-3.oe2203sp3.x86_6493readline-devel-8.1-3.oe2203sp3.x86_6494psmisc-23.5-2.oe2203sp3.x86_6495ksh-2020.0.0-10.oe2203sp3.x86_6496nfs-utils-2.5.4-15.oe2203sp3.x86_6497tar-1.34-5.oe2203sp3.x86_6498未安装软件包 device-mapper-multipath 99avahi-0.8-18.oe2203sp3.x86_64100ntp-4.2.8p15-13.oe2203sp3.x86_64101chrony-4.1-6.oe2203sp3.x86_64102libXtst-1.2.4-1.oe2203sp3.x86_64103libXrender-devel-0.9.10-12.oe2203sp3.x86_64104fontconfig-devel-2.13.94-3.oe2203sp3.x86_64105policycoreutils-3.3-8.oe2203sp3.x86_64106未安装软件包 policycoreutils-python 107未安装软件包 librdmacm 108未安装软件包 libnsl* 109未安装软件包 libibverbs 110未安装软件包 compat-openssl10 111policycoreutils-python-utils-3.3-8.oe2203sp3.noarch112113#==============================================================# 114配置主机名 115#==============================================================# 116117openEuler118119#==============================================================# 120配置 /etc/hosts 文件 121#==============================================================# 122123127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4124::1 localhost localhost.localdomain localhost6 localhost6.localdomain6125126## OracleBegin127## Public IP128192.168.6.123 openEuler129130#==============================================================# 131创建用户和组 132#==============================================================# 133134oracle 用户： 135136用户id=54321(oracle) 组id=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)137138139#==============================================================# 140配置 Avahi-daemon 服务 141#==============================================================# 142143○ avahi-daemon.service - Avahi mDNS/DNS-SD Stack144 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)145 Active: inactive (dead)146TriggeredBy: ○ avahi-daemon.socket147148#==============================================================# 149配置透明大页 && NUMA && 磁盘 IO 调度器 150#==============================================================# 151152args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"153-resume=/dev/mapper/openeuler-swap154-args="ro155args="ro resume=/dev/mapper/openeuler-swap rd.lvm.lv=openeuler/root rd.lvm.lv=openeuler/swap cgroup_disable=files apparmor=0 crashkernel=512M rhgb quiet numa=off transparent_hugepage=never elevator=deadline"156-rhgb157-crashkernel=512M158159#==============================================================# 160配置 sysctl.conf 161#==============================================================# 162163kernel.sysrq = 0164net.ipv4.ip_forward = 0165net.ipv4.conf.all.send_redirects = 0166net.ipv4.conf.default.send_redirects = 0167net.ipv4.conf.all.accept_source_route = 0168net.ipv4.conf.default.accept_source_route = 0169net.ipv4.conf.all.accept_redirects = 0170net.ipv4.conf.default.accept_redirects = 0171net.ipv4.conf.all.secure_redirects = 0172net.ipv4.conf.default.secure_redirects = 0173net.ipv4.icmp_echo_ignore_broadcasts = 1174net.ipv4.icmp_ignore_bogus_error_responses = 1175net.ipv4.conf.all.rp_filter = 1176net.ipv4.conf.default.rp_filter = 1177net.ipv4.tcp_syncookies = 1178kernel.dmesg_restrict = 1179net.ipv6.conf.all.accept_redirects = 0180net.ipv6.conf.default.accept_redirects = 0181fs.aio-max-nr = 1048576182fs.file-max = 6815744183kernel.shmall = 2097152184kernel.shmmax = 7795081215185kernel.shmmni = 4096186kernel.sem = 250 32000 100 128187net.ipv4.ip_local_port_range = 9000 65500188net.core.rmem_default = 262144189net.core.rmem_max = 4194304190net.core.wmem_default = 262144191net.core.wmem_max = 1048576192vm.min_free_kbytes = 30449193net.ipv4.conf.ens33.rp_filter = 1194vm.swappiness = 10195kernel.panic_on_oops = 1196kernel.randomize_va_space = 2197kernel.numa_balancing = 0198199#==============================================================# 200配置 RemoveIPC 201#==============================================================# 202203[Login]204RemoveIPC=no205206#==============================================================# 207配置 /etc/security/limits.conf 和 /etc/pam.d/login 208#==============================================================# 209210查看 /etc/security/limits.conf： 211212oracle soft nofile 1024213oracle hard nofile 65536214oracle soft stack 10240215oracle hard stack 32768216oracle soft nproc 2047217oracle hard nproc 16384218oracle hard memlock unlimited219oracle soft memlock unlimited220221查看 /etc/pam.d/login 文件： 222223auth substack system-auth224auth include postlogin225account required pam_nologin.so226account include system-auth227password include system-auth228session required pam_selinux.so close229session required pam_loginuid.so230session required pam_selinux.so open231session required pam_namespace.so232session optional pam_keyinit.so force revoke233session include system-auth234session include postlogin235-session optional pam_ck_connector.so236session required pam_limits.so237session required /lib64/security/pam_limits.so238239#==============================================================# 240配置 /dev/shm 241#==============================================================# 242243/dev/mapper/openeuler-root / ext4 defaults 1 1244UUID=ac85e3a2-8535-4088-ae31-19e4938ffcbc /boot ext4 defaults 1 2245/dev/mapper/openeuler-swap none swap defaults 0 0246tmpfs /dev/shm tmpfs size=7612384k 0 0247248#==============================================================# 249Root 用户环境变量 250#==============================================================# 251252if [ -f ~/.bashrc ]; then253 . ~/.bashrc254fi255PATH=$PATH:$HOME/bin256export PATH257alias so='su - oracle'258export PS1="[`whoami`@`hostname`:"'$PWD]$ '259260#==============================================================# 261Oracle 用户环境变量 262#==============================================================# 263264[ -f ~/.bashrc ] && . ~/.bashrc265umask 022266export TMP=/tmp267export TMPDIR=$TMP268export NLS_LANG=AMERICAN_AMERICA.AL32UTF8269export ORACLE_BASE=/u01/app/oracle270export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db271export ORACLE_TERM=xterm272export TNS_ADMIN=$ORACLE_HOME/network/admin273export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib274export ORACLE_SID=lucifer275export PATH=/usr/sbin:$PATH276export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH277export PERL5LIB=$ORACLE_HOME/perl/lib278alias sas='sqlplus / as sysdba'279alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'280alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'281alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'282export PS1="[`whoami`@`hostname`:"'$PWD]$ '283export CV_ASSUME_DISTID=OL7284285#==============================================================# 286静默解压 Oracle 软件包 287#==============================================================# 288289正在静默解压缩 Oracle 软件包，请稍等： 290291.---- -. -. . . . .292( .',----- - - ' ' ' __293 \_/ ;--:- __--------------------___ ____=========_||___294__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|295c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |296,_\___________'_|,L______],|______________________|_i,!________________!_i297/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)298""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""299300301静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 302303静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 304305静默解压 OJVM 软件补丁包： /soft/p35926646*.zip 306307#==============================================================# 308Oracle 安装静默文件 309#==============================================================# 310311oracle.install.option=INSTALL_DB_SWONLY312UNIX_GROUP_NAME=oinstall313INVENTORY_LOCATION=/u01/app/oraInventory314ORACLE_BASE=/u01/app/oracle315oracle.install.db.InstallEdition=EE316oracle.install.db.DBA_GROUP=dba317oracle.install.db.OPER_GROUP=oper318oracle.install.db.OSBACKUPDBA_GROUP=backupdba319oracle.install.db.OSDGDBA_GROUP=dgdba320oracle.install.db.OSKMDBA_GROUP=kmdba321oracle.install.db.OSRACDBA_GROUP=racdba322oracle.install.db.rootconfig.executeRootScript=false323oracle.install.db.rootconfig.configMethod=324oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0325326#==============================================================# 327静默安装数据库软件 328#==============================================================# 329330Preparing the home to patch...331Applying the patch /soft/35943157...332Successfully applied the patch.333The log can be found at: /tmp/InstallActions2024-03-18_11-06-18AM/installerPatchActions_2024-03-18_11-06-18AM.log334Launching Oracle Database Setup Wizard...335336[WARNING] [INS-13014] Target environment does not meet some optional requirements.337 CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2024-03-18_11-06-18AM.log338 ACTION: Identify the list of failed prerequisite checks from the log: installActions2024-03-18_11-06-18AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.339The response file for this session can be found at:340 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-03-18_11-06-18AM.rsp341342You can find the log of this install session at:343 /tmp/InstallActions2024-03-18_11-06-18AM/installActions2024-03-18_11-06-18AM.log344345As a root user, execute the following script(s):346 1. /u01/app/oraInventory/orainstRoot.sh347 2. /u01/app/oracle/product/19.3.0/db/root.sh348349Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 350[openEuler]351Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 352[openEuler]353354355Successfully Setup Software with warning(s).356Moved the install session logs to:357 /u01/app/oraInventory/logs/InstallActions2024-03-18_11-06-18AM358359#==============================================================# 360执行 root 脚本 361#==============================================================# 362363Changing permissions of /u01/app/oraInventory.364Adding read,write permissions for group.365Removing read,write,execute permissions for world.366367Changing groupname of /u01/app/oraInventory to oinstall.368The execution of the script is complete.369Check /u01/app/oracle/product/19.3.0/db/install/root_openEuler_2024-03-18_11-29-22-449207943.log for the output of root script370371#==============================================================# 372OJVM 补丁安装 373#==============================================================# 374375Oracle Interim Patch Installer version 12.2.0.1.40376Copyright (c) 2024, Oracle Corporation. All rights reserved.377378PREREQ session379380Oracle Home : /u01/app/oracle/product/19.3.0/db381Central Inventory : /u01/app/oraInventory382 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc383OPatch version : 12.2.0.1.40384OUI version : 12.2.0.7.0385Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-18_11-29-25AM_1.log386387Invoking prereq "checkconflictagainstohwithdetail"388389Prereq "checkConflictAgainstOHWithDetail" passed.390391OPatch succeeded.392Oracle Interim Patch Installer version 12.2.0.1.40393Copyright (c) 2024, Oracle Corporation. All rights reserved.394395396Oracle Home : /u01/app/oracle/product/19.3.0/db397Central Inventory : /u01/app/oraInventory398 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc399OPatch version : 12.2.0.1.40400OUI version : 12.2.0.7.0401Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-18_11-29-40AM_1.log402403Verifying environment and performing prerequisite checks...404OPatch continues with these patches: 35926646 405406Do you want to proceed? [y|n]407Y (auto-answered by -silent)408User Responded with: Y409All checks passed.410411Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.412(Oracle Home = '/u01/app/oracle/product/19.3.0/db')413414415Is the local system ready for patching? [y|n]416Y (auto-answered by -silent)417User Responded with: Y418Backing up files...419Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'420421Patching component oracle.javavm.server, 19.0.0.0.0...422423Patching component oracle.javavm.server.core, 19.0.0.0.0...424425Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...426427Patching component oracle.rdbms, 19.0.0.0.0...428429Patching component oracle.javavm.client, 19.0.0.0.0...430Patch 35926646 successfully applied.431Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-18_11-29-40AM_1.log432433OPatch succeeded.434435#==============================================================# 436Oracle 软件版本 437#==============================================================# 438439440SQL*Plus: Release 19.0.0.0.0 - Production441Version 19.22.0.0.0442443444#==============================================================# 445Oracle 补丁信息 446#==============================================================# 44744835926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)44935943157;Database Release Update : 19.22.0.0.240116 (35943157)45029585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)451452OPatch succeeded.453454455#==============================================================# 456配置监听 457#==============================================================# 458459460Parsing command line arguments:461 Parameter "silent" = true462 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp463Done parsing command line arguments.464Oracle Net Services Configuration:465Profile configuration complete.466Oracle Net Listener Startup:467 Running Listener Control: 468 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER469 Listener Control complete.470 Listener started successfully.471Listener configuration complete.472Oracle Net Services configuration successful. The exit code is 0473474检查监听状态： 475476477LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 18-MAR-2024 11:31:51478479Copyright (c) 1991, 2023, Oracle. All rights reserved.480481Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=openEuler)(PORT=1521)))482STATUS of the LISTENER483------------------------484Alias LISTENER485Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production486Start Date 18-MAR-2024 11:31:51487Uptime 0 days 0 hr. 0 min. 0 sec488Trace Level off489Security ON: Local OS Authentication490SNMP OFF491Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora492Listener Log File /u01/app/oracle/diag/tnslsnr/openEuler/listener/alert/log.xml493Listening Endpoints Summary...494 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=openEuler)(PORT=1521)))495 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))496The listener supports no services497The command completed successfully498499#==============================================================# 500静默建库命令 501#==============================================================# 502503dbca -silent -createDatabase \504-ignorePrereqFailure \505-templateName General_Purpose.dbc \506-responseFile NO_VALUE \507-gdbName lucifer \508-sid lucifer \509-sysPassword oracle \510-systemPassword oracle \511-redoLogFileSize 100 \512-datafileDestination /oradata \513-storageType FS \514-enableArchive true \515-archiveLogDest /oradata \516-databaseConfigType SINGLE \517-characterset AL32UTF8 \518-nationalCharacterSet AL16UTF16 \519-emConfiguration NONE \520-automaticMemoryManagement false \521-totalMemory 3716 \522-databaseType OLTP \523-createAsContainerDatabase false 524525#==============================================================# 526创建数据库 527#==============================================================# 528529[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.530 CAUSE: 531a. 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].532b.The password entered is a keyword that Oracle does not recommend to be used as password533 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.534[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.535 CAUSE: 536a. 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].537b.The password entered is a keyword that Oracle does not recommend to be used as password538 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.539Prepare for db operation54010% complete541Copying database files54240% complete543Creating and starting Oracle instance54442% complete54546% complete54650% complete54754% complete54860% complete549Completing Database Creation55066% complete55169% complete55270% complete553Executing Post Configuration Actions554100% complete555Database creation complete. For details check the logfiles at:556 /u01/app/oracle/cfgtoollogs/dbca/lucifer.557Database Information:558Global Database Name:lucifer559System Identifier(SID):lucifer560Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.561562#==============================================================# 563配置在线重做日志 564#==============================================================# 565566数据库在线重做日志文件： 567568 THREAD# GROUP# MEMBER size(M)569---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------570 1 1 /oradata/LUCIFER/redo01.log 100571 1 2 /oradata/LUCIFER/redo02.log 100572 1 3 /oradata/LUCIFER/redo03.log 100573 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_lzhgs4j9_.log 100574 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_lzhgs4o6_.log 100575 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_lzhgs4sp_.log 100576 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_lzhgs4y4_.log 100577 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_lzhgs53o_.log 100578579#==============================================================# 580配置 RMAN 备份任务 581#==============================================================# 582583## OracleBegin58400 02 * * * /home/oracle/scripts/del_arch.sh585#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh586#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh587588#==============================================================# 589配置 glogin.sql 590#==============================================================# 591592define _editor=vi593set serveroutput on size 1000000594set pagesize 9999595set long 99999596set trimspool on597col name format a80598set termout off599define gname=idle600column global_name new_value gname601select 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 );602ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';603set sqlprompt '&gname _DATE> '604set termout on605606#==============================================================# 607优化数据库参数 608#==============================================================# 609610数据库参数： 611612NAME SID SPVALUE VALUE613-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------614_b_tree_bitmap_plans * FALSE FALSE615_datafile_write_errors_crash_instance * FALSE FALSE616audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump617audit_trail * NONE DB618compatible * 19.0.0 19.0.0619control_file_record_keep_time * 31 31620db_block_size * 8192 8192621db_create_file_dest * /oradata /oradata622db_file_multiblock_read_count * 128623db_files * 5000 200624db_name * lucifer lucifer625db_writer_processes * 1626deferred_segment_creation * FALSE FALSE627diagnostic_dest * /u01/app/oracle /u01/app/oracle628dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)629event * 10949 trace name context forever,level 1630event * 28401 trace name context forever,level 1631fast_start_parallel_rollback * LOW632log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog633log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf634max_dump_file_size * unlimited635max_string_size * STANDARD636nls_language * AMERICAN AMERICAN637nls_territory * AMERICA AMERICA638open_cursors * 1000 300639optimizer_adaptive_plans * TRUE640optimizer_adaptive_statistics * FALSE641optimizer_index_caching * 0642optimizer_mode * ALL_ROWS643parallel_force_local * FALSE644parallel_max_servers * 64 64645pga_aggregate_target * 1246756864 780140544646processes * 2000 640647remote_login_passwordfile * EXCLUSIVE EXCLUSIVE648session_cached_cursors * 300 50649sessions * 984650sga_max_size * 4988076032 3120562176651sga_target * 4988076032 3120562176652spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora653statistics_level * TYPICAL654undo_retention * 10800 900655656恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y657658正在重启 ......