INSTALLATION DOCUMENTS BY RAVI

Sunday, February 11, 2018

Failure -Test failed: ORA-00257: archive error. Connect internal only, until freed














Check the status of the archive log






Check the database archive log destination








It is showing archive log space is full

Remove some archive log files






If we get limit exceed error, increase the archive log size as below

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=20048576000 SCOPE=BOTH;





Restart the database


































No comments:

Post a Comment

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...