How to Get SQLPLUS Query Output to a Shell Script Variable
Most of the time during the shell
scripting we get requirement to get the database table query result values to a
shell script variables. Here is one example to get a single column values to a
variable. If you have multiple column outputs then we will have to concatenate
into a single column and pass it to the shell script variable. You can use awk
or scripting commands to make it separate.
Linux Screen Command: re Attach an Already Attached Session
Here are some useful
tips to use screen command in Linux user logins. Linux screen command is very useful
command to keep the session logged in without any failure even if any kind of
network failure etc.
- Invoke a Screen
session
Login to
your a/c
Fix for Chrome: These Settings Are Enforced By Your Administrator. A 100% working solution
Problem Description:
In Chrome browser unable to change the
proxy settings and the browsing is not working with Chrome. IE and Firefox
browser working perfectly but chrome is not working. Chrome throws error saying
unable to connect to the proxy. When I tried to change the proxy settings it
says “These settings are enforced by your
administrator”.
Fix ORA-15505: cannot start workload capture because instance 1 encountered errors
Error Description
Workload_caputre.start_capture failed
with Fix ORA-15505: cannot start workload capture because instance 1
encountered errors
SQL>
create directory WLDIR as '/export/prod_db/workload/’;
Directory
Created
SQL>
begin
Unix Linux Script to Attach and Embed the HTML File in Mail Body
(
export ATTACH="/home/sthomas/xyz.html"
export MAILTO=xyx@abc.com ##
export MAILPART=`uuidgen` ## Generates
Unique ID
export MAILPART_BODY=`uuidgen` ##
Generates Unique ID
export SUBJECT=”Attach And Embed HTML”
echo "To: $MAILTO"
echo "Subject: $SUBJECT"
echo "MIME-Version: 1.0"
TNSPING and SQLPlus works but not Able to connect SQL Developer
Error
description:
TNSPING and SQLPlus is working perfectly
but when I try to connect through SQL developer it is giving error.
Solution
description
You will have to set the tnsnames.ora
location in the SQL developer configuration