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
Shell Script
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 Type Control Character in vi Editor
Control Character In some cases, developers may use a control character to delimit the data for every field in a flat file. For example, we… Read More »How to Type Control Character in vi Editor
Check if Directory Exists by Shell Script
Test Command In some situations, we may need to detect the existence of a directory in shell or scripts. If so, there's a quick way… Read More »Check if Directory Exists by Shell Script
How to Resolve Command Not Found in Bash
I do have an executable file in the present working directory ($PWD). [edchen@test ~]$ ll total 4 -rwxr--r-- 1 edchen edchen 21 Mar 12 12:45… Read More »How to Resolve Command Not Found in Bash
How to Cat a File Content by iNode
Symptoms At times, we may see some garbled filenames or even worse, empty or white-spaced names like this: [root@test ~]# ls -lai total 48 402653349… Read More »How to Cat a File Content by iNode
How to Delete Log Files Periodically in Oracle
Trace File, Audit File and Alert Log In this post I will introduce a shell script that can delete log files automatically. We will handle… Read More »How to Delete Log Files Periodically in Oracle
How Oracle Auto Start Database in Solaris
For Linux Os, you should check this post: How to Auto Start Oracle Database on Linux. Assuming that you already have some knowledge about how… Read More »How Oracle Auto Start Database in Solaris
How Oracle Auto Start Database in Linux
For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how… Read More »How Oracle Auto Start Database in Linux
How to Increase Bash History Size
Some valuable or complex commands may not be able to keep in your mind constantly when you need them. In this moment, you can leverage… Read More »How to Increase Bash History Size