在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 Fedora 40 一键安装 Oracle 19C 单机（全程无需人工干预）。 ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://ora100.com/shell-install Fedora 40 一键安装 Oracle 19C 单机详细日志记录： bash root@fedora40-0
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 Fedora 40 一键安装 Oracle 19C 单机（全程无需人工干预）。
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
Fedora 40 一键安装 Oracle 19C 单机详细日志记录：
1[root@fedora40-01 ~]# tail -2000f /soft/print_shell_install_20240626225128.log23#==============================================================#4打印系统信息5#==============================================================#67服务器时间:892024年 06月 26日 星期三 22:51:38 CST1011操作系统版本:1213NAME="Fedora Linux"14VERSION="40 (Server Edition)"15ID=fedora16VERSION_ID=4017VERSION_CODENAME=""18PLATFORM_ID="platform:f40"19PRETTY_NAME="Fedora Linux 40 (Server Edition)"20ANSI_COLOR="0;38;2;60;110;180"21LOGO=fedora-logo-icon22CPE_NAME="cpe:/o:fedoraproject:fedora:40"23HOME_URL="https://fedoraproject.org/"24DOCUMENTATION_URL="https://docs.fedoraproject.org/en-US/fedora/f40/system-administrators-guide/"25SUPPORT_URL="https://ask.fedoraproject.org/"26BUG_REPORT_URL="https://bugzilla.redhat.com/"27REDHAT_BUGZILLA_PRODUCT="Fedora"28REDHAT_BUGZILLA_PRODUCT_VERSION=4029REDHAT_SUPPORT_PRODUCT="Fedora"30REDHAT_SUPPORT_PRODUCT_VERSION=4031SUPPORT_END=2025-05-1332VARIANT="Server Edition"33VARIANT_ID=server3435内核信息:3637Linux version 6.8.5-301.fc40.x86_64 (mockbuild@0bc0cc78c12e4762acf61c209bd02e96) (gcc (GCC) 14.0.1 20240328 (Red Hat 14.0.1-0), GNU ld version 2.41-34.fc40) #1 SMP PREEMPT_DYNAMIC Thu Apr 11 20:00:10 UTC 20243839Glibc 版本:40412.394243CPU 信息:4445型号名称 ：Intel(R) Xeon(R) CPU E5-2630 v2 @ 2.60GHz46物理 CPU 个数 ：447每个物理 CPU 的逻辑核数 ：248系统的 CPU 线程数 ：849系统的 CPU 类型 ：x86_645051内存信息:5253 total used free shared buff/cache available54Mem: 15987 694 11816 1 3758 1529255Swap: 24575 0 245755657挂载信息:5859UUID=c6341104-d694-4d61-b282-ff0bdbae5d07 / xfs defaults 0 060UUID=be347418-a6a0-4e13-b6d8-012909a2e580 /boot xfs defaults 0 061UUID=212128b3-799e-413c-b7ca-f36e0693d9ba none swap defaults 0 06263目录信息:6465文件系统 大小 已用 可用 已用% 挂载点66/dev/mapper/fedora-root 83G 6.5G 77G 8% /67devtmpfs 4.0M 0 4.0M 0% /dev68tmpfs 7.9G 0 7.9G 0% /dev/shm69tmpfs 3.2G 1.3M 3.2G 1% /run70tmpfs 7.9G 0 7.9G 0% /tmp71/dev/sda2 960M 285M 676M 30% /boot72tmpfs 1.6G 4.0K 1.6G 1% /run/user/07374#==============================================================#75配置网络软件源76#==============================================================#7778[fedora]79name=Fedora $releasever - $basearch80baseurl=http://mirrors.tuna.tsinghua.edu.cn/fedora/releases/$releasever/Everything/$basearch/os/81#metalink=https://mirrors.fedoraproject.org/metalink?repo=fedora-$releasever&arch=$basearch82enabled=183countme=184metadata_expire=7d85repo_gpgcheck=086type=rpm87gpgcheck=188gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-$releasever-$basearch89skip_if_unavailable=False9091[fedora-debuginfo]92name=Fedora $releasever - $basearch - Debug93baseurl=http://mirrors.tuna.tsinghua.edu.cn/fedora/releases/$releasever/Everything/$basearch/debug/tree/94#metalink=https://mirrors.fedoraproject.org/metalink?repo=fedora-debug-$releasever&arch=$basearch95enabled=096metadata_expire=7d97repo_gpgcheck=098type=rpm99gpgcheck=1100gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-$releasever-$basearch101skip_if_unavailable=False102103[fedora-source]104name=Fedora $releasever - Source105baseurl=http://mirrors.tuna.tsinghua.edu.cn/fedora/releases/$releasever/Everything/source/tree/106#metalink=https://mirrors.fedoraproject.org/metalink?repo=fedora-source-$releasever&arch=$basearch107enabled=0108metadata_expire=7d109repo_gpgcheck=0110type=rpm111gpgcheck=1112gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-$releasever-$basearch113skip_if_unavailable=False114115#==============================================================#116安装依赖软件包117#==============================================================#118119psmisc \120tar \121glibc \122libaio \123libgcc \124libstdc++ \125bc \126make \127binutils \128glibc-devel \129ksh \130libstdc++-devel \131unzip \132gcc \133gcc-c++ \134libnsl \135libaio-devel \136e2fsprogs \137e2fsprogs-libs \138smartmontools \139net-tools \140nfs-utils \141elfutils-libelf \142elfutils-libelf-devel \143libibverbs \144librdmacm \145fontconfig \146fontconfig-devel \147libXrender \148libXrender-devel \149libX11 \150libXau \151libXi \152libXtst \153libxcb \154unixODBC \155sysstat \156readline \157readline-devel \158policycoreutils \159libvirt-libs \160policycoreutils-python-utils \161libnsl2 \162libasan \163liblsan \164compat-openssl10 \165libxcrypt-compat \166compat-openssl11 \167libgfortran \168rlwrap169170171#==============================================================#172静默安装软件包173#==============================================================#174175检查必需软件包安装情况：176177psmisc-23.6-6.fc40.x86_64178tar-1.35-3.fc40.x86_64179glibc-2.39-15.fc40.x86_64180libaio-0.3.111-19.fc40.x86_64181libgcc-14.1.1-6.fc40.x86_64182libstdc++-14.1.1-6.fc40.x86_64183bc-1.07.1-21.fc40.x86_64184make-4.4.1-6.fc40.x86_64185binutils-2.41-34.fc40.x86_64186glibc-devel-2.39-15.fc40.x86_64187ksh-1.0.8-4.fc40.x86_64188libstdc++-devel-14.1.1-6.fc40.x86_64189unzip-6.0-63.fc40.x86_64190gcc-14.1.1-6.fc40.x86_64191gcc-c++-14.1.1-6.fc40.x86_64192libnsl-2.39-15.fc40.x86_64193194#==============================================================#195禁用防火墙196#==============================================================#197198○ firewalld.service - firewalld - dynamic firewall daemon199 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; preset: enabled)200 Drop-In: /usr/lib/systemd/system/service.d201 └─10-timeout-abort.conf202 Active: inactive (dead)203 Docs: man:firewalld(1)2042056月 26 22:33:10 fedora40-01 systemd[1]: Starting firewalld.service - firewalld - dynamic firewall daemon...2066月 26 22:33:12 fedora40-01 systemd[1]: Started firewalld.service - firewalld - dynamic firewall daemon.2076月 26 22:53:07 fedora40-01 systemd[1]: Stopping firewalld.service - firewalld - dynamic firewall daemon...2086月 26 22:53:07 fedora40-01 systemd[1]: firewalld.service: Deactivated successfully.2096月 26 22:53:07 fedora40-01 systemd[1]: Stopped firewalld.service - firewalld - dynamic firewall daemon.2106月 26 22:53:07 fedora40-01 systemd[1]: firewalld.service: Consumed 2.471s CPU time, 42.6M memory peak, 0B memory swap peak.211212#==============================================================#213禁用 SELinux214#==============================================================#215216SELinux status: enabled217SELinuxfs mount: /sys/fs/selinux218SELinux root directory: /etc/selinux219Loaded policy name: targeted220Current mode: permissive221Mode from config file: disabled222Policy MLS status: enabled223Policy deny_unknown status: allowed224Memory protection checking: actual (secure)225Max kernel policy version: 33226227#==============================================================#228配置 nsysctl.conf229#==============================================================#230231NOZEROCONF=yes232233#==============================================================#234配置主机名235#==============================================================#236237fedora40-01238239#==============================================================#240配置 /etc/hosts 文件241#==============================================================#242243127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4244::1 localhost localhost.localdomain localhost6 localhost6.localdomain6245192.168.6.130 fedora40-01246247#==============================================================#248创建用户和组249#==============================================================#250251oracle 用户：252253uid=54321(oracle) gid=54321(oinstall) 组=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)254255256#==============================================================#257配置透明大页 && NUMA && 磁盘 IO 调度器258#==============================================================#259260args="ro resume=UUID=212128b3-799e-413c-b7ca-f36e0693d9ba rd.lvm.lv=fedora/root rd.lvm.lv=fedora/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"261-resume=UUID=212128b3-799e-413c-b7ca-f36e0693d9ba262-args="ro263args="ro resume=UUID=212128b3-799e-413c-b7ca-f36e0693d9ba rd.lvm.lv=fedora/root rd.lvm.lv=fedora/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"264-elevator=deadline"265-transparent_hugepage=never266267#==============================================================#268配置 sysctl.conf269#==============================================================#270271查看 sysctl.conf 配置情况 ：sysctl -p272273fs.aio-max-nr = 1048576274fs.file-max = 6815744275kernel.shmall = 4092814276kernel.shmmax = 16764170230277kernel.shmmni = 4096278kernel.sem = 250 32000 100 128279net.ipv4.ip_local_port_range = 9000 65500280net.core.rmem_default = 262144281net.core.rmem_max = 4194304282net.core.wmem_default = 262144283net.core.wmem_max = 1048576284vm.min_free_kbytes = 65485285net.ipv4.conf.ens33.rp_filter = 1286vm.swappiness = 10287kernel.panic_on_oops = 1288kernel.randomize_va_space = 2289kernel.numa_balancing = 0290291#==============================================================#292配置 /etc/security/limits.conf 和 /etc/pam.d/login293#==============================================================#294295查看 /etc/security/limits.conf：296297oracle soft nofile 1024298oracle hard nofile 65536299oracle soft stack 10240300oracle hard stack 32768301oracle soft nproc 2047302oracle hard nproc 16384303oracle hard memlock unlimited304oracle soft memlock unlimited305306查看 /etc/pam.d/login 文件：307308auth substack system-auth309auth include postlogin310account required pam_nologin.so311account include system-auth312password include system-auth313session required pam_selinux.so close314session required pam_loginuid.so315session required pam_selinux.so open316session required pam_namespace.so317session optional pam_keyinit.so force revoke318session include system-auth319session include postlogin320-session optional pam_ck_connector.so321session required pam_limits.so322323#==============================================================#324配置 /dev/shm325#==============================================================#326327查看 Linux 挂载情况：/etc/fstab328329UUID=c6341104-d694-4d61-b282-ff0bdbae5d07 / xfs defaults 0 0330UUID=be347418-a6a0-4e13-b6d8-012909a2e580 /boot xfs defaults 0 0331UUID=212128b3-799e-413c-b7ca-f36e0693d9ba none swap defaults 0 0332tmpfs /dev/shm tmpfs size=16371260k 0 0333334#==============================================================#335Root 用户环境变量336#==============================================================#337338查看 root 用户环境变量：/root/.bash_profile339340if [ -f ~/.bashrc ]; then341 . ~/.bashrc342fi343alias so='su - oracle'344export PS1=[`whoami`@`hostname`:'$PWD]# '345346#==============================================================#347Oracle 用户环境变量，实例名：lucifer348#==============================================================#349350查看 Oracle 用户环境变量：/home/oracle/.bash_profile351352if [ -f ~/.bashrc ]; then353 . ~/.bashrc354fi355umask 022356export TMP=/tmp357export TMPDIR=$TMP358export NLS_LANG=AMERICAN_AMERICA.AL32UTF8359export ORACLE_BASE=/u01/app/oracle360export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db361export ORACLE_TERM=xterm362export TNS_ADMIN=$ORACLE_HOME/network/admin363export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib364export ORACLE_SID=lucifer365export PATH=/usr/sbin:$PATH366export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH367export PERL5LIB=$ORACLE_HOME/perl/lib368alias sas='sqlplus / as sysdba'369alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'370alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'371alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'372export PS1="[`whoami`@`hostname`:"'$PWD]$ '373export CV_ASSUME_DISTID=OL7374alias sqlplus='rlwrap sqlplus'375alias rman='rlwrap rman'376alias adrci='rlwrap adrci'377378#==============================================================#379静默解压 Oracle 软件包380#==============================================================#381382正在静默解压缩 Oracle 软件包，请稍等：383384385静默解压 Oracle 软件安装包： /soft/LINUX.X64_193000_db_home.zip386387#==============================================================#388Oracle 安装静默文件389#==============================================================#390391oracle.install.option=INSTALL_DB_SWONLY392UNIX_GROUP_NAME=oinstall393INVENTORY_LOCATION=/u01/app/oraInventory394ORACLE_BASE=/u01/app/oracle395oracle.install.db.InstallEdition=EE396oracle.install.db.OSDBA_GROUP=dba397oracle.install.db.OSOPER_GROUP=oper398oracle.install.db.OSBACKUPDBA_GROUP=backupdba399oracle.install.db.OSDGDBA_GROUP=dgdba400oracle.install.db.OSKMDBA_GROUP=kmdba401oracle.install.db.OSRACDBA_GROUP=racdba402oracle.install.db.rootconfig.executeRootScript=false403oracle.install.db.rootconfig.configMethod=404oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0405406#==============================================================#407静默安装 Oracle 软件命令408#==============================================================#409410/u01/app/oracle/product/19.3.0/db/runInstaller \411-silent \412-ignorePrereqFailure \413-responseFile /soft/oracle.rsp \414-waitForCompletion415416417#==============================================================#418静默安装数据库软件419#==============================================================#420421检查 Oracle 软件 OPacth 版本：422423OPatch Version: 12.2.0.1.17424425OPatch succeeded.426427正在安装 Oracle 软件：428429正在启动 Oracle 数据库安装向导...430431[WARNING] [INS-13014] 目标环境不满足一些可选要求。432 原因: 不满足一些可选的先决条件。有关详细信息, 请查看日志。installActions2024-06-26_10-54-27PM.log433 操作: 从日志 installActions2024-06-26_10-54-27PM.log 中确定失败的先决条件检查列表。然后, 从日志文件或安装手册中查找满足这些先决条件的适当配置, 并手动进行修复。434可以在以下位置找到此会话的响应文件:435 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-06-26_10-54-27PM.rsp436437可以在以下位置找到本次安装会话的日志:438 /tmp/InstallActions2024-06-26_10-54-27PM/installActions2024-06-26_10-54-27PM.log439440以 root 用户的身份执行以下脚本:441 1. /u01/app/oraInventory/orainstRoot.sh442 2. /u01/app/oracle/product/19.3.0/db/root.sh443444在以下节点上执行/u01/app/oraInventory/orainstRoot.sh:445[fedora40-01]446在以下节点上执行/u01/app/oracle/product/19.3.0/db/root.sh:447[fedora40-01]448449450Successfully Setup Software with warning(s).451已将安装会话日志移动到:452 /u01/app/oraInventory/logs/InstallActions2024-06-26_10-54-27PM453454#==============================================================#455执行 root 脚本456#==============================================================#457458执行命令：/u01/app/oraInventory/orainstRoot.sh459460更改权限/u01/app/oraInventory.461添加组的读取和写入权限。462删除全局的读取, 写入和执行权限。463464更改组名/u01/app/oraInventory 到 oinstall.465脚本的执行已完成。466467执行命令：/u01/app/oracle/product/19.3.0/db/root.sh468469Check /u01/app/oracle/product/19.3.0/db/install/root_fedora40-01_2024-06-26_22-56-26-087407557.log for the output of root script470471#==============================================================#472Oracle 软件版本473#==============================================================#474475476SQL*Plus: Release 19.0.0.0.0 - Production477Version 19.3.0.0.0478479480#==============================================================#481Oracle 补丁信息482#==============================================================#48348429585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)48529517242;Database Release Update : 19.3.0.0.190416 (29517242)486487OPatch succeeded.488489#==============================================================#490静默安装 Oracle 软件命令491#==============================================================#492493/u01/app/oracle/product/19.3.0/db/bin/netca -silent \494-responsefile /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp 495496497#==============================================================#498创建监听499#==============================================================#500501正在创建监听：502503504正在对命令行参数进行语法分析:505 参数"silent" = true506 参数"responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp507完成对命令行参数进行语法分析。508Oracle Net Services 配置:509完成概要文件配置。510Oracle Net 监听程序启动:511 正在运行监听程序控制:512 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER513 监听程序控制完成。514 监听程序已成功启动。515监听程序配置完成。516成功完成 Oracle Net Services 配置。退出代码是0517518519#==============================================================#520检查监听状态521#==============================================================#522523524LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-JUN-2024 22:56:32525526Copyright (c) 1991, 2019, Oracle. All rights reserved.527528Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fedora40-01)(PORT=1521)))529STATUS of the LISTENER530------------------------531Alias LISTENER532Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production533Start Date 26-JUN-2024 22:56:32534Uptime 0 days 0 hr. 0 min. 0 sec535Trace Level off536Security ON: Local OS Authentication537SNMP OFF538Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora539Listener Log File /u01/app/oracle/diag/tnslsnr/fedora40-01/listener/alert/log.xml540Listening Endpoints Summary...541 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fedora40-01)(PORT=1521)))542 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))543The listener supports no services544The command completed successfully545546#==============================================================#547DBCA 静默建库文件：lucifer548#==============================================================#549550gdbName=lucifer551sid=lucifer552templateName=General_Purpose.dbc553sysPassword=Passw0rd#PST554systemPassword=Passw0rd#PST555characterSet=AL32UTF8556nationalCharacterSet=AL16UTF16557automaticMemoryManagement=false558totalMemory=12790559initParams=db_block_size=8192BYTES560createAsContainerDatabase=false561databaseConfigType=SI562storageType=FS563datafileDestination=/oradata564recoveryAreaDestination=/oradata565responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0566567#==============================================================#568静默创建数据库命令569#==============================================================#570571/u01/app/oracle/product/19.3.0/db/bin/dbca -silent -createDatabase \572-responseFile /soft/db.rsp \573-ignorePreReqs \574-ignorePrereqFailure \575-J-Doracle.assistants.dbca.validate.ConfigurationParams=false576577578#==============================================================#579创建数据库实例：lucifer580#==============================================================#581582正在创建数据库：lucifer583584准备执行数据库操作585已完成 10%586复制数据库文件587已完成 40%588正在创建并启动 Oracle 实例589已完成 42%590已完成 46%591已完成 50%592已完成 54%593已完成 60%594正在进行数据库创建595已完成 66%596已完成 69%597已完成 70%598执行配置后操作599已完成 100%600数据库创建完成。有关详细信息, 请查看以下位置的日志文件:601 /u01/app/oracle/cfgtoollogs/dbca/lucifer。602数据库信息:603全局数据库名:lucifer604系统标识符 (SID):lucifer605有关详细信息, 请参阅日志文件 "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log"。606607#==============================================================#608配置 OMF && 优化 RMAN609#==============================================================#610611612NAME TYPE VALUE613------------------------------------ ----------- ------------------------------614db_create_file_dest string /oradata615616#==============================================================#617配置 Oracle 数据库控制文件复用618#==============================================================#619620621数据库控制文件：622623624NAME625----------------------------------------------------------------------------------------------------626/oradata/LUCIFER/control01.ctl627/oradata/LUCIFER/control02.ctl628629#==============================================================#630配置在线重做日志631#==============================================================#632633634 THREAD# GROUP# MEMBER size(M)635---------- ---------- -------------------------------------------------------------------------------- ----------636 1 1 /oradata/LUCIFER/redo01.log 10637 1 2 /oradata/LUCIFER/redo02.log 10638 1 3 /oradata/LUCIFER/redo03.log 10639 1 4 /oradata/LUCIFER/redo04.log 10640 1 5 /oradata/LUCIFER/redo05.log 10641 1 6 /oradata/LUCIFER/redo06.log 10642 1 7 /oradata/LUCIFER/redo07.log 10643 1 8 /oradata/LUCIFER/redo08.log 10644645#==============================================================#646配置 Oracle 数据库开机自启647#==============================================================#648649数据库开机自启配置：650651su oracle -lc "/u01/app/oracle/product/19.3.0/db/bin/lsnrctl start"652su oracle -lc "/u01/app/oracle/product/19.3.0/db/bin/dbstart"653654#==============================================================#655配置 RMAN 备份任务656#==============================================================#657658# OracleBegin65900 02 * * * /home/oracle/scripts/del_arch_lucifer.sh660#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0_lucifer.sh661#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1_lucifer.sh662663#==============================================================#664优化数据库参数665#==============================================================#666667数据库参数：668669670NAME SID SPVALUE VALUE671-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------672_b_tree_bitmap_plans * FALSE FALSE673_datafile_write_errors_crash_instance * FALSE FALSE674audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump675audit_trail * NONE DB676compatible * 19.0.0 19.0.0677control_file_record_keep_time * 31 31678db_block_size * 8192 8192679db_create_file_dest * /oradata /oradata680db_file_multiblock_read_count * 128681db_files * 5000 200682db_name * lucifer lucifer683db_recovery_file_dest * /oradata /oradata684db_recovery_file_dest_size * 6863978496 6863978496685db_writer_processes * 1686deferred_segment_creation * FALSE FALSE687diagnostic_dest * /u01/app/oracle /u01/app/oracle688dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)689event * 10949 trace name context forever,level 1690event * 28401 trace name context forever,level 1691fast_start_parallel_rollback * LOW692log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog693log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf694max_dump_file_size * unlimited695max_string_size * STANDARD696nls_language * SIMPLIFIED CHINESE AMERICAN697nls_territory * CHINA AMERICA698open_cursors * 1000 300699optimizer_adaptive_plans * TRUE700optimizer_adaptive_statistics * FALSE701optimizer_index_caching * 0702optimizer_mode * ALL_ROWS703parallel_force_local * FALSE704parallel_max_servers * 64 64705pga_aggregate_target * 2682257408 3353346048706processes * 2000 640707remote_login_passwordfile * EXCLUSIVE EXCLUSIVE708session_cached_cursors * 300 50709sessions * 984710sga_max_size * 10729029632 10066329600711sga_target * 10729029632 10066329600712spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora713statistics_level * TYPICAL714undo_retention * 10800 900715716#==============================================================#717配置 glogin.sql718#==============================================================#719720define _editor=vi721set serveroutput on size 1000000722set pagesize 9999723set long 99999724set trimspool on725col name format a80726set termout off727define gname=idle728column global_name new_value gname729select 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 );730ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';731set sqlprompt '&gname _DATE> '732set termout on