在oracle 12c的环境中折腾了安装apex ,最后导致了连接oracle出现错误ora-01035, 看看怎么解决
发现错误ORA-01035 only available to users with RESTRICTED,网上的解决方案
SQL> alter system disable restricted session;
运行该段代码后报错
ORA-65144 ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
继续查错,网上说使用下面语句查询出错的问题
select * from PDB_PLUG_IN_VIOLATIONS
查出结果
APEX mismatch: PDB has installed common APEX. CDB has not installed APEX.
继续搜查这个问题,网上介绍卸载CDB的apex,我判断应该是卸载pdb的apex。网上的链接:https://blogs.oracle.com/UPGRADE/entry/apex_in_pdb_does_not
故执行@apxremov.sql 卸载apex
完成后, 重启pdb。
连接正常了。