Oracle 12c to 19c Database upgrade Issues

Which version(UPD) of Apps10 are you on? Before UPD7 the PLAP was a struggle. After UPD7 things should be much easier (there is a bug in the metric that it shows red after UPD7)

Here are my old note on the PLAP reconfig:

 

GRANT EXECUTE ON utl_http TO ifssys ;

GRANT SELECT ON dba_network_acls TO ifssys;

GRANT EXECUTE ON dbms_network_acl_admin TO ifssys;

BEGIN

  prepare_sys.dbagrant('IFSAPP','YES');

END;

/

UPDATE ifsapp.plsqlap_environment_tab SET value = 'http://<original url>' WHERE name = 'CONN_STR';

BEGIN

   Dbms_Network_Acl_Admin.Create_Acl('IFSAPP-Utl_Http-Permission.xml',

                                     'Permission for Foundation1 users to run HTTP from the database.',

                                     'IFSAPP',

                                     TRUE,

                                     'connect');

END;

BEGIN

   Dbms_Network_Acl_Admin.Add_Privilege('IFSAPP-Utl_Http-Permission.xml',

                                     'IFSSYS',

                                     TRUE,

                                     'connect');

END;

BEGIN

   Dbms_Network_Acl_Admin.Assign_Acl('IFSAPP-Utl_Http-Permission.xml',

                                     '<original FQDN>',

                                     59080,

                                     59080);

END;

COMMIT;

Verify:

SELECT * FROM dba_network_acls

SELECT utl_http.request((SELECT value FROM plsqlap_environment_tab WHERE name='CONN_STR'),null, (SELECT value FROM plsqlap_environment_tab WHERE name='SSL_WALLET_PATH'), null ) FROM dual;

SELECT Plsqlap_Server_API.Ping_Result__ FROM dual;

​@hhanse 

Thank you for the above input.

This is UPD 16.

Before upgrade to 19c there was 113028 Database objects related to the IFSAPP but after the upgrade its only 85677.

Is it normal behaviour?

Best Regards,

Rusiru

If you only upgraded Oracle, it should not remove any objects in the IFSAPP schema as far as i can see.