1 2 Previous Next 19 Replies Latest reply: Oct 8, 2012 12:08 PM by 877087 RSS

    NL-08002: Diagnosability  context creation failed - Listener startup fail

    877087
      Dear Experts,

      I am facing problem with listener startup on newly installed database. Please provide the solution below issue

      OS:
      Linux solmanserver 2.6.9-55.EL #1 Fri Apr 20 16:25:34 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

      Database: Oracle 11.2.0.3.0

      =================================================================
      [orasmp@solmanserver 112_64]$ lsnrctl start LISTENERSMP

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-OCT-2012 23:02:16

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

      Starting /oracle/SMP/112_64/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 11.2.0.3.0 - Production
      System parameter file is /oracle/SMP/112_64/network/admin/listener.ora
      Log messages written to /oracle/SMP/112_64/network/log/listenersmp.log
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMP.WORLD)))
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SMP)))
      TNS-01150: The address of the specified listener name is incorrect
      TNS-01153: Failed to process string: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=solmanserver)(PORT=1521))
      NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging

      NL-08002: Diagnosability context creation failed

      Listener failed to start. See the error message(s) above...
      =================================================================

      ===============================
      listener.ora file contents
      ===============================

      ################
      # Filename......: listener.ora
      # Created.......: created by SAP AG, R/3 Rel. >= 6.10
      # Name..........:
      # Date..........:
      # @(#) $Id: //bas/720_REL/src/krn/tpls/ora/LISTENER.ORA#2 $
      ################
      ADMIN_RESTRICTIONS_LISTENERSMP = on
      LISTENERSMP =
      (ADDRESS_LIST =
      (ADDRESS =
      (PROTOCOL = IPC)
      (KEY = SMP.WORLD)
      )
      (ADDRESS=
      (PROTOCOL = IPC)
      (KEY = SMP)
      )
      (ADDRESS =
      (COMMUNITY = SAP.WORLD)
      (PROTOCOL = TCP)
      (HOST = solmanserver)
      (PORT = 1521)
      )
      )
      STARTUP_WAIT_TIME_LISTENERSMP = 0
      CONNECT_TIMEOUT_LISTENERSMP = 10
      TRACE_LEVEL_LISTENERSMP = OFF
      SID_LIST_LISTENERSMP =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = SMP)
      (ORACLE_HOME = /oracle/SMP/112_64)
      )
      )
      ADR_BASE_LISTENERSMP = undefined
        • 1. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
          Osama_Mustafa
          Try to recreate you listener again please using netca
          -netca
          -drop you old listener
          -recreate it again

          and post output again if it not working
          • 2. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
            Osama_Mustafa
            If the above solution not working for you enable trace and more investigate

            vi $ORACLE_HOME/network/admin/listener.ora


            add the following
            TRACE_FILE_LISTENER = LISTENERTEST.trc (The destination file for the trace file)
            TRACE_DIRECTORY_LISTENER = /export/home (The destination directory for the trace file)
            TRACE_LEVEL_listener=support
            TRACE_TIMESTAMP_listener=true


            http://arjudba.blogspot.com/2008/04/how-to-enable-listener-logging-and.html
            • 3. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
              952768
              Your listener.ora is mixed up.

              Your listener.ora should look for example like this:
              SID_LIST_LISTENER =
                (SID_LIST =
                  (SID_DESC =
                    (SID_NAME = PLSExtProc)
                    (ORACLE_HOME = /oracle/SMP/112_64)
                    (PROGRAM = extproc)
                  )
                )
              
              LISTENERSMP =
                (DESCRIPTION_LIST =
                  (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = solmanserver)(PORT = 1521))
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                  )
                )
              • 4. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                877087
                @@specdev ,

                I have changed as suggested by you. However, still same error.

                Here is my environment variables for reference

                [orasmp@solmanserver admin]$ env
                HOSTNAME=solmanserver
                SHELL=/bin/bash
                TERM=xterm
                HISTSIZE=1000
                OLDPWD=/home/orasmp
                USER=orasmp
                LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
                ORACLE_SID=SMP
                ORACLE_BASE=/oracle/SMP
                MAIL=/var/spool/mail/orasmp
                PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/orasmp/bin:/oracle/SMP/112_64/bin
                INPUTRC=/etc/inputrc
                PWD=/oracle/SMP/112_64/network/admin
                LANG=en_US.UTF-8
                SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
                SHLVL=1
                HOME=/home/orasmp
                LOGNAME=orasmp
                LESSOPEN=|/usr/bin/lesspipe.sh %s
                ORACLE_HOME=/oracle/SMP/112_64
                G_BROKEN_FILENAMES=1
                _=/bin/env
                • 5. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                  sb92075
                  do as below

                  cd /oracle/SMP/112_64/network/admin/
                  lsnrctl stop
                  mv listener.ora listener.ora.sav
                  lsnrctl start
                  lsnrctl service

                  COPY results then PASTE all back here
                  • 6. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                    877087
                    @@sb92075


                    [orasmp@solmanserver admin]$ mv listener.ora listener.ora.sav
                    [orasmp@solmanserver admin]$ lsnrctl start

                    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-OCT-2012 01:44:32

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

                    Starting /oracle/SMP/112_64/bin/tnslsnr: please wait...

                    TNSLSNR for Linux: Version 11.2.0.3.0 - Production
                    Log messages written to /oracle/SMP/diag/tnslsnr/solmanserver/listener/alert/log.xml
                    TNS-01150: The address of the specified listener name is incorrect
                    TNS-01153: Failed to process string: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

                    Listener failed to start. See the error message(s) above...

                    [orasmp@solmanserver admin]$ lsnrctl service

                    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-OCT-2012 01:44:38

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

                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                    TNS-12538: TNS:no such protocol adapter
                    TNS-12560: TNS:protocol adapter error
                    TNS-00508: No such protocol adapter
                    • 7. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                      sb92075
                      874084 wrote:
                      @@sb92075


                      [orasmp@solmanserver admin]$ mv listener.ora listener.ora.sav
                      [orasmp@solmanserver admin]$ lsnrctl start

                      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-OCT-2012 01:44:32

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

                      Starting /oracle/SMP/112_64/bin/tnslsnr: please wait...

                      TNSLSNR for Linux: Version 11.2.0.3.0 - Production
                      Log messages written to /oracle/SMP/diag/tnslsnr/solmanserver/listener/alert/log.xml
                      TNS-01150: The address of the specified listener name is incorrect
                      TNS-01153: Failed to process string: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

                      Listener failed to start. See the error message(s) above...

                      [orasmp@solmanserver admin]$ lsnrctl service

                      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-OCT-2012 01:44:38

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

                      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                      TNS-12538: TNS:no such protocol adapter
                      TNS-12560: TNS:protocol adapter error
                      TNS-00508: No such protocol adapter
                      these errors indicate that OS/networking is mis-configure.
                      Oracle is victim; not the culprit.

                      issue the following OS commands below

                      uname -a
                      hostname
                      cat /etc/hosts
                      ifconfig
                      ping <hostname>
                      ping <IP#>


                      COPY results from above then PASTE all back here
                      • 8. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                        877087
                        @@sb92075

                        Here is the information requested:

                        [root@solmanserver ~]# uname -a
                        Linux solmanserver 2.6.9-55.EL #1 Fri Apr 20 16:25:34 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

                        [root@solmanserver ~]# hostname
                        solmanserver

                        [root@solmanserver ~]# cat /etc/hosts
                        # Do not remove the following line, or various programs
                        # that require network functionality will fail.
                        127.0.0.1 localhost.localdomain localhost
                        192.168.19.15 solmanserver solmanserver.com

                        [root@solmanserver ~]# ping solmanserver
                        PING solmanserver (192.168.19.15) 56(84) bytes of data.
                        64 bytes from solmanserver (192.168.19.15): icmp_seq=0 ttl=64 time=0.034 ms
                        64 bytes from solmanserver (192.168.19.15): icmp_seq=1 ttl=64 time=0.032 ms
                        64 bytes from solmanserver (192.168.19.15): icmp_seq=2 ttl=64 time=0.030 ms
                        64 bytes from solmanserver (192.168.19.15): icmp_seq=3 ttl=64 time=0.030 ms
                        64 bytes from solmanserver (192.168.19.15): icmp_seq=4 ttl=64 time=0.030 ms

                        --- solmanserver ping statistics ---
                        5 packets transmitted, 5 received, 0% packet loss, time 3999ms
                        rtt min/avg/max/mdev = 0.030/0.031/0.034/0.004 ms, pipe 2

                        [root@solmanserver ~]# ping 192.168.19.15
                        PING 192.168.19.15 (192.168.19.15) 56(84) bytes of data.
                        64 bytes from 192.168.19.15: icmp_seq=0 ttl=64 time=0.023 ms
                        64 bytes from 192.168.19.15: icmp_seq=1 ttl=64 time=0.041 ms
                        64 bytes from 192.168.19.15: icmp_seq=2 ttl=64 time=0.030 ms

                        --- 192.168.19.15 ping statistics ---
                        3 packets transmitted, 3 received, 0% packet loss, time 1999ms
                        rtt min/avg/max/mdev = 0.023/0.031/0.041/0.008 ms, pipe 2
                        • 9. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                          Richard Harrison .
                          Hi,
                          Take your original listener.ora file and just remove this line

                          ADR_BASE_LISTENERSMP = undefined

                          Then try starting.

                          Regards,
                          Harry
                          • 10. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                            Osama_Mustafa
                            Check MOS Note :
                            Listener Fails To Start On Tcps Protocol With TNS-01153 And TNS-01150 [ID 837910.1]
                            • 11. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                              877087
                              Hi Harry,

                              Removed below from listener.ora file. But didn't work.

                              ADR_BASE_LISTENERSMP = undefined
                              • 12. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                                sb92075
                                874084 wrote:
                                Hi Harry,

                                Removed below from listener.ora file. But didn't work.

                                ADR_BASE_LISTENERSMP = undefined
                                post results from OS command below

                                /sbin/ifconfig
                                • 13. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                                  877087
                                  Hi,

                                  Here is the output of ifconfig

                                  [root@solmanserver /]# ifconfig
                                  eth0 Link encap:Ethernet HWaddr 00:0C:29:07:83:7A
                                  inet addr:192.168.19.15 Bcast:192.168.19.255 Mask:255.255.255.0
                                  inet6 addr: fe80::20c:29ff:fe07:837a/64 Scope:Link
                                  UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                                  RX packets:3759 errors:0 dropped:0 overruns:0 frame:0
                                  TX packets:2972 errors:0 dropped:0 overruns:0 carrier:0
                                  collisions:0 txqueuelen:1000
                                  RX bytes:372493 (363.7 KiB) TX bytes:381045 (372.1 KiB)
                                  Base address:0x2000 Memory:c9020000-c9040000

                                  lo Link encap:Local Loopback
                                  inet addr:127.0.0.1 Mask:255.0.0.0
                                  inet6 addr: ::1/128 Scope:Host
                                  UP LOOPBACK RUNNING MTU:16436 Metric:1
                                  RX packets:2750 errors:0 dropped:0 overruns:0 frame:0
                                  TX packets:2750 errors:0 dropped:0 overruns:0 carrier:0
                                  collisions:0 txqueuelen:0
                                  RX bytes:2971062 (2.8 MiB) TX bytes:2971062 (2.8 MiB)
                                  • 14. Re: NL-08002: Diagnosability  context creation failed - Listener startup fail
                                    877087
                                    Hello all,

                                    While searching Oracle metalinks, I executed command adapters and found below results:
                                    Mainly error coming at TCP/IP while starting listener. However IPC protocol is fine. I have removed TCP ADDRESS from listener.ora and it's working fine. Reverted to original now.

                                    I suspect the issue with TCP/IP adapters. Please guide to me fix TCP/IP adapter installation.

                                    [orasmp@solmanserver admin]$ adapters

                                    Installed Oracle Net transport protocols are:

                                    IPC
                                    BEQ
                                    Error!!! TCP/IP is not completely installed!
                                    Present in libntcp11, but missing from ntcontab.o...
                                    Error!!! SSL is not completely installed!
                                    Present in libntcps11, but missing from ntcontab.o...
                                    RAW
                                    Error!!! SDP/IB is not completely installed!
                                    Present in libntcp11, but missing from ntcontab.o...

                                    Installed Oracle Net naming methods are:

                                    Local Naming (tnsnames.ora)
                                    Oracle Directory Naming
                                    Oracle Host Naming
                                    Error!!! Oracle Names Server Naming is not completely installed!

                                    Installed Oracle Advanced Security options are:

                                    RC4 40-bit encryption
                                    RC4 56-bit encryption
                                    RC4 128-bit encryption
                                    RC4 256-bit encryption
                                    DES40 40-bit encryption
                                    DES 56-bit encryption
                                    3DES 112-bit encryption
                                    3DES 168-bit encryption
                                    AES 128-bit encryption
                                    AES 192-bit encryption
                                    AES 256-bit encryption
                                    MD5 crypto-checksumming
                                    SHA-1 crypto-checksumming
                                    Kerberos v5 authentication
                                    RADIUS authentication
                                    1 2 Previous Next