|
UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
![]() |
|
Thread Tools | Search this Thread | Display Modes |
#1
|
||||
|
||||
![]() 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 |
Sponsored Links | ||
|
#2
|
||||
|
||||
Sounds like the problem of 99% of cron jobs, not having the environment set up.
|
Sponsored Links | ||
|
#3
|
||||
|
||||
Any Suggustion
Any suggestion which environment variable may be missing?
|
Sponsored Links | ||
|
![]() |
Thread Tools | Search this Thread |
Display Modes | |
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
crontab not working | isaacniu | Solaris | 6 | 01-09-2012 05:41 PM |
crontab not working | lg123 | UNIX for Dummies Questions & Answers | 2 | 04-24-2011 03:47 PM |
Unable to update the Crontab | Jeremy3 | Solaris | 4 | 02-22-2007 06:02 AM |
crontab NOT working | baanprog | UNIX for Advanced & Expert Users | 2 | 09-26-2006 12:11 PM |
crontab not working right | kymberm | UNIX for Dummies Questions & Answers | 3 | 07-09-2003 04:21 PM |
|