We are on PPM 7.5 SP5. We have a patch migration process which internally uses the OOTB workflow for patch deployments (We have Oracle e-business suite v7.5 extension). Same patch goes through DEV --> TEST --> QA --> PROD environment.
Recently we have migrated TEST environment from one database server to another. After migration, necessary changes are done in the 'Environment' tab for TEST environment but it fails to set the instance to maintenance mode and again back to NORMAL mode. Is any other change required other than changing server names in environment settings? Please advise.
The following Command Step is not subject to timing out: com.kintana.core.server.execution.CLScriptCommand KSC Script Command Source Command: Reset to Original Instance Mode Successfully created: /u02/kintana/itg/transfers/TMP_kintana_3960/reset_mode.sql CL Local Exec Source Command: Reset to Original Instance Mode sqlplus APPS/#!#*****#!#@DWCHOA2 @/u02/kintana/itg/transfers/TMP_kintana_3960/reset_mode.sql SQL*Plus: Release 10.2.0.4.0 - Production on Sun Nov 22 22:21:29 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor