Use the Oracle client to remotely access the ASM instance

When configuring Goldengate, we need to connect to the ASM instance. The configuration method is as follows: Oracle10gRAC: add the listener. ora file to the two local RAC nodes

When configuring Goldengate, we need to connect to the ASM instance. The configuration method is as follows: Oracle 10g RAC method: add the listener. ora file to the two local RAC nodes

When configuring Goldengate, we need to connect to the ASM instance. The configuration method is as follows:
Oracle 10g RAC method:
Add the following to the listener. ora file on two local RAC nodes:
RAC1 node:
(SID_DESC =
(GLOBAL_NAME = ASM)
(ORACLE_HOME =/oracle/app/product/10.2.0/db_1)
(SID_NAME = + ASM1)
)
)
RAC2 node:
(SID_DESC =
(GLOBAL_NAME = ASM)
(ORACLE_HOME =/oracle/app/product/10.2.0/db_1)
(SID_NAME = + ASM2)
)
)
Add the following content to the tnsnames. ora file of two local RAC nodes and remote clients:
ASM2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.12) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASM)
(INSTANCE_NAME = + ASM2)
(UR =)
)
)
ASM1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.11) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASM)
(INSTANCE_NAME = + ASM1)
(UR =)
)
)

Then restart the listener and remotely test the connection:

[Oracle @ target ~] $ Sqlplus "/as sysdba"
SQL * Plus: Release 10.2.0.4.0-Production on Wed Oct 19 05:17:20 2011
Copyright (c) 1982,200 7, Oracle. All Rights Reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> connsys/sys @ asm1 as sysdba;
Connected.

For more information about Oracle, see the Oracle topic page? Tid = 12