ORACLE 12.1克隆到ORACLE 12.2

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、在目标端创建DB LINK

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

4、开始克隆：

     create pluggable database clone_orcl from orcl@test_link;

5、执行升级脚本：

    @ORACLE_HOME/bin/dbupgrade -c clone_orcl

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30061144/viewspace-2153103/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30061144/viewspace-2153103/