Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    13

    Unanswered: tnsnames.ora conflict

    Hi all,

    I am unable to login into an instance via sqlplus. i get ora 12154 error while trying the same.

    But, i am able to work in the same instance using toad without any problems.

    I have developer6i installation and oracle workflow installation. so, i have two tnsnames entry one in c:\orant.... and the other in c:\workflow\.....

    I have the same entries in both the tnsnames.ora files.

    Please let me know how i could solve this problem.

    bfn

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Hi sanchapanzo,

    Did you check the entries for the service name in the tnsnames.ora file residing at

    $ORACLE_HOME/network/admin/tnsnames.ora

    Also check the entries for DOMAIN_NAME in the sqlnet.ora file.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Dec 2003
    Posts
    13
    hi hings,

    thanks for your effort but i am unable to file any DOMAIN_NAME entries in the sqlnet.ora found in
    "C:\orant\NET80\ADMIN"

    Awaiting your help.

    bfn

  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Hi,

    It is NAMES.DEFAULT_NAME. It defaults to world.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

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