Re: Unable to connect to ASM instance
Date: Tue, 26 Feb 2008 11:16:44 -0500
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).
(ADDRESS = (PROTOCOL = TCP)(HOST = [hostname])(PORT = [portN]))
(SERVER = DEDICATED) (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)
$ 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
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 > > >Received on Tue Feb 26 2008 - 10:16:44 CST