GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate 12.3 Can't Get Downstream Log Shipping to Work Getting ORA-03135: connection lost contact

in GoldenGate, Streams and Distributed Database (MOSC)

Created EXTRACT on downstream mining database for newly restored Oracle 12.2.0.1 database. We can write archived redo logs to a nfs drive using log_archive_dest_3 LOCATION= ... and them manually register the logs on the mining database but we can't get log shipping to work. Using log_archive_dest_5 SERVICE=connect alias ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=10 TEMPLATE=/same nfs drive /downstream/sourcedb_arch_%t_%s_%r.log DB_UNIQUE_NAME=sourcedb we consistently get ORA-03135: connection lost contact. Maybe 1 or two logs out of 10 get through. dba_registered_archived_log is full of file names for log files that don't exist downstream. Any ideas what the problem might be?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center