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

    TNS-12542: TNS:address already in use

    Tim Faitsch

      I'm running EPM 11.1.2.4.009 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?

      Thanks,

      Tim

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

          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> ???