Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

Oracle DB client access

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
GouthamAnand
Asked:
GouthamAnand
1 Solution
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
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
 
GouthamAnandAuthor Commented:
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
 
Geert GruwezOracle dbaCommented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
slightwv (䄆 Netminder) Commented:
>>TNS-12535: TNS:operation timed out

99.99% of the time this is a firewall blocking the ports.
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
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
 
GouthamAnandAuthor Commented:
Thank you very much.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now