9 Replies Latest reply: Jun 19, 2013 9:36 PM by Hussein Sawwan-Oracle RSS

    ORA-12518 : TNS:listener could not hand off client connection

    Chiedu7-yahoo

      Every time I try to start EBS r12 from the windows services it works ok!

       

      This is my spec

      8GB Ram

      750GB HardDrive
      i3 2.4Ghz

      Windows 7 Ultimate 64-bit

      Cgywin 2.774

               Visual C++ 2008 Express Edition

       

       

       

      Once I try to start EBS r12 from the command line using commands

      1. cd %ORACLE_HOME%
      2. Set Environment variables SID_hostname.cmd
      3. addlnctl.cmd start SID
      4. addbctl.cmd start immediate

        I always get this error
        ORA-12518 : TNS:listener could not hand off client connection

        I have increased my processes as recommended.

        what is the problem???



        • 1. Re: ORA-12518 : TNS:listener could not hand off client connection
          Asif Muhammad

          Hi,

           

          3. addlnctl.cmd start SID

           

          After this, can provide the output of "lsnrctl status <SID>"

          4. addbctl.cmd start immediate

           

          Please note, the command goes as  "addbctl.cmd start"

           

          Regards,

          • 2. Re: ORA-12518 : TNS:listener could not hand off client connection
            Chiedu7-yahoo

            This is the output =>

            ECHO is off.

            ECHO is off.

            19/06/2013 09:13

            ECHO is off.

            ECHO is off.

            19/06/2013 09:13

            VISION_invasion.cmd exiting with status 0

            ECHO is off.

            The environment settings are as follows ...

            ECHO is off.

            ORACLE_HOME : c:\oracle\VISION\db\tech_st\11.1.0

            LOCAL : VISION

            ORACLE_SID :

            PATH (windows path contents)

            LD_LIBRARY_PATH : c:\oracle\VISION\db\tech_st\11.1.0\lib

            ECHO is off.

            ECHO is off.

            The log information will be written to

                "c:\oracle\VISION\db\tech_st\11.1.0\appsutil\log\VISION_invasion\addlnctl.txt"

            ECHO is off.

            ECHO is off.

            Starting listener process VISION ...

            ECHO is off.

             

            LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 19-JUN-2013 09:13:37

             

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

             

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=invasion.lord.com)(PORT=1526)))

            TNS-12541: TNS:no listener

            TNS-12560: TNS:protocol adapter error

              TNS-00511: No listener

               32-bit Windows Error: 61: Unknown error

             

            LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 19-JUN-2013 09:13:38

             

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

             

            Starting tnslsnr: please wait...

             

            TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production

            System parameter file is C:\Oracle\VISION\db\tech_st\11.1.0\NETWORK\ADMIN\VISION_invasion\listener.ora

            Log messages written to c:\oracle\vision\db\tech_st\11.1.0\log\diag\tnslsnr\Invasion\vision\alert\log.xml

            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Invasion.Lord.Com)(PORT=1526)))

             

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=invasion.lord.com)(PORT=1526)))

            STATUS of the LISTENER

            ------------------------

            Alias                     VISION

            Version                   TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production

            Start Date                19-JUN-2013 09:13:44

            Uptime                    0 days 0 hr. 0 min. 6 sec

            Trace Level               off

            Security                  ON: Local OS Authentication

            SNMP                      OFF

            Listener Parameter File   C:\Oracle\VISION\db\tech_st\11.1.0\NETWORK\ADMIN\VISION_invasion\listener.ora

            Listener Log File         c:\oracle\vision\db\tech_st\11.1.0\log\diag\tnslsnr\Invasion\vision\alert\log.xml

            Listening Endpoints Summary...

              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Invasion.Lord.Com)(PORT=1526)))

            Services Summary...

            Service "VISION" has 1 instance(s).

              Instance "VISION", status UNKNOWN, has 1 handler(s) for this service...

            The command completed successfully

            addlnctl.cmd exiting with status 0

            • 3. Re: ORA-12518 : TNS:listener could not hand off client connection
              Asif Muhammad

              Hi,

               

              As per your output the listener is handling your DB instance and is working fine. Please issue the command I have posted above

              addbctl.cmd start

              Could you post the content of your listener.ora file at $TNS_ADMIN/$CONTEXT_NAME.

               

              Regards,

              • 4. Re: ORA-12518 : TNS:listener could not hand off client connection
                Hussein Sawwan-Oracle
                1. addlnctl.cmd start SID

                 

                Do you issue "addlnctl.cmd start SID" or "addlnctl.cmd start VISION"?

                 

                Thanks,

                Hussein

                • 5. Re: ORA-12518 : TNS:listener could not hand off client connection
                  Chiedu7-yahoo
                  As per your output the listener is handling your DB instance and is working fine. Please issue the command I have posted above

                  addbctl.cmd start

                  Yep did addbctl.cmd start


                  /*-----------------------------------------Contents of listener.ora  ---------------------------------*/

                  DIRECT_HANDOFF_TTC_LISTENER = OFF

                   

                  VISION =

                    (DESCRIPTION_LIST =

                      (DESCRIPTION =

                        (ADDRESS = (PROTOCOL = TCP)(HOST = invasion.lord.com)(PORT = 1526))

                      )

                    )

                   

                  SID_LIST_VISION =

                    (SID_LIST =

                      (SID_DESC =

                        (ORACLE_HOME= c:\oracle\VISION\db\tech_st\11.1.0)

                        (SID_NAME = VISION)

                      )

                    )

                   

                  STARTUP_WAIT_TIME_VISION = 0

                  CONNECT_TIMEOUT_VISION = 10

                  TRACE_LEVEL_VISION = ON

                   

                  LOG_DIRECTORY_VISION = c:\oracle\VISION\db\tech_st\11.1.0/network/admin

                  LOG_FILE_VISION = VISION

                  TRACE_DIRECTORY_VISION = c:\oracle\VISION\db\tech_st\11.1.0/network/admin

                  TRACE_FILE_VISION = VISION

                  ADMIN_RESTRICTIONS_VISION = OFF

                  SUBSCRIBE_FOR_NODE_DOWN_EVENT_VISION = OFF

                   

                  INBOUND_CONNECT_TIMEOUT_VISION = 0

                   

                  IFILE=c:\oracle\VISION\db\tech_st\11.1.0\network\admin\VISION_invasion\listener_ifile.ora

                   

                  /*-------------------------------------------End Contents-------------------------------------------------*/

                  • 7. Re: ORA-12518 : TNS:listener could not hand off client connection
                    Hussein Sawwan-Oracle

                    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 19-JUN-2013 09:13:37

                     

                    LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 19-JUN-2013 09:13:38

                     

                    From the above entries in the log, it looks like the listener is up and running.

                     

                    Thanks,

                    Hussein

                    • 8. Re: ORA-12518 : TNS:listener could not hand off client connection
                      Chiedu7-yahoo
                      From the above entries in the log, it looks like the listener is up and running.

                       

                      The Listener starts ok!

                       

                      It's when I try to start the database that I get the errors

                      • 9. Re: ORA-12518 : TNS:listener could not hand off client connection
                        Hussein Sawwan-Oracle

                        Thanks for the clarification.

                         

                        Can you please review (TROUBLESHOOTING GUIDE TNS-12518 TNS listener could not hand off client connection [ID 550859.1]) and see if it helps?

                         

                        Thanks,

                        Hussein