How to Check DB Status by Script
To check if a databae is alive or not, we already have a way to do it. However, such script can't tell NOMOUNT, MOUNT or… Read More »How to Check DB Status by Script
grep
How to Check if Oracle Database is Running
To make sure that an Oracle database is alive, we can use a piece of shell script to check it. [oracle@test ~]$ vi check_database_alive.sh #!/bin/bash… Read More »How to Check if Oracle Database is Running
How to Find Oracle DBID
DBID Database Identifier (DBID) is a unique number that can be identified by RMAN so as to do backup and restore whenever needed. In some… Read More »How to Find Oracle DBID
Where is Oracle Control File Location
Oracle Control File Location We use different ways to find out the location of control file when the database is online and offline. 1. When… Read More »Where is Oracle Control File Location
How to Kill LOCAL=NO Process at OS-Level
Unstoppable Sessions In some situation, you might see AP server spawned thousands of sessions for no reason, we should take some actions on the spot.… Read More »How to Kill LOCAL=NO Process at OS-Level
How to Monitor Specific Terms by Filtering Output of "tail -f" on Linux
You might feel tedious or nothing special when watching log files by tail -f, especially when the log files contain thousands of transaction at the… Read More »How to Monitor Specific Terms by Filtering Output of "tail -f" on Linux
How to grep A But Not B out of Text
3 kinds of exquisite fruit platters that customers can order in our restaurant.[root@localhost ~]# cat -n fruits.lst 1 apple banana cherry mango 2… Read More »How to grep A But Not B out of Text
3 Ways to Remove Blank Lines on Linux
In this post, I will introduce 3 ways to remove blank lines in files. Let's see the original file in this example first.[root@localhost ~]$ cat… Read More »3 Ways to Remove Blank Lines on Linux