GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Streams setup for E-Business Suite database

edited Jan 11, 2011 10:27PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
EBS:  12.0.6
DB: 10.2.0.4
OS: HP-UX Itanium


As a proof of concept, we used streams to replicate some tables from EBS database to a cloned EBS database for reporting.  We have no issue setting up streams, but the issue is setting the parameter GOLBAL_NAMES=TRUE.  According to streams requirements, GOLBAL_NAMES must set to true (althought it works without setting it), but setting this parameter will render EBS seeded/existing DB links unusable with ORA-02085.
ORA-02085: database link APPS_TO_APPS.XX.COM connects to DBXX.XX.COM
We cannot change the name of  those EBS seeded database links to the global database name it connect to.  Have anyone setup streams without setting GOLBAL_NAMES=TRUE?  Will Oracle still support our streams setup if this parameter GOLBAL_NAMES=TRUE is not set?

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