CODEWITHSUNDEEP
oracle-databasenotificationsotl
charisMao
charisMao

Reputation: 99

When use Change Notification interface, the ORA-24912: Listener thread failed. Listen failed error occur?

When I try to run the demo program to verify that the interface is right or not of Oracle Change Notification via otl_subscriber from the website: http://otl.sourceforge.net/otl4_ex585.htm.

I got the errors as below:

ORA-24912: Listener thread failed. Listen failed!

And after I search google, I got:"The client needs to be restarted." But I don't know which client needs to be restarted? The Oracle SQL Developer or any other clients?

I almost never revise the demo program, If I comment the segment as below:

//subs.subscribe();
//subs.subscribe();

the program works fine, and I can insert or drop tables.

From the beginning of the program, I learned that "The required 'change notification' privilege can be set by "grant change notification to scott" by the DBA."

Until now, I have no DBA privilege, Does the ORA-24912 bugs related with the DBA privilege?

Upvotes: 0

Views: 1511

Answers (1)

Kirs Sudh
Kirs Sudh

Reputation: 298

if you have installed then you might find some services pertaining to oracle. stop all service, start one by one again and check.

The client which the oracle is referring is a oracle db client supports to interfere with users through their dedicated protocols.

You will find even the client services under Services modules.

Upvotes: 0

Related Questions