Month: November 2012

  • ORA-00257: archiver error. Connect internal only, until freed.

    When connecting to a database via SQL*Plus (similar error would be displayed via other products) the following error is thrown: SQL*Plus: Release 10.2.0.3.0 – Production on Fri Nov 16 10:15:15 2012 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-00257: archiver error. Connect internal only, until freed. Cause: The area used as the Archive…

  • ORA-29280: invalid directory path

    Having migrated to a new database server, I encountered this error. After some investigation I checked the system parameter utl_file_path. This lists the directories where files can be created from Oracle. During migration I had set this parameter to a location where part of our system generates files which are then FTP’d to a different…