imp with network link
Hi All,
Trying to set up impdp to import data from "orcl" db using a network link. But my initial step "tnsping" is failing ;
> tnsping orcl
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.112.138)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
TNS-12543: TNS:destination host unreachable
My source db (orcl)- 11.2.0.1, target (aux) -11.2.0.4
in my target "aux" database, tnsnames.ora>
aux =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.112.139)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aux)
)
)
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.112.138)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)