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.
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@]
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 SYSASMIf 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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/161195/viewspace-1057162/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/161195/viewspace-1057162/