R12.2 adop fs_clone Fails with ORA-00936: missing expression
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.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.