Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to clone ORACLE 12.1 to ORACLE 12.2, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

1. Resolve version conflicts: ora-17630 ora-17628

Patch the source side: 18633374

2. Delete the source APEX:ORA-65346

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

Connect to your CDB$ROOT:

Sqlplus / as sysdba

Run the "Remove APEX from the CDB$ROOT" script:

SQL > @ apxremov_con.sql

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. Create a DB LINK on the destination side

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

4. Start cloning:

Create pluggable database clone_orcl from orcl@test_link

5. Execute the upgrade script:

@ ORACLE_HOME/bin/dbupgrade-c clone_orcl

The above is how to clone ORACLE 12.1 to ORACLE 12.2. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.