Demantra Upgrade From 12.2.3 To 12.2.5- Engine fails-NOTIFICATION.INITIALIZE FAILURE: -24000 ORA-24000: invalid value. Editioned Schema (Doc ID 2138804.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Upgraded Demantra from 12.2.3 to 12.2.5.1 and engine fails- Failed to
initialize notification queue for Engine Starter

customer following this Note:12.2.5.1 Engine Deployment Guide (Doc ID 2069139.1)
Applied Generic patches for 12.2.5.1 version

Manually create:
create or replace TYPE notification_type
AS OBJECT
( msg_id VARCHAR2(32),
timeout INTEGER,
content VARCHAR2(4000)
);

Still has this issue.
[demuat@demqaapp01 bin]$ ./EngineStarter.sh &
[1] 13712
[demuat@demqaapp01 bin]$ source
/demantra/product/Engine/bin/setenv.sh; ./EngineStarter DEM_CONN
starter1 5
2016-04-19.05:31:04 WARNING: Old aapp01.DEMANTRA.com was removed from
ENGINE_STARTER_LIST
2016-04-19.05:31:04 ERROR: Failed to initialize notification queue for Engine
Starter ID: aapp01.DEMANTRA.com, Status: FAILURE: -24000 ORA-24000: invalid
value DEMANTRA.AAPP01.DEMANTRA.COM_OUT, QUEUE_TABLE should be of the form
[SCHEMA.]NAME, Exiting...

[1]+ Done ./EngineStarter.sh

db_exception_log :
NOTIFICATION.INITIALIZE Error failed to create queue
table : AAPP01.DEMANTRA.COM_OUT
NOTIFICATION.INITIALIZE ERROR - Failed to create queue
table : AAPP01.DEMANTRA.COM_IN
NOTIFICATION.INITIALIZE FAILURE: -24000 ORA-24000:
invalid value DEMANTRA.AAPP01.DEMANTRA.COM_IN, QUEUE_TABLE should be of the form
[SCHEMA.]NAME
NOTIFICATION.INITIALIZE Error failed to create queue
table : AAPP01.DEMANTRA.COM_IN

Changes

Cause

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