Repeated, unnecessary Oracle information in job logs
- 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