在知识库中专注阅读，并随时返回相关工具与课程
Oracle 一键安装脚本，演示 Oracle Linux 8.10 ARM 一键安装 Oracle 19C 单机（全程无需人工干预）。 ⭐️ <font color='red'脚本下载地址</font：Shell脚本安装Oracle数据库https://ora100.com/shell-install Oracle Linux 8.10 ARM 一键安装 Oracle 19C 单机详细日志
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
Oracle 一键安装脚本，演示 Oracle Linux 8.10 ARM 一键安装 Oracle 19C 单机（全程无需人工干预）。
⭐️ 脚本下载地址：Shell脚本安装Oracle数据库
Oracle Linux 8.10 ARM 一键安装 Oracle 19C 单机详细日志记录：
1[root@oel810-arm64 ~]# tail -2000f /soft/print_shell_install_20240627130857.log23#==============================================================# 4打印系统信息 5#==============================================================# 67服务器时间: 89Thu Jun 27 13:09:04 CST 20241011操作系统版本: 1213NAME="Oracle Linux Server"14VERSION="8.10"15ID="ol"16ID_LIKE="fedora"17VARIANT="Server"18VARIANT_ID="server"19VERSION_ID="8.10"20PLATFORM_ID="platform:el8"21PRETTY_NAME="Oracle Linux Server 8.10"22ANSI_COLOR="0;31"23CPE_NAME="cpe:/o:oracle:linux:8:10:server"24HOME_URL="https://linux.oracle.com/"25BUG_REPORT_URL="https://github.com/oracle/oracle-linux"2627ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"28ORACLE_BUGZILLA_PRODUCT_VERSION=8.1029ORACLE_SUPPORT_PRODUCT="Oracle Linux"30ORACLE_SUPPORT_PRODUCT_VERSION=8.103132内核信息: 3334Linux version 5.15.0-206.153.7.1.el8uek.aarch64 (mockbuild@host-100-100-224-51) (gcc (GCC) 11.4.1 20230605 (Red Hat 11.4.1-2.1.0.1), GNU ld version 2.36.1-4.0.2.el8_6) #2 SMP Wed May 22 23:22:35 PDT 20243536Glibc 版本: 37382.283940CPU 信息: 4142型号名称 ： 43物理 CPU 个数 ：0 44每个物理 CPU 的逻辑核数 ：0 45系统的 CPU 线程数 ：4 46系统的 CPU 类型 ：aarch64 4748内存信息: 4950 total used free shared buff/cache available51Mem: 7918 235 5179 11 2503 751352Swap: 8191 0 81915354挂载信息: 5556/dev/mapper/ol-root / xfs defaults 0 057UUID=33b0abab-16cf-4341-aa9b-01197bc9f343 /boot xfs defaults 0 058UUID=E906-4461 /boot/efi vfat umask=0077,shortname=winnt 0 259/dev/mapper/ol-swap none swap defaults 0 06061目录信息: 6263Filesystem Size Used Avail Use% Mounted on64devtmpfs 3.9G 0 3.9G 0% /dev65tmpfs 3.9G 0 3.9G 0% /dev/shm66tmpfs 3.9G 8.9M 3.9G 1% /run67tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup68/dev/mapper/ol-root 55G 4.8G 50G 9% /69/dev/sda2 924M 278M 647M 31% /boot70/dev/sda1 599M 7.2M 592M 2% /boot/efi71tmpfs 792M 0 792M 0% /run/user/072/dev/sr0 11G 11G 0 100% /mnt7374#==============================================================# 75配置本地软件源 76#==============================================================# 7778[BaseOS]79name=BaseOS80baseurl=file:///mnt/BaseOS81enabled=182gpgcheck=083[AppStream]84name=AppStream85baseurl=file:///mnt/AppStream86enabled=187gpgcheck=08889#==============================================================# 90安装依赖软件包 91#==============================================================# 9293psmisc \94tar \95glibc \96libaio \97libgcc \98libstdc++ \99bc \100make \101binutils \102glibc-devel \103ksh \104libstdc++-devel \105unzip \106gcc \107gcc-c++ \108libnsl \109psmisc \110gcc \111gcc-c++ \112libaio-devel \113e2fsprogs \114e2fsprogs-libs \115smartmontools \116net-tools \117nfs-utils \118elfutils-libelf \119elfutils-libelf-devel \120libibverbs \121librdmacm \122fontconfig \123fontconfig-devel \124libXrender \125libXrender-devel \126libX11 \127libXau \128libXi \129libXtst \130libxcb \131unixODBC \132sysstat \133readline \134readline-devel \135policycoreutils \136libvirt-libs \137policycoreutils-python-utils \138libnsl2 \139libasan \140liblsan \141compat-openssl10 \142libxcrypt-compat \143compat-openssl11 \144libgfortran \145rlwrap 146147148#==============================================================# 149静默安装软件包 150#==============================================================# 151152检查必需软件包安装情况： 153154psmisc-23.1-5.el8.aarch64155tar-1.30-9.el8.aarch64156glibc-2.28-251.0.2.el8.aarch64157libaio-0.3.112-1.el8.aarch64158libgcc-8.5.0-21.0.1.el8.aarch64159libstdc++-8.5.0-21.0.1.el8.aarch64160bc-1.07.1-5.el8.aarch64161make-4.2.1-11.el8.aarch64162binutils-2.30-123.0.2.el8.aarch64163glibc-devel-2.28-251.0.2.el8.aarch64164ksh-20120801-267.0.1.el8.aarch64165libstdc++-devel-8.5.0-21.0.1.el8.aarch64166unzip-6.0-46.0.1.el8.aarch64167gcc-8.5.0-21.0.1.el8.aarch64168gcc-c++-8.5.0-21.0.1.el8.aarch64169libnsl-2.28-251.0.2.el8.aarch64170psmisc-23.1-5.el8.aarch64171gcc-8.5.0-21.0.1.el8.aarch64172gcc-c++-8.5.0-21.0.1.el8.aarch64173174#==============================================================# 175禁用防火墙 176#==============================================================# 177178● firewalld.service - firewalld - dynamic firewall daemon179 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)180 Active: inactive (dead)181 Docs: man:firewalld(1)182183Jun 27 12:49:38 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...184Jun 27 12:49:39 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.185Jun 27 12:49:39 localhost.localdomain firewalld[849]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now.186Jun 27 13:09:46 oel810-arm64 systemd[1]: Stopping firewalld - dynamic firewall daemon...187Jun 27 13:09:46 oel810-arm64 systemd[1]: firewalld.service: Succeeded.188Jun 27 13:09:46 oel810-arm64 systemd[1]: Stopped firewalld - dynamic firewall daemon.189190#==============================================================# 191禁用 SELinux 192#==============================================================# 193194SELinux status: enabled195SELinuxfs mount: /sys/fs/selinux196SELinux root directory: /etc/selinux197Loaded policy name: targeted198Current mode: permissive199Mode from config file: disabled200Policy MLS status: enabled201Policy deny_unknown status: allowed202Memory protection checking: actual (secure)203Max kernel policy version: 33204205#==============================================================# 206配置 nsysctl.conf 207#==============================================================# 208209NOZEROCONF=yes210211#==============================================================# 212配置主机名 213#==============================================================# 214215oel810-arm64216217#==============================================================# 218配置 /etc/hosts 文件 219#==============================================================# 220221127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4222::1 localhost localhost.localdomain localhost6 localhost6.localdomain622310.211.55.130 oel810-arm64224225#==============================================================# 226创建用户和组 227#==============================================================# 228229oracle 用户： 230231uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)232233234#==============================================================# 235配置透明大页 && NUMA && 磁盘 IO 调度器 236#==============================================================# 237238args="ro rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline $tuned_params"239-rd.lvm.lv=ol/root240-args="ro241args="ro rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet numa=off transparent_hugepage=never elevator=deadline"242-243-elevator=deadline"244245#==============================================================# 246配置 sysctl.conf 247#==============================================================# 248249查看 sysctl.conf 配置情况 ：sysctl -p 250251fs.aio-max-nr = 1048576252fs.file-max = 6815744253kernel.shmall = 2097152254kernel.shmmax = 8303366134255kernel.shmmni = 4096256kernel.sem = 250 32000 100 128257net.ipv4.ip_local_port_range = 9000 65500258net.core.rmem_default = 262144259net.core.rmem_max = 4194304260net.core.wmem_default = 262144261net.core.wmem_max = 1048576262vm.min_free_kbytes = 32435263net.ipv4.conf.enp0s5.rp_filter = 1264vm.swappiness = 10265kernel.panic_on_oops = 1266kernel.randomize_va_space = 2267kernel.numa_balancing = 0268269#==============================================================# 270配置 RemoveIPC 271#==============================================================# 272273查看 RemoveIPC ：/etc/systemd/logind.conf 274275RemoveIPC=no276RemoveIPC=no277278#==============================================================# 279配置 /etc/security/limits.conf 和 /etc/pam.d/login 280#==============================================================# 281282查看 /etc/security/limits.conf： 283284oracle soft nofile 1024285oracle hard nofile 65536286oracle soft stack 10240287oracle hard stack 32768288oracle soft nproc 2047289oracle hard nproc 16384290oracle hard memlock unlimited291oracle soft memlock unlimited292293查看 /etc/pam.d/login 文件： 294295auth substack system-auth296auth include postlogin297account required pam_nologin.so298account include system-auth299password include system-auth300session required pam_selinux.so close301session required pam_loginuid.so302session optional pam_console.so303session required pam_selinux.so open304session required pam_namespace.so305session optional pam_keyinit.so force revoke306session include system-auth307session include postlogin308-session optional pam_ck_connector.so309session required pam_limits.so310311#==============================================================# 312配置 /dev/shm 313#==============================================================# 314315查看 Linux 挂载情况：/etc/fstab 316317/dev/mapper/ol-root / xfs defaults 0 0318UUID=33b0abab-16cf-4341-aa9b-01197bc9f343 /boot xfs defaults 0 0319UUID=E906-4461 /boot/efi vfat umask=0077,shortname=winnt 0 2320/dev/mapper/ol-swap none swap defaults 0 0321tmpfs /dev/shm tmpfs size=8108756k 0 0322323#==============================================================# 324Root 用户环境变量 325#==============================================================# 326327查看 root 用户环境变量：/root/.bash_profile 328329if [ -f ~/.bashrc ]; then330 . ~/.bashrc331fi332PATH=$PATH:$HOME/bin333export PATH334alias so='su - oracle'335export PS1=[`whoami`@`hostname`:'$PWD]# '336337#==============================================================# 338Oracle 用户环境变量，实例名：lucifer 339#==============================================================# 340341查看 Oracle 用户环境变量：/home/oracle/.bash_profile 342343if [ -f ~/.bashrc ]; then344 . ~/.bashrc345fi346umask 022347export TMP=/tmp348export TMPDIR=$TMP349export NLS_LANG=AMERICAN_AMERICA.AL32UTF8350export ORACLE_BASE=/u01/app/oracle351export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db352export ORACLE_TERM=xterm353export TNS_ADMIN=$ORACLE_HOME/network/admin354export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib355export ORACLE_SID=lucifer356export PATH=/usr/sbin:$PATH357export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH358export PERL5LIB=$ORACLE_HOME/perl/lib359alias sas='sqlplus / as sysdba'360alias awr='sqlplus / as sysdba @?/rdbms/admin/awrrpt'361alias ash='sqlplus / as sysdba @?/rdbms/admin/ashrpt'362alias alert='vi $ORACLE_BASE/diag/rdbms/*/$ORACLE_SID/trace/alert_$ORACLE_SID.log'363export PS1="[`whoami`@`hostname`:"'$PWD]$ '364export CV_ASSUME_DISTID=OL7365366#==============================================================# 367静默解压 Oracle 软件包 368#==============================================================# 369370正在静默解压缩 Oracle 软件包，请稍等： 371372373静默解压 Oracle 软件安装包： /soft/LINUX.ARM64_1919000_db_home.zip 374375#==============================================================# 376Oracle 安装静默文件 377#==============================================================# 378379oracle.install.option=INSTALL_DB_SWONLY380UNIX_GROUP_NAME=oinstall381INVENTORY_LOCATION=/u01/app/oraInventory382ORACLE_BASE=/u01/app/oracle383oracle.install.db.InstallEdition=EE384oracle.install.db.OSDBA_GROUP=dba385oracle.install.db.OSOPER_GROUP=oper386oracle.install.db.OSBACKUPDBA_GROUP=backupdba387oracle.install.db.OSDGDBA_GROUP=dgdba388oracle.install.db.OSKMDBA_GROUP=kmdba389oracle.install.db.OSRACDBA_GROUP=racdba390oracle.install.db.rootconfig.executeRootScript=false391oracle.install.db.rootconfig.configMethod=392oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0393394#==============================================================# 395静默安装 Oracle 软件命令 396#==============================================================# 397398/u01/app/oracle/product/19.3.0/db/runInstaller \399-silent \400-ignorePrereqFailure \401-responseFile /soft/oracle.rsp \402-waitForCompletion 403404405#==============================================================# 406静默安装数据库软件 407#==============================================================# 408409检查 Oracle 软件 OPacth 版本： 410411OPatch Version: 12.2.0.1.37412413OPatch succeeded.414415正在安装 Oracle 软件： 416417Launching Oracle Database Setup Wizard...418419The response file for this session can be found at:420 /u01/app/oracle/product/19.3.0/db/install/response/db_2024-06-27_01-10-35PM.rsp421422You can find the log of this install session at:423 /tmp/InstallActions2024-06-27_01-10-35PM/installActions2024-06-27_01-10-35PM.log424425As a root user, execute the following script(s):426 1. /u01/app/oraInventory/orainstRoot.sh427 2. /u01/app/oracle/product/19.3.0/db/root.sh428429Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 430[oel810-arm64]431Execute /u01/app/oracle/product/19.3.0/db/root.sh on the following nodes: 432[oel810-arm64]433434435Successfully Setup Software.436Moved the install session logs to:437 /u01/app/oraInventory/logs/InstallActions2024-06-27_01-10-35PM438439#==============================================================# 440执行 root 脚本 441#==============================================================# 442443执行命令：/u01/app/oraInventory/orainstRoot.sh 444445Changing permissions of /u01/app/oraInventory.446Adding read,write permissions for group.447Removing read,write,execute permissions for world.448449Changing groupname of /u01/app/oraInventory to oinstall.450The execution of the script is complete.451452执行命令：/u01/app/oracle/product/19.3.0/db/root.sh 453454Check /u01/app/oracle/product/19.3.0/db/install/root_oel810-arm64_2024-06-27_13-11-05-819882490.log for the output of root script455456#==============================================================# 457Oracle 软件版本 458#==============================================================# 459460461SQL*Plus: Release 19.0.0.0.0 - Production462Version 19.19.0.0.0463464465#==============================================================# 466Oracle 补丁信息 467#==============================================================# 468469There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/19.3.0/db".470471OPatch succeeded.472473#==============================================================# 474静默安装 Oracle 软件命令 475#==============================================================# 476477/u01/app/oracle/product/19.3.0/db/bin/netca -silent \478-responsefile /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp 479480481#==============================================================# 482创建监听 483#==============================================================# 484485正在创建监听： 486487488Parsing command line arguments:489 Parameter "silent" = true490 Parameter "responsefile" = /u01/app/oracle/product/19.3.0/db/assistants/netca/netca.rsp491Done parsing command line arguments.492Oracle Net Services Configuration:493Profile configuration complete.494Oracle Net Listener Startup:495 Running Listener Control: 496 /u01/app/oracle/product/19.3.0/db/bin/lsnrctl start LISTENER497 Listener Control complete.498 Listener started successfully.499Listener configuration complete.500Oracle Net Services configuration successful. The exit code is 0501502503#==============================================================# 504检查监听状态 505#==============================================================# 506507508LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-JUN-2024 13:11:07509510Copyright (c) 1991, 2023, Oracle. All rights reserved.511512Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel810-arm64)(PORT=1521)))513STATUS of the LISTENER514------------------------515Alias LISTENER516Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production517Start Date 27-JUN-2024 13:11:07518Uptime 0 days 0 hr. 0 min. 0 sec519Trace Level off520Security ON: Local OS Authentication521SNMP OFF522Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora523Listener Log File /u01/app/oracle/diag/tnslsnr/oel810-arm64/listener/alert/log.xml524Listening Endpoints Summary...525 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel810-arm64)(PORT=1521)))526 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))527The listener supports no services528The command completed successfully529530#==============================================================# 531DBCA 静默建库文件：lucifer 532#==============================================================# 533534gdbName=lucifer535sid=lucifer536templateName=General_Purpose.dbc537sysPassword=Passw0rd#PST538systemPassword=Passw0rd#PST539characterSet=AL32UTF8540nationalCharacterSet=AL16UTF16541automaticMemoryManagement=false542totalMemory=6334543initParams=db_block_size=8192BYTES544createAsContainerDatabase=false545databaseConfigType=SI546storageType=FS547datafileDestination=/oradata548recoveryAreaDestination=/oradata549responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0550551#==============================================================# 552静默创建数据库命令 553#==============================================================# 554555/u01/app/oracle/product/19.3.0/db/bin/dbca -silent -createDatabase \556-responseFile /soft/db.rsp \557-ignorePreReqs \558-ignorePrereqFailure \559-J-Doracle.assistants.dbca.validate.ConfigurationParams=false 560561562#==============================================================# 563创建数据库实例：lucifer 564#==============================================================# 565566正在创建数据库：lucifer 567568Prepare for db operation56910% complete570Copying database files57140% complete572Creating and starting Oracle instance57342% complete57446% complete57550% complete57654% complete57760% complete578Completing Database Creation57966% complete58069% complete58170% complete582Executing Post Configuration Actions583100% complete584Database creation complete. For details check the logfiles at:585 /u01/app/oracle/cfgtoollogs/dbca/lucifer.586Database Information:587Global Database Name:lucifer588System Identifier(SID):lucifer589Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/lucifer/lucifer.log" for further details.590591#==============================================================# 592配置 OMF && 优化 RMAN 593#==============================================================# 594595596NAME TYPE VALUE597------------------------------------ ----------- ------------------------------598db_create_file_dest string /oradata599600#==============================================================# 601配置 Oracle 数据库控制文件复用 602#==============================================================# 603604605数据库控制文件： 606607608NAME609----------------------------------------------------------------------------------------------------610/oradata/LUCIFER/control01.ctl611/oradata/LUCIFER/control02.ctl612613#==============================================================# 614配置在线重做日志 615#==============================================================# 616617618 THREAD# GROUP# MEMBER size(M)619---------- ---------- -------------------------------------------------------------------------------- ----------620 1 1 /oradata/LUCIFER/redo01.log 10621 1 2 /oradata/LUCIFER/redo02.log 10622 1 3 /oradata/LUCIFER/redo03.log 10623 1 4 /oradata/LUCIFER/redo04.log 10624 1 5 /oradata/LUCIFER/redo05.log 10625 1 6 /oradata/LUCIFER/redo06.log 10626 1 7 /oradata/LUCIFER/redo07.log 10627 1 8 /oradata/LUCIFER/redo08.log 10628629#==============================================================# 630配置 Oracle 数据库开机自启 631#==============================================================# 632633数据库开机自启配置： 634635touch /var/lock/subsys/local636su oracle -lc "/u01/app/oracle/product/19.3.0/db/bin/lsnrctl start"637su oracle -lc "/u01/app/oracle/product/19.3.0/db/bin/dbstart"638639#==============================================================# 640配置 RMAN 备份任务 641#==============================================================# 642643# OracleBegin64400 02 * * * /home/oracle/scripts/del_arch_lucifer.sh645#00 00 * * 0 /home/oracle/scripts/dbbackup_lv0_lucifer.sh646#00 00 * * 1,2,3,4,5,6 /home/oracle/scripts/dbbackup_lv1_lucifer.sh647648#==============================================================# 649优化数据库参数 650#==============================================================# 651652数据库参数： 653654655NAME SID SPVALUE VALUE656-------------------------------------------------- ---------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------657_b_tree_bitmap_plans * FALSE FALSE658_datafile_write_errors_crash_instance * FALSE FALSE659audit_file_dest * /u01/app/oracle/admin/lucifer/adump /u01/app/oracle/admin/lucifer/adump660audit_trail * NONE DB661compatible * 19.0.0 19.0.0662control_file_record_keep_time * 31 31663db_block_size * 8192 8192664db_create_file_dest * /oradata /oradata665db_file_multiblock_read_count * 128666db_files * 5000 200667db_name * lucifer lucifer668db_recovery_file_dest * /oradata /oradata669db_recovery_file_dest_size * 6769606656 6769606656670db_writer_processes * 1671deferred_segment_creation * FALSE FALSE672diagnostic_dest * /u01/app/oracle /u01/app/oracle673dispatchers * (PROTOCOL=TCP) (SERVICE=luciferXDB) (PROTOCOL=TCP) (SERVICE=luciferXDB)674event * 10949 trace name context forever,level 1675event * 28401 trace name context forever,level 1676fast_start_parallel_rollback * LOW677log_archive_dest_1 * location=/oradata/archivelog location=/oradata/archivelog678log_archive_format * %t_%s_%r.dbf %t_%s_%r.dbf679max_dump_file_size * unlimited680max_string_size * STANDARD681nls_language * AMERICAN AMERICAN682nls_territory * AMERICA AMERICA683open_cursors * 1000 300684optimizer_adaptive_plans * TRUE685optimizer_adaptive_statistics * FALSE686optimizer_index_caching * 0687optimizer_mode * ALL_ROWS688parallel_force_local * FALSE689parallel_max_servers * 64 64690pga_aggregate_target * 1327497216 1660944384691processes * 2000 320692remote_login_passwordfile * EXCLUSIVE EXCLUSIVE693session_cached_cursors * 300 50694sessions * 504695sga_max_size * 5313134592 4982833152696sga_target * 5313134592 4982833152697spfile * /u01/app/oracle/product/19.3.0/db/dbs/spfilelucifer.ora698statistics_level * TYPICAL699undo_retention * 10800 900700701#==============================================================# 702配置 glogin.sql 703#==============================================================# 704705define _editor=vi706set serveroutput on size 1000000707set pagesize 9999708set long 99999709set trimspool on710col name format a80711set termout off712define gname=idle713column global_name new_value gname714select 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 );715ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH24:MI:SS';716set sqlprompt '&gname _DATE> '717set termout on