Delphix Products

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

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%