Show running processes in Oracle DB
Oracle tip: a script displays queries running on an Oracle database, similar to show processlist in MySQL.
THE KNOWLEDGE BASE
All articles.
392 notes on Linux, tools and troubleshooting
How to trim space from bash variable
A small Bash shell tip: remove trailing spaces, leading spaces, or both from a variable with sed.
How to turn off Oracle password expiration
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.
How to fix chroot return "Exec format error"
A chroot Exec format error in Red Hat/CentOS rescue mode usually means the running environment and target commands use different architectures.
How to count blank lines and non-blank lines in a file
Shell techniques for counting blank and nonblank lines in a file, useful in scripts and troubleshooting.
Export mysql database based on a where condition
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…
How to read pcap file in Linux CLI using tcpdump
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.
Installing MySQL 5.6 using the MySQL yum repository
Oracle has released a MySQL Yum repository to make installing and updating MySQL server easier. Initially it supports Red Hat/Oracle Enterprise Linux/CentOS 6 and Fedora 18 and 19…
[Bug] Invalid of GRANT command will breaks replication
MySQL 5.6 has a bug to watch for: running GRANT privileges in PhpMyAdmin may cause a slave to stop replicating (bug report: http://bugs.mysql.com/bug.php?id=68892). After using MySQL 5…