Oracle database connect error

[burzinmk]

I am unable to connect to an Oracle database which is on my machine using SQL* Plus while connected to my company network. I get the error (TNS-12535: TNSperation timed out). But when I remove the network cable, I am able to connect to the same Oracle database. I am also successfully able to TNSPING the Oracle database server with the network cable connected. I am not sure what network security settings need to be modified, if any.

Any help is highly appreciated.

[PAVB]

Tell us about your TNSNAMES entry for your local database, is it pointing to localhost?

[burzinmk]

This was the entry in my TNSNAMES.ORA file

XEL9DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = H1B-6F301-8Y49)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xel9db)
)
)

But I am able to connect when I changed the entry to

XEL9DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xel9db)
)
)

PAVB, Thank you very very much for the hint

[PAVB]

Cool! I'm glad it worked out.