Sorta OT - Business Objects and Listener Load Balancing

  • From: "Mark Strickland" <strickland.mark@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Sep 2006 09:08:55 -0700

Any Business Objects sites out there?  Last Friday evening, we
modified the tnsnames.ora on the BO windows server to access all three
of our RAC instances rather than one.  BO report jobs started
intermittently running twice.   The tnsnames alias is (identifying
info disguised):

   (ADDRESS = (PROTOCOL = TCP)(HOST = = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = = 1522))
   (ADDRESS = (PROTOCOL = TCP)(HOST = = 1522))
   (LOAD_BALANCE = yes)
       (TYPE = SELECT)
       (METHOD = BASIC)
       (RETRIES = 180)
       (DELAY = 5)

Yesterday, we reverted back to accessing a single instance and all is well. I've pored over the BO trace files and haven't spotted a method to the madness. Only thing I can think of is that maybe BO links the database IP or SID with the report job and when it contacts the database again to check up on the job, it comes in on a different instance from where the job is running and doesn't find the job running where it expects. Any ideas?

Mark Strickland

Other related posts:

  • » Sorta OT - Business Objects and Listener Load Balancing