PROBLEM

Can't connect locally to Oracle 10g on HP TRU64 UNIX

Last Published: April 25, 2020

Description

There are problems connecting locally to Oracle 10g on HP TRU64 UNIX.

Cause

An HP TRU64 UNIX platform-specific Oracle 10g bug prevents any Oracle user but "sys" to establish a local connection. The Oracle bug number is 3616023, the Oracle version affected is 10.1.0.2.0. The error message is:

"ORA-12547 (TNS:lost contact)"

Solution or Workaround

There are a number of workarounds for this problem:
  • Use ArcSDE direct connect from a remote machine.
  • Put ArcSDE application server on a remote machine and point it to Oracle on the HP TRU64 server.
  • Put ArcSDE and Oracle on same machine and set TWO_TASK Unix environment variable to the Oracle database service-name.

Article ID:000007530

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic