Tuesday, January 29, 2008

file var/log/nessages Flooded with "su(pam_unix)session opened/closed for user oracle

Metalink Doc ID : 415665.1

The problem is reported in Bug 5722352

Solution

Obtain patch for unpublished Bug 5679560 from MetaLink and apply it

Or:

1. take a backup copy of /etc/init.d/init.cssd

2. edit /etc/init.d/init.cssd

Replace code section:

$SU $ORACLE_USER -c "$ECHO \$TZ > /tmp/oratz.$$ " > /dev/null 2>&1
NEWTZ=`$SED 's/^[ \t]*//;s/[ \t]*$//' < /tmp/oratz.$$`
$RMF /tmp/oratz.$$
if [ ! -z "$NEWTZ" ]; then
TZ=$NEWTZ;
export TZ;
fi


with:

TZCHANGE=/tmp/TZCHANGE
if [ -f $TZCHANGE ]then
$SU $ORACLE_USER -c "$ECHO \$TZ > /tmp/oratz.$$ " > /dev/null 2>&1
NEWTZ=`$SED 's/^[ \t]*//;s/[ \t]*$//' < /tmp/oratz.$$`
$RMF /tmp/oratz.$$
if [ ! -z "$NEWTZ" ]; then
TZ=$NEWTZ;
export TZ;
fi
$RMF $TZCHANGE
fi