Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Call parallel sql scripts from shell and return status when both sql are done
Top Forums UNIX for Advanced & Expert Users Call parallel sql scripts from shell and return status when both sql are done Post 302495261 by durden_tyler on Wednesday 9th of February 2011 08:03:59 PM
Old 02-09-2011
Quote:
Originally Posted by huasheng8
...
This is my code:

Code:
{
  echo "$ORA_LOGIN"
  echo "@$file_name;"
} | sqlplus -silent >> test.log 2>&1 &
SQL1_PID=$!
echo "SQL1_PID is $SQl1_PID."

And the output is SQL1_PID is .

Why is that?
...
Change these lines:

Code:
SQL1_PID=$!
echo "SQL1_PID is $SQl1_PID."

to this -

Code:
echo "PID is $!"

tyler_durden
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how can a call shell script from pl/sql

I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin. can any one suggest me how can i do this (0 Replies)
Discussion started by: rajesh.P
0 Replies

2. Shell Programming and Scripting

how can i call a shell script from pl/sql

I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure. can any one suggest me how can i do that? (3 Replies)
Discussion started by: rajesh.P
3 Replies

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

4. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

5. UNIX for Advanced & Expert Users

call sql through shell script

Hi i am not able to connect sqlplus my script is as follows $ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt and output is SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: t175481... (1 Reply)
Discussion started by: tushar_spatil
1 Replies

6. Shell Programming and Scripting

Parallel SQL sessions in shell script

i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes sqlplus username1/password1@DB1 @sql >> log1 & sqlplus username2/password2@DB2 @sql2 >> log1 & how can i execute the... (7 Replies)
Discussion started by: only4satish
7 Replies

7. Shell Programming and Scripting

Return value to shell script, depending on status of pl/sql udpate

Hi All, I need to return value to the main shell script, depending on whether the UPDATE command in the embedded pl/sql is successfu or not. #!bin/ksh updateStatus=`sqlplus --conn details-- << EOF DECLARE var_rows NUMBER; BEGIN update table_name set column_name =... (7 Replies)
Discussion started by: rituparna_gupta
7 Replies

8. Shell Programming and Scripting

Parallel processing of SQL through Shell

Hi Friends, I am trying to write a shell which will invoke 3 CTAS (ORACLE create table XXX as select * from YYYY). The approximate time for one CTAS is around 25 mins. So i want to run the CTAS script parallely. My pseudocode is as below. Main script nohup sh CTAS1.sh &... (3 Replies)
Discussion started by: Showdown
3 Replies

9. Shell Programming and Scripting

How to call SQL Loader in shell script?

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies

10. Shell Programming and Scripting

Shell script to call sql file

hi , the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt. i want to make this script generic so that it can accept the sql file as parameter and can... (5 Replies)
Discussion started by: itzkashi
5 Replies

LEARN ABOUT DEBIAN

dspam_maintenance

dspam_maintenance(1)						   User Commands					      dspam_maintenance(1)

NAME

       dspam_maintenance - remove old signatures and unimportant tokens from the DSPAM storage backend

SYNOPSIS

       dspam_maintenance [--profile=PROFILE] [--logdays=no_of_days] [--signatures=no_of_days] [--neutral=no_of_days] [--unused=no_of_days]
       [--hapaxes=no_of_days] [--hits1s=no_of_days] [--hits1i=no_of_days] [--without-sql-purge] [--with-sql-automatization] [--with-sql-autoup-
       date] [--purgescriptdir=directory] [--with-all-drivers] [--verbose]

DESCRIPTION

       dspam_maintenance  is  used to remove old signatures/tokens and unimportant tokens from the DSPAM storage backend and purge old log entries
       in user and system logs.

       This script can be called from the command line or run from within cron. Either add a line in your crontab  or  add  this  script  in  your
       cron.{hourly,daily,weekly,monthly}.  Running this script every hour might not be the best idea but it's your decision if you want to do so.

OPTIONS

       --profile=PROFILE

	      Specify a storage profile from dspam.conf. The storage profile selected will be used for all database connectivity.

	      NOTE: See dspam.conf for more information.

       --logdays=no_of_days

	      All log entries older than no_of_days days will be removed.

	      NOTE: Default is 31 days. (for more info: man dspam_logrotate)

       --signatures=no_of_days

	      All signatures older than no_of_daysdays will be removed.

	      NOTE:  Default  value  is  set by the PurgeSignatures option in dspam.conf, if this option is not set, the default value is 14 days.
	      This option is only used for the Hash driver.

       --neutral=no_of_days

	      Deletes all tokens from the target users database whose probability is between 0.35 and 0.65 (fairly neutral, useless data).

	      NOTE: Default value is set by the PurgeNeutral option in dspam.conf, if this option is not set, the default value is 90 days.

       --unused=no_of_days

	      Remove stale tokens which have not been used for a long period of time.

	      NOTE: Default value is set by the PurgeUnused option in dspam.conf, if this option is not set, the default value is 90 days.

       --hapaxes=no_of_days

	      Remove tokens with a total hit count below 5 (which will be assigned a hapaxial value by DSPAM).

	      NOTE: Default value is set by the PurgeHapaxes option in dspam.conf, if this option is not set, the default value is 30 days.

       --hits1s=no_of_days

	      Remove tokens with a single SPAM hit.

	      NOTE: Default value is set by the PurgeHits1S option in dspam.conf, if this option is not set, the default value is 15 days.

       --hits1i=no_of_days

	      Remove tokens with a single INNOCENT hit.

	      NOTE: Default value is set by the PurgeHits1I option in dspam.conf, if this option is not set, the default value is 15 days.

       --without-sql-purge

	      Do not use SQL based purging. Only run dspam_clean.

	      NOTE: Default is off (aka: use SQL based purging).

       --with-sql-optimization

	      Run VACUUM (for PostgreSQL/SQLite) and/or OPTIMIZE (for MySQL).

	      NOTE: Default is off (aka: do not use optimizations).

       --with-sql-autoupdate

	      Run SQL based purging with purge day values passed to dspam_maintenance.

	      NOTE: Default is off (aka: do not attempt to modify SQL instructions).

       --purgescriptdir=directory

	      Space separated list of directories where to search for SQL files used for the SQL based purging.

       --with-all-drivers

	      Process all installed storage drivers (not just the active driver).

	      NOTE: Default is true (aka: process all installed drivers).

       --verbose

	      Verbose output while running maintenance script.

EXIT VALUE

       0      Operation was successful.
       other  Operation resulted in an error. Run the script with --verbose to get more information about error.

COPYRIGHT

       Copyright (C) 2002-2010 DSPAM Project
       All rights reserved.

       For more information, see http://dspam.sourceforge.net.

SEE ALSO

       dspam(1), dspam_admin(1), dspam_clean(1), dspam_crc(1), dspam_dump(1), dspam_logrotate(1), dspam_merge(1), dspam_stats(1), dspam_train(1)

dspam_maintenance						   Apr 26, 2010 					      dspam_maintenance(1)
All times are GMT -4. The time now is 09:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy