Wednesday, January 30, 2008

Connecting to ASM remotely

Configure the listener.ora


SID_LIST_LISTENER_LINUX1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(SID_NAME = +ASM1)
(ORACLE_HOME = /opt/oracle/app/oracle/product/10.2.0/db_1)
)
)


Add a tnsnames.ora entry


ASM1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = +ASM)
(UR = A)
)
)


How to connect to ASM instance from a remote client (Oracle Net) [ID 340277.1]