A variety of Linux Shell Scripts I wrote over the years in particular Oracle.
License: GNU General Public License v3.0
Shell 99.91%Batchfile 0.09%
linux-shell-scripts's Introduction
Linux Shell Scripts
ADG:
check_dg_redo_apply.sql - Checking redo data apply on physical standby database of Oracle Active Data Guard
check_dg_redo_apply.sh - The shell script calling the previous "check_dg_redo_apply.sql"
BATCH REMOVE:
batch_remove_listener_xml_on_2018.sh - Removing listener log xml file that located in "$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/alert" directory generated by 2018
DIG LISTENER LOG:
dig_ip_via_listener_log_xml.sh - Digging real IP Address connecting to oracle database server recently via oracle listener log file "log.xml"
EXP:
exp_test_and_del_yesterday.sh - Exporting (logical backup with exp command) today's dmp files with specific user(s) and then deleting yesterday's
exp_test_and_del_yesterday_2.sh - The 2nd version of "exp_test_and_del_yesterday.sh", by the way adding four number of new parameters - "direct, buffer, feedback and recordlength" at the end of EXP command
EXPDP:
expdp_test_and_del_yesterday.sh - Exporting (logical backup with expdp command) today's dmp files with specific user(s) and then deleting yesterday's
expdp_test_and_del_yesterday_2.sh - The 2nd version of "expdp_test_and_del_yesterday.sh", by the way adding a new parameter compression at the end of EXPDP command
Linux Logo:
buddha_bless_never_downtime.sh - Showing a pattern consisting of several special keyboard characters for "Buddha bless, Never downtime"
Oracle Logo Banner:
oracle_logo.sh - Showing banner logo of oracle database server
oracle_logo_2.sh - The 2nd version showing banner logo of oracle database server
oracle_logo_3.sh - The 3rd version showing banner logo of oracle database server
Oracle Service:
automatically_open_oracle.sh - Invoking this SHELL script in /etc/rc.local in order to be able to automatically startup oracle database after restarting server
oracle - Being able to run the service "oracle" for automatically open the Oracle Database in case of Linux (OS) restarts
RMAN Backup:
rman_backup.sh - Doing rman backup one week via rman utility on oracle database server
rman_backup_ASM.sh - Doing rman backup one week to ASM disk via rman utility on oracle database server
rman backup on Windows - Doing rman backup one week on Windows
back_and_clean_alert_log.sh - Backup and clean alert log file that located in "$ORACLE_BASE/diag/rdbms/orcl/orcl/trace" directory of oracle database server
back_and_clean_listener_log.sh - Backup and clean listener log file that located in "$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/trace" directory on oracle user of oracle database server
retention_expdp_test_dump_file_2days.sh - Deleting all of expdp's dmp file about user "test" on oracle database 2 days before
rotate_reserve_base_dmp.sh - Periodically removing some earliest so far 7 number of "xxxx_base_xxxx.dmp" file, which located in directory "/u01/oradata" on oracle user for keeping sufficient disk space in reserve
scp_expdp_parallel_local_to_remote.sh - Copying several files that is gerenated by oracle datapump tool with expdp command from local to another linux server via scp
statistics_all_disk_files.sh - Listing the first file and last with only reserving the format of date and count total files number on each disk on linux server
statistics_all_disk_files_2.sh - The 2nd version listing the first file and last with only reserving the format of date and count total files number on each disk on linux server