Error SEN-20038 returned opening or creating archive file with SDM

  • 7007181
  • 09-Nov-2010
  • 26-Apr-2012

Environment


Novell Sentinel 6.1
Oracle
Sentinel Database Manager

Situation

While  trying to archive partitions using Sentinel Database Manager (SDM) on Oracle Server database, the following error occurs:

Wed Dec 10 13:27:40 BRST 2008|Thread-5|SEVERE|esecurity.base.exceptions.DBException: SEN-20038 Error with opening file: directory /bkpcvrd/hvt055/archive_sentinel, file ESEC_ARCH_CORRELATED_EVENTS_P_20081031020000.1, INVALID_PATH
at esecurity.db.util.DBStatement.executeStatement(DBS tatement.java:470)
at esecurity.db.util.DBStatement.execute(DBStatement. java:269)
at esecurity.db.archive.ArchivePartitionManager.callA rchiveStoredProc(ArchivePartitionManager.java:229)
at esecurity.db.archive.ArchivePartitionManager.archi vePartitions(ArchivePartitionManager.java:167)
at esecurity.db.archive.ArchivePartitionManager.archi veData(ArchivePartitionManager.java:112)
at esecurity.db.archive.ArchivePartitionManager.archi ve(ArchivePartitionManager.java:83)
at esecurity.db.gui.ThreadSegmentsArchive.run(ThreadS egmentsArchive.java:47)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: SEN-20038::Error with opening file: directory {0}, file {1}, INVALID_PATH::/bkpcvrd/hvt055/archive_sentinel::ESEC_ARCH_CORRELATED_EVENTS_P_20 081031020000.1
at esecurity.db.util.DBStatement.checkForErrors(DBSta tement.java:514)
at esecurity.db.util.DBStatement.executeStatement(DBS tatement.java:466)
... 7 more
||||esecurity.db.gui.ThreadSegmentsArchive|run|

Resolution

If you installed the Oracle database on your own (without using Sentinel Installer), check to see in your init.ora or spfile the following parameter:

UTL_FILE_DIR=/path/to/archiving/directory

By default, Oracle does not permit a database instance to access the filesystem directly.   This needs to be explicitly allowed.