Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
troubleshooting Change Notification Registrations?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  1 message - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Mark Harrison  
View profile  
 More options Oct 28, 5:17 pm
Newsgroups: comp.databases.oracle.misc
From: Mark Harrison <m...@pixar.com>
Date: Wed, 28 Oct 2009 14:17:21 -0700
Local: Wed, Oct 28 2009 5:17 pm
Subject: troubleshooting Change Notification Registrations?
I've got a program that uses OCI Change Notification callbacks.

On my test system, everything works perfectly... I get a callback
every time I modify my table.

On my production system, I never get a callback.

An odd thing I've noticed:  when running

     SELECT CALLBACK FROM USER_CHANGE_NOTIFICATION_REGS

on my working test system, the callback HOST= points to my
client computer.  This makes intuitive sense, since it's a
registration for a callback.

   (46, 4, 'net8://(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.252.1)(PORT=49406))?PR=0',
    0, 0, 1800, 'MH.CBDEMO')
   # 172.16.252.1 = client box

On my busted production system, the callback HOST= string
points to the database server.

   (271, 4, 'net8://(ADDRESS=(PROTOCOL=tcp)(HOST=138.72.249.167)(PORT=50966))?PR=0',
    0, 0, 1800, 'MH.CBDEMO')
   # 138.72.249.167 = database node

So, two questions:

1.  Is it the case that HOST= should always point to the
     client machine?

2.  What's the best way to troubleshoot a problem with
     change notifications like this?

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google