Perherman
asked on
Connectin to a remote computer with Oracle via internet, Error: ORA-12535: TNS:operation timed out
I am trying to connect to another computer with Oracle 10G, via internet.
I have defined a local service name, SRM, with the remote IP adress (which is a router/firewall), and port 1521.
When i issue the commande TNSPING SRM I get a successfull reply: Ok, (100 msek), but when I test the service using Oracle Net manager I get the error: ORA-12535: TNS:operation timed out, and the same if I try to connect to the database using my application (which is what I want).
Any suggesttions?
Thanks
Per-Olof
I have defined a local service name, SRM, with the remote IP adress (which is a router/firewall), and port 1521.
When i issue the commande TNSPING SRM I get a successfull reply: Ok, (100 msek), but when I test the service using Oracle Net manager I get the error: ORA-12535: TNS:operation timed out, and the same if I try to connect to the database using my application (which is what I want).
Any suggesttions?
Thanks
Per-Olof
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great! I can now connect via Net Managers test function! Thanks a lot! (Where did you learn all this??)
ASKER
I had to change the connection type to Shared Server (it was first Dedicated Server)
I have installed two 10g instances for selfeducational purposes.
I suffered from the same issue days before I found the solution.
And where are you from?
I suffered from the same issue days before I found the solution.
And where are you from?
ASKER
I am from Sweden, and work as a consultant with membership and subscription systems. From your name I guess you are from Germany?
I have German name and my father is German, but I was born and am living in Bulgaria, Eastern Europe. See my Profile.
Nice to meet you!
Nice to meet you!
ASKER
The same to you!
ASKER