Oracle & Linux Blog

This demo is to show issues during Oracle 11g Database cloning. Oracle Version: 11.2.0.4 Operating System: Oracle Enterprise Linux 6.5 I have two nodes : rac1 ( Catalog Database )  & rac2 ( Target Database ) Target Database Name: DB002 Catalog DB Name: DB001 Catalog TNS service name: SN001 Auxiliary DB Name: clone Auxiliary TNS Service Name: clone Catalog TNS entry:  SN001 =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1621))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = SN001)     )   ) Auxiliary TNS Entry: CLONE =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = rac1.localdomain)(PORT = 1721))     )     (CONNECT_DATA =       (SERVICE_NAME = clone)     )   ) We are going to create the Auxiliary inst...

ORA-12543: TNS:destination host unreachable [oracle@rac2 bin]$tnsping oradb001 TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 30-Nov-2012 01:52:34 Copyright (c) 1997, 2009, Oracle.  All rights reserved. Used parameter files: /oracle/11gdb/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oradb001))) TNS-12543: TNS:destination host unreachable Diagnosis process: ------------------- Please use the oerr utility to get the more information on this error. oracle@rac2 $ oerr ora 12543 12543, 00000, "TNS:destination host unreachable" *Cause: Contact can not be made with remote party. *Action: Make sure the network driver is functioning and the network is up. Solution: --------- Reason : Firewall was enabled on both the servers(rac1 & rac2). ------------------------------------...