I did test Oracle GoldenGate for MongoDB Migrations.
but error is caused when running Create GoldenGate credentials.
All validations are ok.
in step ‘Load Target Database’ is completed. but docker logs have some warnings.
env. is oracle oci instance with oracle linux 9, mongodb 8, autonomous json database.
error list
[08/22 12:58:41.377 SEVERE Thread#207 3cf7da5a-bef1-47c7-bd26-9837aa09735a [path:jobs/B43AFA45-E4F8-4915-BD3D-203EE7412082/actions/start] B43AFA45-E4F8-4915-BD3D-203EE7412082 o.c.g.o.steps.replicate.CreateCredentials lambda$validateAliases$0][CreateCredentials] [validateUserIdAlias] Source alias validation failed: sc49, Error: GoldenGate Microservice Api Connection issue with error message : Connection Exception, java.net.ConnectException: Connection refusedoracle.cloud.ggfe.orchestrator.diag.OrchestratorException: GoldenGate Microservice Api Connection issue with error message : Connection Exception, java.net.ConnectException: Connection refused
[08/22 12:58:56.408 INFO Thread#207 3cf7da5a-bef1-47c7-bd26-9837aa09735a [path:jobs/B43AFA45-E4F8-4915-BD3D-203EE7412082/actions/start] B43AFA45-E4F8-4915-BD3D-203EE7412082 o.c.ggfe.support.JobUpdater updateStatus]updateStatus: stepKey:migrate, Status: FAILED
[08/22 12:58:56.409 INFO Thread#742 o.c.g.api.impl.EventEndpointImpl run]sending subscriberId:414CAAE7-F946-4730-B510-332A3565B13B {
"eventType" : "UPDATE_STATUS",
"stepKey" : "migrate",
"status" : "FAILED"
}
[08/22 12:58:56.411 INFO Thread#742 o.c.g.api.impl.EventEndpointImpl run]sending subscriberId:414CAAE7-F946-4730-B510-332A3565B13B {
"eventType" : "ADD_MESSAGE",
"stepKey" : "migrate",
"message" : {
"code" : "OGGOS-70000",
"severity" : "SEVERE",
"issued" : 1755867536411,
"message" : "Failed at migrate/createCredentials"
}
}
OGGOS-10007 Connection Exception, java.net.ConnectException: Connection refused
OGGOS-70040 GoldenGate Microservice Api Connection issue with error message : Connection Exception, java.net.ConnectException: Connection refused
- logs below is related with Load Target Database step.
[08/22 12:11:50.857 INFO Thread#588 o.c.g.api.impl.EventEndpointImpl run]sending subscriberId:82050302-017C-4241-9524-F626FAD887BF {
"eventType" : "ADD_MESSAGE",
"stepKey" : "migrate/mongoDBRestore",
"message" : {
"severity" : "WARNING",
"issued" : 1755864710856,
"message" : "2025-08-22T12:11:49.844+0000\tpreparing collections to restore from\n2025-08-22T12:11:49.844+0000\tdon't know what to do with file \"/u02/oggf/db_dumps/82050302-017C-4241-9524-F626FAD887BF_source/oplog.json\", skipping...\n2025-08-22T12:11:49.845+0000\treading metadata for sample_guides.planets from /u02/oggf/db_dumps/82050302-017C-4241-9524-F626FAD887BF_source/sample_guides/planets.metadata.json.gz\n2025-08-22T12:11:50.854+0000\tfinished restoring sample_guides.planets (0 documents, 0 failures)\n2025-08-22T12:11:50.854+0000\tFailed: sample_guides.planets: error reading database: (MONGO-3052) Operation listCollections on SAMPLE_GUIDES is not authorized.\n2025-08-22T12:11:50.854+0000\t0 document(s) restored successfully. 0 document(s) failed to restore."
}
}
[08/22 12:12:13.309 INFO Thread#355 d957ef99-76d2-4227-87ac-2649141f6023 [path:jobs/58BF31E1-CEB3-44AE-87AB-7C175E204823/actions/start] 58BF31E1-CEB3-44AE-87AB-7C175E204823 o.c.ggfe.support.JobUpdater updateStatus]updateStatus: stepKey:migrate/createCredentials, Status: FAILED
[08/22 12:12:13.311 INFO Thread#588 o.c.g.api.impl.EventEndpointImpl run]sending subscriberId:82050302-017C-4241-9524-F626FAD887BF {
"eventType" : "UPDATE_STATUS",
"stepKey" : "migrate/createCredentials",
"status" : "FAILED"
}
[08/22 12:12:13.315 INFO Thread#588 o.c.g.api.impl.EventEndpointImpl run]sending subscriberId:82050302-017C-4241-9524-F626FAD887BF {
"eventType" : "ADD_MESSAGE",
"stepKey" : "migrate/createCredentials",
"message" : {
"code" : "OGGOS-10007",
"severity" : "SEVERE",
"cause" : "A connection error occurred while communicating with the service",
"action" : "Ensure the service is running and accessible",
"issued" : 1755864733315,
"message" : "Connection Exception, java.net.ConnectException: Connection refused",
"link" : ""
}
}