SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Oracle 8i

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Oracle 8i
Author Message
John Natale



Joined: 13 Sep 2000
Posts: 107

Post Oracle 8i Reply with quote

I have the Oracle 8.1.6.0.0 Client installed on my server and I experience an intermittent problem where a scheduled job will work fine one night and then error out on another night.

I was wondering if there was some type of problem with the interface between 24x7 and Oracle 8i. I have switched to using the Oracle ODBC driver instead and this appears to work better.

Fri Sep 22, 2000 9:36 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: Oracle 8i Reply with quote

From what I heard, if your run your Oracle job from a JAL script using DatabaseConnectEx(...full profile...) instead of DatabaseConnect(...only profile name...) it will fix the problem. For some reasons second connection made to Oracle 8.0.4 (or a later varsion) using database type job or DatabaseConnect statement may crash the scheduler. DatabaseConnectEx works just fine.

: I have the Oracle 8.1.6.0.0 Client installed on my server and I experience an
: intermittent problem where a scheduled job will work fine one night and
: then error out on another night.

: I was wondering if there was some type of problem with the interface between
: 24x7 and Oracle 8i. I have switched to using the Oracle ODBC driver
: instead and this appears to work better.

Fri Sep 22, 2000 10:38 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.