Home › Blogs › gccbanner's blog

Banner Job Submissions

Wed, 2008-04-16 20:44 — gccbanner
Average: 3 (2 votes)

Any body experiencing problems with Banner Job Sub? We need to reset the banjobs on our production server every hour of the day manually....

I would appreciate any suggestions, ideas, scripts, or howto's ....

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 2008-04-16 23:33 — rdbadave2

Re: Banner Job Submissions

questions:
1. How many job submission processes are you running?
** Most sites we work with have three gurjobs processes running to listen for work. This requires a small mod to the baseline but I think there is a Sungard FAQ on the topic.

2. Do you have a script to view processes running in the database?
** I recommend whoiswho.sql which you can get at www.rtsdba.com if you don't have something that shows what processes are running. You can modify the script for your specifics if you would like. Basically it will report INB access with form name, running jobs by name and recent SSB logins.

3. Are you running a RAC database?

4. Do you know what is happening with jobsub when you 'reset'? Is a long running job happening or is the gurjobs listening process simply dying?
** You can investigate the logs in the jobsub directory to gather more information.

Personally, I have rarely seen a problem with gurjobs in the 15 years I have been a Banner Oracle dba. If the process is truly dying, then you have a configuration issue of some sort.

Dave
---------------
Dave Hill, RTS Inc.
OCP Oracle DBA
www.rtsdba.com
--------------
Cherish the good times, endure the bad,
for this too will pass.