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

msdnchina發表於2012-01-18
ASMOracleGo

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@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/161195/viewspace-1057162/，如需轉載，請註明出處，否則將追究法律責任。

相關文章