Oracle DB access through client
Posted on 2014-03-24
I installed Oracle database 11g on Windows Server 2008 R2 Standard edition OS.
But I am not able to access the Oracle database from other machine through Oracle client.
Getting error like "ORA-12541: TNS:no listener".
But am able to connect to the database on the same machine. The listner is also running.
I am able to ping the machine but not able to tnsping the db due to the above error
Earlier It was mentioned that this is a firewall blocking the ports.
If I disable the firewall in the services also am getting the same problem. And to the machine itself I am not able to connect (take remote desktop).
Is there any otherway for this issue for the oracle client connectivity?