When registering the extract of a downstream capture, I got the the following error:
GGSCI> register extract EXT_01 database CONTAINER(F900028557DEV2_F) 2018-01-09 04:54:09 ERROR OGG-08221 Cannot register or unregister EXTRACT EXT_02 because of the following SQL error: OCI Error 44,004.
I check the source database's global_name and db_domain and I got the following results:
select * from global_name: GLOBAL_NAME --------------------------------------------- âHC1AABF.900021494.US1.INTERNAL show parameter domain NAME TYPE VALUE ---------------------------------------------- db_domain string
Why do I get this error message?
Answer: Because the db_domain name if null, the domain name portion in the global name starts with a number. This causes the error shown. There are two approached:
â(1) Change the domain name (2)
â(1) Change the domain name (2)
alter system set db_domain='' scope=spfile sid='*';
(2) Change the global_name
For downstream capture, the change has to be done in the source database. It's also suggested to fix in the downstream database.
alter database rename global_name to <newdb_name>.<domain> i.e. alter database rename global_name to HC1AABF.A900021494.US1.INTERNAL;
Resources
- Doc ID 2053567.1: Cannot Register Or Unregister EXTRACT GGEXT1 Because Of The Following SQL Error: OCI Error 44,004