?
Solved

Oracle DB client access

Posted on 2013-11-18
6
Medium Priority
?
472 Views
Last Modified: 2013-11-18
Hi,

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

ORA11 =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = ORA11)
 )
)

then I tried tnsping like in my Windows 7 (32 bit) machine like below.

C:\Users\usr1>tnsping ORA11

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?

Thanks.
0
Comment
Question by:GouthamAnand
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 12

Expert Comment

by:Praveen Kumar Chandrashekatr
ID: 39656188
The tnsnames.ora is configured in your client machines, from the above i see that the host name/ip address  is not proper i.e 127.0.0.1 is not your DB server ip address. So please add your hostname /ip address then try tnsping.
0
 

Author Comment

by:GouthamAnand
ID: 39656251
The above one is a sample one I gave.
But I gave correctly the complete ip address. Also I tried by giving the complete machine name. But both of them not worked. But when I do the same thing for other database its working fine. Problem came for this particular database server on this particular server machine.

Is it something related with the operating system? because only this database is on 64 bit windows operating system. And my client machine and all other databases are in 32 bit operating system.

Also what else I can check otherthan tns entries?

Thanks.
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 39656272
the listener create a log file on the host
> diag\tnslsnr\servername\listenername\trace\listener.log

can you find the entries in that log and the error ?

if the listener.log is too big an option is to delete or rename it.
the listener will recreate a new one if it doesn't exist
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39656285
>>TNS-12535: TNS:operation timed out

99.99% of the time this is a firewall blocking the ports.
0
 
LVL 12

Expert Comment

by:Praveen Kumar Chandrashekatr
ID: 39656296
Yes i totally agree with Slightwv ,please check your firewall settings on database server  and disable it then try.

here is the doc for disable the firewall.

http://technet.microsoft.com/en-us/library/cc766337(v=ws.10).aspx
0
 

Author Closing Comment

by:GouthamAnand
ID: 39658521
Thank you very much.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question