在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 龙蜥 Anolis OS 8.8 一键安装 Oracle 19C（19.22）单机版过程（全程无需人工干预）：（脚本包括 <font color='red'ORALCE PSU/OJVM 等补丁自动安装</font） ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://www.oracleshell
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程Oracle 一键安装脚本，演示 龙蜥 Anolis OS 8.8 一键安装 Oracle 19C（19.22）单机版过程（全程无需人工干预）：（脚本包括 ORALCE PSU/OJVM 等补丁自动安装）
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
脚本第三代支持 N 节点一键安装，不限制节点数！
✨ 偷懒可以直接下载本文安装包合集：龙蜥 Anolis OS 8.8 一键安装 Oracle 19C（19.22）单机版安装包合集（包含补丁！！！）
1# 主机版本2[root@anolis8 soft]# cat /etc/anolis-release3Anolis OS release 8.845# 网络信息6[root@anolis8 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:c3:5e:e1 brd ff:ff:ff:ff:ff:ff9 altname enp2s110 inet 192.168.6.137/24 brd 192.168.6.255 scope global noprefixroute ens3311 valid_lft forever preferred_lft forever12 inet6 fe80::20c:29ff:fec3:5ee1/64 scope link noprefixroute 13 valid_lft forever preferred_lft forever1415# 挂载本地 ISO 镜像16[root@anolis8 soft]# mount | grep iso | grep -v "/run/media"17/dev/sr0 on /mnt type iso9660 (ro,relatime,nojoliet,check=s,map=n,blocksize=2048,iocharset=utf8)18[root@anolis8 soft]# df -h|grep /mnt19/dev/sr0 15G 15G 0 100% /mnt2021# 安装包存放在 /soft 目录下22[root@anolis8 soft]# ll23-rwx------ 1 root root 3059705302 Mar 25 11:17 LINUX.X64_193000_db_home.zip24-rwxr-xr-x 1 root root 163320 Mar 25 11:18 OracleShellInstall25-rwx------ 1 root root 127451050 Mar 25 11:16 p35926646_190000_Linux-x86-64.zip26-rwx------ 1 root root 1817908992 Mar 25 11:19 p35943157_190000_Linux-x86-64.zip27-rwx------ 1 root root 127774864 Mar 25 11:16 p6880880_190000_Linux-x86-64.zip28-rwx------ 1 root root 321590 Mar 25 11:15 rlwrap-0.44.tar.gz默认使用专业版脚本。脚本下载：ora100.com/shell-install 确保安装环境准备完成后，即可执行一键安装。
使用标准生产环境安装参数：
1# 根据脚本 README 或者 -h 命令提示，编辑好一键安装命令，进入 /soft 目录执行安装：2./OracleShellInstall -lf ens33 `# local ip ifname`\3-n anolis8 `# hostname`\4-op oracle `# oracle password`\5-d /u01 `# software base dir`\6-ord /oradata `# data dir`\7-o lucifer `# dbname`\8-dp oracle `# sys/system password`\9-ds AL32UTF8 `# database character`\10-ns AL16UTF16 `# national character`\11-redo 100 `# redo size`\12-opa 35943157 `# oracle PSU/RU`\13-jpa 35926646 `# OJVM PSU/RU`\14-opd Y `# optimize db`默认使用专业版脚本。脚本下载：ora100.com/shell-install
选择需要安装的模式以及版本，即可开始安装：
1 ███████ ██ ████████ ██ ██ ██ ██ ██ ██ ██2 ██░░░░░██ ░██ ██░░░░░░ ░██ ░██ ░██░██ ░██ ░██ ░██3 ██ ░░██ ██████ ██████ █████ ░██ █████ ░██ ░██ █████ ░██ ░██░██ ███████ ██████ ██████ ██████ ░██ ░██4░██ ░██░░██░░█ ░░░░░░██ ██░░░██ ░██ ██░░░██░█████████░██████ ██░░░██ ░██ ░██░██░░██░░░██ ██░░░░ ░░░██░ ░░░░░░██ ░██ ░██5░██ ░██ ░██ ░ ███████ ░██ ░░ ░██░███████░░░░░░░░██░██░░░██░███████ ░██ ░██░██ ░██ ░██░░█████ ░██ ███████ ░██ ░██6░░██ ██ ░██ ██░░░░██ ░██ ██ ░██░██░░░░ ░██░██ ░██░██░░░░ ░██ ░██░██ ░██ ░██ ░░░░░██ ░██ ██░░░░██ ░██ ░██7 ░░███████ ░███ ░░████████░░█████ ███░░██████ ████████ ░██ ░██░░██████ ███ ███░██ ███ ░██ ██████ ░░██ ░░████████ ███ ███8 ░░░░░░░ ░░░ ░░░░░░░░ ░░░░░ ░░░ ░░░░░░ ░░░░░░░░ ░░ ░░ ░░░░░░ ░░░ ░░░ ░░ ░░░ ░░ ░░░░░░ ░░ ░░░░░░░░ ░░░ ░░░ 91011请选择安装模式 [单机(si)/单机ASM(sa)/集群(rac)] : si1213数据库安装模式: single 1415请选择数据库版本 [11/12/19/21] : 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; vendor preset: enabled)40 Active: inactive (dead) since Mon 2024-03-25 11:48:53 CST; 60ms ago41 Docs: man:firewalld(1)42 Process: 1061 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)43 Main PID: 1061 (code=exited, status=0/SUCCESS)4445Mar 25 11:12:31 anolis8 systemd[1]: Starting firewalld - dynamic firewall daemon...46Mar 25 11:12:33 anolis8 systemd[1]: Started firewalld - dynamic firewall daemon.47Mar 25 11:12:33 anolis8 firewalld[1061]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.48Mar 25 11:48:52 anolis8 systemd[1]: Stopping firewalld - dynamic firewall daemon...49Mar 25 11:48:53 anolis8 systemd[1]: firewalld.service: Succeeded.50Mar 25 11:48:53 anolis8 systemd[1]: Stopped firewalld - dynamic firewall daemon.5152#==============================================================# 53禁用 SELinux 54#==============================================================# 5556SELinux status: disabled5758#==============================================================# 59YUM 静默安装依赖包 60#==============================================================# 6162bc-1.07.1-5.0.1.an8.x86_6463binutils-2.30-117.0.1.an8.x86_6464package compat-libcap1 is not installed65gcc-8.5.0-10.1.0.3.an8.x86_6466gcc-c++-8.5.0-10.1.0.3.an8.x86_6467elfutils-libelf-0.187-4.0.1.an8.x86_6468elfutils-libelf-devel-0.187-4.0.1.an8.x86_6469glibc-2.28-189.5.0.2.an8_6.x86_6470glibc-devel-2.28-189.5.0.2.an8_6.x86_6471libaio-0.3.112-1.0.1.an8.x86_6472libaio-devel-0.3.112-1.0.1.an8.x86_6473libgcc-8.5.0-10.1.0.3.an8.x86_6474libstdc++-8.5.0-10.1.0.3.an8.x86_6475libstdc++-devel-8.5.0-10.1.0.3.an8.x86_6476libxcb-1.13.1-1.el8.x86_6477libX11-1.7.0-7.an8.x86_6478libXau-1.0.9-8.an8.x86_6479libXi-1.7.10-1.an8.x86_6480libXrender-0.9.10-7.el8.x86_6481make-4.2.1-11.0.1.an8.x86_6482net-tools-2.0-0.52.20160912git.an8.x86_6483smartmontools-7.1-1.0.2.an8.x86_6484sysstat-11.7.3-7.0.1.an8.x86_6485e2fsprogs-1.46.0-1.0.1.an8.x86_6486e2fsprogs-libs-1.46.0-1.0.1.an8.x86_6487unzip-6.0-46.0.1.an8.x86_6488openssh-clients-8.0p1-13.0.1.an8.x86_6489readline-7.0-10.0.1.an8.x86_6490readline-devel-7.0-10.0.1.an8.x86_6491psmisc-23.1-5.0.1.an8.x86_6492ksh-20120801-257.0.1.an8.x86_6493nfs-utils-2.3.3-51.0.3.an8.x86_6494tar-1.30-6.0.1.an8.x86_6495device-mapper-multipath-0.8.4-28.0.1.an8_6.2.x86_6496avahi-0.7-20.an8.x86_6497package ntp is not installed98chrony-4.2-1.0.1.an8.x86_6499libXtst-1.2.3-7.el8.x86_64100libXrender-devel-0.9.10-7.el8.x86_64101fontconfig-devel-2.13.1-4.an8.x86_64102policycoreutils-2.9-20.an8.x86_64103package policycoreutils-python is not installed104librdmacm-37.2-1.0.3.an8.x86_64105package libnsl* is not installed106libibverbs-37.2-1.0.3.an8.x86_64107compat-openssl10-1.0.2o-4.0.1.an8_6.x86_64108policycoreutils-python-utils-2.9-20.an8.noarch109package elfutils* is not installed110glibc-2.28-189.5.0.2.an8_6.x86_64111112#==============================================================# 113配置主机名 114#==============================================================# 115116anolis8117118#==============================================================# 119配置 /etc/hosts 文件 120#==============================================================# 121122127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4123::1 localhost localhost.localdomain localhost6 localhost6.localdomain6124125## OracleBegin126## Public IP127192.168.6.137 anolis8128129#==============================================================# 130创建用户和组 131#==============================================================# 132133oracle 用户： 134135uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)136137138#==============================================================# 139配置 Avahi-daemon 服务 140#==============================================================# 141142● avahi-daemon.service - Avahi mDNS/DNS-SD Stack143 Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)144 Active: inactive (dead)145146Mar 25 11:12:36 anolis8 avahi-daemon[910]: New relevant interface virbr0.IPv4 for mDNS.147Mar 25 11:12:36 anolis8 avahi-daemon[910]: Registering new address record for 192.168.122.1 on virbr0.IPv4.148Mar 25 11:49:59 anolis8 systemd[1]: Stopping Avahi mDNS/DNS-SD Stack...149Mar 25 11:49:59 anolis8 avahi-daemon[910]: Got SIGTERM, quitting.150Mar 25 11:49:59 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface virbr0.IPv4 with address 192.168.122.1.151Mar 25 11:49:59 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface ens33.IPv6 with address fe80::20c:29ff:fec3:5ee1.152Mar 25 11:49:59 anolis8 avahi-daemon[910]: Leaving mDNS multicast group on interface ens33.IPv4 with address 192.168.6.137.153Mar 25 11:49:59 anolis8 avahi-daemon[910]: avahi-daemon 0.7 exiting.154Mar 25 11:49:59 anolis8 systemd[1]: avahi-daemon.service: Succeeded.155Mar 25 11:49:59 anolis8 systemd[1]: Stopped Avahi mDNS/DNS-SD Stack.156157#==============================================================# 158配置透明大页 && NUMA && 磁盘 IO 调度器 159#==============================================================# 160161args="ro resume=/dev/mapper/ao-swap rd.lvm.lv=ao/root rd.lvm.lv=ao/swap rhgb quiet $tuned_params cgroup.memory=nokmem crashkernel=0M-2G:0M,2G-8G:192M,8G-:256M numa=off transparent_hugepage=never elevator=deadline"162-resume=/dev/mapper/ao-swap163-args="ro164args="ro resume=/dev/mapper/ao-swap rd.lvm.lv=ao/root rd.lvm.lv=ao/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"165-elevator=deadline"166-transparent_hugepage=never167168#==============================================================# 169配置 sysctl.conf 170#==============================================================# 171172fs.aio-max-nr = 1048576173fs.file-max = 6815744174kernel.shmall = 2097152175kernel.shmmax = 8126386175176kernel.shmmni = 4096177kernel.sem = 250 32000 100 128178net.ipv4.ip_local_port_range = 9000 65500179net.core.rmem_default = 262144180net.core.rmem_max = 4194304181net.core.wmem_default = 262144182net.core.wmem_max = 1048576183vm.min_free_kbytes = 31743184net.ipv4.conf.ens33.rp_filter = 1185vm.swappiness = 10186kernel.panic_on_oops = 1187kernel.randomize_va_space = 2188kernel.numa_balancing = 0189190#==============================================================# 191配置 nsysctl.conf 192#==============================================================# 193194NOZEROCONF=yes195196#==============================================================# 197配置 RemoveIPC 198#==============================================================# 199200[Login]201RemoveIPC=no202203#==============================================================# 204配置 /etc/security/limits.conf 和 /etc/pam.d/login 205#==============================================================# 206207查看 /etc/security/limits.conf： 208209oracle soft nofile 1024210oracle hard nofile 65536211oracle soft stack 10240212oracle hard stack 32768213oracle soft nproc 2047214oracle hard nproc 16384215oracle hard memlock unlimited216oracle soft memlock unlimited217218查看 /etc/pam.d/login 文件： 219220auth substack system-auth221auth include postlogin222account required pam_nologin.so223account include system-auth224password include system-auth225session required pam_selinux.so close226session required pam_loginuid.so227session optional pam_console.so228session required pam_selinux.so open229session required pam_namespace.so230session optional pam_keyinit.so force revoke231session include system-auth232session include postlogin233-session optional pam_ck_connector.so234session required pam_limits.so235session required /lib64/security/pam_limits.so236237#==============================================================# 238配置 /dev/shm 239#==============================================================# 240241/dev/mapper/ao-root / xfs defaults 0 0242UUID=5b4f444b-7f7f-4cf1-9e1b-474e447b8075 /boot xfs defaults 0 0243/dev/mapper/ao-swap none swap defaults 0 0244tmpfs /dev/shm tmpfs size=7935924k 0 0245246#==============================================================# 247安装 rlwrap 插件 248#==============================================================# 249250成功安装 rlwrap： rlwrap 0.44 251252#==============================================================# 253Root 用户环境变量 254#==============================================================# 255256if [ -f ~/.bashrc ]; then257 . ~/.bashrc258fi259PATH=$PATH:$HOME/bin260export PATH261alias so='su - oracle'262export PS1="[`whoami`@`hostname`:"'$PWD]$ '263264#==============================================================# 265Oracle 用户环境变量 266#==============================================================# 267268if [ -f ~/.bashrc ]; then269 . ~/.bashrc270fi271umask 022272export TMP=/tmp273export TMPDIR=$TMP274export NLS_LANG=AMERICAN_AMERICA.AL32UTF8275export ORACLE_BASE=/u01/app/oracle276export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db277export ORACLE_TERM=xterm278export TNS_ADMIN=$ORACLE_HOME/network/admin279export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib280export ORACLE_SID=lucifer281export PATH=/usr/sbin:$PATH282export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH283export PERL5LIB=$ORACLE_HOME/perl/lib284alias sas='sqlplus / as sysdba'285alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'286alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'287alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'288export PS1="[`whoami`@`hostname`:"'$PWD]$ '289export CV_ASSUME_DISTID=OL7290alias sqlplus='rlwrap sqlplus'291alias rman='rlwrap rman'292alias adrci='rlwrap adrci'293294#==============================================================# 295静默解压 Oracle 软件包 296#==============================================================# 297298正在静默解压缩 Oracle 软件包，请稍等： 299300.---- -. -. . . . .301( .',----- - - ' ' ' __302 \_/ ;--:- __--------------------___ ____=========_||___303__U__n_^_''__[. ooo___ | |_!_||_!_||_!_||_!_| | |..|_i_|..|_i_|..|304c(_ ..(_ ..(_ ..( /,,,,,,] | |___||___||___||___| | | |305,_\___________'_|,L______],|______________________|_i,!________________!_i306/;_(@)(@)==(@)(@) (o)(o) (o)^(o)--(o)^(o) (o)(o)-(o)(o)307""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"""~"'""308309310静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip 311312静默解压 OPatch 软件补丁包： /soft/p6880880_*.zip 313314静默解压 Oracle 软件补丁包： /soft/p35943157*.zip 315316静默解压 OJVM 软件补丁包： /soft/p35926646*.zip 317318#==============================================================# 319Oracle 安装静默文件 320#==============================================================# 321322oracle.install.option=INSTALL_DB_SWONLY323UNIX_GROUP_NAME=oinstall324INVENTORY_LOCATION=/u01/app/oraInventory325ORACLE_BASE=/u01/app/oracle326oracle.install.db.InstallEdition=EE327oracle.install.db.DBA_GROUP=dba328oracle.install.db.OPER_GROUP=oper329oracle.install.db.OSBACKUPDBA_GROUP=backupdba330oracle.install.db.OSDGDBA_GROUP=dgdba331oracle.install.db.OSKMDBA_GROUP=kmdba332oracle.install.db.OSRACDBA_GROUP=racdba333oracle.install.db.rootconfig.executeRootScript=false334oracle.install.db.rootconfig.configMethod=335oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0336337#==============================================================# 338静默安装数据库软件 339#==============================================================# 340341Preparing the home to patch...342Applying the patch /soft/35943157...343Successfully applied the patch.344The log can be found at: /tmp/InstallActions2024-03-25_11-53-50AM/installerPatchActions_2024-03-25_11-53-50AM.log345Launching Oracle Database Setup Wizard...346347[WARNING] [INS-13014] Target environment does not meet some optional requirements.348 CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2024-03-25_11-53-50AM.log349 ACTION: Identify the list of failed prerequisite checks from the log: installActions2024-03-25_11-53-50AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.350The response file for this session can be found at:351 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-03-25_11-53-50AM.rsp352353You can find the log of this install session at:354 /tmp/InstallActions2024-03-25_11-53-50AM/installActions2024-03-25_11-53-50AM.log355356As a root user, execute the following script(s):357 1. /u01/app/oraInventory/orainstRoot.sh358 2. /u01/app/oracle/product/19.3.0/db/root.sh359360Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 361[anolis8]362Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 363[anolis8]364365366Successfully Setup Software with warning(s).367Moved the install session logs to:368 /u01/app/oraInventory/logs/InstallActions2024-03-25_11-53-50AM369370#==============================================================# 371执行 root 脚本 372#==============================================================# 373374Changing permissions of /u01/app/oraInventory.375Adding read,write permissions for group.376Removing read,write,execute permissions for world.377378Changing groupname of /u01/app/oraInventory to oinstall.379The execution of the script is complete.380Check /u01/app/oracle/product/19.3.0/db/install/root_anolis8_2024-03-25_12-21-29-545308061.log for the output of root script381382#==============================================================# 383OJVM 补丁安装 384#==============================================================# 385386Oracle Interim Patch Installer version 12.2.0.1.40387Copyright (c) 2024, Oracle Corporation. All rights reserved.388389PREREQ session390391Oracle Home : /u01/app/oracle/product/19.3.0/db392Central Inventory : /u01/app/oraInventory393 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc394OPatch version : 12.2.0.1.40395OUI version : 12.2.0.7.0396Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-25_12-21-33PM_1.log397398Invoking prereq "checkconflictagainstohwithdetail"399400Prereq "checkConflictAgainstOHWithDetail" passed.401402OPatch succeeded.403Oracle Interim Patch Installer version 12.2.0.1.40404Copyright (c) 2024, Oracle Corporation. All rights reserved.405406407Oracle Home : /u01/app/oracle/product/19.3.0/db408Central Inventory : /u01/app/oraInventory409 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc410OPatch version : 12.2.0.1.40411OUI version : 12.2.0.7.0412Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-25_12-21-48PM_1.log413414Verifying environment and performing prerequisite checks...415OPatch continues with these patches: 35926646 416417Do you want to proceed? [y|n]418Y (auto-answered by -silent)419User Responded with: Y420All checks passed.421422Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.423(Oracle Home = '/u01/app/oracle/product/19.3.0/db')424425426Is the local system ready for patching? [y|n]427Y (auto-answered by -silent)428User Responded with: Y429Backing up files...430Applying interim patch '35926646' to OH '/u01/app/oracle/product/19.3.0/db'431432Patching component oracle.javavm.server, 19.0.0.0.0...433434Patching component oracle.javavm.server.core, 19.0.0.0.0...435436Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...437438Patching component oracle.rdbms, 19.0.0.0.0...439440Patching component oracle.javavm.client, 19.0.0.0.0...441Patch 35926646 successfully applied.442Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2024-03-25_12-21-48PM_1.log443444OPatch succeeded.445446#==============================================================# 447Oracle 软件版本 448#==============================================================# 449450451SQL*Plus: Release 19.0.0.0.0 - Production452Version 19.22.0.0.0453454455#==============================================================# 456Oracle 补丁信息 457#==============================================================# 45845935926646;OJVM RELEASE UPDATE: 19.22.0.0.240116 (35926646)46035943157;Database Release Update : 19.22.0.0.240116 (35943157)46129585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)462463OPatch succeeded.464465466#==============================================================# 467配置监听 468#==============================================================# 469470471Parsing command line arguments:472 Parameter "silent" = true473 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp474Done parsing command line arguments.475Oracle Net Services Configuration:476Profile configuration complete.477Oracle Net Listener Startup:478 Running Listener Control: 479 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER480 Listener Control complete.481 Listener started successfully.482Listener configuration complete.483Oracle Net Services configuration successful. The exit code is 0484485检查监听状态： 486487488LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 25-MAR-2024 12:24:18489490Copyright (c) 1991, 2023, Oracle. All rights reserved.491492Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=anolis8)(PORT=1521)))493STATUS of the LISTENER494------------------------495Alias LISTENER496Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production497Start Date 25-MAR-2024 12:24:07498Uptime 0 days 0 hr. 0 min. 10 sec499Trace Level off500Security ON: Local OS Authentication501SNMP OFF502Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora503Listener Log File /u01/app/oracle/diag/tnslsnr/anolis8/listener/alert/log.xml504Listening Endpoints Summary...505 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anolis8)(PORT=1521)))506 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))507The listener supports no services508The command completed successfully509510#==============================================================# 511静默建库命令 512#==============================================================# 513514dbca -silent -createDatabase \515-ignorePrereqFailure \516-templateName General_Purpose.dbc \517-responseFile NO_VALUE \518-gdbName lucifer \519-sid lucifer \520-sysPassword oracle \521-systemPassword oracle \522-redoLogFileSize 100 \523-datafileDestination /oradata \524-storageType FS \525-enableArchive true \526-archiveLogDest /oradata \527-databaseConfigType SINGLE \528-characterset AL32UTF8 \529-nationalCharacterSet AL16UTF16 \530-emConfiguration NONE \531-automaticMemoryManagement false \532-totalMemory 3874 \533-databaseType OLTP \534-createAsContainerDatabase false 535536#==============================================================# 537创建数据库 538#==============================================================# 539540[WARNING] [DBT-06208] The 'SYS' 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.545[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.546 CAUSE: 547a. 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].548b.The password entered is a keyword that Oracle does not recommend to be used as password549 ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.550Prepare for db operation55110% complete552Copying database files55340% complete554Creating and starting Oracle instance55542% complete55646% complete55750% complete55854% complete55960% complete560Completing Database Creation56166% complete56269% complete56370% complete564Executing Post Configuration Actions565100% complete566Database creation complete. For details check the logfiles at:567 /u01/app/oracle/cfgtoollogs/dbca/lucifer.568Database Information:569Global Database Name:lucifer570System Identifier(SID):lucifer571Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.572573#==============================================================# 574配置在线重做日志 575#==============================================================# 576577数据库在线重做日志文件： 578579580 THREAD# GROUP# MEMBER size(M)581---------- ---------- ------------------------------------------------------------------------------------------------------------------------ ----------582 1 1 /oradata/LUCIFER/redo01.log 100583 1 2 /oradata/LUCIFER/redo02.log 100584 1 3 /oradata/LUCIFER/redo03.log 100585 1 11 /oradata/LUCIFER/onlinelog/o1_mf_11_m020k9m2_.log 100586 1 12 /oradata/LUCIFER/onlinelog/o1_mf_12_m020k9q8_.log 100587 1 13 /oradata/LUCIFER/onlinelog/o1_mf_13_m020k9tv_.log 100588 1 14 /oradata/LUCIFER/onlinelog/o1_mf_14_m020k9yn_.log 100589 1 15 /oradata/LUCIFER/onlinelog/o1_mf_15_m020kb6l_.log 100590591#==============================================================# 592配置 RMAN 备份任务 593#==============================================================# 594595## OracleBegin59600 02 * * * /home/oracle/scripts/del_arch.sh597#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0.sh598#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1.sh599600#==============================================================# 601配置 glogin.sql 602#==============================================================# 603604define _editor=vi605set serveroutput on size 1000000606set pagesize 9999607set long 99999608set trimspool on609col name format a80610set termout off611define gname=idle612column global_name new_value gname613select 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 );614ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';615set sqlprompt '&gname _DATE> '616set termout on617618#==============================================================# 619优化数据库参数 620#==============================================================# 621622数据库参数： 623624625NAME SID SPVALUE VALUE626-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------627_b_tree_bitmap_plans * FALSE FALSE628_datafile_write_errors_crash_instance * FALSE FALSE629audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump630audit_trail * NONE DB631compatible * 19.0.0 19.0.0632control_file_record_keep_time * 31 31633db_block_size * 8192 8192634db_create_file_dest * /oradata /oradata635db_file_multiblock_read_count * 128636db_files * 5000 200637db_name * lucifer lucifer638db_writer_processes * 1639deferred_segment_creation * FALSE FALSE640diagnostic_dest * /u01/app/oracle /u01/app/oracle641dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)642event * 10949 trace name context forever,level 1643event * 28401 trace name context forever,level 1644fast_start_parallel_rollback * LOW645log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog646log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf647max_dump_file_size * unlimited648max_string_size * STANDARD649nls_language * AMERICAN AMERICAN650nls_territory * AMERICA AMERICA651open_cursors * 1000 300652optimizer_adaptive_plans * TRUE653optimizer_adaptive_statistics * FALSE654optimizer_index_caching * 0655optimizer_mode * ALL_ROWS656parallel_force_local * FALSE657parallel_max_servers * 64 64658pga_aggregate_target * 1299185664 812646400659processes * 2000 640660remote_login_passwordfile * EXCLUSIVE EXCLUSIVE661session_cached_cursors * 300 50662sessions * 984663sga_max_size * 5199888384 3254779904664sga_target * 5199888384 3254779904665spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora666statistics_level * TYPICAL667undo_retention * 10800 900668669恭喜！Oracle 单机安装成功，现在是否重启主机：[Y/N] Y