I have installed Oracle 11g R2 datbase server on Windows server 2008 machine(64 bit).
I could access the database by installing the Toad 11.6 compatible for 64 bit operating system in the same machine. But I am not able to access this database from other client machines which are in the same network. ie I could ping the machine. but I could not be able to tnsping the service address. ie
I added in my tnsnames.ora like below
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(SERVICE_NAME = ORA11)
then I tried tnsping like in my Windows 7 (32 bit) machine like below.
its giving error like below
TNS-12535: TNS:operation timed out
Can anyone please help how can I access the database from other client machines?