#28 Subscripton (Database Change Notification) does not work

[Anonymous]

Hi,

I'm fighting with subscription (DCN);
I'm trying to write a wrapper with Go, but with my 11.2.0.2.0 db even the example does not work:

gthomas@waterhouse:~/src/github.com/tgulacsi/gocilib/tmp$ gcc -o subs -locilib subs.c && ./subs XE tgulacsi tgulacsi
=> Initializing OCILIB in event mode...

=> Connecting to tgulacsi@XE...

=> Creating statement...

=> Creating tables...

=> Registering subscription...

=> Adding queries to be notified...

=> Executing some DDL operation...

=> Executing some DML operation...

=> Droping tables...

=> Disconnecting from DB...

=> Stopping the remote database...

** Error - ORA-12154: TNS:could not resolve the connect identifier specified

=> Starting the remote database...

** Error - ORA-12154: TNS:could not resolve the connect identifier specified

=> Unregistering subscription...

** Error - ORA-29970: Specified registration id does not exist

=> Cleaning up OCILIB resources...

=> Done...

Meanwhile user_change_notification_regs is empty!

Thanks,
Tamás Gulácsi

[Tamás Gulácsi]

I've created an account, if it helps.

[Vincent Rogier]

Hi,

Did you specify a specific port ? DO you have a firewall?

Regards,

Vincent

[Anonymous]

Both (Oracle-XE and the test binary) are running on my laptop, without firewall.

The only modification from the example in the documentation is the
non-fixed login.

Thanks,
Tamás Gulácsi

2014-03-31 19:42 GMT+02:00 Vincent Rogier vince_del_paris@users.sf.net:

Hi,

Did you specify a specific port ? DO you have a firewall?

Regards,

Vincent

---

[bugs:#28] Subscripton (Database Change Notification) does not work

Status: open
Group: v1.0_(example)
Created: Sat Mar 29, 2014 09:42 AM UTC by Anonymous
Last Updated: Sat Mar 29, 2014 07:34 PM UTC
Owner: nobody

Hi,

I'm fighting with subscription (DCN);
I'm trying to write a wrapper with Go, but with my 11.2.0.2.0 db even the
example does not work:

gthomas@waterhouse:~/src/github.com/tgulacsi/gocilib/tmp$ gcc -o subs
-locilib subs.c && ./subs XE tgulacsi tgulacsi
=> Initializing OCILIB in event mode...

=> Connecting to tgulacsi@XE...

=> Creating statement...

=> Creating tables...

=> Registering subscription...

=> Adding queries to be notified...

=> Executing some DDL operation...

=> Executing some DML operation...

=> Droping tables...

=> Disconnecting from DB...

=> Stopping the remote database...

** Error - ORA-12154: TNS:could not resolve the connect identifier specified

=> Starting the remote database...

** Error - ORA-12154: TNS:could not resolve the connect identifier specified

=> Unregistering subscription...

** Error - ORA-29970: Specified registration id does not exist

=> Cleaning up OCILIB resources...

=> Done...

Meanwhile user_change_notification_regs is empty!

Thanks,
Tamás Gulácsi

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/orclib/bugs/28/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Anonymous]

Hi,
I am testing same examples and have same problem. Do you found solution, please let me know. Thanks

[Tamás Gulácsi]

Nope, I don't have a firewall, and Oracle XE is running on the same laptop, as the client.

If you can show a minimal C example, that will help.

[Tamás Gulácsi]

Hi,

I've been able to manage to use DCN - both with OCILIB, and with "raw" OCI: the trick is to try on a properly configure machine with proper (allowing) network.

So on my laptop it still does not work, but at work it does.