1 Reply Latest reply on Apr 25, 2016 4:31 PM by clcarter

    TNS-12542: TNS:address already in use


      I'm running EPM on Linux. Was working fine up until yesterday. Now when I try to start EPM it fails. It looks like the reason is that the XE database has an issue. When I try to start the database now I see this in /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/listener.log:


      Sat Apr 23 17:03:56 2016

      Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))

      23-APR-2016 17:03:56 * service_register * XE * 12542

      TNS-12542: TNS:address already in use

      TNS-12560: TNS:protocol adapter error

        TNS-00512: Address already in use

         Linux Error: 98: Address already in use

      23-APR-2016 17:03:58 * service_update * XE * 0

      23-APR-2016 17:04:03 * service_died * XE * 12537

      23-APR-2016 17:04:05 * ping * 0


      Can someone point me in the right direction on how to troubleshoot this?



        • 1. Re: TNS-12542: TNS:address already in use

          Tim Faitsch wrote:

          ...TNS-12542: TNS:address already in use


          A listener has already been started or some other process has that port. Try and see if its a listener, also check netstat output and verify if it is the listener using that port:


          ps -ef |egrep lsnr

            oracle <PID> 1 ... <OH>/bin/tnslsnr LISTENER ...

          netstat -an |egrep 1521


            tcp4... <ip>.1521  *.* LISTEN


          sudo lsof -i :1521

            ... <PID> ???