Oracle APEX ORDSURL 500 Internal Server Error

Oracle APEX ORDSURL  500 Internal Server Error

1.检查日志
ords.log under /u01/app/oracle/product/ords/logs

Stop ORDS

       /etc/init.d/ords stop

Connect to the CDB as SYS and OPEN the ORDS_PUBLIC_USER , make sure to use the Exact same password used before (usually the same one used by SYS if in DBCS)
如果是用户名过期  需要执行以下操作
      SQL> Alter user ords_public_user identified by xxxx;
      SQL> ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK;

Delete or Move out the ords.log under /u01/app/oracle/product/ords/logs so fresh logs start generating

Re-Start ORDS

       /etc/init.d/ords start

Try again to access the APEX URL on the PDB: http://<IP>/ords/<PDBNAME>

2.检查下数据库是否有关于ORDS的 失效对象

-- 刘轶鹤