lsnrctl status

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

Hi all,

We are using Delphix Engine 5.0.4.0 on a number of Linux 7 servers and keep getting the following warnings :-


WARNING

Nov 09, 2016 1:55 AM

petldv04

Title: Command exited with a non-zero status

Details: Command 'lsnrctl status' exited with a non-zero exit code:

User Action: Check the exit status of the command when run by the Delphix OS user.


When logged on as the delphix_os account 'lsnrctl status' does not run as the Oracle environment is not set so I added the following to the .bash_profile :-


ORACLE_SID=<sid>;export ORACLE_SID

ORAENV_ASK=NO;export ORAENV_ASK

. oraenv


Now when logging in manually 'lsnrctl status' runs fine and returns a zero exit code yet we still see the warnings in the engine.

Has anyone else come across and resolved this issue?

Thanks in anticipation.

Photo of John Hubbard

John Hubbard

  • 142 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
Hi John
Could you please try setting the TNS_ADMIN environment variable correctly via the .bashrc?
Photo of John Hubbard

John Hubbard

  • 142 Points 100 badge 2x thumb

Hi Jaclyn,

thanks for the response. TNS_ADMIN is already set as far as I can tell. I have a support call open for this now and will update once we have a resolution.

Thanks again.

Photo of John Hubbard

John Hubbard

  • 142 Points 100 badge 2x thumb

I have had the following update from Support now :-

" The issue gets raised by the Environment Monitor incorrectly using/setting the TNS_ADMIN path. This has been fixed in the next main release (5.1.x), but for now it should be treated as a Warning, if you can manually run 'lsnrctl status' then you can safely mark the faults as "Ignore" and they will not then recur for the same object. "

Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
Thanks for the update John!