Re: RAC Restore - Listener "Blocked"

From: David Barbour <david.barbour1_at_gmail.com>
Date: Thu, 8 Aug 2013 17:36:35 -0500
Message-ID: <CAFH+iffA2=BA_2jyz6MEb38ArAqzWQ2LP9YdFADkF1m6V87h8w_at_mail.gmail.com>

Sorry. I'm trying to restore a database - P00. The database currently runs on a three-node RAC with instances P0001, P0002 & P0003. For the restore, I've set up a RAC which consists of one node. The instance I'm trying to utilize on this node is P0001. Storage is ASM.

You're correct, the database is started in nomount mode. I can't seem to get it to register statically with the scan listener.

Here are the RMAN attempts, the listener.ora file, the endpoints_listener.ora file and the tnsnames.ora file.

RMAN> connect target sys/<password>_at_P0001

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

RMAN> connect target sys/<password>_at_P00

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

RMAN> connect target /

connected to target database: P00 (not mounted)

RMAN> LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line
added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                # line
added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                # line
added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by

Agent

LISTENER_RCHR1P01(DESCRIPTION   (ADDRESS_LIST      (ADDRESS=(PROTOCOL=TCP)(HOST=rchr1p01-vip)(PORT21))


      (ADDRESS=(PROTOCOL=TCP)(HOST5.1.2.225)(PORT21)(IP=FIRST))

   )
)               # line added by Agent

P00   (DESCRIPTION     (ADDRESS = (PROTOCOL = TCP)(HOST = rchr1p-scan.lennoxintl.com)(PORT 1525))
    (CONNECT_DATA       (SERVICE_NAME = P00)


      (GLOBAL_NAME = P00)

      (FAILOVER_MODE                 (TYPE = SELECT)

                (METHOD = BASIC)
        )

    )
  )

P0001   (DESCRIPTION     (ADDRESS = (PROTOCOL = TCP)(HOST = rchr1p-scan.lennoxintl.com)(PORT 1525))
    (CONNECT_DATA       (SERVICE_NAME=P0001)


      (GLOBAL_NAME = P00)

      (FAILOVER_MODE = (TYPE=SELECT)(METHODºSIC))

    )
  )

On Thu, Aug 8, 2013 at 4:55 PM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:

> Hi David,
>
> First, I'm a bit confused by your terminology, as in 'Å trying to restore a
> single node of a RAC instance'.  Not to be a nitpicker, but, to be clear,
> the RAC cluster is made up of multiple nodes, and a node will host a
> single instance of a RAC database.  There is only one database, so, it's
> not clear to me, when doing a restore, how you're restoring a "single
> node".
>
> If you're restoring a controlfile, that control file will be on shared
> storage, and will (should) be visible to all nodes of the RAC cluster.
>
> My next question is, what state is the instance you're trying to connect
> to?  (NOMOUNT? MOUNT? OPEN?)  Since you're restoring the control file, I'm
> guessing that it's in NOMOUNT state.  This would explain the BLOCKED
> status of the listener, if you're relying strictly on dynamic
> registration.
>
> The error you're getting, ORA-12514, means that the service you've
> specified is not recognized by the listener, most likely meaning it's
> either incorrectly specified, or it's specified correctly, but currently
> not recognized because dynamic listener registration hasn't happened yet
> for that service name.  (If, for example, instance is in NOMOUNT state.)
>
> To get to the bottom of the problem, we'll need to see that connect
> information you're providing to RMAN for the 'target' connection.  (Is it
> a SYSDBA connection?)
>
> Also, you could try adding a static service registration in the
> listener.ora.  If you do that, 'lsnrctl status' should report 'UNKNOWN'
> rather than 'BLOCKED', and an appropriately privileged connection (SYSDBA)
> should be able to connect to a NOMOUNT or MOUNT status instance.
>
> Hope that helps,
>
> -Mark
>
> On 8/8/13 5:25 PM, "David Barbour" <david.barbour1_at_gmail.com> wrote:
>
> >Dog Days of Summer.
> >Oracle 11.2.0.3.5 on RHEL 6.3  ASM
> >
> >I'm trying to restore a single node of a RAC instance for DR practice.
> >The
> >controlfile is on tape.  I started the instance in nomount, connected to
> >the target with RMAN, set the DBID, allocated a channel and told it to go
> >out and get the specified controlfile.
> >
> >Here's what I got:
> >
> >RMAN-12001: could not open channel c1
> >RMAN-10008: could not create channel context
> >RMAN-10003: unable to connect to target database
> >ORA-12514: TNS:listener does not currently know of service requested in
> >connect descriptor
> >
> >Okay.  Here's the listener status:
> >
> >Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT21))
> >STATUS of the LISTENER
> >------------------------
> >Alias                     LISTENER
> >Version                   TNSLSNR for Linux: Version 11.2.0.3.0 -
> >Production
> >Start Date                08-AUG-2013 12:00:10
> >Uptime                    0 days 0 hr. 18 min. 57 sec
> >Trace Level               off
> >Security                  ON: Local OS Authentication
> >SNMP                      OFF
> >Listener Parameter File   /oracle/grid/11203/network/admin/listener.ora
> >Listener Log File
> >/opt/oracle/diag/tnslsnr/rchr1p01/listener/alert/log.xml
> >Listening Endpoints Summary...
> >  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
> >  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST5.1.2.225)(PORT21)))
> >  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST5.1.2.226)(PORT21)))
> >Services Summary...
> >Service "+ASM" has 1 instance(s).
> >  Instance "+ASM1", status READY, has 1 handler(s) for this service...
> >Service "P00" has 1 instance(s).
> >  Instance "P0001", status *BLOCKED*, has 1 handler(s) for this service...
> >The command completed successfully
> >
> >I've tried a number of approaches to try to fix this, and none have
> >worked.  Googled and MOS'd.  Even did the (UR=A) thing.  Missing
> >something.
> >  I'm seriously open for ideas here.
> >
> >
> >--
> >http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
>
>
>

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

Received on Fri Aug 09 2013 - 00:36:35 CEST