PL/SQL Recompile package no response case 2

In this "PL/SQL Recompile package no response" inside the compiler package is not responding to the situation, and today encountered a case, in the test environment, a package status of invalid, recompile, has been in the compilation state, check that the following two factors do not exist:

1: When the package is being invoked to execute, compiling the package causes a non-responsive situation.
2: The object or dependent object in the package is owned by the other session.

After checking that a linked server was called in the package, the IP address of the original server changed due to the migration of the test server, causing the linked server to become invalid. So that's what happened. After rebuilding the linked server, recompile the package through!

PL/SQL Recompile package no response case 2