Delphix Products

Expand all | Collapse all

Oracle EBS R12.1.3 - db stack provisioning - "Missing listener name" error

Jump to Best Answer
  • 1.  Oracle EBS R12.1.3 - db stack provisioning - "Missing listener name" error

    Posted 04-17-2015 04:25:00 PM
    Delphix Engine 4.1.3
    Oracle EBS R12.1.3

    When provisioning db stack I'm receiving following error.



    Part of the log file (addlnctl.txt).
    ...
    Copyright (c) 1991, 2008, Oracle. All rights reserved.

    Starting /data/u01/oracle/VISDEV/db/tech_st/11.1.0/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.1.0.7.0 - Production
    System parameter file is /data/u01/oracle/VISDEV/db/tech_st/11.1.0/network/admin/VISDEV_ebstrg10/listener.ora
    Log messages written to /data/u01/oracle/VISDEV/db/tech_st/11.1.0/log/diag/tnslsnr/ebstrg10/visdev/alert/log.xml
    TNS-01151: Missing listener name, VISDEV, in LISTENER.ORA

    Listener failed to start. See the error message(s) above...



    04/17/15-20:20:04 :: addlnctl.sh: exiting with status 1

    listener.ora generated during provisioning process

    #
    # $Header: ad8ilsnr.ora 120.3.12010000.3 2010/03/09 07:07:03 jmajumde ship $
    #
    # ###############################################################
    #
    # This file is automatically generated by AutoConfig. It will be read and
    # overwritten. If you were instructed to edit this file, or if you are not
    # able to use the settings created by AutoConfig, refer to Metalink Note
    # 387859.1 for assistance.
    #
    # ###############################################################

    #

    #
    # Net8 definition for Database listener
    #

    =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ebstrg10.spica.local)(PORT = 1522))
    )
    )

    SID_LIST_ =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME= /data/u01/oracle/VISDEV/db/tech_st/11.1.0)
    (SID_NAME = VISDEV)
    )
    )

    STARTUP_WAIT_TIME_ = 0
    CONNECT_TIMEOUT_ = 10
    TRACE_LEVEL_ = OFF

    LOG_DIRECTORY_ = /data/u01/oracle/VISDEV/db/tech_st/11.1.0/network/admin
    LOG_FILE_ =
    TRACE_DIRECTORY_ = /data/u01/oracle/VISDEV/db/tech_st/11.1.0/network/admin
    TRACE_FILE_ =
    ADMIN_RESTRICTIONS_ = ON
    SUBSCRIBE_FOR_NODE_DOWN_EVENT_ = OFF


    # added parameters for bug# 9286476
    LOG_STATUS_ = ON
    INBOUND_CONNECT_TIMEOUT_ = 60

    # ADR is only applicable for 11gDB
    DIAG_ADR_ENABLED_ = ON
    ADR_BASE_ = /data/u01/oracle/VISDEV/db/tech_st/11.1.0/admin/VISDEV_ebstrg10

    IFILE=/data/u01/oracle/VISDEV/db/tech_st/11.1.0/network/admin/VISDEV_ebstrg10/listener_ifile.ora
    
    What is the problem here? Why new cloned listener.ora gets corrupted?

    #OracleEBS


  • 2.  RE: Oracle EBS R12.1.3 - db stack provisioning - "Missing listener name" error
    Best Answer

    Posted 04-18-2015 06:09:00 AM
    I think it is solved. It was not Delphix toolkit problem but Oracle's.

    The problem was related to Oracle's cloning script error. I found the variable %s_db_listener% in file $ORACLE_HOME/appsutil/templates/ad8ilsnr.ora was not populated by cloning script. I replaced variable %s_db_listener% with %s_dbSid%.

    File before the change:
    #
    # $Header: ad8ilsnr.ora 120.3.12010000.3 2010/03/09 07:07:03 jmajumde ship $
    #
    # $AutoConfig$
    #

    #
    # Net8 definition for Database listener
    #

    %s_db_listener% =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = %s_virtual_hostname%.%s_domainname%)(PORT = %s_dbport%))
    )
    )

    SID_LIST_%s_db_listener% =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME= %s_db_oh%)
    (SID_NAME = %s_dbSid%)
    )
    )

    STARTUP_WAIT_TIME_%s_db_listener% = 0
    CONNECT_TIMEOUT_%s_db_listener% = 10
    TRACE_LEVEL_%s_db_listener% = OFF

    LOG_DIRECTORY_%s_db_listener% = %s_db_oh%/network/admin
    LOG_FILE_%s_db_listener% = %s_db_listener%
    TRACE_DIRECTORY_%s_db_listener% = %s_db_oh%/network/admin
    TRACE_FILE_%s_db_listener% = %s_db_listener%
    ADMIN_RESTRICTIONS_%s_db_listener% = %s_admin_restrictions%
    SUBSCRIBE_FOR_NODE_DOWN_EVENT_%s_db_listener% = %s_subscribe_for_node_down_event%


    # added parameters for bug# 9286476
    LOG_STATUS_%s_db_listener% = %s_lsnr_log_status%
    INBOUND_CONNECT_TIMEOUT_%s_db_listener% = 60

    # ADR is only applicable for 11gDB
    DIAG_ADR_ENABLED_%s_db_listener% = %s_diag_adr_enabled%
    ADR_BASE_%s_db_listener% = %s_adr_base%
    File after change:

    #
    # $Header: ad8ilsnr.ora 120.3.12010000.3 2010/03/09 07:07:03 jmajumde ship $
    #
    # $AutoConfig$
    #

    #
    # Net8 definition for Database listener
    #

    %s_dbSid% =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = %s_virtual_hostname%.%s_domainname%)(PORT = %s_dbport%))
    )
    )

    SID_LIST_%s_dbSid% =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME= %s_db_oh%)
    (SID_NAME = %s_dbSid%)
    )
    )

    STARTUP_WAIT_TIME_%s_dbSid% = 0
    CONNECT_TIMEOUT_%s_dbSid% = 10
    TRACE_LEVEL_%s_dbSid% = OFF

    LOG_DIRECTORY_%s_dbSid% = %s_db_oh%/network/admin
    LOG_FILE_%s_dbSid% = %s_dbSid%
    TRACE_DIRECTORY_%s_dbSid% = %s_db_oh%/network/admin
    TRACE_FILE_%s_dbSid% = %s_dbSid%
    ADMIN_RESTRICTIONS_%s_dbSid% = %s_admin_restrictions%
    SUBSCRIBE_FOR_NODE_DOWN_EVENT_%s_dbSid% = %s_subscribe_for_node_down_event%


    # added parameters for bug# 9286476
    LOG_STATUS_%s_dbSid% = %s_lsnr_log_status%
    INBOUND_CONNECT_TIMEOUT_%s_dbSid% = 60

    # ADR is only applicable for 11gDB
    DIAG_ADR_ENABLED_%s_dbSid% = %s_diag_adr_enabled%
    ADR_BASE_%s_dbSid% = %s_adr_base%