• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2420
  • Last Modified:

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
0
Perherman
Asked:
Perherman
  • 5
  • 3
1 Solution
 
schwertnerCommented:
This is the typical 10g trap.

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Thats all.
0
 
PerhermanAuthor Commented:
I'll try it
0
 
PerhermanAuthor Commented:
Great! I can now connect via Net Managers test function! Thanks a lot! (Where did you learn all this??)
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
PerhermanAuthor Commented:
I had to change the connection type to Shared Server (it was first Dedicated Server)
0
 
schwertnerCommented:
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?
0
 
PerhermanAuthor Commented:
I am from Sweden, and work as a consultant with membership and subscription systems. From your name I guess you are from Germany?
0
 
schwertnerCommented:
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!
0
 
PerhermanAuthor Commented:
The same to  you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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