某生产数据库ora-12012 ora-06575报错排查

某日，客户生产数据库告警发出如下报错：

告警描述：Tue Jul 13 00:00:00 2021
Errors in file hrdb1_j001_26981.trc:
ORA-12012: �Զ�ִ����ҵ "NC65"."V_HIK_PANDOC" ����
ORA-06575: ��������� V_HIK_PANDOCV ������Ч״̬

trace如下：

Trace file hrdb1_j001_26981.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name:    Linux
Node name:      hrdb01
Release:        2.6.32-696.20.1.el6.x86_64
Version:        #1 SMP Fri Jan 26 17:51:45 UTC 2018
Machine:        x86_64
VM name:        VMWare Version: 6
Instance name: hrdb1
Redo thread mounted by this instance: 1
Oracle process number: 92
Unix process pid: 26981, image: oracle@hrdb01 (J001)


*** 2021-07-13 00:00:00.496
*** SESSION ID:(1715.55109) 2021-07-13 00:00:00.496
*** CLIENT ID:() 2021-07-13 00:00:00.496
*** SERVICE NAME:(SYS$USERS) 2021-07-13 00:00:00.496
*** MODULE NAME:(DBMS_SCHEDULER) 2021-07-13 00:00:00.496
*** ACTION NAME:(V_HIK_PANDOC) 2021-07-13 00:00:00.496
 
ORA-12012: ִҵ "NC65"."V_HIK_PANDOC" 

                                    ORA-06575:  V_HIK_PANDOCV ״̬ 

根据提示查看对象相关信息：

select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS from dba_objects where object_name='V_HIK_PANDOCV';

OWNER                OBJECT_NAME          OBJECT_TYPE         CREATED           LAST_DDL_TIME     STATUS
-------------------- -------------------- ------------------- ----------------- ----------------- -------
NC65                 V_HIK_PANDOCV        PROCEDURE           20210329 14:36:54 20210713 12:00:00 INVALID

select text from dba_source where name='V_HIK_PANDOCV';

TEXT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
procedure v_hik_pandocv()
as
begin
  delete from v_hik_psndoc_1;
  insert into v_hik_psndoc_1 select * from v_hik_psndoc;
  commit;
end;

检查发现是由于NC65用户下的V_HIK_PANDOCV函数失效，导致频繁报错，并将报错反馈至应用。