DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 6, 2017

Cannot register or unregister EXTRACT TEST because of the following SQL error: OCI Error 44,004

GGSCI (goldengate as ggadmin@DB1) 2> register extract test database
ERROR: Cannot register or unregister EXTRACT TEST because of the following SQL error: OCI Error 44,004
Analysis

1.The first test that you have to do is to control the global name of database.

SQL> SELECT * FROM global_name;

GLOBAL_NAME
------------------------------
DB1.IT.DBI-SERVICES.COM

2.The second test is to control the domain name.

SQL> show parameter db_domain

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_domain                            string      it.dbi-services.com

The problem comes from the character “-” in the domain name. GoldenGate doesn’t support this character.
You must change your domain name to use the integrated capture mode.
Solution

SQL> alter system set db_domain='it.dbi.services.com' scope=spfile;

System altered.

And for the global name :

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO DB1.IT.DBI.SERVICES.COM;

Database altered.

3.Now the database must be restarted to apply the changes.
After that it is possible to register an extract.

GGSCI (srvoracle) 1> dblogin useridalias ggadmin
Successfully logged into database.

GGSCI (srvoracle as ggadmin@DB1) 2> register extract test database
Extract TEST successfully registered with database at SCN 773304.

No comments: