ORA-12543: TNS:destination host unreachable
Hi,
I have oracle installed on my local machine . And when I try to connect, it gives me host un reachable error. tnsping works but when i try to connect here is a what i get
C:\Documents and Settings\feroz>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-APR-2011 17:35:32
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\feroz\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = BUSINESSOBJECTS.isi.edu)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
OK (30 msec)
C:\Documents and Settings\feroz>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 6 17:37:38 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect scott/tiger@orcl
ERROR:
ORA-12543: TNS:destination host unreachable
SQL>
Here is the tnsnames.ora and listner.ora file entry for orcl in C:\app\feroz\product\11.2.0\dbhome_1\NETWORK\ADMIN
listner.ora entry :
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = BUSINESSOBJECTS.isi.edu)(PORT = 1521))
)
tnsnames.ora entry :
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = BUSINESSOBJECTS.isi.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
any suggestions :
thanks