RE: BLOCKED STATUS

To be fair, I went looking for it and could not find the reversal. However, I do expect that I will come across it again someday. Meanwhile it is one of those DBA days and so only have time to pass along this quick addendum.  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Joel.Patterson_at_crowley.com
Sent: Thursday, March 13, 2008 11:57 AM
To: JHostetter_at_decommunications.com; howard.latham_at_gmail.com; oracle-l_at_freelists.org
Subject: RE: BLOCKED STATUS  

I agree, and if I remember right, Robert Freeman reversed them in his lastest RMAN book (10g).  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hostetter, Jay M
Sent: Thursday, March 13, 2008 11:32 AM
To: howard.latham_at_gmail.com; ORACLE-L
Subject: RE: BLOCKED STATUS

Howard,  

  I find the rman parameter nomenclature confusing when duplicating a database. TARGET is the database from which you are duplicating (normally a production database in my case). AUXILIARY is the database to which you are copying (in my mind, the real target). The auxiliary must be started up in nomount mode.  

Jay  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham
Sent: Thursday, March 13, 2008 10:30 AM
To: ORACLE-L
Subject: BLOCKED STATUS

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

**DISCLAIMER This e-mail message and any files transmitted with it are
intended for the use of the individual or entity to which they are
addressed and may contain information that is privileged, proprietary
and confidential. If you are not the intended recipient, you may not
use, copy or disclose to anyone the message or any information contained
in the message. If you have received this communication in error, please
notify the sender and delete this e-mail message. The contents do not
represent the opinion of D&E except to the extent that it relates to
their official business.


--
http://www.freelists.org/webpage/oracle-l