Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Pro*C Update not working from Crontab

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Pro*C Update not working from Crontab
Prev   Next
# 1  
Old 09-13-2007
Data Pro*C Update not working from Crontab
Dear All,

I have writen a Pro*c program that does a data base select,insert,update statements and I have scheduled the program to run from crontab,

It is runing fine for the select insert and commit statement till it reaches the update statement , it throws the following error:

SQL On IPB Account 239907203 - Bill 2411212954

Oracle error, sqlstate is

Error occured. sqlcode = -3114
message = ORA-03114: not connected to ORACLE

Last SQL statement: update ipb_fix_batch_err_t e set e.STATUS=3,e.e_date=:b0 where (e.bil

At or near line number 2096

Cursor Cache Statistics
------------------------
Maximum value of MAXOPENCURSORS: 10
Maximum open cursors required: 10
Current number of open cursors: 10
Number of cache reassignments: 7
Number of SQL statement parses: 17
Number of SQL statement executions: 21

If I run the program from the command line it runs fine,

Please can any one help me in this, it is so urgent

Thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Crontab update

Hello. We have a big crontab file where we need to comment out for few countries and also uncomment out based on situations . Could someone let us know how this can be done using a script . Sample file look like & here i need to comment/uncomment based on country code . 0-59 ...... (15 Replies)
Discussion started by: ron5174
15 Replies

2. Linux

Crontab not working

Hi, I know this is a common topic. I'm trying to launch a perl script using a contab -e entry. I've been trying diff options but nothing seems to work: My cron is running: UID PID PPID C STIME TTY TIME CMD root 3755 1 0 Nov27 ? 00:00:00 crond This... (4 Replies)
Discussion started by: krebe
4 Replies

3. HP-UX

Pro*c binary file is not working

Hi, I have written a sample pro*c code and able compile and create a executable file without any error. But I have to run this binary in some other server by FTPing this binary to other server. The directory structure of ORACLE_HOME for both server is different. I used ORACLE_HOME as... (10 Replies)
Discussion started by: Akhirul
10 Replies

4. Solaris

crontab not working

Shell = ksh Hi all, I scheduled an automated job on my application server like below, 30 13 * * 1-5 $HOME/my_script.sh However the script was not executed as expected. Any reason that may cause this to happen? (6 Replies)
Discussion started by: isaacniu
6 Replies

5. Red Hat

crontab is not working!!

I can run manually script of ntopdump.sh but crontab can't run this script very five minutes. # crontab -l */3 * * * * root sh /root/ping.sh */5 * * * * root sh /root/ntopdump.sh # # pwd /root # ls -l total 88 -rwxrwxr-x 1 root root 1645 Jun 14 19:01 anaconda-ks.cfg drwxrwxr-x 2 root... (14 Replies)
Discussion started by: getrue
14 Replies

6. UNIX for Dummies Questions & Answers

crontab not working

In /oracle folder, I created a file called "script.ksh" using vi command. The content of script.ksh is * * * * * echo "welcome">/tmp/capture.log I want the word "welcome" to be displayed in /tmp/capture.log file every minute. I have created capture.log under /tmp folder. Then in... (2 Replies)
Discussion started by: lg123
2 Replies

7. UNIX for Advanced & Expert Users

crontab not working

Dear all We have SunOS 5.10 Generic_127127-11 sun4u sparc SUNW,Sun-Fire-V250 i have scheduled cronjob but its not working Crontab details 15 15 * * * /d5/oratest/testdb/hotbackup_new.sh TEST247 15 15 * * * mkdir -p rajesh /d4/appltest Crontab log details > CMD: mkdir... (4 Replies)
Discussion started by: rajesh_hv
4 Replies

8. Solaris

Unable to update the Crontab

Hi Everyone, Each time I do update the crontab, it gets reset after exiting from the telnet session. I'm using Solaris 2.8 So it goes like this: Step 1: Login as root, from a telnet session Step 2: Crontab -e (I make modification) Step 3: Save and exit Step 4: Type crontab -l , changes... (4 Replies)
Discussion started by: Jeremy3
4 Replies

9. UNIX for Advanced & Expert Users

crontab NOT working

Hi, I have put the following entry in crontab and it is NOT working 1 * * * * && /mybin/myjob.sh As today is Sep 26th, Iam using NF-4 to test. Thanks (2 Replies)
Discussion started by: baanprog
2 Replies
Login or Register to Ask a Question

LEARN ABOUT SUSE

geoipupdate

GEOIPUPDATE(1)						      General Commands Manual						    GEOIPUPDATE(1)

NAME

       geoipupdate - a program for updating the MaxMind GeoIP databases

SYNOPSIS

       geoipupdate [-v] [-f licensefile]

DESCRIPTION

       geoipupdate  automatically updates the GeoIP database for GeoIP subscribers.  It connects to the MaxMind GeoIP Update server and checks for
       an updated database.  If it finds an updated database, then it downloads it, uncompresses it, and installs it.  If you are running a  fire-
       wall, it requires that the DNS and HTTP (80) ports be open.

       For example

       geoipupdate -v

       Performs the update in verbose mode.

OPTIONS

       -v     Verbose mode, prints out the steps that geoipupdate takes.

       -d     Specify a custom directory target to install the GeoIP datafile(s).  By default geoipupdate installs to /var/lib/GeoIP

       -f     Specifies the configuration file that contains the license key.  Defaults to /etc/GeoIP.conf

USAGE

       Typically you'll want to write a weekly crontab that will run geoipupdate.  Below is a sample crontab that runs geoipupdate on each Wednes-
       day at noon:

	      # top of crontab

	      MAILTO=your@email.com

	      0 12 * * 3 BIN_DIR/geoipupdate

	      # end of crontab

RETURN CODES

       geoipupdate returns 0 on success, 1 on error.

FILES

       /etc/GeoIP.conf

       Configuration file for GeoIP, should contain license key.

AUTHOR

       Written by T.J. Mather

REPORTING BUGS

       Report bugs to <support@maxmind.com>

COPYRIGHT

       Copyright (C) 2006 MaxMind LLC

       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       Visit <http://www.maxmind.com/app/products> to sign up for a GeoIP subscription.

       geoiplookup(1), crontab(5)

4th Berkeley Distribution					    14 May 2006 						    GEOIPUPDATE(1)