Skip to main content

Working Around Oracle Bug 27044169 ORA-17500 (KBA9163)




KBA# 9163

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases





How to Workaround Oracle Bug 27044169 ORA-17500

When trying to start a VDB, the Delphix engine reports an error similar to the following and the DB start fails:

ERROR at line 1: 
ORA-01142: cannot end online backup - none of the files are in backup 
ORA-06512: at line 6 

SQL> alter database open 
ERROR at line 1: ORA-03113: end-of-file on communication channel

This can be indicative of Oracle Bug 27044169  ORA-17500: ODM err:File exists when Creating Archivelog where the Rdbms is unable to create a new archivelog due to a file existing with a matching name (the log is prefixed with a full stop/period to mark as hidden), for example:


This hidden file will only remain if the archivelog fails to create successfully.

The easiest solution would be to refresh the VDB through the user interface (GUI). However, if that is not possible, the following steps can be used to workaround the issue.

To complete the workaround for Oracle Bug 27044169 ORA-17500

  1. Connect to the engine via ssh.
ssh admin@<delphix-engine>
  1. Stop the VDB from automatically starting (this will mount the file systems but not start the database).

delphix-engine> source
delphix-engine source> select VDBNAME
delphix-engine source VDBNAME> disable
delphix-engine source VDBNAME disable> commit
delphix-engine source VDBNAME> enable
delphix-engine source VDBNAME enable> set attemptStart=false
delphix-engine source VDBNAME enable> commit
  1. On the target target host execute the following.
$ mv /mnt/provision/VDBNAME/archive/.1_958_1093039296.dbf /mnt/provision/VDBNAME/archive/1_958_1093039296.dbf
  1. Start the VDB through the user interface (GUI). 

If this procedure is unsuccessful, then it will be necessary to refresh the VDB