PLS-00907: cannot load library unit
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
We have 2 databases. We are referenced db 2 from db 1 using a dblink V4_ASIA_TEP.WORLD. Normally, we can easily use as normal but suddenly we encountered the following issue:
We have 2 databases. We are referenced db 2 from db 1 using a dblink V4_ASIA_TEP.WORLD. Normally, we can easily use as normal but suddenly we encountered the following issue:
HostName: IAASPRO1
Message: TOMCAT:V4_ASIA: ERROR: ORA-06550: line 1, column 7:
HostName: IAASPRO1
Message: TOMCAT:V4_ASIA: ERROR: java.sql.SQLException: ORA-06550: line 0, column 0:
HostName: IAASPRO1
Message: TOMCAT:V4_ASIA: ERROR: PLS-00907: cannot load library unit IDLIVE.FICRXMST@V4_ASIA_TEP.WORLD (referenced by V4_ASIA.F_FUN_TEP_GET_CRC_RATE)
After we got found this issue, we compiled the V4_ASIA.F_FUN_TEP_GET_CRC_RATE with no changes. We have checked and there were not any changes to the table IDLIVE.FICRXMST in db V4_ASIA_TEP.WORLD nor was it compiled. We would like to find the root cause of this issue that we encountered, is there any way we can trace the root cause?
0