R12.2 Apps DBA. Powered by Blogger.

R12.2 adop fs_clone Fails with ORA-00936: missing expression

No comments :
Error:
Performing CLONE steps...
  Log: /opt/oracle/CLOUD/fs_ne/EBSapps/log/adop/11/fs_clone_20150806_103139/CLOUD_ebsclone4
*******FATAL ERROR*******
PROGRAM : (/opt/oracle/*****/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME : Thu Aug 6 10:34:59 2015
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 6 10:34:59 2015

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

SQL> SQL> Connected.
SQL> SELECT clone_status||',' FROM ad_adop_session_patches WHERE status in ('R','F','N') AND bug_number = 'CLONE' AND node_name = 'ebsclone4' AND adop_session_id =
  *
ERROR at line 1:
ORA-00936: missing expression
:
:
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
A STACK TRACE reflects the following errors:
 at /opt/oracle/*****/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0x26687a0)') called at /opt/oracle/CLOUD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x40e2188)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /opt/oracle/CLOUD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x40e2188)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /opt/oracle/CLOUD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
  [UNEXPECTED]Error occurred while CLONE Patch File System from Run File System using command: "perl /opt/oracle/CLOUD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/opt/oracle/CLOUD/fs2/inst/apps/CLOUD_ebsclone4/appl/admin/CLOUD_ebsclone4.xml -patchcontextfile=/opt/oracle/CLOUD/fs1/inst/apps/CLOUD_ebsclone4/appl/admin/CLOUD_ebsclone4.xml -promptmsg=hide -console=off -mode=create -sessionid=11 -timestamp=20150806_103139 -outdir=/opt/oracle/CLOUD/fs_ne/EBSapps/log/adop/11/fs_clone_20150806_103139/CLOUD_ebsclone4".
  Releasing the managed servers ports...
  Log: /opt/oracle/CLOUD/fs_ne/EBSapps/log/adop/11/fs_clone_20150806_103139/CLOUD_ebsclone4/txkCloneAcquirePort.log
  Stopping services on patch file system...

  Stopping admin server...
Solution:
1. Apply Patch 19765466 to obtain the diagnostic information for the latest adop sessions.
2. From generated diagnostics check the adzdshowstatus.out.
  For example:
=========================================================================
=                 Summary of the Last 10 ADOP Cycles
=========================================================================
Session ID Node Name  Node Type Started    Elapsed(Prepare) Elapsed(Cutover) Elapsed(Cleanup) Elapsed(Apply)  Status       Patches Applied      Session Type
---------- ---------- --------- ---------- ---------------- ---------------- ---------------- --------------- ------------ -------------------- ---------------
       13 ebsystem  master    24-AUG-15  1:04:50          0:00:00          0:00:00          0:00:00         FAILED       --                   --
       11 ebsystem  master    04-AUG-15  0:33:39          0:00:00          0:01:56          0:00:00         FAILED       CONFIG_CLONE         CONFIG_CLONE
3. Take a back up for table ad_adop_session_patches.
4. Run the following sql:
 update ad_adop_session_patches set
 bug_number='CLONE',status='N',SESSION_TYPE='CLONE',CLONE_STATUS='NOT STARTED'
 where bug_number='CONFIG_CLONE' and status <> 'Y' and adop_Session_id=<*>  ;
 commit;
Where <*> =  the session_id related to the CONFIG_CLONE row, in above example eg.  adop_Session_id= '11'.
5. Re-run adop phase=fs_clone to confirm the results.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.