Enable Non-Oracle User Run SQL*Plus
Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »Enable Non-Oracle User Run SQL*Plus
Shell Scripts
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 Take Parallel Jobs to Background in One Line
Suppose you're a SA. In the beginning of the year 2016, you have to execute multiple system analysis reports parallelly for every month last year.… Read More »How to Take Parallel Jobs to Background in One Line
How to Backup RMAN Configuration Daily
Backup RMAN Configuration RMAN can backup almost everything at any state of execution time, includes data, archive logs, even control file and spfile, but I… Read More »How to Backup RMAN Configuration Daily
3 Replace-Equivalent Commands on Linux
Here are several ways to do replacement on Linux:Output the replacing result to the same file by sed with option -i[oracle@test ~]$ sed -i 's/Ed… Read More »3 Replace-Equivalent Commands 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
How to Combine Multiple Files Into One on Linux
In this post, I will introduce several ways to Combine files into one file. Suppose we have 4 files as followings:[root@localhost ~]$ cat 1.txt1. Database.1.… Read More »How to Combine Multiple Files Into One on Linux
How to Remove First Few Characters on All Lines
If you'd like to remove the first few characters with fixed width on all lines, you can try the following methods. For example, we have… Read More »How to Remove First Few Characters on All Lines
How to Trim Both Ends of Lines
In this post, I plan to remove the leading and trailing white spaces or tab characters from the file. Let's see the original file.[root@localhost ~]$… Read More »How to Trim Both Ends of Lines
How to Append Blank Lines to Files on Linux
How to Distinguish Carriage Returns CR, Line Feeds LF, and New Lines CRLF on LinuxI assume that you have read my previous post. In that… Read More »How to Append Blank Lines to Files on Linux