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

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...