Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Repeated, unnecessary Oracle information in job logs

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    Services which initiate an SQL*Plus connection are creating added SQL parameter information (see Additional information) in the job log. Since many custom jobs initiate multiple baseline Aleph services, their log files are becoming extremely lengthy and difficult to read.

    Cause:
    $aleph_proc/show_proc_env

    Resolution:
    To disable the display of all the information about the environment in the service log, in $aleph_proc/start_p_proc -- put a hash sign (#) at the beginning of the line

    source $aleph_proc/show_proc_env

    The show_proc_env script only displays system environment parameters, and the start_p_proc routine works fine without it.

    Additional Information

    The following is the added, repeated, extraneous Oracle information:

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 6 10:05:21 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

    Enter user-name:
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    aleph_admin@DALPH21> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ***********************************
    DATABASE NLS PARAMETERS
    ***********************************
    PARAMETER VALUE
    ========================================
    NLS_TERRITORY AMERICA
    NLS_LANGUAGE AMERICAN
    NLS_COMP BINARY
    NLS_SORT BINARY
    NLS_NCHAR_CHARACTERSET UTF8
    NLS_CHARACTERSET UTF8
    ***********************************
    env |grep NLS
    ***********************************
    NLS_COMP=BINARY
    NLS_LANG=American_America.UTF8
    NLS_SORT=BINARY
    ***********************************
    env |grep ORA
    ***********************************
    ARC_ORACLE_SID=aleph5
    ORACLE_ALERT_LOG=/exlibris/app/oracle/diag/rdbms/DALPH21/DALPH21/trace/alert_DALPH21.log
    ORACLE_BASE=/exlibris/app/oracle
    ORACLE_CONF=/exlibris/aleph/ora_aleph
    ORACLE_HOME=/exlibris/app/oracle/product/11r2
    ORACLE_OWNER=oracle11
    ORACLE_SID=DALPH21
    ORACLE_VERSION=11
    ORA_HOST=ruckus
    ORA_INST_CLIENT=/exlibris/product/instantclient_11_2
    ORA_LIB=lib
    TEMPORARY_TS=TEMP

    • Article last edited: 11/20/2013