Ora-12535 error message

Posted on 2006-11-03
Last Modified: 2012-08-13
I am getting and ora-12535 error message while I trying to connect to or server out side the  our domain  we tried to ping the machine and was  successful  but we tried tnsping  is give me the same error message listed above.
Question by:Perveen
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 35

Accepted Solution

Raynard7 earned 84 total points
ID: 17870964

This error is ORA-12535:    TNS:operation timed out

Which means effectivley what it says, the requested operation could not be completed within the time out period.
If you read the SQLNET.LOG it should show you what errors were occuring on the server if they were not mentioned in the error message.  If you enable tracing you may also get more information.

This seems to be a server error and you will need to go there to find the cause of the problem.

Assisted Solution

Tayger earned 83 total points
ID: 17875236
Look at the documentation on the secondary errors for possible remedy. See SQLNET.LOG to find secondary error if not provided explicitly. Turn on tracing to gather more information.

If the ping is working fine then possibile causes are ip address conflicts, virtual ip addresses that can be resolved anymore, failed cluster groups or veritas cluster packages, DNS outages, ...

The best way to solve this timeout is to look for any network issues.

Author Comment

ID: 17881250
Hi RayNard7 and Tayger,
Thank you for your quick response.
I have checked on sqlnet.log and the error message I am getting is below.

Fatal NI connect error 12638, connecting to:

      TNS for 32-bit Windows: Version - Production
      Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version - Production
  Time: 02-NOV-2006 12:05:22
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12638
    TNS-12638: Credential retrieval failed
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

I am pretty new in the oracle please advice.
Any help will be appreciate
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!


Assisted Solution

btutt earned 83 total points
ID: 17881740
Remember that if you are outside the domain it is possible that some ports are being blocked. Although normally Oracle will communicate on port 1521 (1526 also) there is a dynamic choosing of the port to initially connect on via the oracle engine, essentially a "handshake" that occurs on any number of WellKnown Ports, and then communication is finally initiated on port 1521.


Expert Comment

ID: 17884553
Was thinking abou tthe same. Any firewall up blocking Oracle services in background?

Expert Comment

ID: 17884671
It is possible to force the Oracle engine to communicate strictly on port 1521. Look at Note:124140.1 and to verify this.

Of course, this would assume that your instance is running on a Windows machine.

LVL 35

Expert Comment

ID: 18040869
I'd suggest a split RayNard7 and Tayger,

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SYbase 4 44
ServiceCenter IR Query Expressions 1 53
How efficient to move databases to Azure? 5 58
C# DataTable (in memory) vs SQL Lookups 4 37
Read about achieving the basic levels of HRIS security in the workplace.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 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