Problem: Can't connect locally to Oracle 10g on HP TRU64 UNIX
There are problems connecting locally to Oracle 10g on HP TRU64 UNIX.
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.