ORACLE 12CR1 PDB plugin 12CR2遇到问题
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=352071746945740&id=2111010.1&_afrWindowMode=0&_adf.ctrl-state=36hq5gpm3_4按照以上链接的步骤想在自己的环境中进行测试。
目前我的环境:
12cR1 RAC 两节点
12cR2 RAC 两节点
将1preupgrade_12201_cbuild_005包解压到 12.1 的 /u01/app/oracle/12.2 目录下，然后在12cR1节点使用如下命令 它就报错了，不管我将PDB 改成OPEN还是READ ONLY 模式都会报错，导致测试无法继续。如下：
$ /u01/app/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/app/oracle/12.2/preupgrade.jar dir /tmp -c NEW_PDB
File: dir_preUpgrade_catCon1.log Line: 65 --> error: ORA-16000: database or pluggable database open for read-only access
File: dir_preUpgrade_catCon1.log Line: 66 --> error: ORA-06512: at line 1
File: dir_preUpgrade_catCon2.log Line: 65 --> error: ORA-16000: database or pluggable database open for read-only access
File: dir_preUpgrade_catCon2.log Line: 66 --> error: ORA-06512: at line 1
ERROR - Unable to run the preupgrade due to: please see the log files for further information.
如果PDB被 关闭运行以上的命令 就会报：
$ /u01/app/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/app/oracle/12.2/preupgrade.jar dir /tmp -c NEW_PDB
ERROR - There are no databases or PDBs to process.
请问：/u01/app/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/app/oracle/12.2/preupgrade.jar dir /tmp -c NEW_PDB 这条命令在什么情况下才能运行成功？具体怎么实现 12cR1的 PDB 插入 12cR2
plugin图片 是 操作步骤。pre图片是报错信息
本帖最后由 chen1999 于 2017-7-21 22:35 编辑
参照此操作http://blog.csdn.net/u010692693/article/details/73826447
报错
SQL> create pluggable database NEW_PDB using '/u01/app/oracle/pdb/NEW_PDB.xml' nocopy;
create pluggable database NEW_PDB using '/u01/app/oracle/pdb/NEW_PDB.xml' nocopy
*
ERROR at line 1:
ORA-65346: The PDB version is lower and components (APEX) are missing in CDB.
查看NEW_PDB.xml：删除此行 <APEX>4.2.5.00.08:1</APEX>
执行升级PDB脚本后，已成功导入到12.2
页:
[1]