ITPub博客

首页 > 数据库 > Oracle > How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]

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

原创 Oracle 作者:msdnchina 时间:2012-01-18 15:00:37 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1393654