DevOps, CI/CD and Automation

Hi,

I'm trying to set up DCN events from the python script, using cx_Oracle.  I'm getting the following error when trying to subscribe to table changes:

subscriptionInsDel = con.subscribe(callback = DCNCallback, operations = cx_Oracle.OPCODE_INSERT | cx_Oracle.OPCODE_DELETE, rowids = True)

cx_Oracle.DatabaseError: ORA-29972: user does not have privilege to change/ create registration

It seems that connection was established succesfully as I am able to read data from my table. cur.execute('select * from mytab') works fine. But when it comes to con.subscribe(), the error above appears.

Do I need to specify any aditional grants?

Or something wrong with how I use the syntax of con.subscribe() ?

os: Linux 6.5

python: 2.6.6

cx_Oracle: 5.2.1

db oracle: 12.1.0.2.0

Here is the code:

import cx_Oracle
def DCNCallback(message): 
    print "Notification:" 
    for tab in message.tables: 
        print "Table:", tab.name
        for row in tab.rows: 
            if row.operation & cx_Oracle.OPCODE_INSERT: 
                print "INSERT of rowid:", row.rowid
            if row.operation & cx_Oracle.OPCODE_DELETE: 
                print "DELETE of rowid:", row.rowid
host = 'myhost'
port = '1521'
dbase = 'mydb'
login = 'myuser'
password = 'mypassword'
dsn = cx_Oracle.makedsn(host, port, dbase)
con = cx_Oracle.connect(login, password, dsn, events = True)
cur = con.cursor()
cur.execute('select * from mytab')
for result in cur:
    print result
cur.close()
subscriptionInsDel = con.subscribe(callback = DCNCallback, operations = cx_Oracle.OPCODE_INSERT | cx_Oracle.OPCODE_DELETE, rowids = True)

Thanks in advance!