Link to home
Start Free TrialLog in
Avatar of Perherman
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
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Perherman
Perherman

ASKER

I'll try it
Great! I can now connect via Net Managers test function! Thanks a lot! (Where did you learn all this??)
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 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!
The same to  you!