Why all stored procedures suddenly fail

su27mkk

Dear experts, please ask:
  Only one of the stored procedures in our company's database is valid, and the rest all suddenly fail, causing very serious consequences, which is considered a major failure. I understand that if the objects (tables, stored procedures, functions) involved in the stored procedure are changed (table structure, stored procedure recompilation, etc.), it will cause the stored procedure to fail, but almost all failures cannot be Caused by a modified table or stored procedure.
   
  The question is what else can cause the stored procedure to fail; Note: After the stored procedure fails, I compile them first and pass them.
   
  Many thanks! !! !!

panda_ren

Look at the alert_sid.log for any errors?

su27mkk

to:panda_ren
   Where can I see the log of alert_sid.log? Which path under the oracle installation directory?

panda_ren

If it is a windows system, you can use the windows search tool to search
This file is generally placed
windows:% ORACLE_BASE% / admin / bdump
unix: $ ORACLE_BASE / admin / bdump

whbilly

alert.log under $ ORACLE_BASE / admin / sid / bdump

panda_ren

This file is generally placed
windows:% ORACLE_BASE% / admin / bdump
unix: $ ORACLE_BASE / admin / bdump

su27mkk

I've seen it, there are no modified objects or error logs found

whbilly

It may be that Oracle's own underlying package has failed

su27mkk

How could your own underlying package suddenly fail? What can cause

su27mkk

I still haven't found the reason, alas