GouthamAnand
asked on
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.
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.
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.
ASKER
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.
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.
the listener create a log file on the host
> diag\tnslsnr\servername\li stenername \trace\lis tener.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
> diag\tnslsnr\servername\li
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
here is the doc for disable the firewall.
http://technet.microsoft.com/en-us/library/cc766337(v=ws.10).aspx
ASKER
Thank you very much.