1 2 3 Previous Next 34 Replies Latest reply: Feb 15, 2013 11:37 AM by sb92075 Go to original post RSS
      • 15. Re: ORA-12154:TNS:could not resolve the connect identifier specified
        Oceaner
        Can you try to set environment variable TNS_ADMIN =C:\app\10017134\product\11.2.0\dbhome_1\network\admin and see if thats work..

        Regards,
        Navneet
        • 16. Re: ORA-12154:TNS:could not resolve the connect identifier specified
          Osama_Mustafa
           TNS-01189: The listener could not authenticate the user
          Are you sure you set your right ORACLE_HOME ????

          Listener Could Not Authenticate User TNS-01189 [ID 297520.1]
          • 17. Re: ORA-12154:TNS:could not resolve the connect identifier specified
            Tshifhiwa
            when i set my ORACLE_HOME=C:\DevSuiteHome

            Edited by: adf009 on 2013/02/15 7:36 PM
            • 18. Re: ORA-12154:TNS:could not resolve the connect identifier specified
              Osama_Mustafa
              if you are using toad like you said , connect directly without tnsnames
              • 19. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                EdStevens
                ADF112 wrote:
                when i set my ORACLE_HOME=C:\DevSuiteHome i get this error
                C:\>sqlplus /nolog
                SP2-1503: Message 1503 not found; product=SQLPlus; facility=SP2
                SP2-0152: ORACLE may not be functioning properly
                Above messages are indicative of ORACLE_HOME not being properly set.
                >
                but when set my ORACLE_HOME=C:\app\10017134\product\11.2.0\dbhome_1 am able to connect

                my PATH is
                C:\>path
                PATH=C:\app\10017134\product\11.2.0\dbhome_1\BIN;C:\DevSuiteHome\jdk\jre\bin\cla
                ssic;C:\DevSuiteHome\jdk\jre\bin;C:\DevSuiteHome\jdk\jre\bin\client;C:\DevSuiteH
                ome\jlib;C:\DevSuiteHome\bin;C:\DevSuiteHome\jre\1.4.2\bin\client;C:\DevSuiteHom
                e\jre\1.4.2\bin;C:\DevSuiteHome;C:\app\10017134\product\11.2.0\dbhome_1;C:\Windo
                ws\System32;C:\Windows;C:\DevSuiteHome\BIN;C:\app\10017134\product\11.2.0\dbhome
                _1\NETWORK\ADMIN

                and my set is
                ALLUSERSPROFILE=C:\ProgramData
                APPDATA=C:\Users\10017134\AppData\Roaming
                CommonProgramFiles=C:\Program Files\Common Files
                CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
                CommonProgramW6432=C:\Program Files\Common Files
                COMPUTERNAME=SRD-WS23042
                ComSpec=C:\Windows\system32\cmd.exe
                FPPUILang=en-US
                FP_NO_HOST_CHECK=NO
                HOMEDRIVE=C:
                HOMEPATH=\Users\10017134
                LOCALAPPDATA=C:\Users\10017134\AppData\Local
                LOGONSERVER=\\SRDVCDW001
                NUMBER_OF_PROCESSORS=4
                OnlineServices=Online Services
                OOBEUILang=en-US
                ORACLE_HOME=C:\app\10017134\product\11.2.0\dbhome_1
                OS=Windows_NT
                Path=C:\app\10017134\product\11.2.0\dbhome_1\BIN;C:\DevSuiteHome\jdk\jre\bin\cla
                ssic;C:\DevSuiteHome\jdk\jre\bin;C:\DevSuiteHome\jdk\jre\bin\client;C:\DevSuiteH
                ome\jlib;C:\DevSuiteHome\bin;C:\DevSuiteHome\jre\1.4.2\bin\client;C:\DevSuiteHom
                e\jre\1.4.2\bin;C:\DevSuiteHome;C:\app\10017134\product\11.2.0\dbhome_1;C:\Windo
                ws\System32;C:\Windows;C:\DevSuiteHome\BIN;C:\app\10017134\product\11.2.0\dbhome
                _1\NETWORK\ADMIN
                PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
                Platform=BPC
                PROCESSOR_ARCHITECTURE=AMD64
                PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
                PROCESSOR_LEVEL=6
                PROCESSOR_REVISION=3a09
                ProgramData=C:\ProgramData
                ProgramFiles=C:\Program Files
                ProgramFiles(x86)=C:\Program Files (x86)
                ProgramW6432=C:\Program Files
                PROMPT=$P$G
                PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
                PTSMInstallPath_X86=c:\Program Files (x86)\Hewlett-Packard\HP ProtectTools Secur
                ity Manager\
                PUBLIC=C:\Users\Public
                SESSIONNAME=Console
                SystemDrive=C:
                SystemRoot=C:\Windows
                TEMP=C:\Users\10017134\AppData\Local\Temp
                TMP=C:\Users\10017134\AppData\Local\Temp
                TNS_Admin=C:\app\10017134\product\11.2.0\dbhome_1\NETWORK\ADMIN
                UATDATA=C:\Windows\SysWOW64\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
                USERDNSDOMAIN=ZA.ASTGROUP.COM
                USERDOMAIN=ASTZA
                USERNAME=10017134
                USERPROFILE=C:\Users\10017134
                windir=C:\Windows
                windows_tracing_flags=3
                windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

                and my error log is
                Started with pid=2388
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.253.14)(PORT=1521)))
                TNS-12545: Connect failed because target host or object does not exist
                What does this message suggest to you???? What does the IP address in your HOST= parameter point to?

                <snip more of same>
                my listener from C:\app\10017134\product\11.2.0\dbhome_1\NETWORK\ADMIN is

                # listener.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                # Generated by Oracle configuration tools.

                SID_LIST_LISTENER =
                (SID_LIST =
                (SID_DESC =
                (SID_NAME = SID)
                (ORACLE_HOME = C:\app\10017134\product\11.2.0\dbhome_1)
                (PROGRAM = extproc)
                (ENVS = "EXTPROC_DLLS=ONLY:C:\app\10017134\product\11.2.0\dbhome_1\bin\oraclr11.dll")
                )
                )

                LISTENER =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
                )
                )

                LISTENER =
                (DESCRIPTION_LIST =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
                )
                )
                Why do you have two LISTENER sections? Would I be correct in assuming HOST=IP is not the actual value in the file, but you have substituted "IP" for the actual IP address? If so, is the actual IP address correct? Does it match it IP address shown in the error messages, which I pointed out above?
                ADR_BASE_LISTENER = C:\app\10017134

                and my tnsname from C:\app\10017134\product\11.2.0\dbhome_1\NETWORK\ADMIN

                # tnsnames.ora Network Configuration File: C:\app\10017134\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
                # Generated by Oracle configuration tools.

                ORACLR_CONNECTION_DATA =
                (DESCRIPTION =
                (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                )
                (CONNECT_DATA =
                (SID = CLRExtProc)
                (PRESENTATION = RO)
                )
                )

                ORCL =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = SID)
                )
                )
                Again, it looks like you masked the actual IP address with the literal "IP". I hope the real file has the real IP address. And I hope you have also masked SERVICE_NAME=, because "SID" is most certainly NOT the correct value.
                DBNAME =
                (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
                (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = DB)
                )
                )

                Edited by: ADF112 on 2012/09/26 9:59 AM
                • 20. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                  sb92075
                  ADF112 wrote:
                  the log error is
                  Started with pid=2564
                  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                  Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.253.14)(PORT=1521)))
                  TNS-12545: Connect failed because target host or object does not exist
                  TNS-12560: TNS:protocol adapter error
                  TNS-00515: Connect failed because target host or object does not exist
                  64-bit Windows Error: 49: Unknown error
                  errors indicate basic OS/Networking mis-configuration.
                  These errors are DIFFERENT from error in this thread Title.
                  Problem & solution are external to Oracle.

                  Since you insist on obfuscating reality in what you post, I won't waste more time trying to discern fact from fiction.

                  You're On Your Own (YOYO)!
                  • 21. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                    Mahmoud_Rabie
                    Dear ADF112

                    Look at this thread
                    sqlplus hr/hr@orcl error

                    It may help you

                    Best Regards
                    Mahmoud Rabie
                    • 22. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                      Tshifhiwa
                      hi when i tnsping MYDB

                      i got this massage

                      TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 28-SEP-2
                      012 09:55:04

                      Copyright (c) 1997, 2010, Oracle. All rights reserved.



                      Used TNSNAMES adapter to resolve the alias
                      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)


                      i got this

                      Edited by: adf009 on 2013/02/15 7:39 PM
                      • 23. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                        Osama_Mustafa
                        You trying to connect to which database orcl or another database ?
                        • 24. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                          Tshifhiwa
                          am trying to connect to another database which is in remoter server. how can i Check that remote database services are currently known by the listener ,because at the moment when i run lsnrctl status am not able to see my remote database

                          now am able to see my remote db services but the status is unknown

                          LSNRCTL> status
                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host.
                          com)(PORT=1521)))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                          ction
                          Start Date 28-SEP-2012 12:08:54
                          Uptime 0 days 0 hr. 2 min. 12 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Listener Parameter File C:\app\00000\product\11.2.0\dbhome_1\network\admin\
                          listener.ora
                          Listener Log File c:\app\00000\diag\tnslsnr\srd-ws23042\listener\aler
                          t\log.xml
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=15
                          21)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
                          Services Summary...
                          Service "SID" has 1 instance(s).
                          Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
                          Service "PLSExtProc" has 1 instance(s).
                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                          Service "ORCL" has 2 instance(s).
                          Instance "orcl", status READY, has 1 handler(s) for this service...
                          Instance "ORCL", status UNKNOWN, has 1 handler(s) for this ser
                          vice...
                          Service "ORCL" has 1 instance(s).
                          Instance "orcl", status READY, has 1 handler(s) for this service...
                          The command completed successfully

                          my log error is

                          Thu Sep 27 12:25:18 2012
                          Create Relation ADR_CONTROL
                          Create Relation ADR_INVALIDATION
                          Create Relation INC_METER_IMPT_DEF
                          Create Relation INC_METER_PK_IMPTS
                          System parameter file is C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                          Log messages written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\alert\log.xml
                          Trace information written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\trace\ora_7708_5708.trc
                          Trace level is currently 0

                          Started with pid=7708
                          Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1522)))
                          TNS-12545: Connect failed because target host or object does not exist
                          TNS-12560: TNS:protocol adapter error
                          TNS-00515: Connect failed because target host or object does not exist
                          64-bit Windows Error: 49: Unknown error
                          Fri Sep 28 11:21:34 2012
                          System parameter file is C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                          Log messages written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\alert\log.xml
                          Trace information written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\trace\ora_4512_5756.trc
                          Trace level is currently 0

                          Started with pid=4512
                          Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1521)))
                          TNS-12545: Connect failed because target host or object does not exist
                          TNS-12560: TNS:protocol adapter error
                          TNS-00515: Connect failed because target host or object does not exist
                          64-bit Windows Error: 49: Unknown error
                          Fri Sep 28 11:22:00 2012
                          System parameter file is C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                          Log messages written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\alert\log.xml
                          Trace information written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\trace\ora_7528_3476.trc
                          Trace level is currently 0

                          Started with pid=7528
                          Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1521)))
                          TNS-12545: Connect failed because target host or object does not exist
                          TNS-12560: TNS:protocol adapter error
                          TNS-00515: Connect failed because target host or object does not exist
                          64-bit Windows Error: 49: Unknown error

                          Edited by: ADF112 on 2012/09/28 12:34 PM

                          Edited by: ADF112 on 2012/09/28 1:11 PM

                          Edited by: ADF112 on 2012/09/28 1:28 PM
                          • 25. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                            Mahmoud_Rabie
                            Dear ADF112,

                            Try to compact your major 3 files concerned with this problem as the following

                            *1) Edit tnsname.ora to be* (The service name is case-sensitive. So, orcl is not as ORCL) (host is the fully qualified computer name or IP)
                            orcl =
                                 (DESCRIPTION =
                                       (ADDRESS_LIST =
                                               (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))
                                       )
                                      (CONNECT_DATA =
                                            (SERVICE_NAME = orcl)
                                       )
                                 )
                            *2) Edit listener.ora to be* (the service name as I said is case-sensitive). Also, make sure about the ORACLE_HOME
                            LISTENER =
                              (DESCRIPTION_LIST =
                                (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))
                                )
                              )
                            SID_LIST_LISTENER =
                              (SID_LIST =
                                (SID_DESC =
                                  (GLOBAL_DBNAME = orcl)
                                  (SID_NAME = orcl)
                                  (ORACLE_HOME = C:\app\10017134\product\11.2.0\dbhome_1)
                                )
                              )
                            ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
                            ADR_BASE_LISTENER = C:\app\10017134
                            *3) Edit sqlnet.ora to be*
                            SQLNET.AUTHENTICATION_SERVICES= (NTS)
                            NAMES.DIRECTORY_PATH= (TNSNAMES)
                            *4) Restart the listener*

                            5) Please, mark the post as helpful or correct if it is so. :)

                            Best Regards
                            Mahmoud
                            • 26. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                              EdStevens
                              ADF112 wrote:
                              am trying to connect to another database which is in remoter server. how can i Check that remote database services are currently known by the listener ,because at the moment when i run lsnrctl status am not able to see my remote database

                              now am able to see my remote db services but the status is unknown
                              On which machine are you executing 'lsnrctl'. Listener exists only on the database server. lsnrctl should be executed ON THE SERVER HOSTING THE DATABASE IN QUESTION.
                              LSNRCTL> status
                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host.
                              com)(PORT=1521)))
                              STATUS of the LISTENER
                              ------------------------
                              Alias LISTENER
                              Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                              ction
                              Start Date 28-SEP-2012 12:08:54
                              Uptime 0 days 0 hr. 2 min. 12 sec
                              Trace Level off
                              Security ON: Local OS Authentication
                              SNMP OFF
                              Listener Parameter File C:\app\00000\product\11.2.0\dbhome_1\network\admin\
                              listener.ora
                              Listener Log File c:\app\00000\diag\tnslsnr\srd-ws23042\listener\aler
                              t\log.xml
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=15
                              21)))
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
                              Services Summary...
                              Service "SID" has 1 instance(s).
                              Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
                              I've never seen an instance named SID. It's possible, but the above strongly suggests someone created the listener.ora file by copying an example and didn't understand that 'SID' should have been replaced with a real value when completing the SID_DESC section.

                              In other words, in their SID_DESC section they had this:
                              SID_LIST_LISTENER =
                                (SID_LIST =
                                  (SID_DESC =
                                    (SID_NAME = PLSExtProc)
                                    (ORACLE_HOME = /u01/app/oracl/product/11.2.0/db1)
                                    (PROGRAM = extproc)
                                  )
                                  (SID_DESC =
                                    (GLOBAL_DBNAME=SID)
                                    (ORACLE_HOME = /u01/app/oracl/product/11.2.0/db1)
                                    (SID_NAME = SID)
                                  )
                                )
                              when they should have had this:
                              SID_LIST_LISTENER =
                                (SID_LIST =
                                  (SID_DESC =
                                    (SID_NAME = PLSExtProc)
                                    (ORACLE_HOME = /u01/app/oracl/product/11.2.0/db1)
                                    (PROGRAM = extproc)
                                  )
                                  (SID_DESC =
                                    (GLOBAL_DBNAME=mydbname)
                                    (ORACLE_HOME = /u01/app/oracl/product/11.2.0/db1)
                                    (SID_NAME = mydbname)
                                  )
                                )
                              Service "PLSExtProc" has 1 instance(s).
                              Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                              Service "ORCL" has 2 instance(s).
                              Instance "orcl", status READY, has 1 handler(s) for this service...
                              Instance "ORCL", status UNKNOWN, has 1 handler(s) for this ser
                              vice...
                              Service "ORCL" has 1 instance(s).
                              Instance "orcl", status READY, has 1 handler(s) for this service...
                              The command completed successfully

                              my log error is

                              Thu Sep 27 12:25:18 2012
                              Create Relation ADR_CONTROL
                              Create Relation ADR_INVALIDATION
                              Create Relation INC_METER_IMPT_DEF
                              Create Relation INC_METER_PK_IMPTS
                              System parameter file is C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                              Log messages written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\alert\log.xml
                              Trace information written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\trace\ora_7708_5708.trc
                              Trace level is currently 0

                              Started with pid=7708
                              Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1522)))
                              TNS-12545: Connect failed because target host or object does not exist
                              TNS-12560: TNS:protocol adapter error
                              TNS-00515: Connect failed because target host or object does not exist
                              Whatever was asking for this connection specified a host that does not exist. The message indicates HOST=IP. Was that the actual value, or did you change that to IP when you pasted into this forum posting?
                              64-bit Windows Error: 49: Unknown error
                              Fri Sep 28 11:21:34 2012
                              System parameter file is C:\app\10017134\product\11.2.0\dbhome_1\network\admin\listener.ora
                              Log messages written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\alert\log.xml
                              Trace information written to c:\app\10017134\diag\tnslsnr\srd-ws23042\devoltpdb\trace\ora_4512_5756.trc
                              Trace level is currently 0
                              <snip two more occurrences of the same message>

                              Did you follow the links I posted earlier?
                              • 27. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                                Tshifhiwa
                                now my orcl database is ready,but still cannot connect through my IDE

                                Edited by: adf009 on 2013/02/15 7:22 PM
                                • 28. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                                  Osama_Mustafa
                                  How you are trying to connect ?
                                  What did you do ?anything changed ?
                                  • 29. Re: ORA-12154:TNS:could not resolve the connect identifier specified
                                    Mahmoud_Rabie
                                    ADF112 wrote:
                                    now my orcl database is ready,but still cannot connect through my IDE
                                    LSNRCTL> status
                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
                                    STATUS of the LISTENER
                                    ------------------------
                                    Alias LISTENER
                                    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                                    ction
                                    Start Date 01-OCT-2012 08:10:40
                                    Uptime 0 days 0 hr. 1 min. 55 sec
                                    Trace Level off
                                    Security ON: Local OS Authentication
                                    SNMP OFF
                                    Listener Parameter File C:\app\10017134\product\11.2.0\dbhome_1\network\admin\
                                    listener.ora
                                    Listener Log File c:\app\10017134\diag\tnslsnr\srd-ws23042\listener\aler
                                    t\log.xml
                                    Listening Endpoints Summary...
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srd-ws23042.za.astgroup.com)(PORT=15
                                    21)))
                                    Services Summary...
                                    Service "orcl" has 2 instance(s).
                                    Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    Service "orclXDB" has 1 instance(s).
                                    Instance "orcl", status READY, has 1 handler(s) for this service...
                                    The command completed successfully
                                    LSNRCTL>
                                    Dear ADF112,

                                    So, the TNS-12154 is resolved now.
                                    Please
                                    1) Mark the question as answered and give appropriate (helpful) or (correct) points to who deserves from your view
                                    2) Open a new thread titled with *(cannot connect through my IDE)* and describe the problem clearly

                                    Best Regards
                                    Mahmooud