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