Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help required with xargs to use sqlplus

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help required with xargs to use sqlplus
# 1  
Old 06-20-2015
Help required with xargs to use sqlplus
Hello All,

I have a requirement in which i need to run few Oracle sql files in parallel.
I want to use xargs command [I don't want to use & and send the job to background] to achieve parallelism.

I tried below command:
Code:
cat x|xargs -n 1 -P 5 sqlplus -s $usr/$pwd@$Host @{}

File x has the list of sql files to be executed.

I am getting the error message
SP2-0310: unable to open file "{}.sql"

Please help me.

Thanks in Advance
# 2  
Old 06-20-2015
Quote:
Originally Posted by vikas_trl
Hello All,

I have a requirement in which i need to run few Oracle sql files in parallel.
I want to use xargs command [I don't want to use & and send the job to background] to achieve parallelism.

I tried below command:
Code:
cat x|xargs -n 1 -P 5 sqlplus -s $usr/$pwd@$Host @{}

File x has the list of sql files to be executed.

I am getting the error message
SP2-0310: unable to open file "{}.sql"

Please help me.

Thanks in Advance
I wonder if that helps.
Code:
xargs -I {} -n 1 -P 5 sqlplus -s $usr/$pwd@$Host @"{}" < x

This User Gave Thanks to Aia For This Post:
vikas_trl
# 3  
Old 06-20-2015
I don't think xargs will run those programs in parallel without sending any of them into background.
# 4  
Old 06-20-2015
RESOLVED: Help required with xargs to use sqlplus
Quote:
Originally Posted by Aia
I wonder if that helps.
Code:
xargs -I {} -n 1 -P 5 sqlplus -s $usr/$pwd@$Host @"{}" < x

Thankyou very much Aia. You solved my issue. SmilieSmilieSmilie

Quote:
Originally Posted by RudiC
I don't think xargs will run those programs in parallel without sending any of them into background.
Thanks RudiC for your reply. I know xargs runs the parallel jobs in background, but i don't want to do it myself using &.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Problem on SQLplus command ""bash: sqlplus: command not found""

Hi all, i face an error related to my server ""it's running server"" when i use sqlplus command $ sqlplus bash: sqlplus: command not found the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup. i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies

2. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies

3. Windows & DOS: Issues & Discussions

Help required for Running SQLPLUS command from Bat file

Hello All, Good Afternoon. I am new to this platform and I need one small help regarding running a SQL file from Bat file. Below is what I am doing, 1. I placed the below command in one Bat file. start putty.exe -ssh user@host -pw pwd -m C:\2.txt 2. In 2.txt, I have below command. ... (3 Replies)
Discussion started by: PavanPatil
3 Replies

4. Shell Programming and Scripting

Help with xargs

Using the bash shell I'm trying to either create a command for the command line or a script that will show netstat info for a given process name. Here is an example of what I'm trying to do:$ ps aux |grep catalina |grep -v grep | awk '{print $2}' 5132 $ netstat -nlp |grep 5132 (Not all processes... (11 Replies)
Discussion started by: axiopisty
11 Replies

5. Shell Programming and Scripting

Help in using xargs

Hi, I have a requirement to RCP the files from remote server to local server. Also the RCP has to run in parallel. However using 'xargs' retrives 2 file names during each loop. How do we restrict to only one file name using xargs and loop till remaining files. I use the below code for... (2 Replies)
Discussion started by: senthil3d
2 Replies

6. Shell Programming and Scripting

Using xargs

hi i just want to know that how do we use xargs command to find files which are greater than specified memory in a given directory (6 Replies)
Discussion started by: sumit the cool
6 Replies

7. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies

8. UNIX for Advanced & Expert Users

xargs -P

I discovered that GNU's xargs has a -P option to allow its processes to run in parallel. Great! Is this a GNU thing, or is it supported by other platforms as well? (4 Replies)
Discussion started by: otheus
4 Replies

9. Shell Programming and Scripting

why we use xargs..

hi , can anyone help me by saying why we use xargs.. is it acing like a place holder..? thanks, Krips. (3 Replies)
Discussion started by: kripssmart
3 Replies

10. UNIX for Dummies Questions & Answers

Help with xargs

Hi there, I am trying to move around 3000 files from one directory to another. The mv command is complaining from too many arguments. I tried to use the xargs command but with no luck. Could some body provide help? Regards (4 Replies)
Discussion started by: JimJim
4 Replies
Login or Register to Ask a Question