Monday, May 2, 2011

What are these shrept.lst files, and are they can be safely removed?

Symptoms:

[oracle@vmxdb01 db_1]$ find $ORACLE_HOME -name '*shrept.lst'
/u01/app/oracle/product/11.2.0.2/db_1/xdk/admin/shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/network/admin/shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/rdbms/admin/shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/rdbms/admin/orasdkbase_shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/rdbms/admin/orasdk_shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/plsql/admin/shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/precomp/admin/shrept.lst
/u01/app/oracle/product/11.2.0.2/db_1/ldap/admin/shrept.lst

Explaination:
From $ORACLE_HOME/bin/genclntsh
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


# mluong 05/30/97 - Read entry points from $PRODUCT/admin/shrept.lst

# List the required symbols from a product's shrept.lst file
listf () {
product=$1
entryList=$ORACLE_HOME/$product/admin/shrept.lst
grep -v '#' $entryList | \
grep $product | \
awk '{ printf (" -u %s", $3); }'
}
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

From $ORACLE_HOME/bin/genorasdksh
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


# listf2: List the required symbols from the given shrept.lst file
###
listf2 () {
entryList=$1
product=$2
grep -v '#' $entryList | grep "$product *:" | \
awk '{ printf (" -u %s", $3); }'
}

# listf: List the required symbols from a product's shrept.lst file
###
listf () {
listf2 $ORACLE_HOME/$1/admin/shrept.lst $1
}

#------------------------------------------------------------------------------
# Main program starts here
#------------------------------------------------------------------------------

# Each product *must* provide a $PRODUCT/admin/shrept.lst
###
ErrFiles=
for product in rdbms precomp plsql ldap network; do
SHREPT=$ORACLE_HOME/$product/admin/shrept.lst
[ ! -f $SHREPT ] && ErrFiles="$ErrFiles $SHREPT"
done
[ "$ErrFiles" ] && Error 1 "$PROGRAM: Could not locate $ErrFiles"

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Can these files being manually modified/removed?No recommended. DBA should not modify them unless fully understand the impact.