RE: BLOCKED STATUS
Date: Thu, 13 Mar 2008 14:54:17 -0600
Message-ID: <006801c8854c$68a6f500$6501a8c0@BHAIRAVIPC01>
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.
Regards,
-Krish
Krish Hariharan
President/Executive Architect, Quasar Database Technologies, LLC
http://www.linkedin.com/in/quasardb
-----Original Message-----
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
Howard,
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.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Svetoslav Gyurov
Sent: Thursday, March 13, 2008 8:30 AM
To: howard.latham_at_gmail.com
Cc: ORACLE-L
Subject: Re: BLOCKED STATUS
Hi Howard,
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