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
Korn Shell (KSH)
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
How to Resolve 0403-005 Cannot create the specified file
Error 0403-005 Found an error 0403-005 Cannot create the specified file when I tried to output some text to a file. [oracle@primary01 oracle]$ echo "Hello!"… Read More »How to Resolve 0403-005 Cannot create the specified file
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 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
How to Change Default Shell to Bash
Some users may ask you to change the default shell to BASH as their used to be. Here are the steps: Check Default Shell Login… Read More »How to Change Default Shell to Bash