Forum Stats

  • 3,770,908 Users
  • 2,253,180 Discussions
  • 7,875,653 Comments

Discussions

why this error message

cptkirksh
cptkirksh Member Posts: 83 Red Ribbon

Ok, so i went through and learned the command line way now I am off to Microservices. The initial load worked just fine but now I want to add the extract and the replicat for data. When use the administration server webpage it gives me an error about container DBs. This is an Oracle 18c multitenant DB. Here is the error.

Code:

OGG-08100

Severity:

INFO

Title:

EXTRACT (Integrated) added.

Code:

OGG-08223

Severity:

ERROR

Title:

ERROR: One or more containers must be specified when registering Extract for a container database.

Code:

OGG-08100

Severity:

INFO

Title:

Deleted EXTRACT EXTHR.


Whether I hit create or create and run i get the above error. I have attached my screen shots. Thanks in advance. I now in ggsci I can run the command

register extract <extract_name> database container(<trgt_pdb_name>)


but how do I do that here?


Answers

  • cptkirksh
    cptkirksh Member Posts: 83 Red Ribbon

    I figured it out. It seems that the firewall on my test DB was blocking connections after a reboot.

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    Yes, FIREWALL is one of the cause of the issue. Other causes are,


    --- Missing privileges

    exec dbms_goldengate_auth.grant_admin_privilege('C##GGADMIN',container=>'all')

    Some people miss to give the option container=>all


    --- PDBs are not in OPEN state

    --- GG admin user is not created with C##


    Regards,

    Veera