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

Oracle - CONNECT_TIMEOUT

Hello All,

My database runs on 9i.There are remote databases that connected to it.Today all of them are failing to connect because of the error message ora-12535.I increased the CONNECT_TIMEOUT but error still persists.I even set it to zero (0) .tns ping to these remote databases is successful.
Local users connected directly to the Live database don't have this error.What should I do?


Thanks.
0
PillalamarriVenkateswaraRao
Asked:
PillalamarriVenkateswaraRao
  • 3
  • 3
  • 3
  • +1
2 Solutions
 
schwertnerCommented:
Check for firewall between that prevent connections.

Check if the Listener is running:

lsnrctl status
lsnrctl services
0
 
garysadlerCommented:
If you are using shared server connections (MTS) try dedicated server connections.  Less synchronization necessary.
0
 
FayyazCommented:
On the database server try to connect with the TNS entry which is given to clients. If you are not able to connect then there is a problem with Network Layer. Check the listener log files and sqlnet.logs
sqlplus scott@<yourdb>
Note: <yourdb> is a name of TNS entry into your $ORACLE_HOME/network/admin/tnsnames.ora file
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
PillalamarriVenkateswaraRaoAuthor Commented:
Thanks to all,
   We done all the steps you provided. But Getting Connect _ Time Out Error.
Thanks
0
 
FayyazCommented:
what was the results of those steps on database server?
0
 
schwertnerCommented:
Does the Listener runs?

Check

lsnrctl status
lsnrctl services

Has somebody changed the parameter of the network?
Changed Name server, changed default gateway?
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Sorry For the delay in responding,
From SQL Plus it is not going to connect. All the things are ok and TNS Ping is connecting perfectly.
THanks
0
 
FayyazCommented:
you mean with TNS entry it is not able to connect to the database?
May be you can try creating another listener with different port and try. or try to switch the host name from I.P address to hostname and vice versa
 
0
 
schwertnerCommented:
See if the instance is registered by the Listener (I have posted more then enough times how to ensure static registration!).
The check if the instance is known

lsnrctl services

On the server of course!
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
ThanQ Very Much guys. Sorry for the delay in assigning the points.
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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