Maintenance

Regular Tasks Clean Trace Files:

bash

Copy

# Remove old trace files
find $ORACLE_HOME/log -name "*.trc" -mtime +30 -delete
find $ORACLE_HOME/log -name "*.trm" -mtime +30 -delete

Update TNS entries:

bash

Copy

# Backup tnsnames.ora
cp $ORACLE_HOME/network/admin/tnsnames.ora tnsnames.ora.bak
# Edit tnsnames.ora
vi $ORACLE_HOME/network/admin/tnsnames.ora

Cache Maintenance

bash

Copy

# Clear SQL*Net cache
rm -rf $ORACLE_HOME/network/admin/*.ora.cache