English

Error: Connecting to ORACLE returns an "ORA-02700" message

Solution or Workaround

What causes an "ORA-02700" message when attempting to connect to Oracle from
ArcInfo?

Answer:

Environment variables may not have been set, or Oracle didn't understand an
abbreviated command.

Environment variables need to be set:

ORACLE_HOME - if this isn't set, you get ora-02701
ORACLE_SID - if this isn't set, you get ora-02700

Use the full connection syntax:
connect oracle user/password@T:server:oracle_sid