How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]

Goal

How to check ASM login for Oracle Goldengate (OGG) ?


Solution

If ASM is in use, OGG must be able to connect to the ASM server via listener.
The connection can be tested in the following (and other) manners:
sqlplus sys/pwd@ASM1.

Use the following statement to connect locally to an ASM instance using operating system authentication:

sqlplus / AS SYSASM

Use the following statement to connect locally using password authentication:

sqlplus SYS AS SYSASM
If that connection test to the ASM server with sqlplus is responding with 'connected', the connection should be fine.
If the sqlplus connect test to the ASM server fails, open another service request with the DATABASE ASM team to solve the ASM connection issue first.

If there is an issue with the OGG extract, please send the full report file to support.
[@more@]
请使用浏览器的分享功能分享到微信等