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>@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>@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@xxxxxxxxxxxx> 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@xxxxxxxxx> 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. > > > > > >-- > >//www.freelists.org/webpage/oracle-l > > > > > > > > > > > -- //www.freelists.org/webpage/oracle-l