RE: ASM - remote access via listener and sql

From: Crisler, Jon <Jon.Crisler_at_usi.com>
Date: Wed, 31 Oct 2007 16:59:20 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675014FF188@mds3aex08.USIEXCHANGE.COM>

This suggestion fixed my problem- the UR=A parameter was missing, although I had to make minor changes to the tnsnames and listener.ora files.

Thanks Luca !!

-----Original Message-----
From: Luca Canali [mailto:Luca.Canali_at_cern.ch] Sent: Wednesday, October 31, 2007 4:19 AM To: Crisler, Jon; oracle-l_at_freelists.org Subject: RE: ASM - remote access via listener and sql

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 - 15:59:20 CDT