Oracle error during create script; install exited.
The CA_UIM schema did not have permissions to v$session.
As a result, the stored procedure: SPN_LOGEVENT was marked invalid.
All other stored procedures that have SPN_LOGEVENT as a dependency were also marked invalid.
An easy way to troubleshoot this would be to use Oracle SQL Developer, connect as the "CA_UIM" user and expand the "Procedures" folder.
Look for any stored procedures marked with a red X.
Open those stored procedures.
The editor will mark any missing or invalid objects with a red underline.
1- In Oracle, execute the following commands::