11
Apr

Error on login page of Oracle E-Business Suite

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


Try to login now

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to Top