Printable View
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: TNS:operation 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.
Tell us about your TNSNAMES entry for your local database, is it pointing to localhost?
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
Cool! I'm glad it worked out.