Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: sqlplus tns errors ORA-12154

    I have Oracle 9.2 client installed on my Windows XP workstation and can connect to the Oracle databases on remote server with the Oracle Enterprise Manager software. However, when I attempt to connect to Oracle via SQL*Plus or via Quest TOAD software, I keep getting TNS Oracle errors ORA-12154. I have the Oracle tnsnames.ora file on my local machine and need help. How can I resolve this issue so that I can access the remote Oracle databases with SQL*Plus and TOAD without getting these TNS errors? Thanks.

    Scott

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Try looking at Metalink Note# 114085.1
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    May 2003
    Posts
    369

    Thanks! Had to remove names_domain from sqlnet.ora

    Thanks a million! Had to remove the entry for names.default_domain=world from my sqlnet.ora file on the windows client workstation. Now all works fine.

    Regards
    Scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •