Listener Status Failed

[Former Member]

Dear Experts, I am getting one error during starting up the oracle listener. See the below error details...SID = BRX brxadm> lsnrctl LSNRCTL for HPUX: Version 12.1.0.2.0 - Production on 10-JUL-2016 17:16:48 Copyright (c) 1991, 2014, Oracle.  All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> status Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BRX.WORLD)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error   TNS-00511: No listener   HPUX Error: 239: Connection refused Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BRX)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error   TNS-00511: No listener   HPUX Error: 239: Connection refused Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erpbangsbx)(PORT=1521)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error   TNS-00511: No listener   HPUX Error: 239: Connection refused LSNRCTL> Help me to resolve this issue. Regards, Asad

[Reagan]

It says there is no Listener. If the Listener is down you need to start it.

By the way why are you checking the listener status using the <SID>adm user (brxadm)?

You should use ora<SID> to start the Listener.

[Former Member]

Dear Benjamin,

Thanks for your reply. But I am facing issue during starting the listener using ORASID ID. See the below error:

orabrx> lsnrctl start

LSNRCTL for HPUX: Version 12.1.0.2.0 - Production on 11-JUL-2016 09:41:43

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

Starting /oracle/BRX/121/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 12.1.0.2.0 - Production

System parameter file is /oracle/BRX/121/network/admin/listener.ora

Log messages written to /oracle/BRX/saptrace/diag/tnslsnr/erpbangsbx/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BRX.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=BRX)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpbangsbx)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BRX.WORLD))

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

  TNS-00507: Connection closed

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BRX))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

  HPUX Error: 239: Connection refused

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=erpbangsbx)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

  HPUX Error: 239: Connection refused

orabrx>

[JamesZ]

Since 12c, oracle user is used a lot,
Which is your database owner? "oracle" or "orasid"

[Former Member]

Hi Zhang, This is good question, How to know it? Regards, Asad

[JamesZ]

check the oracle, listener executables from os level, ls. who is the owner?

Then you should use the owner to start up listener

[Former Member]

Hi , Owner is ORASID, but I am trying to start listener using ORASID... but getting the same error.

[JamesZ]

Please do a clean startup:

lsnrctl stop
lsnrctl start

Also check if there is firewall in the landscape, because this looks like pure os issue:

HPUX Error: 239: Connection refused

[Former Member]

Dear Zhang,

Thanks for your prompt response.

I think it is not a firewall issue. I have performed the Oracle Upgrade from 11G to 12C. In 11C the Listener was running fine.

Regards,

[Reagan]

Check if the port is already in use.

If possible supply the configuration files from /oracle/BRX/121/network/admin location