Re: Unable to connect to ASM instance

There was a post about this 2-3 months ago. I'm pasting from that post :

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)
   ) )

<...>
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

Finn

On 2/26/08, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:

>
> Hi,
>
> We have a 2 node RAC using ASM on Linux AS4 and is working fine except
> that whenever I am try to connect to ASM instance from client machine or
> Grid control I get the following error:
>
> ORA-12528: TNS:Listener: all appropriate instances are blocking new
> connections
>
> Do I need to configure something or we can only connect to ASM instance
> as "sysdba" user from server machine only?
>
> Thanks
> --Harvinder
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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