Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script (with sql queries) not working using cron
Top Forums Shell Programming and Scripting Script (with sql queries) not working using cron Post 302716059 by nypreH on Tuesday 16th of October 2012 08:08:14 AM
Old 10-16-2012
Here it is:

Code:
[root@dsafn1 ttg_project]# crontab -l
07,17,27,37,47,57 * * * * bash -lc /opt/nokiaoss/bin/dgrepchk.pl > /dev/null 2>&1 # HOST=scv2db ID=DBSC_101
07 * * * * /root/ttg_project/run.sh
50 * * * * /root/ttg_project/test.sh

/root/ttg_project/run.sh - is the script which I am trying to run.

---------- Post updated at 05:08 PM ---------- Previous update was at 11:09 AM ----------

I added some parameters and now, when trying to connect i am getting this error:

Code:
[root@dsafn1 20121016]# more NOKRWW_PS_INTERSHO_MNC1_RAW-201210161600.csv 
ERROR:
ORA-12545: Connect failed because target host or object does not exist


SP2-0640: Not connected
[root@dsafn1 20121016]#


This is whatI added tomy script:

Code:
#!/bin/sh  
LD_LIBRARY_PATH="/usr/lib/oracle/10.2.0.2/client/lib:{/usr/lib/oracle/10.2.0.2/client/lib:{}:/opt/nokia/oss/lib:/opt/nokia/oss/tao/lib:/usr/lib:/usr/lib/oracle/10.2.0.2/client/lib}:/opt/nokia/oss/lib:/opt/nokia/oss/tao/lib:/usr/lib:/usr/lib/oracle/10.2.0.2/client/lib"
export LD_LIBRARY_PATH
PATH="/usr/lib/oracle/10.2.0.2/client/bin:/opt/nokia/oss/bin:/opt/nokia/oss/perl/bin:/opt/nokia/oss/tao/bin:/bin:/usr/bin:/usr/lib/oracle/10.2.0.2/client/bin:/opt/nokia/oss/bin:/usr/lib/oracle/10.2.0.2/client/bin:/opt/nokia/oss/bin:/opt/nokia/oss/perl/bin:/opt/nokia/oss/tao/bin:/bin:/usr/bin:/usr/lib/oracle/10.2.0.2/client/bin:/opt/nokia/oss/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/sbin:/opt/nokia/oss/sbin:/root/bin:/usr/sbin:/opt/nokia/oss/sbin"
export PATH
ORACLE_HOME=/usr/lib/oracle/10.2.0.2/client
export ORACLE_HOME
ORACLE_SID=oss
export ORACLE_SID
ORACLE_BASE=/usr/lib/oracle
ORACLE_PATH=/opt/nokia/oss/lib/sql
ORACLE_TERM=xterm
ORAENVFILE=/opt/nokia/oss/bin/omkoraenvmx.sh
SERVICE_NAME=oss
HOST=scv2db.r01.netact.azerfon.az
export SERVICE_NAME
export HOST
export ORACLE_BASE
export ORACLE_PATH
export ORACLE_TERM
export ORACLE_TERM

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL queries in background?

I have to query a DB2 database, and sometimes they take a long time to produce results. Can I run these queries in the background, and if so, where will the results appear? (1 Reply)
Discussion started by: jpprial
1 Replies

2. UNIX for Dummies Questions & Answers

Sh Shell Script executing remote SQL queries

Hi there folks, I am trying to execute remote sql queries on an Oracle server. I would like to save the result of the executed sql queries on a text file, and send that text file as an attachment to an email address. Could anyone give me an idea on how the above could be achieved? Any help... (2 Replies)
Discussion started by: Javed
2 Replies

3. UNIX for Dummies Questions & Answers

shell script for sql queries

Hi All, I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries... i.e 1.select * from head; 2. select * from detail; 3. delete from head; 4. delete from detail; Please let me know how to write a shell script... Thank you (1 Reply)
Discussion started by: user71408
1 Replies

4. Shell Programming and Scripting

Nested SQL queries within Shell script

Hi, Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows: my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g" connect... (2 Replies)
Discussion started by: shrutihardas
2 Replies

5. Shell Programming and Scripting

Script is not working from cron while working manually

Hello, I am facing a very strange problem when I run my script manuallu ./Fetchcode which is using to connect with MKS integrity from linux end it workks fine but when I run it from cron it doesn't work.Can someone help me 1) How could I check my script when it is running from cron like... (3 Replies)
Discussion started by: anuragpgtgerman
3 Replies

6. Shell Programming and Scripting

Script not working in cron but working fine manually

Help. My script is working fine when executed manually but the cron seems not to catch up the command when registered. The script is as follow: #!/bin/sh for file in file_1.txt file_2.txt file_3.txt do awk '{ print "0" }' $file > tmp.tmp mv tmp.tmp $file done And the cron... (2 Replies)
Discussion started by: jasperux
2 Replies

7. Shell Programming and Scripting

Executing set of sql queries from shell script

Hi All, I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below sqlplus user/pwd@dbname << EOF > output.log $(<inputfile.txt) EOF The above code is capturing the output of queries into... (9 Replies)
Discussion started by: loggedin.ksh
9 Replies

8. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

9. Shell Programming and Scripting

run sql queries from UNIX shell script.

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused: (1 Reply)
Discussion started by: 24ajay
1 Replies

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

LEARN ABOUT DEBIAN

rt-shredder-4

rt-shredder(8)						     Request Tracker Reference						    rt-shredder(8)

NAME

       rt-shredder - Script which wipes out tickets from RT DB

SYNOPSIS

	 rt-shredder --plugin list
	 rt-shredder --plugin help-Tickets
	 rt-shredder --plugin 'Tickets=query,Queue="general" and Status="deleted"'

	 rt-shredder --sqldump unshred.sql --plugin ...
	 rt-shredder --force --plugin ...

DESCRIPTION

       rt-shredder - is script that allow you to wipe out objects from RT DB. This script uses API that RT::Shredder module adds to RT.  Script
       can be used as example of usage of the shredder API.

USAGE

       You can use several options to control which objects script should wipeout.

OPTIONS

   --sqldump <filename>
       Outputs INSERT queries into file. This dump can be used to restore data after wiping out.

       By default creates files <RT_home>/var/data/RT-Shredder/<ISO_date>-XXXX.sql

   --object (DEPRECATED)
       Option has been deprecated, use plugin "Objects" instead.

   --plugin '<plugin name>[=<arg>,<val>[;<arg>,<val>]...]'
       You can use plugins to select RT objects with various conditions.  See also --plugin list and --plugin help options.

   --plugin list
       Output list of the available plugins.

   --plugin help-<plugin name>
       Outputs help for specified plugin.

   --force
       Script doesn't ask any questions.

SEE ALSO

       RT::Shredder

perl v5.14.2							    2013-05-22							    rt-shredder(8)
All times are GMT -4. The time now is 03:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy