5 Replies Latest reply: Jan 14, 2013 10:57 AM by clcarter RSS

    Error starting listener

    JackK
      Hi!
      $ lsnrctl start
      LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 12-STY-2013 19:19:07
      
      Copyright (c) 1991, 2011, Oracle.  All rights reserved.
      
      Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...
      
      TNSLSNR for Linux: Version 11.2.0.2.0 - Production
      System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
      Log messages written to /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
      Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
      TNS-12555: TNS:permission denied
       TNS-12560: TNS:protocol adapter error
        TNS-00525: Insufficient privilege for operation
         Linux Error: 1: Operation not permitted
          NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging 
       No valid ADR Base to use 
      
           NL-08013:  Invalid ADR Base directory
      
      Listener failed to start. See the error message(s) above...
      tnsnames.ora and listener.ora files are:
      # tnsnames.ora Network Configuration File:
      
      XE =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = vz11.vihost.pl)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = XE)
          )
        )
      
      EXTPROC_CONNECTION_DATA =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
          )
          (CONNECT_DATA =
            (SID = PLSExtProc)
            (PRESENTATION = RO)
          )
        )
      # listener.ora Network Configuration File:
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
            (PROGRAM = extproc)
          )
        )
      
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
            (ADDRESS = (PROTOCOL = TCP)(HOST = vz11.vihost.pl)(PORT = 1521))
          )
        )
      
      DEFAULT_SERVICE_LISTENER = (XE)
      What's wrong?
        • 1. Re: Error starting listener
          damorgan
          Did you read and follow the installation instructions including changes to the Linux kernel before performing the install?

          Post a copy of the file etc/hosts
          • 2. Re: Error starting listener
            JackK
            Thanks for your reply, damorgan.
            damorgan wrote:
            Did you read and follow the installation instructions including changes to the Linux kernel before performing the install?
            No, I didn't. However, few months ego I did install Oracle 11gXE on my another VPS (also not doing any changes in kernel) and DB is working fine.
            Post a copy of the file etc/hosts
            ::1          localhost ip6-localhost ip6-loopback
            fe00::0          ip6-localnet
            ff00::0          ip6-mcastprefix
            ff02::1          ip6-allnodes
            ff02::2          ip6-allrouters
            
            127.0.0.1 localhost.localdomain localhost
            # Auto-generated hostname. Please do not remove this comment.
            37.28.156.228 jackk_fx
            -------------
            Edited by: JackK on Jan 13, 2013 8:13 AM


            I can connect to DB like this:
            $ sqlplus / as sysdba
            SQL*Plus: Release 11.2.0.2.0 Production on N Sty 13 09:14:40 2013
            
            Copyright (c) 1982, 2011, Oracle.  All rights reserved.
            
            
            Connected to:
            Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
            
            SQL>
            PHP5 can also connect to my DB.
            I'm not able to connect remotely to this DB via SQL*Developer, however. The error message is:
            Status : Failure -Test failed: Błąd we-wy: The Network Adapter could not establish the connection
            I think this is because of not working listener. I don't know that to do to make him work.
            • 3. Re: Error starting listener
              JackK
              After reinstalling DB again and configuring (commented few lines in /etc/init.d oracle-xe) the listener can start.
              $ whoami
              oracle
              $ lsnrctl status
              LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-STY-2013 09:31:18
              
              Copyright (c) 1991, 2011, Oracle.  All rights reserved.
              
              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
              STATUS of the LISTENER
              ------------------------
              Alias                     LISTENER
              Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
              Start Date                12-STY-2013 22:27:38
              Uptime                    0 days 11 hr. 3 min. 40 sec
              Trace Level               off
              Security                  ON: Local OS Authentication
              SNMP                      OFF
              Default Service           XE
              Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
              Listener Log File         /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/vz11/listener/alert/log.xml
              Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vz11.vihost.pl)(PORT=1521)))
              Services Summary...
              Service "PLSExtProc" has 1 instance(s).
                Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
              Service "XE" has 1 instance(s).
                Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
              The command completed successfully
              But I still cannot connect remotely to DB.
              $ env
              SHELL=/bin/bash
              TERM=xterm
              SSH_CLIENT=<cutted IP> 41807 22
              NLS_LANG=POLISH_POLAND.AL32UTF8
              SSH_TTY=/dev/pts/2
              USER=oracle
              ORACLE_SID=XE
              PATH=/u01/app/oracle/product/11.2.0/xe/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
              MAIL=/var/mail/oracle
              PWD=/u01/app/oracle
              LANG=pl_PL.UTF-8
              HOME=/u01/app/oracle
              SHLVL=2
              LOGNAME=oracle
              SSH_CONNECTION=<cutted IP> 41807 <cutted IP> 22
              ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
              _=/usr/bin/env
              OLDPWD=/root
              --------------------
              Edited by: JackK on Jan 13, 2013 10:44 AM
              oracle@vz11:~$ sqlplus sygnalyfx
              
              SQL*Plus: Release 11.2.0.2.0 Production on N Sty 13 11:42:59 2013
              
              Copyright (c) 1982, 2011, Oracle.  All rights reserved.
              
              Enter password: 
              
              Connected to:
              Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
              
              SQL> exit
              Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
              oracle@vz11:~$ sqlplus sygnalyfx@localhost:1521/XE
              
              SQL*Plus: Release 11.2.0.2.0 Production on N Sty 13 11:43:29 2013
              
              Copyright (c) 1982, 2011, Oracle.  All rights reserved.
              
              ERROR:
              ORA-12541: TNS:no listener
              
              
              Enter user-name: 
              listener.ora file:
              # listener.ora Network Configuration File:
              
              SID_LIST_LISTENER =
                (SID_LIST =
                  (SID_DESC =
                    (SID_NAME = PLSExtProc)
                    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
                    (PROGRAM = extproc)
                  )
                  (SID_DESC =
                    (SID_NAME = XE)
                    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
                  )
                )
              
              LISTENER =
                (DESCRIPTION_LIST =
                  (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                    (ADDRESS = (PROTOCOL = TCP)(HOST = vz11.vihost.pl)(PORT = 1521))
                  )
                )
              
              DEFAULT_SERVICE_LISTENER = (XE)
              tnsnames.ora file:
              # tnsnames.ora Network Configuration File:
              
              XE =
                (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = vz11.vihost.pl)(PORT = 1521))
                  (CONNECT_DATA =
                    (SERVER = DEDICATED)
                    (SID = XE)
                  )
                )
              
              EXTPROC_CONNECTION_DATA =
                (DESCRIPTION =
                  (ADDRESS_LIST =
                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                  )
                  (CONNECT_DATA =
                    (SID = PLSExtProc)
                    (PRESENTATION = RO)
                  )
                )
              Help me, please... I need to be able to connect remotely.
              • 4. Re: Error starting listener
                damorgan
                I may well be wrong on this ... check the docs ... but I didn't know XE supported IPV6.
                • 5. Re: Error starting listener
                  clcarter
                  XE supported IPV6.
                  It does, but in name only. In other words, I don't think you can set your listener HOST= to an IPv6 address, but if its an IPv6 hostname, it can work. But the IPv6 address needs to be in /etc/hosts. Also see MOS note ID 362956.1 for info regarding 10g and 11g IPv6 support.

                  There are a couple things probably not quite correct with the networking setup. Looks like the interface has no IPv4 address, but in /etc/hosts:
                  # Auto-generated hostname. Please do not remove this comment.
                  37.28.156.228 jackk_fx
                  And for the instant client try (@host:port/service_name) ...
                  sqlplus sygnalyfx@localhost:1521/XE
                  ...
                  ORA-12541: TNS:no listener
                  That isn't going to work, since /etc/hosts has localhost for an alias to the IPv6 loopback address. The localhost /etc/hosts should point to 127.0.0.1, the IPv4 loopback. But if IPv4 is not configured on the interface, that would be a broken NIC setup anyway. Try:
                  sqlplus sygnalyfx@vz11.vihost.pl:1521/XE
                  ... ? also try the tnsnames.ora alias:
                  sqlplus sygnalyfx@xe
                  ... ?
                  And lastly, have you checked the firewall? Port 1521 has to be open to allow remote database connections, also port 8080 if Apex needs to be accessed remotely. A tnsping from any remote client will return different results, if the listener is running and the firewall port(s) are open it should return an "OK (<n> MSec)".

                  Usually for a blocked port, tnsping might return "TNS-12547: TNS:lost contact". From the database host, tnsping should work since tcp traffic won't be going through the firewall port.