Upgrade to Oracle Audit Vault and Database Firewall (Oracle AVDF) 20.5.0.0.0 failed while executing database-migrations.rb (Doc ID 2826739.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

While upgrading to Oracle AVDF 20.5.0.0.0, it failed while executing database-migrations.rb

How to Identify, if upgrade has failed because of this issue:

Login to Oracle AVDF server as root and run following command

/opt/avdf/bin/privmigutl –status

Command will show the below error, if upgrade has failed because of this issue.

System state - recovery

Migration set 'AVS' - failed

Last migration 'Updating Oracle Audit Vault and Database Firewall data' - failed

Migrations will be resumed with 'Upgrading apex20'

Please review /var/log/messages and /var/log/debug for more information. Perform the actions necessary to get the system to the expected final state of migration.

The output of  “/opt/avdf/bin/privmigutl –history” command from last 3 lines will be showing as below.

Migration AVS:35, database-migrations.rb (as root) - failed

Migration APPLICATION:4, run-application-migrations["avs"] (as root; retry permitted) - failed

Migration TOP:11, run-privileged-migrations["application"] (as root; retry permitted) - failed

Check /var/log/messages, it should have following error message

database-migrations.rb ERROR - ODF-10001: Internal error: Failed to execute: ["/usr/bin/sudo", "-u", "oracle", "-E", "-H", "/var/lib/oracle/dbfw/bin/sqlplus", "/", "as", "sysdba", "@/usr/local/dbfw/bin/migration/connector.sql", "/usr/local/dbfw/bin/migration/2021/changeset_210528_PIGYKICYSE/database.sql"]

database-migrations.rb ERROR - ODF-10001: Internal error: Incremental migration of the system failed 

Check /var/log/debug, it should have below similar messages

database-migrations.rb DEBUG - Command output: alter table avsys.alert_event_map_arch add policy_name varchar2(4000 char)

database-migrations.rb DEBUG - Command output: *

database-migrations.rb DEBUG - Command output: ERROR at line 1:

database-migrations.rb DEBUG - Command output: ORA-01658: unable to create INITIAL extent for segment in tablespace

database-migrations.rb DEBUG - Command output: AV_ILM_0615_0621

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.