Win remote ASM instance in Linux
I. Windows ASM instances in remote Linux
1. Listener files in Linux
[Grid @ myrac1 admin] $ cat listener. ora
# Listener. ora Network Configuration File:/g01/app/grid/product/11.2.0/grid/network/admin/listener. ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = myrac1) (PORT = 1521 ))
)
)
ADR_BASE_LISTENER =/g01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON # line added by Agent
2. Listener status
[Grid @ myrac1 admin] $ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0-Production on 23-FEB-2014 05:48:20
Copyright (c) 1991,200 9, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0-Production
Start Date 23-FEB-2014 05:37:13
Uptime 0 days 0 hr. 11 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/g01/app/grid/product/11.2.0/grid/network/admin/listener. ora
Listener Log File/g01/app/grid/diag/tnslsnr/myrac1/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = myrac1) (PORT = 1521 )))
Services Summary...
Service "+ ASM" has 1 instance (s ).
Instance "+ ASM", status READY, has 1 handler (s) for this service...
Service "hjj" has 1 instance (s ).
Instance "hjj", status READY, has 1 handler (s) for this service...
Service "hjjXDB" has 1 instance (s ).
Instance "hjj", status READY, has 1 handler (s) for this service...
The command completed successfully
3. Add the following content to the tns file of the win client:
LIN_ASM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.171) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = + ASM)
(INSTANCE_NAME = + ASM)
)
)
4. Test in win
C: \ Users \ Administrator> tnsping lin_asm
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0-Production on 23-FEB-2014 21:52:49
Copyright (c) 1997,201 0, Oracle. All rights reserved.
Used parameter files:
C: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ sqlnet. ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.171) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = + ASM) (INSTANCE_NAME = + ASM )))
OK (360 msec)
C: \> sqlplus sys/oracle @ lin_asm as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Sun Feb 23 21:55:11 2014
Copyright (c) 1982,201 0, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Automatic Storage Management option
SQL> select instance_name, host_name, version, status from v $ instance;
INSTANCE_NAME HOST_NAME VERSION STATUS
----------------------------------------------------------------------------------------------------------------------
+ ASM myrac1.oracle.com 11.2.0.1.0 STARTED
In addition, in the blog of Fei Zong, we mentioned UR = A, A parameter used for asm remote access. I installed oracle11gR2 in both Windows and linux, in the test, all the dynamic listeners without UR = A can be remotely accessed.