How to enables command-line history in SQL*PLUS
SQL*PLUS (sqlplus) does not let you press the up or down arrow to browse previous commands. It only lets you inspect one previous command, making repeated commands inconvenient.
394 notes on Linux, tools and troubleshooting
SQL*PLUS (sqlplus) does not let you press the up or down arrow to browse previous commands. It only lets you inspect one previous command, making repeated commands inconvenient.
Use date with -d in Bash to display yesterday's date or an earlier date.
Oracle tip: a script displays queries running on an Oracle database, similar to show processlist in MySQL.
A small Bash shell tip: remove trailing spaces, leading spaces, or both from a variable with sed.
By default, Oracle user passwords expire after 180 days and must be changed. To remove the expiry, change PASSWORD_LIFE_TIME on the user's profile.
A chroot Exec format error in Red Hat/CentOS rescue mode usually means the running environment and target commands use different architectures.
Shell techniques for counting blank and nonblank lines in a file, useful in scripts and troubleshooting.
MYSQLDUMP exports data from MySQL databases. It is commonly used to export all data from a table or database, but it can also export selected data…
pcap files from tcpdump or network devices are binary and cannot be read in ordinary text editors. tcpdump can read them directly from the Linux console.