Error:
Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
ORA-00257: archiver error. Connect internal only, until freed
Solution:
Check Flash Recovery Area usage:
SELECT
ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,
ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,
ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,
SUM(B.PERCENT_SPACE_USED) AS PERCENT_OF_SPACE_USED
FROM
V$RECOVERY_FILE_DEST A,
V$FLASH_RECOVERY_AREA_USAGE B
GROUP BY
SPACE_LIMIT,
SPACE_USED ,
SPACE_RECLAIMABLE;
Output:
FLASH_IN_GB: 300
FLASH_USED_IN_GB: 299.59
FLASH_RECLAIMABLE_GB: 0
PERCENT_OF_SPACE_USED: 99.86
From the output we see that the FRA is full.
Release space from the FRA and then try logging in.
FLASH_IN_GB: 300
FLASH_USED_IN_GB: 133.15
FLASH_RECLAIMABLE_GB: 0
PERCENT_OF_SPACE_USED: 44.83