1 2 3 Previous Next 37 Replies Latest reply: Mar 15, 2012 5:30 AM by karthiksingh_india Go to original post RSS
      • 15. Re: Listener is not up
        karthiksingh_india
        Hi again..

        I again tried creating a new listener in the name of listener23

        MY LISTENER.ORA*

        *# listener.ora Network Configuration File: C:\app\SKS\product\11.1.0\db_1\\network\admin\listener.ora*
        *# Generated by Oracle configuration tools.*

        LISTENER23 =
        *(DESCRIPTION_LIST =*
        *(DESCRIPTION =*
        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1523))*
        *)*
        *)*

        SID_LIST_LISTENER =
        *(SID_LIST =*
        *(SID_DESC =*
        *(GLOBAL_DBNAME = VESS)*
        *(SID_NAME = VESS)*
        *(ORACLE_HOME = /app/SKS/product/11.1.0/db_1)*
        *)*
        *)*

        LISTENER =
        *(DESCRIPTION_LIST =*
        *(DESCRIPTION =*
        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1521))*
        *)*
        *)*

        MY TNSNAMES.ORA*

        *# tnsnames.ora Network Configuration File: C:\app\SKS\product\11.1.0\db_1\network\admin\tnsnames.ora*
        *# Generated by Oracle configuration tools.*

        VESS =
        *(DESCRIPTION =*
        *(ADDRESS_LIST =*
        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1521))*
        *)*
        *(CONNECT_DATA =*
        *(SERVER = DEDICATED)*
        *(SERVICE_NAME = VESS)*
        *)*
        *)*

        LISTENER_VESS23 =
        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1523))*

        BUT MY LISTENER STATUS SHOWS*

        LSNRCTL> status
        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SKS)(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
        *32-bit Windows Error: 1001: Unknown error*
        LSNRCTL>

        For uninstalling and re-installing may leads to unknown issues and its actions+

        but+

        I want to know what and where is the issue arises..+

        Please Help

        Thanks in advance
        • 16. Re: Listener is not up_Partially solved
          karthiksingh_india
          oh god now I have changed my host name to a local IP so that now my listener is working it seems

          C:\Documents and Settings\SKS>lsnrctl status

          LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 17:49:37

          Copyright (c) 1991, 2008, Oracle.  All rights reserved.

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=_+127.0.0.1+_)(PORT=1521))) -- -- -- previous host name is SKS
          STATUS of the LISTENER
          ------------------------
          Alias                     LISTENER
          Version                   TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
          Start Date                13-MAR-2012 17:45:31
          Uptime                    0 days 0 hr. 4 min. 7 sec
          Trace Level               off
          Security                  ON: Local OS Authentication
          SNMP                      OFF
          Listener Parameter File   C:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora
          Listener Log File         c:\app\sks\diag\tnslsnr\computer\listener\alert\log.xml
          Listening Endpoints Summary...
          *(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))*
          Services Summary...
          Service "VESS" has 1 instance(s).
          Instance "VESS", status UNKNOWN, has 1 handler(s) for this service...
          The command completed successfully

          Now the problem is now i cant reconfigure my listener with previous database or a newly created database..

          It shows an error

          ORA- 12560: TNS: protocol adapter error

          NOTE:In my services

          the service named:OracleOraDb11g_home1ConfigurationManager

          path to executable:c:\app\sks\product\11.1.0\db_1\ccr\bin\nmz.exe VESS

          All other service relating to my database and listener has been started now and working but except the above one..+.*

          Please help me..

          10000000000000's of thanks
          • 17. Re: Listener is not up
            EdStevens
            karthiksingh_india wrote:
            Please help me

            I cant come out of this issue..

            Karthik..
            =================================

            Patience, Grasshopper

            You posted this follow-up a mere 33 minutes after your previous post.

            This forum is not a chat line, and it is not paid support.

            No one is responsible for monitoring it and giving a quick response.

            Furthermore, it is a global forum. The person with the information you seek may very well live 20 time zones away from you and was going to bed just as you posted. He will not even see your post for several more hours.

            Your original post went up in the middle of the night for half the world.

            No one with the information you seek is deliberately withholding it until you sound sufficiently desperate.

            Plus .... you actually make it more difficult for everyone (and thus more difficult for yourself) by starting multiple threads for the same issue.
            • 18. Re: Listener is not up
              karthiksingh_india
              OK sorry

              Please solve my issue..
              • 19. Re: Listener is not up_Partially solved
                Aman....
                I am not sure that this is asked to you before or not, are you using DHCP on this machine?

                Aman....
                • 20. Re: Listener is not up
                  EdStevens
                  karthiksingh_india wrote:
                  Hi Everyone,

                  As I have installed Oracle 11g and I tried to start work with sqlplus by entering

                  sqlplus sys@orcl then it shows

                  ORA-12154: TNS:could not resolve the connect identifier specified

                  and at the same time while installing I got an error that Listener configuration failed..by saying Listener is not up..

                  Thanks in advance
                  ORA-12154 has zero to do with the listener. The request never got far enough to involve the listener.
                  • 21. Re: Listener is not up
                    EdStevens
                    karthiksingh_india wrote:
                    ok I have created another listener using NETCA

                    I have created in the name of LISTENER 2 but it says that the listener has been already in use and it cannot be started..

                    NOW

                    MY LISTENER STATUS*
                    C:\Documents and Settings\SKS>lsnrctl status

                    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 11:48:35

                    Copyright (c) 1991, 2008, Oracle.  All rights reserved.

                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
                    TNS-12541: TNS:no listener
                    TNS-12560: TNS:protocol adapter error
                    TNS-00511: No listener
                    *32-bit Windows Error: 61: Unknown error*

                    IF I TRY TO START LISTENER IT SHOWS*
                    C:\Documents and Settings\SKS>lsnrctl start

                    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 11:50:22

                    Copyright (c) 1991, 2008, Oracle.  All rights reserved.

                    Starting tnslsnr: please wait...

                    Failed to start service, error 3.
                    TNS-12560: TNS:protocol adapter error
                    TNS-00530: Protocol adapter error


                    MY LISTENER.ORA*

                    *# listener.ora Network Configuration File: C:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora*
                    *# Generated by Oracle configuration tools.*

                    LISTENER2 =
                    *(DESCRIPTION_LIST =*
                    *(DESCRIPTION =*
                    *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1521))*
                    *)*
                    *)*

                    LISTENER =
                    *(DESCRIPTION_LIST =*
                    *(DESCRIPTION =*
                    *(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))*
                    *)*
                    *)*
                    Two listeners (LISTENER and LISTENER2) are very rarely ever needed. And since you have both of them configured to use the same port, all bets are off. Without testing, I'd guess that's the cause of your error trying to start one of the two listeners.
                    MY TNSNAME.ORA*
                    *# tnsnames.ora Network Configuration File: C:\app\SKS\product\11.1.0\db_1\network\admin\tnsnames.ora*
                    *# Generated by Oracle configuration tools.*

                    VESS =
                    *(DESCRIPTION =*
                    *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1521))*
                    *(CONNECT_DATA =*
                    *(SERVER = DEDICATED)*
                    *(SERVICE_NAME = vess)*
                    *)*
                    *)*


                    THIS IS MY SET OUTPUT*
                    C:\Documents and Settings\SKS>set
                    ALLUSERSPROFILE=C:\Documents and Settings\All Users
                    APPDATA=C:\Documents and Settings\SKS\Application Data
                    CLIENTNAME=Console
                    CommonProgramFiles=C:\Program Files\Common Files
                    COMPUTERNAME=COMPUTER
                    ComSpec=C:\WINDOWS\system32\cmd.exe
                    FP_NO_HOST_CHECK=NO
                    HOMEDRIVE=C:
                    HOMEPATH=\Documents and Settings\SKS
                    LOGONSERVER=\\COMPUTER
                    NUMBER_OF_PROCESSORS=2
                    ORACLE_HOSTNAME=SKS
                    OS=Windows_NT
                    Path=C:\app\SKS\product\11.1.0\db_1\bin;C:\app1\SKS\product\11.1.0\db_2\bin;C:\WINDOWS\system32;C:\WINDOW
                    S;C:\WINDOWS\System32\Wbem
                    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
                    PROCESSOR_ARCHITECTURE=x86
                    PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
                    PROCESSOR_LEVEL=6
                    PROCESSOR_REVISION=0f0d
                    ProgramFiles=C:\Program Files
                    PROMPT=$P$G
                    SESSIONNAME=Console
                    SystemDrive=C:
                    SystemRoot=C:\WINDOWS
                    TEMP=C:\DOCUME~1\SKS\LOCALS~1\Temp
                    TMP=C:\DOCUME~1\SKS\LOCALS~1\Temp
                    USERDOMAIN=COMPUTER
                    USERNAME=SKS
                    USERPROFILE=C:\Documents and Settings\SKS
                    VBOX_INSTALL_PATH=C:\Program Files\Oracle\VirtualBox\
                    windir=C:\WINDOWS


                    Please make some help...
                    Thanks
                    • 22. Re: Listener is not up
                      EdStevens
                      karthiksingh_india wrote:
                      No its not doing anything

                      I have set the path as

                      ORACLE_HOME=C:\app\SKS\product\11.1.0\db_1\BIN\
                      ORACLE_HOSTNAME=SKS

                      is it correct???

                      I have restarted the machine...

                      and i tried to restart or start or status of the listener it shows

                      C:\Documents and Settings\SKS>lsnrctl start

                      LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 12:37:14

                      Copyright (c) 1991, 2008, Oracle.  All rights reserved.

                      Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-12557: Message 12557 not fou
                      nd; No message file for product=NETWORK, facility=TNS
                      TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
                      TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

                      Edited by: karthiksingh_india on Mar 13, 2012 12:07 AM
                      Now you've made things worse. "No message file for product" means you have have incorrectly specified ORACLE_HOME. Since this is Windows, I'd recommend you NOT try to specify oracle environment variables, as that will just complicate the fact that Oracle will try to get them from the registry instead. And I'd trust what oracle itself put in the registry more than I'd trust what you put in the environment.
                      • 23. Re: Listener is not up
                        EdStevens
                        karthiksingh_india wrote:
                        Hi again..

                        I again tried creating a new listener in the name of listener23
                        When you find yourself in a hole, the first rule is to stop digging.

                        MY LISTENER.ORA*

                        *# listener.ora Network Configuration File: C:\app\SKS\product\11.1.0\db_1\\network\admin\listener.ora*
                        *# Generated by Oracle configuration tools.*

                        LISTENER23 =
                        *(DESCRIPTION_LIST =*
                        *(DESCRIPTION =*
                        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1523))*
                        *)*
                        *)*

                        SID_LIST_LISTENER =
                        *(SID_LIST =*
                        *(SID_DESC =*
                        *(GLOBAL_DBNAME = VESS)*
                        *(SID_NAME = VESS)*
                        *(ORACLE_HOME = /app/SKS/product/11.1.0/db_1)*
                        *)*
                        *)*

                        LISTENER =
                        *(DESCRIPTION_LIST =*
                        *(DESCRIPTION =*
                        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1521))*
                        *)*
                        *)*

                        MY TNSNAMES.ORA*

                        *# tnsnames.ora Network Configuration File: C:\app\SKS\product\11.1.0\db_1\network\admin\tnsnames.ora*
                        *# Generated by Oracle configuration tools.*

                        VESS =
                        *(DESCRIPTION =*
                        *(ADDRESS_LIST =*
                        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1521))*
                        *)*
                        *(CONNECT_DATA =*
                        *(SERVER = DEDICATED)*
                        *(SERVICE_NAME = VESS)*
                        *)*
                        *)*

                        LISTENER_VESS23 =
                        *(ADDRESS = (PROTOCOL = TCP)(HOST = SKS)(PORT = 1523))*

                        BUT MY LISTENER STATUS SHOWS*

                        LSNRCTL> status
                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SKS)(PORT=1521)))
                        TNS-12545: Connect failed because target host or object does not exist
                        Now windows can't resolve hostname SKS to a valid IP address.
                        TNS-12560: TNS:protocol adapter error
                        TNS-00515: Connect failed because target host or object does not exist
                        *32-bit Windows Error: 1001: Unknown error*
                        LSNRCTL>

                        For uninstalling and re-installing may leads to unknown issues and its actions+

                        but+

                        I want to know what and where is the issue arises..+

                        Please Help

                        Thanks in advance
                        • 24. Re: Listener is not up_Partially solved
                          EdStevens
                          karthiksingh_india wrote:
                          oh god now I have changed my host name to a local IP so that now my listener is working it seems

                          C:\Documents and Settings\SKS>lsnrctl status

                          LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 17:49:37

                          Copyright (c) 1991, 2008, Oracle.  All rights reserved.

                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=_+127.0.0.1+_)(PORT=1521))) -- -- -- previous host name is SKS
                          Now the listener will not listen for anything coming from another machine. IP address 127.0.0.1 is NONroutable. And I've never seen the "_+" with an iP address .. Is that some sort of IPv6 construct? Or is that some sort of attempt at text formatting? Please go to the FAQ and read up on use of the code tags and quit trying to format your text, as that simply introduces the possibility/probability that what you show is is not exactly what you got.

                          STATUS of the LISTENER
                          ------------------------
                          Alias                     LISTENER
                          Version                   TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
                          Start Date                13-MAR-2012 17:45:31
                          Uptime                    0 days 0 hr. 4 min. 7 sec
                          Trace Level               off
                          Security                  ON: Local OS Authentication
                          SNMP                      OFF
                          Listener Parameter File   C:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora
                          Listener Log File         c:\app\sks\diag\tnslsnr\computer\listener\alert\log.xml
                          Listening Endpoints Summary...
                          *(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))*
                          Services Summary...
                          Service "VESS" has 1 instance(s).
                          Instance "VESS", status UNKNOWN, has 1 handler(s) for this service...
                          The command completed successfully

                          Now the problem is now i cant reconfigure my listener with previous database or a newly created database..
                          What do you mean you can't reconfigure your listener? which listener? At last count, you'd created 3 different ones. A listener does not have to be configured for a database. If it is running on the default port of 1521, and the instance hasn't been told any differently, it (the instance) will register itself with the listener. Please (*please*) read all of my tnS related posts at edstevensdba.wordpress.com.


                          >
                          It shows an error

                          ORA- 12560: TNS: protocol adapter error
                          What "it" shows that error? Starting one of your many listeners? Connecting to a database? Error messages taken out of context are not much more help than no error message at all.
                          NOTE:In my services

                          the service named:OracleOraDb11g_home1ConfigurationManager

                          path to executable:c:\app\sks\product\11.1.0\db_1\ccr\bin\nmz.exe VESS

                          All other service relating to my database and listener has been started now and working but except the above one..+.*

                          Please help me..

                          10000000000000's of thanks
                          • 25. Re: Listener is NOW up_Partially solved
                            karthiksingh_india
                            Ok

                            Now what should I do?

                            I have deleted the LISTENER23

                            But I couldnt connect to sql*plus and also cant Re-Configure with My database VESS

                            Please Help
                            • 26. Re: Listener is NOW up_Partially solved
                              karthiksingh_india
                              Sorry to ask and post again and again Please ignore

                              Now this is My Listener
                              -----
                              C:\Documents and Settings\SKS>lsnrctl status

                              LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 20:09:14

                              Copyright (c) 1991, 2008, Oracle. All rights reserved.

                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
                              STATUS of the LISTENER
                              ------------------------
                              Alias LISTENER
                              Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
                              Start Date 13-MAR-2012 17:45:31
                              Uptime 0 days 2 hr. 23 min. 44 sec
                              Trace Level off
                              Security ON: Local OS Authentication
                              SNMP OFF
                              Listener Parameter File C:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora
                              Listener Log File c:\app\sks\diag\tnslsnr\computer\listener\alert\log.xml
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                              Services Summary...
                              Service "VESS" has 1 instance(s).
                              Instance "VESS", status UNKNOWN, has 1 handler(s) for this service...
                              The command completed successfully
                              -----
                              and now I connected to sql*plus by
                              ------
                              C:\Documents and Settings\SKS>sqlplus /nolog

                              SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 13 20:12:04 2012

                              Copyright (c) 1982, 2008, Oracle. All rights reserved.

                              SQL> connect sys as sysdba
                              Enter password:
                              ERROR:
                              ORA-12560: TNS:protocol adapter error

                              SQL>
                              -----

                              As per your previous suggestion I have taken a look over your blog and done the following

                              -----
                              C:\Documents and Settings\SKS>sqlplus / as sysdba

                              SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 13 20:16:46 2012

                              Copyright (c) 1982, 2008, Oracle. All rights reserved.

                              ERROR:
                              ORA-12560: TNS:protocol adapter error


                              Enter user-name: scott
                              Enter password:
                              ERROR:
                              ORA-12560: TNS:protocol adapter error


                              Enter user-name: hr
                              Enter password:
                              ERROR:
                              ORA-12560: TNS:protocol adapter error


                              SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

                              C:\Documents and Settings\SKS>

                              -----

                              Please help me STEVE I wanna learn more and shine only in DBA
                              Karthik...
                              • 27. Re: Listener is NOW up_Partially solved
                                sb92075
                                karthiksingh_india wrote:
                                Sorry to ask and post again and again Please ignore

                                Now this is My Listener
                                -----
                                C:\Documents and Settings\SKS>lsnrctl status

                                LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 13-MAR-2012 20:09:14

                                Copyright (c) 1991, 2008, Oracle. All rights reserved.

                                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
                                STATUS of the LISTENER
                                Listener can never be accessed by remote client system.
                                ------------------------
                                Alias LISTENER
                                Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
                                Start Date 13-MAR-2012 17:45:31
                                Uptime 0 days 2 hr. 23 min. 44 sec
                                Trace Level off
                                Security ON: Local OS Authentication
                                SNMP OFF
                                Listener Parameter File C:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora
                                Listener Log File c:\app\sks\diag\tnslsnr\computer\listener\alert\log.xml
                                Listening Endpoints Summary...
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                                Services Summary...
                                Service "VESS" has 1 instance(s).
                                Instance "VESS", status UNKNOWN, has 1 handler(s) for this service...
                                The command completed successfully
                                -----
                                and now I connected to sql*plus by
                                ------
                                C:\Documents and Settings\SKS>sqlplus /nolog

                                SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 13 20:12:04 2012

                                Copyright (c) 1982, 2008, Oracle. All rights reserved.

                                SQL> connect sys as sysdba
                                Enter password:
                                ERROR:
                                ORA-12560: TNS:protocol adapter error
                                above occurs when OS/Networking mis-configuration exists
                                problem & solution are external to Oracle.

                                Can result when ORACLE_SID does not match oradmin Service name.
                                Can result when hostname does not match what is used by listener
                                • 28. Re: Listener is NOW up_Partially solved
                                  karthiksingh_india
                                  Sorry really I couldn't get what you are trying to say...

                                  Please am a New one to this alone in my organization as a trainee..
                                  • 29. Re: Listener is NOW up_Partially solved
                                    EdStevens
                                    karthiksingh_india wrote:
                                    Ok

                                    Now what should I do?
                                    Two things.

                                    First, decide which thread you are going to use and close the other.

                                    Second, get rid of all listeners except the one with the default name of LISTENER.

                                    After you have done both of the above, we can start to work the problem without having to carry on multiple conversations and without trying to hit a moving target.


                                    >
                                    I have deleted the LISTENER23

                                    But I couldnt connect to sql*plus and also cant Re-Configure with My database VESS

                                    Please Help