We are using Replicate log reader to read Oracle logs from ASM. When using ASM, Replicate requires us to specify the ASM connection string and credentials to connect to ASM. This connection string is different from the database connection string specified in the general settings.
We use Oracle GDS to automate management of services and connection strings. However, GDS does not support ASM connection strings. Because of this we are able to automate the generation of Oracle endpoint.
As a result we always have to manually enter the ASM connection string in the Oracle endpoint.
The ASM connection string is generally the physical Exadata host of the database. This could be easily determined by connecting to the database using the connection details in general connection.
Ref:
select SYS_CONTEXT('USERENV', 'SERVER_HOST') as DB_CLUSTER from dual;
I would like to propose an enhancement to use this to derive the ASM connection string. That way if the DB service is migrated in GDS, the ASM connection string can be automatically derived without having the need for manual intervention.
