Error while trying to retrieve text for error ORA-12154

Posted on 2005-04-26
Last Modified: 2012-05-05
I have a problem in a client application which began occurring after an Oracle database installed Oracle 8.1.7.  Once the software installation has completed, to configure the Oracle Net8 client then the installer freezes at this point of the installation. when i try to configure Net8 manually it's not show up ( not working). so, what i gonna do? i cannot use application client i.e : toad, etc. plzz help me..

Any pointers would be greatly appreciated...


Question by:HERBET
    LVL 3

    Expert Comment

    try for a client update or uninstall and try to reinstall the client software..
    LVL 11

    Accepted Solution

    ORA-12154: TNS:could not resolve the connect identifier specified
    Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.
    Action: - If you are using local naming (TNSNAMES.ORA file):- Make sure that &quo;TNSNAMES&quo; is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)- Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.- Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.- Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.- If you are using directory naming:- Verify that &quo;LDAP&quo; is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).- Verify that the LDAP directory server is up and that it is accessible.- Verify that the net service name or database name used as the connect identifier is configured in the directory.- Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier- If you are using easy connect naming:- Verify that &quo;EZCONNECT&quo; is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).- Make sure the host, port and service name specified are correct.- Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.

    So check your tnsnames.ora file, for the connection string details you are ussing to connect to your server.
    LVL 4

    Expert Comment

    Hi HERBET,

      if you are using a windows system please go to the directory where oralce is installed.Under which go to network\admin. There you will find two files called tnsname.ora and sqlnet.ora.If you want to do a client configuration you have to edit this file(if you cannot use the gui tool,gui tools internaly edit these files).

       eg. of path where you can find C:\Oracle\Ora81\network\ADMIN\

      you can find entries like this in tnsnames.ora file.
        (ADDRESS_LIST =
            (ADDRESS =
              (PROTOCOL = TCP)
              (HOST = hostname or IP Address of the target computer)
              (PORT = 1521)
        (CONNECT_DATA = (SID = sidname of your database)

    the connect string can be any string which you use while connecting to the database .

       eg.    connect scott/tiger@connectsting

       the main things you need to specify here is connect string,protocol which you are using(default it will be TCP),Host computer name ie. server name or the IP of the server.Default PORT is enough.
      The next thing you need to define is SID.Here you can specify your database name.

    Once you specify all these details you can save the file.The next step you can open sqlnet.ora file

    Check an entries like these in sqlnet.ora file.    names.directory_path = (TNSNAMES)


        (ADDRESS_LIST =
            (ADDRESS =
              (PROTOCOL = TCP)
              (HOST = kripa)
              (PORT = 1521)
        (CONNECT_DATA = (SID = test)

    in this case my connect string is testdb,i use this connect string while connecting to the host computer name is kripa where oracle server is running.and my database name is test.'

    you can connect to the database  like this.

     sql>connect scott/tiger@testdb

    you can test the connection once you configure this tnsnames.ora using tnsping utility.

     eg.   tnsping testdb

    once its responding you can connect to database.

    Hope this will solve your problem.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Introduction If you are not already aware of what you could use a table with sequential integer values for in SQL, you can read Delimited String Parsing in SQL Server 2005 or later ( by BrandonGalderisi (h…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now