Wikis - Page

Knowledge Doc: MPODB 2021.11.P4.022​​​​​​​ - Error in script dbspi_lsnr

1 Likes

Environment

OBM Management Pack for Oracle Database 2021.11.P4.022

Situation

Mistake in "ORACLE_HOME":

ovdeploy -cmd '/var/opt/OV/bin/instrumentation/dbspi_lsnr -v' -node dcplnx23275881 -ovrg server
ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
LSNR_STATUS: ''
listener 'LISTENER_OWBA074P' is OKAY

ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
LSNR_STATUS: 'LSNRCTL> TNS-01101: Could not find listener name or service name '
listener 'LISTENER_OWBA075P' is FAILED
OracleDB10-29: One or more Oracle network services are not configured.

ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
LSNR_STATUS: 'LSNRCTL> TNS-01101: Could not find listener name or service name '
listener 'LISTENER_OWBA076P' is FAILED
OracleDB10-29: One or more Oracle network services are not configured.

ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
LSNR_STATUS: 'LSNRCTL> TNS-01101: Could not find listener name or service name '
listener 'LISTENER_OWBA078P' is FAILED
OracleDB10-29: One or more Oracle network services are not configured.

ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
ORACLE_HOME=/oracle/OWBA074P/product/12.1.0.2_ee/db_1
LSNR_STATUS: 'LSNRCTL> TNS-01101: Could not find listener name or service name '
listener 'LISTENER_OWBA079P' is FAILED
OracleDB10-29: One or more Oracle network services are not configured.

This version of script dbspi_lsnr use only FIRST ORACLE_HOME in case that there is more LISTENERS in local.cfg:

ovdeploy -cmd 'dbspicfg -e' -node dcplnx23275881 -ovrg server
SYNTAX_VERSION 4

ORACLE

HOME "/oracle/OWBA074P/product/12.1.0.2_ee/db_1"
DATABASE "OWBA074P" CONNECT "TS_MON/***OWBA074P"
LOGFILE "/oracle/OWBA074P/base/diag/rdbms/owba074p/OWBA074P/trace/alert_OWBA074P.log"
LISTENER "LISTENER_OWBA074P" CONNECT ""

HOME "/oracle/OWBA075P/product/12.1.0.2_ee/db_1"
DATABASE "OWBA075P" CONNECT "TS_MON/***@OWBA075P"
LOGFILE "/oracle/OWBA075P/base/diag/rdbms/owba075p/OWBA075P/trace/alert_OWBA075P.log"
LISTENER "LISTENER_OWBA075P" CONNECT ""

HOME "/oracle/OWBA076P/product/19.0.0.0_ee/db_1"
DATABASE "OWBA076P" CONNECT "TS_MON/***t@OWBA076P"
LOGFILE "/oracle/OWBA076P/base/diag/rdbms/owba076p/OWBA076P/trace/alert_OWBA076P.log"
LISTENER "LISTENER_OWBA076P" CONNECT ""

HOME "/oracle/OWBA078P/product/12.1.0.2_ee/db_1"
DATABASE "OWBA078P" CONNECT "TS_MON/***@OWBA078P"
LOGFILE "/oracle/OWBA078P/base/diag/rdbms/owba078p/OWBA078P/trace/alert_OWBA078P.log"
LISTENER "LISTENER_OWBA078P" CONNECT ""

HOME "/oracle/OWBA079P/product/19.0.0.0_ee/db_1"
DATABASE "OWBA079P" CONNECT "TS_MON/***@OWBA079P"
LOGFILE "/oracle/OWBA079P/base/diag/rdbms/owba079p/OWBA079P/trace/alert_OWBA079P.log"
LISTENER "LISTENER_OWBA079P" CONNECT ""​​​​​​​

For resolution, read the complete knowledge article

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended