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
Bourne-Again Shell (BASH)
How vi Editor Add Control Character
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 vi Editor Add Control Character
SSH Remote "Command not found"
Remote: command not found Tried to execute a command on a remote server simply by using SSH tunnel, but it failed with "command not found".… Read More »SSH Remote "Command not found"
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
Usermod Add Group to User
Add Group to User Let's print current id of the user. [root@primary01 ~]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba) In this case, we would like to… Read More »Usermod Add Group to User
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 AIX PS1 Set Command Prompt
AIX PS1 By default, there's little information in prompt for a new user in KSH. If you're used to Linux BASH prompt, then we should… Read More »How AIX PS1 Set Command Prompt
How to Compare Data Between Two Databases
Several years ago I made a stored procedure for comparing table row counts between two databases after migration, which can output a very clear and… Read More »How to Compare Data Between Two Databases
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
How to Set Default Editor to Vi in KSH
You might find out your shell does not respond to your esc + k which can reuse the historical commands in KSH just like ↑… Read More »How to Set Default Editor to Vi in KSH