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 |