Advertisements

Tag Archives: Oracle CLOUD

Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body has been invalidated – ICS Integration Failed

 

 

ORA-04068: existing state of packages has been discarded

Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package “XXX” has been invalidated

ORA-04065: not executed, altered or dropped package “XXXXX”

ORA-06508: PL/SQL: could not find program unit being called: “XXX” ORA-06512: at line 1

 

Recompilation is resulting in invalidation of packages by database for existing database sessions related to ICS.

Avoid recompilation of packages during the working hours and plan such all migrations at once during the weekend.

Hope next execution of ICS integration run should be fine, if not, restarting Agent is the solution at the moment or contact Oracle Support.

 

Thank you !!

 

 

 

Advertisements

Creating Single Instance Database in Oracle Cloud

 

Login to Oracle cloud (https://cloud.oracle.com/home) by providing Identity Domain, you will see following Dashboard console:

Cloud creat1

Click on create Instance and database:

Cloud create2

Click on Custom:

Cloud create3

Provide instance name, DB Software version and other details…

Cloud create4

Provide DB Name and other details as below, Most important upload ssh public key which can be generated using puttygen Generate Public and Private Keys using PuTTYgen, save respective private key which can be used to connect server once after the configuration.

Please provide username and password when you are planning to use cloud storage container for backups.

Cloud create5

Double check the provided configuration before click on create database

Cloud create6

Database creation and configuration takes a while to complete the process and there you go..

Cloud create7

Thank you !!