Message 1053 not found; No message file for product=network giving by lsnrctl status command

Problem:

[oracle@db2 ~]$ /opt/oracle/product/11.2.0.3/bin/lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-APR-2017 12:00:35

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

Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS  Message 1050 not found; No message file for product=network, facility=TNS

Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS

  Message 1408 not found; No message file for product=network, facility=TNS

Message 1411 not found; No message file for product=network, facility=TNS

  Message 1408 not found; No message file for product=network, facility=TNS

Message 1411 not found; No message file for product=network, facility=TNS

  Message 1408 not found; No message file for product=network, facility=TNS

Message 1411 not found; No message file for product=network, facility=TNS

  Message 1408 not found; No message file for product=network, facility=TNS

  Message 1408 not found; No message file for product=network, facility=TNS

Message 1052 not found; No message file for product=network, facility=TNS

 

Solution:

[oracle@db2 ~]$ echo $ORACLE_HOME

 

[oracle@db2 ~]$

No ORACLE_HOME is set in environment variable, therefore it shows the above error

[oracle@db2 ~]$ export ORACLE_HOME=/opt/oracle/product/11.2.0.3

[oracle@db2 ~]$ /opt/oracle/product/11.2.0.3/bin/lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-APR-2017 12:20:31

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stagedevdb2.ipx.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                21-NOV-2016 00:00:22

Uptime                    133 days 11 hr. 20 min. 8 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /opt/oracle/product/11.2.0.3/network/admin/listener.ora

Listener Log File         /opt/oracle/diag/tnslsnr/stagedevdb2/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stagedevdb2.ipx.com)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM", status READY, has 1 handler(s) for this service...

Service "TESTDB" has 1 instance(s).

  Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

Comments