Re: RAC Restore - Listener "Blocked"

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=)(PORT=1521))
>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)(HOST=175.1.2.225)(PORT=1521)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=175.1.2.226)(PORT=1521)))
>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