Check the script for the ORACLE warning File

Check the script for the ORACLE warning File

Check the important information within two days:

Vi alter_error.sh

Echo "Check Alter Error: "cat $ TRACE/alert _ $ ORACLE_SID.log | grep-E ^ ORA-\ | Reconfig \ | abort \ | Shut \ | ^ Start \ | error \ | Instance \ | Suspend \ | resuming \ | Deadlock \ | "'date" + % B % d "'" \ | "'date-d last-day" + % B % d "'"

Configure Environment Variables

Vi/home/oracle/. bash_profile

Export ORACLE_BASE =/u01/app

Export ORACLE_HOME = $ ORACLE_BASE/product/11gR2/db

Export ORACLE_SID = shark

Export SERVICE_NAMES = erp

Export DBUNAME = sharkdb

Export TRACE = $ ORACLE_BASE/diag/rdbms/$ DBUNAME/$ ORACLE_SID/trace
Compress alarm files

Mv_alterlog.sh

Mv $ TRACE/alert _ $ ORACLE_SID.log $ TRACE/bak_alter _ $ ORACLE_SID. 'date + % F _ % H'. log

Ls-lh $ TRACE/bak_alter _ $ ORACLE_SID. 'date must have f_1_h'.log.gz