【MOS】Creating a PDB ... Fails With ORA-17630 (文件 ID 2090019.1)

lhrbest發表於2020-04-13
AI

Creating a PDB Remote Clone from 12.1.0.2 to 12.2 Fails With ORA-17630 (文件 ID 2090019.1)


In this Document

Symptoms
Changes
Cause
Solution
References


APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

Creating a PDB remote clone from 12.1.0.2 to 12.2 fails with:

SQL> create pluggable database MYDB from MYSEED@CDBMYSEED
file_name_convert=('/CDB12R1/','/CDB12R2/');
create pluggable database MYDB from MYSEED@CDBMYSEED
file_name_convert=('/CDB12R1/','/CDB12R2/')
  *
ERROR at line 1:
ORA-17628: Oracle error 17630 returned by remote Oracle server
ORA-17630: Mismatch in the remote file protocol version client server

 
The error is shown in the alert.log file and in the generated trace file as follow:

alert.log 

...
create pluggable database MYPDB from MYSEED@CDB12R1 file_name_convert=('/MYSEED/','/MYPDB/')
2015-12-11T17:48:30.353070+01:00
Errors in file /u01/app/oracle/diag/rdbms/cdb/CDB/trace/CDB_ora_4268_remote.trc:
ORA-17628: Oracle error 17630 returned by remote Oracle server
ORA-17630: Mismatch in the remote file protocol version client  server 
...
/u01/app/oracle/diag/rdbms/cdb/CDB/trace/CDB_ora_4268_remote.trc

...
*** 2015-12-11T17:48:30.352800+01:00 (CDB$ROOT(1))
ORA-17628: Oracle error 17630 returned by remote Oracle server
ORA-17630: Mismatch in the remote file protocol version client  server 
EXEC #0x7f34ee563838:c=76000,e=2344936,p=11,cr=279,cu=13,mis=0,r=0,dep=0,og=1,plh=0,tim=254798627784
ERROR #0x7f34ee563838: err=17628 tim=254798627869
LOBTMPCREATE: type=TEMPORARY LOB,bytes=1,c=0,e=41,p=0,cr=0,cu=0,tim=254798628632
LOBWRITE: type=TEMPORARY LOB,bytes=93,c=0,e=111,p=0,cr=0,cu=7,tim=254798628845
...

 

CHANGES

 

CAUSE

Unpublished Bug 22289708 - ORA-17630 WHILE TRYING TO REMOTE CLONE A PDB, closed as duplicate of:

Bug 18633374 - COPYING ACROSS REMOTE SERVERS: ASMCMD-8016, ORA-17628, ORA-17630, ORA-06512, 

The error is a result of looking for a particular protocol version instead of a set of protocol versions. In this case, the 12.2 client is sending both V1 & V2 as protocol versions and 12.1.0.2 (the remote side in this case) is expecting a single version not both. 
 

SOLUTION

Download and apply  Patch 18633374 on the side that does not include the fix for  Bug 18633374. The fix is included in 12.2 or later.

NOTE: Both sides must have the fix for  Bug 18633374

If no patch exists for your environment, please contact Oracle Support for a backport request.

Check for any conflicting Patches using  Document 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?

REFERENCES


BUG:18633374  - COPYING ACROSS REMOTE SERVERS: ASMCMD-8016, ORA-17628, ORA-17630, ORA-06512
NOTE:18633374.8  - Bug 18633374 - Error copying across remote servers with ASMCMD CP command (ASMCMD-8016, ORA-17628, ORA-17630, ORA-6512)

About Me

........................................................................................................................

● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除

● 本文在itpub、部落格園、CSDN和個人微 信公眾號（ DB寶）上有同步更新

● 本文itpub地址： http://blog.itpub.net/26736162

● 本文部落格園地址： http://www.cnblogs.com/lhrbest

● 本文CSDN地址： https://blog.csdn.net/lihuarongaini

● 本文pdf版、個人簡介及小麥苗雲盤地址： http://blog.itpub.net/26736162/viewspace-1624453/

● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/

● DBA寶典今日頭條號地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826

........................................................................................................................

● QQ群號： 230161599 、618766405

● 微 信群：可加我微 信，我拉大家進群，非誠勿擾

● 聯絡我請加QQ好友 （ 646634621 ），註明新增緣由

● 於 2020-04-01 06:00 ~ 2020-04-30 24:00 在西安完成

● 最新修改時間：2020-04-01 06:00 ~ 2020-04-30 24:00

● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解

● 版權所有，歡迎分享本文，轉載請保留出處

........................................................................................................................

● 小麥苗的微店： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

● 小麥苗出版的資料庫類叢書： http://blog.itpub.net/26736162/viewspace-2142121/

● 小麥苗OCP、OCM、高可用網路班： http://blog.itpub.net/26736162/viewspace-2148098/

● 小麥苗騰訊課堂主頁： https://lhr.ke.qq.com/

........................................................................................................................

使用 微 信客戶端掃描下面的二維碼來關注小麥苗的微 信公眾號（ DB寶）及QQ群（DBA寶典）、新增小麥苗微 信， 學習最實用的資料庫技術。

........................................................................................................................

歡迎與我聯絡

 

 



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-2685915/，如需轉載，請註明出處，否則將追究法律責任。

相關文章