RE: BLOCKED STATUS
Date: Thu, 13 Mar 2008 14:54:17 -0600
This appears to be similar to connecting to an ASM instance remotely. You would have to add the clause below to the tnsnames or you can define it as a static entry (SID_LIST in listener.ora) and connect to the instance.
However, I have always preferred to keep the connection local (connect using / instead of sys/pswd_at_db) when executing a restore.
President/Executive Architect, Quasar Database Technologies, LLC http://www.linkedin.com/in/quasardb
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman
Sent: Thursday, March 13, 2008 11:02 AM
To: softice_at_gmail.com; howard.latham_at_gmail.com Cc: ORACLE-L
Subject: RE: BLOCKED STATUS
Again some additional details would be helpful and I may be stating the obvious. Do you have a password file on the auxiliary server?
What is the error indicating blocked status, is it TNS-12526 or TNS-12527? If so look at Metalink note 444120.1, you may need to add a (UR=A) entry in your tnsnames.ora file. That reolved those errors in my situation.
Univ. of California at Davis
IET Campus Data Center
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Svetoslav Gyurov Sent: Thursday, March 13, 2008 8:30 AM
Subject: Re: BLOCKED STATUS
The target database need to be open and the standby (auxiliary) has to
be in nomount state. Then you issue the following command from the
target database server:
rman target / auxiliary sys_at_standbydb
-- sve Howard Latham wrote:Received on Thu Mar 13 2008 - 15:54:17 CDT
> I;m trying to do an RMAN duplicate database to new host so target db
> is in nomount mode
> trouble is this gives blocked status from sqlnet. I have found stuff
> about dedicated connection in listener but
> it still doesnt seem to work.
> Howard Latham
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l