12c中的APEX,ORA-65346 The PDB version is lower and components

0    76    1

Tags:

👉 本文共约1680个字,系统预计阅读时间或需7分钟。

Oracle APEX 在 12.1.0.2.0 中默认安装,而在 12.2.0.1.0 未默认安装,如果不进行 APEX 卸载,在 12.2.0.1.0 中 plug 12.1.0.2.0 版本的 pdb 将报如下 ORA-65346 错误:

解决:编辑xml 文件 /tmp/ pdbsample.xml , 删除以下行:

或者卸载APEX :

11g 需要跑 apxremov.sql , 12.1.0.2 需要跑脚本 apxremov_con.sql ,其它版本需要跑 apxremov_nocdb.sql 或 apxremov_cdb.sql 进行卸载 APEX 组件。



19c中卸载APEX组件

#移除PDB中的APEX组件,在PDB中执行,在19c中会报错,我们可以将18c中的相应脚本拷贝到19c中的相应位置后再执行@?/apex/apxremov_nocdb.sql即可。

ORA-01435: User does not Exist, Removing APEX (Doc ID 2641217.1)

In this Document

Symptoms
Changes
Cause
Solution

APPLIES TO:

Oracle Application Express (APEX) - Version 3.2.1 and later
Information in this document applies to any platform.

SYMPTOMS

On : APEX 3.2.1 version, Administration

When attempting to remove APEX using script apxremov.sql found under the ORACLE_HOME of a 19c DB
the following error occurs.

ORA-01435: user does not exist

STEPS
-----------------------
\1. Take an RMAN backup from 11g (Database) DB and restore it in a 19c DB
\2. Try to remove APEX using apxremov.sql script

CHANGES

CAUSE

Using the wrong version of the script (for the version of APEX to be remove).

Per example: the script belong to APEX 5.0 and you want to remove APEX 3.2.

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

SOLUTION

You need to use the apxremov.sql script that belongs to the APEX version installed on the DB (i.e for APEX 3.2 you can find the correct script under the $ORACLE_HOME/apex but from 11g database) as the apex version changes with each DB version.

If your 19c DB is on another server, we suggest:

\1. Zip all of the apex directory from the 11g server.

\2. Unzip under /tmp on target machine.

\3. Then change directories (cd) to the new apex directory and connected as SYS run the script from here.



升级APEX 组件

从 18c 开始, Oracle 不会自动更新 APEX 组件,需要手动更新。

下载 APEX : http://www.oracle.com/technetwork/developer-tools/apex/all-archives-099381.html

要写切换到解压的 apex 所在的目录下再以 sysdba 身份登录数据库,执行脚本升级

[oracle@cndba apex]$ pwd

/software/apex

sqlplus / as sysdba

SQL > @apexins.sql SYSAUX SYSAUX TEMP /i/

检查 APEX 版本

COL COMP_NAME FORMAT A40

COL STATUS FORMAT A12

SELECT COMP_NAME, STATUS, VERSION

FROM DBA_REGISTRY

WHERE COMP_NAME='Oracle Application Express';

COMP_NAME STATUS VERSION


Oracle Application Express VALID 5.1.4.00.08

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

6 + 5 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部