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



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

Finn


On 2/26/08, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> 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
>
>
>

Other related posts: