本篇文章給大家分享的是有關(guān)ORACLE 12.1怎樣克隆到ORACLE 12.2，小編覺得挺實用的，因此分享給大家學(xué)習(xí)，希望大家閱讀完這篇文章后可以有所收獲，話不多說，跟著小編一起來看看吧。

為企業(yè)提供做網(wǎng)站、成都網(wǎng)站設(shè)計、網(wǎng)站優(yōu)化、成都營銷網(wǎng)站建設(shè)、競價托管、品牌運營等營銷獲客服務(wù)。創(chuàng)新互聯(lián)建站擁有網(wǎng)絡(luò)營銷運營團隊，以豐富的互聯(lián)網(wǎng)營銷經(jīng)驗助力企業(yè)精準獲客，真正落地解決中小企業(yè)營銷獲客難題，做到“讓獲客更簡單”。自創(chuàng)立至今，成功用技術(shù)實力解決了企業(yè)“網(wǎng)站建設(shè)、網(wǎng)絡(luò)品牌塑造、網(wǎng)絡(luò)營銷”三大難題，同時降低了營銷成本，提高了有效客戶轉(zhuǎn)化率，獲得了眾多企業(yè)客戶的高度認可！

1、解決版本沖突：ora-17630 ora-17628

     在源端打補丁：18633374

2、刪除源端APEX：ORA-65346

1. Make sure to change into the local$ORACLE_HOME/apexdirectoryfirstbefore starting SQL*Plus as otherwise the removal process won’t work and error out – I’d assume that path variables are not carried on correctly.
   cd $ORACLE_HOME/apex

2. Connect to your CDB$ROOT:
   sqlplus / as sysdba

3. Run the “Remove APEX from the CDB$ROOT” script:
   SQL>@apxremov_con.sql

4. Check afterwards if APEX has been removed – also check for invalid objects. If necessary recompile.
   In my tests two objects wereINVALIDafter the removalbut could be easily fixed
   (this part is not mentioned in the documentation):

   SQL> select COMP_ID, STATUS from DBA_REGISTRY where COMP_ID='APEX'; no rows selectedSQL> select object_name, status from dba_objects where status='INVALID';OBJECT_NAME                      STATUS -------------------------------- ------------- APEX_PKG_APP_INSTALL_LOG         INVALID APEX_SPATIAL                     INVALID SQL> @?/rdbms/admin/utlrp.sql SQL> select object_name, status from dba_objects where status='INVALID'; no rows selected

3、在目標(biāo)端創(chuàng)建DB LINK

     create public database link test_link connect to leotest identified by leotest using 'node1:1521/orcl';

4、開始克?。?/p>

     create pluggable database clone_orcl from orcl@test_link;

5、執(zhí)行升級腳本：

    @ORACLE_HOME/bin/dbupgrade -c clone_orcl

以上就是ORACLE 12.1怎樣克隆到ORACLE 12.2，小編相信有部分知識點可能是我們?nèi)粘９ぷ鲿姷交蛴玫降?。希望你能通過這篇文章學(xué)到更多知識。更多詳情敬請關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道。