Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id B17391960293 for ; Thu, 8 Aug 2013 23:27:15 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Thu, 8 Aug 2013 23:27:15 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43C6C245AC; Thu, 8 Aug 2013 17:27:14 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@gmail.com; dkim-adsp=none (insecure policy) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 3SPBprB3C6+d; Thu, 8 Aug 2013 17:27:14 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0CD3B24572; Thu, 8 Aug 2013 17:26:33 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 08 Aug 2013 17:25:52 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CC51A2454E for ; Thu, 8 Aug 2013 17:25:51 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id TO0FFhimsMtT for ; Thu, 8 Aug 2013 17:25:51 -0400 (EDT) Received: from mail-la0-f47.google.com (mail-la0-f47.google.com [209.85.215.47]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A40A2454A for ; Thu, 8 Aug 2013 17:25:48 -0400 (EDT) Received: by mail-la0-f47.google.com with SMTP id eo20so2525322lab.34 for ; Thu, 08 Aug 2013 14:25:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=8zFBXYxCz0yFfiwjdwbEtyxSqFSw8NdrIokAVBp9CX4=; b=k4InrryKY1sKuZ24vbhAe/plN5O0kSjwg62hTQ0VslboP7kfHXqbOpx+ppk0GZhf3k DX6dUExn4lKPL+258HSGdNBaeOb8QmsZzArBLEPLnLCMVNo9B1z9wqEJdOR3kMWpzObG Z5r0WZ7X7pZwuVDl0fveoym24dJRZpoO1d7fVk9chbV8uex5T1/QbpWrngs/SXfq39S3 oZMykeMD74yGhdjIvoC+aiyCg7YHhyWMtYvBl5kk+Kc2DC/vmHWx6KVEZzM1HHWIXQW5 vYGR8gzMSn3vMfCuSsvNoXHhOK7Qt+j35tAgbx5O5H9SQc1FmfgIxDeKX1XFLHtYLFur zSTQ== MIME-Version: 1.0 X-Received: by 10.112.51.166 with SMTP id l6mr2340607lbo.5.1375997148098; Thu, 08 Aug 2013 14:25:48 -0700 (PDT) Received: by 10.112.145.40 with HTTP; Thu, 8 Aug 2013 14:25:47 -0700 (PDT) Date: Thu, 8 Aug 2013 16:25:47 -0500 Message-ID: Subject: RAC Restore - Listener "Blocked" From: David Barbour To: oracle-l mailing list Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 50140 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: david.barbour1@gmail.com Precedence: normal Reply-To: david.barbour1@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l 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