ORACLE12.1怎样克隆到ORACLE12.2

本篇文章给大家分享的是有关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

    以上就是ORACLE 12.1怎样克隆到ORACLE 12.2,小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注创新互联行业资讯频道。


    当前题目:ORACLE12.1怎样克隆到ORACLE12.2
    URL地址:http://myzitong.com/article/gddohs.html