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

Remote Connection Problem to Oracle, Err Msg ORA-12535

I need a remote ODBC connection to my oracle database through a dialup line. Connection to database works fine on the LAN setup, but switched to Dialup Mode, It does not work. I created different Net Service Names for LAN and Dialup setup with their corresponding IP addresses.

The error encountered was ORA-12535: TNS Operation Time out. Is there additional setting required? What can be the cause of the problem? please help

Thanks,
tony.
0
tonylak
Asked:
tonylak
1 Solution
 
pbybeeCommented:
The network latency on your dialup line is causing TNS to
time out.

In your listener.ora file increase the connect_timeout
parameter it's probably set to 10 seconds, try 20 seconds.

or

Use lsnrctl show connect_timeout, if you don't want to bounce your listener, type set connect_timeout 20
0
 
catherinedevlinCommented:
Sometimes firewall problems cause timeout errors.  If increasing connect_timeout doesn't help, maybe your dialup connection is outside the firewall.  Check with your network people.

0
 
DanRollinsCommented:
Hi tonylak,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. If there is no objection or further activity, I will suggest to:

    Split points between: pbybee and catherinedevlin

tonylak, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will followup.

Please do not accept this comment as an answer!

EXPERTS: Your input for closing recommendations are REQUESTED.
==========
DanRollins -- EE database cleanup volunteer
0
 
MoondancerCommented:
Finalized today.  Points split.
Points for catherinedevlin -> http://www.experts-exchange.com/jsp/qShow.jsp?qid=20313348
Thanks for your help here, Dan.
Moondancer - EE Moderator
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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