Oracle EBS R12.1.3 - apps tier provisionig - "Expect script failed with code 1"

  • 0
  • 1
  • Problem
  • Updated 3 years ago
  • Solved
Delphix Engine 4.1.3
Oracle EBS R12.1.3

Apps tier provisioning fails with message "Error: Expect script executed as "oracle" on "ebstrg20.spica.local" failed with exit code 1: #"



The start log is perfectly ok. All services started.
[Service Control Execution Report]
The report format is:
<Service Group> <Service> <Script> <Status>

Root Service Enabled
Root Service Oracle Process Manager for VISDEV_ebstrg20 adopmnctl.sh Started
Web Entry Point Services Enabled
Web Entry Point Services Oracle HTTP Server VISDEV_ebstrg20 adapcctl.sh Started
Web Entry Point Services OracleTNSListenerAPPS_VISDEV_ebstrg20 adalnctl.sh Started
Web Application Services Enabled
Web Application Services OACORE OC4J Instance VISDEV_ebstrg20 adoacorectl.sh Started
Web Application Services FORMS OC4J Instance VISDEV_ebstrg20 adformsctl.sh Started
Web Application Services OAFM OC4J Instance VISDEV_ebstrg20 adoafmctl.sh Started
Batch Processing Services Enabled
Batch Processing Services OracleConcMgrVISDEV_ebstrg20 adcmctl.sh Started
Batch Processing Services Oracle Fulfillment Server VISDEV_ebstrg20 jtffmctl.sh Started
Other Services Disabled
Other Services OracleFormsServer-Forms VISDEV_ebstrg20 adformsrvctl.sh Disabled
Other Services Oracle Metrics Client VISDEV_ebstrg20 adfmcctl.sh Disabled
Other Services Oracle Metrics Server VISDEV_ebstrg20 adfmsctl.sh Disabled
Other Services Oracle MWA Service VISDEV_ebstrg20 mwactlwrpr.sh Disabled


ServiceControl is exiting with status 0

04/18/15-15:03:36 :: You are running adstrtal.sh version 120.15.12010000.3


=================================================================
Clone application is working without problems. I can login and work normally.





Is is also possible to make a snapshot of "VISDEV appsTier" object from CLI.



Unfortunately appsTier object stays FAILED after initial error.



How can I overcome this problem? What can I check? It seem that this time everything is ok at Oracle's part. All services are up and working. adstrtal.sh finishes with exit code 0 and I don't see a reason why toolkit script is failing.
What is the way Delphix engine is checking the apps tier object is running? Is there a way to make it discover this object as RUNNING? 

Error message copied from Dx user interface:

Error:
Expect script executed as "oracle" on "ebstrg20.spica.local" failed with exit code 1: #
# Copyright (c) 2014 by Delphix. All rights reserved.
#
# Runs adcfgclone as part of the E-Business Suite appsTier toolkit.
# Interactively responds to prompts from adcfgclone based on the
# toolkit's provision parameters.
#

set env(ORACLE_HOME) "${env(DLPX_DATA_DIRECTORY)}/${env(DLPX_ORACLE_HOME)}"
set env(COMMON_TOP) "${env(DLPX_DATA_DIRECTORY)}/${env(DLPX_COMMON_TOP)}"
set perlDir "${env(ORACLE_HOME)}/perl/bin"
set env(ADPERLPRG) "${perlDir}/perl"
set env(PATH) "${perlDir}:${env(PATH)}:/usr/ccs/bin"

cd ${env(COMMON_TOP)}/clone/bin
set env(PERL5LIB) [join [glob -nocomplain "${env(ORACLE_HOME)}/perl/lib/*" "${env(ORACLE_HOME)}/perl/lib/site_perl/*" "."] :]

#
# Include our own custom perl module that forces autoflush to be enabled on stdout.
# The standard way to do this is to set the $| variable to a non-zero value.
#
set modulefile [open "dlpx_force_autoflush.pm" w]
puts $modulefile "$| = 1;"
flush $modulefile

set adpid [spawn ${env(ADPERLPRG)} -mdlpx_force_autoflush ./adcfgclone.pl appsTier]
stty -echo
send "${env(DLPX_APPS_PASSWORD)}\n"
stty echo

set timeout [expr 180 * 60]

set exitCode 0
expect {
-re {Target System Hostname \(virtual or normal\).* : } {
send "${env(DLPX_HOSTNAME)}\n"
exp_continue
}
-re {Target System Database SID.* : } {
send "${env(DLPX_SID)}\n"
exp_continue
}
-re {Target System Database Server Node.* : } {
send "${env(DLPX_DB_HOSTNAME)}\n"
exp_continue
}
-re {Target System Database Domain Name.* : } {
send "${env(DLPX_DB_DOMAIN_NAME)}\n"
exp_continue
}
-re {Target System Base Directory.* : } {
send "${env(DLPX_DATA_DIRECTORY)}\n"
exp_continue
}
-re {Target System Tools ORACLE_HOME Directory.* : } {
send "\n"
exp_continue
}
-re {Target System Web ORACLE_HOME Directory.* : } {
send "\n"
exp_continue
}
-re {Target System APPL_TOP Directory.* : } {
send "\n"
exp_continue
}
-re {Target System COMMON_TOP Directory.* : } {
send "\n"
exp_continue
}
-re {Target System Instance Home Directory.* : } {
send "${env(DLPX_INST_TOP)}\n"
exp_continue
}
-re {Username for the Applications File System Owner.* : } {
send "${env(LOGNAME)}\n"
exp_continue
}
-re {Target System Root Service.* : } {
if {[string equal "${env(DLPX_ROOT_SERVICE)}" "true"]} {
send "enabled\n"
} else {
send "disabled\n"
}
exp_continue
}
-re {Target System Web Entry Point Services.* : } {
if {[string equal "${env(DLPX_WEB_ENTRY_SERVICE)}" "true"]} {
send "enabled\n"
} else {
send "disabled\n"
}
exp_continue
}
-re {Target System Web Application Services.* : } {
if {[string equal "${env(DLPX_WEB_APP_SERVICE)}" "true"]} {
send "enabled\n"
} else {
send "disabled\n"
}
exp_continue
}
-re {Target System Batch Processing Services.* : } {
if {[string equal "${env(DLPX_BATCH_SERVICE)}" "true"]} {
send "enabled\n"
} else {
send "disabled\n"
}
exp_continue
}
-re {Target System Other Services.* : } {
if {[string equal "${env(DLPX_OTHER_SERVICE)}" "true"]} {
send "enabled\n"
} else {
send "disabled\n"
}
exp_continue
}
-re {Do you want to preserve the Display.* : } {
send "n\n"
exp_continue
}
-re {Target System Display .* : } {
send "${env(DLPX_DISPLAY)}\n"
exp_continue
}
-re {Do you want the the target system to have the same port values as the source system.* : } {
send "n\n"
exp_continue
}
-re {Target System Port Pool.* : } {
send "${env(DLPX_PORT_POOL)}\n"
exp_continue
}
-re {Do you want to continue.*(y/n)

Error Code:
exception.db.generictarget.expect_script.failed

Suggested Action:
Review the output of the script, correct the error, and run the operation again. To access the VDB you may reenable it. See the Delphix documentation for information on enabling and disabling VDBs.
 
Photo of Piotr Goliasz

Piotr Goliasz

  • 980 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Official Response
Supreme. 
(Edited)