adop Errors ORA-00936: missing expression In Shared Multi Node Environment (Doc ID 1677053.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Applications DBA - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.2.3 version, Patch Application Issues,
when attempting to adop phase=prepare,
the following error occurs:

ORA-00936: missing expression


The issue can be reproduced at will with the following steps:
1. Fresh install multinode
2. In the process to upgrade to 12.2.3
3.- adop phase=prepare

The issue has the following business impact:
Due to this issue, users cannot continue with the upgrade

Error in prepare phase when run adop:

[STATEMENT] [END 2014/04/02 12:33:42] Running AutoConfig
[STATEMENT] Content in remote input file : <nodename=node2>
[STATEMENT] Content in remote input file : <command= /u02/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/bin/adconfig.sh contextfile=/u02/oracle/DEV/fs2/inst/apps/DEV_node2/appl/admin/DEV_node2.xml log=/u02/oracle/DEV/fs_ne/EBSapps/log/adop/2/prepare_20140402_121445/DEV_node2/adconfig.log>
[STATEMENT] Executing <autoconfig> action in all nodes
Running in Serial
xml output = /u02/oracle/DEV/fs1/EBSapps/appl/admin/DEV_BALANCE/log/remote_execution_result.xml
*******FATAL ERROR*******
PROGRAM : (/u02/oracle/DEV/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Wed Apr 2 12:34:51 2014
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Apr 2 12:34:51 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> where adop_session_id = 2 and appltop_id = and node_name in ('node1','node2')
*
ERROR at line 3:
ORA-00936: missing expression


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

STACK TRACE
at /u02/oracle/DEV/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0x29a4730)') called at /u02/oracle
/DEV/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x22c7360)', 'SQLPLUS error: buf
fer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u02/o
racle/DEV/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x22c7360)', 'SQL

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms