?
Solved

Connectin to a remote computer with Oracle  via internet, Error: ORA-12535: TNS:operation timed out

Posted on 2005-05-17
8
Medium Priority
?
2,390 Views
Last Modified: 2013-12-11
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
Comment
Question by:Perherman
  • 5
  • 3
8 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 14017352
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
 

Author Comment

by:Perherman
ID: 14017524
I'll try it
0
 

Author Comment

by:Perherman
ID: 14017653
Great! I can now connect via Net Managers test function! Thanks a lot! (Where did you learn all this??)
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:Perherman
ID: 14017746
I had to change the connection type to Shared Server (it was first Dedicated Server)
0
 
LVL 48

Expert Comment

by:schwertner
ID: 14017867
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
 

Author Comment

by:Perherman
ID: 14017990
I am from Sweden, and work as a consultant with membership and subscription systems. From your name I guess you are from Germany?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 14018075
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
 

Author Comment

by:Perherman
ID: 14018150
The same to  you!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question