Solved

Oracle DB client access

Posted on 2013-11-18
6
450 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
6 Comments
 
LVL 12

Expert Comment

by:praveencpk
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 36

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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:praveencpk
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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.

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now