Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

after Jan 2019 ojvm patch to 11.2.0.4 SE, java component has become invalid

edited May 26, 2019 3:37PM in Database Install/Upgrade/Opatch (MOSC) 12 commentsAnswered

Hi -

RDBMS version is 11.2.0.4 SE on Linux 5. We applied Jan 2019 PSU (DB and OVJM 28790660). After applying OJVM, noticed that there are couple of Java related objects owned by SYS and the component JServer JAVA Virtual Machine have become INVALID.

When tried compiling an object, see this error:

SQL> alter package sys.DBMS_JAVA compile body;

alter package sys.DBMS_JAVA compile body

*

ERROR at line 1:

ORA-01775: looping chain of synonyms

SQL> show errors

No errors.

SQL>

Already went through this: JSserver Java Virtual Machine is INVALID and Unable to Compile SYS.DBMS_JAVA with PLS-201 errors (Doc ID 2126103.1)

Any suggestions.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center