ORA-20163: Your license is not valid for this database. You have licensed the database orcl_a but the software runs on rdscdb_a

Vragen
,
1

When executing the following Oracle code to establish connection:

declare
  l_cnt pls_integer; 
begin 
  insert into bubs_pre_laden_r
  (action_requested, action_parameter1, action_parameter2, action_parameter3, action_parameter4, action_parameter9) 
  values 
  ('LOGON FULL', 'acme', 'acme', 'acme', 'acme', 'acme'); 
  select count(*) 
  into   l_cnt 
  from   bubs_berichten_v 
  where  brt_afgehandeld_vlag='N'
  ;
end;

the following error can occur after upgrading from Oracle 19 to Oracle 19 multi-tenant:

ORA-20163: Your license is not valid for this database. You have licensed the database orcl_a but the software runs on rdscdb_a.
ORA-06512: at “BUBS.ITGEN_LOG”, line 1695
ORA-06512: at “BUBS.ITGEN_ERROR_HANDLER”, line 1347
ORA-06512: at “BUBS.ITGEN_SESSION”, line 3652
ORA-06512: at “BUBS.ITGEN_SESSION”, line 3752
ORA-06512: at “BUBS.ITGEN_SESSION”, line 1863
ORA-06512: at “BUBS.ITGEN_SESSION”, line 1566
ORA-06512: at “BUBS.BUBS_SESSION”, line 3124
ORA-06512: at “BUBS.BUBS_SESSION”, line 3032
ORA-06512: at line 1
ORA-06512: at “BUBS.BUBS_PRE_LADEN_R_ORI”, line 135
ORA-04088: error during execution of trigger > ‘BUBS.BUBS_PRE_LADEN_R_ORI’
ORA-06512: at line 4

This is caused by the database names being changed to follow the new structure with a master and container database.

2

Update the license for Invantive Producer using:

begin
  itgen_boot_util.update_license(false);
  commit;
end;

Update the license for Invantive Estate using:

insert into bubs_pre_laden_r (action_requested) values ('UPDATE LICENSE NO LOGON')

commit

If the license key does not match the Oracle version, please update the license key also for Invantive Producer and Invantive Estate.

The results can be checked using:

select lce_name_database
,      lce_name_product
,      lce_name_schema
from   itgen_licenses_v

and

select lce_naam_database
,      lce_naam_product
,      lce_naam_schema
from   bubs_licenties_v
3

Deze vraag is automatisch gesloten na 1 week inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.

4

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.