My Oracle Support Banner

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

Last updated on FEBRUARY 08, 2019

Applies to:

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


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 multi-node
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= <DIR>/DEV/fs1/EBSapps/appl/ad/12.0.0/bin/ contextfile=<DIR>/fs2/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml log=<DIR>/DEV/fs_ne/EBSapps/log/adop/2/prepare_20140402_121445/<CONTEXT_NAME>/adconfig.log>
[STATEMENT] Executing <autoconfig> action in all nodes
Running in Serial
xml output = <DIR>/<SID>/fs1/EBSapps/appl/admin/<SID>_BALANCE/log/remote_execution_result.xml
*******FATAL ERROR*******
PROGRAM : (<DIR>/<SID>/fs1/EBSapps/appl/ad/12.0.0/bin/
TIME : Wed Apr 2 12:34:51 2014
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
SQLPLUS error: buffer=

SQL*Plus: Release - 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 ('HOST1','HOST2')
ERROR at line 3:
ORA-00936: missing expression

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

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





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.