Rede Zero instance from Backup Rman

[André Renato]

Environment Information:
* Oracle version: Enterprise 11g
* Operating system: WindonWS 2003 Server X64

Sirs, Next ... I am simulating a recovery a customer.
The environment is Windows 2003 64 bits in VMware that is a backup of the production VM that was stared with on the network with an IP and Host different.

I uninstalled all oracle binary (11g) and installed again.
I need to restore a recent backup (done with RMAN) and return the instance to normality.

I am following more or less this article that I found: http://blog.gilbertoca.com/?p=10
I created the password file:
orapwd file =% oracle_home% \ dbs \ Pwd% oracle_sid% password = password entries = 5

I created TNSNAMES:

Select all

SAP = 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.140.30)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVICE_NAME = SAP) 
) 
)

I created the static listener:

Select all

SID_LIST_LISTENER = 
(SID_LIST = 
(SID_DESC = 
(GLOBAL_DBNAME = BMKSAP) 
(ORACLE_HOME = E:\Oracle_Bin\product\11.1.0\db_1) 
(SID_NAME = SAP) 
) 
) 
 
LISTENER = 
(DESCRIPTION_LIST = 
(DESCRIPTION = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.140.30)(PORT = 1521)) 
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) 
) 
)

However, when it comes time to start SQLPlus to give Startup Nomount with Pfile:

Select all

C:\>set oracle_sid=sap 
 
C:\>set local=sap 
 
C:\>sqlplus "/ as sysdba" 
 
SQL*Plus: Release 11.1.0.7.0 - Production on Qui Jul 8 16:35:49 2010 
 
Copyright © 1982, 2008, Oracle. All rights reserved. 
 
ERROR: 
ORA-12518: TNS:listener nπo pode distribuir conexao cliente

I have already uninstalled and installed Oracle about 3 times, I have already tried to change the host of tnnames And the Listener for the hostname of the machine, I'vê tried the dynamic listener but ... nothing works out.

Does anyone have any recipe to climb this?

[victorhugomuniz]

Select all

 
ORA-12518: TNS:listener could not hand off client connection  
Cause: The process of handing off a client connection to another process failed. 
Action: Turn on listener tracing and re-execute the operation. Verify that the listener and database instance are properly configured for direct handoff. If problem persists, call Oracle Support. 

http://www.dba-oracle.com/sf_ora_12518_ ... ection.htm http://en.glufke.net/oracle/viewtopic.php?t=1055 http://forums.oracle.com/forums/thread. ... dID=514403

[André Renato]

Hugo, I'vê already turned all these posts you quoted.
The problem is, is my procedure correct?
Did I jump any step?

give me a light, so kind of blind enough to hunt something wrong I might have done.

[André Renato]

Galera, I already got the solution.
follows:
http://forums.oracle.com/forums/thread. ... 0&tstart=0
Thanks!

[igor.rmarinho]

Thanks for posting the solution!
I'm good to use as a reference! : D