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.

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 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/adconfig.sh 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/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 ('HOST1','HOST2')
*
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 <DIR>/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0x29a4730)') called at <DIR>/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 /<DIR>/oracle/DEV/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x22c7360)', 'SQL

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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