Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
I have shell script which will try to login to SQL Plus and retrieve some data, based on the outcome i will proceed further
Below is the content of the file
pebblz02% cat test1.ksh
#! /bin/ksh
dummyvar=`sqlplus -S csm_admin/csm_admin@SIDNAME <<EOF echo hi; exit; EOF`
Error message on... (0 Replies)
UNIX Gods,
I'll be running this script from CRON. I need to log the status of each of the six sqlplus calls into a file when this job is kicked off. Any suggestions?
Thanks in advance.
#!/bin/ksh
export USAGE="USAGE: `basename $0` -e <DBUSER> <DBPASSWD> <TNSNAME>"
if ; then
... (2 Replies)
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
I have a variable $WORDS that contains a string
Then i want to use sed to break it up.
echo $WORDS | sed 's// /g'
I tried setting this as a variable by doing
WORDS2=`echo $WORDS | sed 's// /g'`
But when i do this it does not return me to the prompt properly
ie.
jmpprd-v1>
jmpprd-v1>... (4 Replies)
Hi ,
I am using below code :
for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading off feedback on verify off
select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Discussion started by: admin_db
5 Replies
LEARN ABOUT PHP
systemd-importd.service
SYSTEMD-IMPORTD.SERVICE(8) systemd-importd.service SYSTEMD-IMPORTD.SERVICE(8)NAME
systemd-importd.service, systemd-importd - VM and container image import and export service
SYNOPSIS
systemd-importd.service
/lib/systemd/systemd-importd
DESCRIPTION
systemd-importd is a system service that allows importing, exporting and downloading of system images suitable for running as VM or
containers. It is a companion service for systemd-machined.service(8), and provides the implementation for machinectl(1)'s pull-raw,
pull-tar, import-raw, import-tar, export-raw, and export-tar commands.
See the importd D-Bus API Documentation[1] for information about the APIs systemd-importd provides.
SEE ALSO systemd(1), machinectl(1), systemd-machined.service(8), systemd-nspawn(1)NOTES
1. importd D-Bus API Documentation
https://www.freedesktop.org/wiki/Software/systemd/importd
systemd 237SYSTEMD-IMPORTD.SERVICE(8)