Is This Content Helpful?
We're glad to know this article was helpful.
What causes an "ORA-02700" message when attempting to connect to Oracle from
Environment variables may not have been set, or Oracle didn't understand an
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