ora-12154 please help me
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-12154 please help me

  1. #1
    Join Date
    Apr 2006
    Posts
    1

    ora-12154 please help me

    Friends,

    I am getting ora-12154 error when connecting from client mechine(Windows 2000 professional) to DB server(Windows XP mechine).

    I am trying to connect like this from client machine

    C:> sqlplus u2/u2@tomat

    Then error is comming

    ======================
    I can able to connect from Server like this
    C:> sqlplus u2/u2@tomat
    =========================

    My listener configuration

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = d-166)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = MAT)
    (ORACLE_HOME = C:\oracle\ora92)
    (SID_NAME = mat)
    )
    )


    My Service name conf in tnsnames.ora in client side

    TOMAT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = D-166)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = MAT)
    )
    )

    What will be the problem? Plz help me

    regards
    Mathew

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you need to configure the tnsnames.ora file on your client machine, or make sire you are using the right tnsnames.ora file.

    That error means the client doesnt know what you want to connect to

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Does your client-side sqlnet.ora have a line like:
    names.default_domain=mydomain.com


    If so three solutions:
    1) delete that line from sqlnet.ora (I've yet to hear of a case where this is needed)
    2) modify tnsnames.ora to start:
    tomat.mydomain.com = ( . . . . . )
    3) connect with u2/u2@tomat. (note the dot!)
    (I prefer the first option).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Quote Originally Posted by davey23uk
    make sire you are using the right tnsnames.ora file.
    Yes, this can happen if you've multiple oracle homes.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

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



Click Here to Expand Forum to Full Width