RE: ASM - remote access via listener and sql

From: Luca Canali <Luca.Canali_at_cern.ch>
Date: Wed, 31 Oct 2007 09:19:24 +0100
Message-ID: <B18EB20A5208EB4DBE0DD2412549861C8BA01B@cernxchg47.cern.ch>

ASM instances appear with a blocked status from the 'lsnrctl services' command (see below). To remotely access a 'blocked service' you need to add (UR=A) to the tns connect string (plus you will need a password file for the asm instance).

Tnsnames.ora entry:

ASM1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = [hostname])(PORT = [portN]))
(CONNECT_DATA =

      (SERVER = DEDICATED) (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)
      (UR=A)
    ) )

$ lsnrctl services listener_mynodename

<...>
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service... Handler(s):

      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER

Cheers,
L.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Crisler, Jon Sent: Tuesday, October 30, 2007 7:09 PM
To: oracle-l_at_freelists.org
Subject: ASM - remote access via listener and sql

We are trying to write some monitoring tools to check the health of ASMin doing a routine install of RAC using ASM on IBM AIX, I find that no listener / tnsnames config is done for the ASM instance.

Can ASM be accessed remotely ? Is there any surprises (other than reduced views) in doing this ? Is it supported ? Thanks in advance.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 31 2007 - 03:19:24 CDT