1 2 3 4 5 6 Previous Next 84 Replies Latest reply on Aug 4, 2010 1:51 PM by rajeysh Go to original post
      • 30. Re: ORA-12154: TNS:could not resolve the connect identifier specified
        458162
        hi Yonan,
        Thanks for your reply. Then seems to be its not the problem of listener.ora as from other machines we are able to access the database.
        I created the tnsnames.ora file on my machine using net Configuration assistant and oracle version is 10g ..and just would like to let you know the same tnsnames.ora entry works from another machine .. is there any other thing I am missing ..

        looking fwd to ur response and more ideas
        • 31. Re: ORA-12154: TNS:could not resolve the connect identifier specified
          376714
          What is the error message you get?

          Try:
          ping hostname
          tnsping alias
          sqlplus "user/pass@alias"
          And let me know the error messages.

          Regards,

          Yoann.
          • 32. Re: ORA-12154: TNS:could not resolve the connect identifier specified
            458162
            I think seems to be problem with registry entries as I added that and its working for me now .. cheerss
            • 33. Re: ORA-12154: TNS:could not resolve the connect identifier specified
              460101
              I am having this same issue, I can not login to SQLplus. Any help would be great.

              SERVICEW =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
              (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = serviceworxs)
              )
              )

              EXTPROC_CONNECTION_DATA =
              (DESCRIPTION =
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
              )
              (CONNECT_DATA =
              (SID = PLSExtProc)
              (PRESENTATION = RO)
              )
              )
              • 34. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                8734
                Hi
                It could be due to firewall or @ in password or ..
                You need to perform certain tests.
                1. Try TNSPING yourconnectstring . What do you get?
                2. Check if you have multiple copies of TNSNAMES.ORA and make sure that the entries are correct in all.
                Rgds
                Adnan
                • 35. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                  463301
                  I think seems to be problem with registry entries as
                  I added that and its working for me now .. cheerss
                  I'm still having this problem. Could you please specify which registry entries you changed and how?

                  Thanks,

                  Robin
                  • 36. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                    462711
                    amashhadi,

                    I was with the same problem.

                    THANKS for your help!!!! Option 2 has solved my problem.

                    user460298,

                    Copy TNSNAMES.ORA (server side) and paste on client side.

                    Regards.
                    Flávio Aquino.
                    • 37. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                      8734
                      Flávio

                      Glad your issue is resolved. ;-)

                      Rgds
                      Adnan
                      • 38. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                        464312
                        How many Oracle homes do you have? The reason why I ask is that you say you have installed more than once. I have picked up problems on Windows 2000 server before because the services are running, but its pointing to an instance that doesn't exist anymore.
                        Make sure that your listener is pointing to the correct database.
                        Via a command prompt, just do a lsnrctl status, see what it shows, and do a tnsping, it should look like this if you can get to your database:

                        Microsoft Windows XP [Version 5.1.2600]
                        (C) Copyright 1985-2001 Microsoft Corp.

                        C:\Documents and Settings\clintonn.JHBMEB>tnsping trinity

                        TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 02-NOV-20
                        05 12:43:51

                        Copyright (c) 1997 Oracle Corporation. All rights reserved.

                        Used parameter files:


                        Used TNSNAMES adapter to resolve the alias
                        Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
                        (HOST = meb01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = trinity)))
                        OK (420 msec)

                        Go into your correct Oracle home if this doesn't work and recreate your listener...
                        • 39. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                          465579
                          how i connect my database.tns could bot resolve error is comming
                          • 40. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                            495468
                            Hi,
                            I have tried almost all solutions listed about this error on this forum but cannot resolve my problem. i can login through SQl+ but login fails when i try it through application. I have tried changing registry and tnsnames.ora. Please help me to cure ORA-12154: TNS:could not resolve service name error.

                            Thanks,
                            Suaid
                            • 41. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                              495468
                              Hi,
                              I have tried almost all solutions listed about this error on this forum but cannot resolve my problem. i can login through SQl+ but login fails when i try it through application. I have tried changing registry and tnsnames.ora. Please help me to cure ORA-12154: TNS:could not resolve service name error. I also oracle Oracle8i installed on my machine but default is set to oracle 10g.

                              Thanks,
                              Suaid

                              Message was edited by:
                              user492465
                              • 42. ora-12154 error
                                508936
                                Friends,

                                I am getting ora-12154 error when connecting from client mechine to DB
                                server. Database server is on Windows XP mechine and client is on Windows 2000 professional.

                                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

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



                                I am trying to connect like this

                                C:> sqlplus u2/u2@tomat

                                Then it is giving error

                                What will be the problem? Plz help me
                                • 43. Re: ORA-12154: TNS:could not resolve the connect identifier specified
                                  508936
                                  Friends,

                                  I am getting ora-12154 error when connecting from client mechine to DB
                                  server. Database server is on Windows XP mechine and client is on Windows 2000 professional.

                                  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)
                                  )
                                  )



                                  I am trying to connect like this

                                  C:> sqlplus u2/u2@tomat

                                  Then it is giving error

                                  What will be the problem? Plz help me
                                  • 44. ORA-12154    error plz help me
                                    508936
                                    Friends,

                                    I am getting ora-12154 error when connecting from client mechine to DB
                                    server. Database server is on Windows XP mechine and client is on Windows 2000 professional.

                                    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)
                                    )
                                    )



                                    I am trying to connect like this

                                    C:> sqlplus u2/u2@tomat

                                    Then it is giving error

                                    What will be the problem? Plz help me