【ORA-28001】密码过期导致的物化视图刷新失败

某日突发alert日志中报错:

Tue Aug 11 17:40:59 2015
ORA-06512: ine 1
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-28001: ʧЧ
ORA-12012: ִҵ 384 

                  Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j008_49029.trc:
Tue Aug 11 17:40:59 2015
ORA-06512: ine 1
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-28001: ʧЧ
ORA-12012: ִҵ 381 

                  Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j003_49011.trc:
Tue Aug 11 17:40:29 2015
ORA-06512: ine 1
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-28001: ʧЧ
ORA-12012: ִҵ 585 

                  Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j001_49006.trc:
Tue Aug 11 17:40:28 2015
ORA-06512: ine 1
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-28001: ʧЧ
ORA-12012: ִҵ 609 

                  Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j000_49004.trc:
ORA-06512: ine 1
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-28001: ʧЧ
ORA-12012: ִҵ 620 

                  Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j002_49008.trc:
Tue Aug 11 17:40:28 2015
ORA-06512: ine 1
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-28001: ʧЧ
ORA-12012: ִҵ 687 

                  Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j000_49004.trc:

从报错来看,这个导致了物化视图刷新job失败,在看详细的trc文件内容:

[root@test01 ~]# cat /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j000_49004.trc
Trace file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_j000_49004.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing option
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name:    Linux
Node name:      CMRAC01
Release:        2.6.32-220.el6.x86_64
Version:        #1 SMP Wed Nov 9 08:03:13 EST 2011
Machine:        x86_64
Instance name: test1
Redo thread mounted by this instance: 1
Oracle process number: 60
Unix process pid: 49004, image: oracle@CMRAC01 (J000)


*** 2015-08-11 17:40:23.868
*** SESSION ID:(2882.35503) 2015-08-11 17:40:23.868
*** CLIENT ID:() 2015-08-11 17:40:23.868
*** SERVICE NAME:(SYS$USERS) 2015-08-11 17:40:23.868
*** MODULE NAME:() 2015-08-11 17:40:23.868
*** ACTION NAME:() 2015-08-11 17:40:23.868
 
ORA-12012: ִҵ 687 

                  ORA-28001: ʧЧ
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: ine 1
*** SESSION ID:(2882.35505) 2015-08-11 17:40:28.940
*** SERVICE NAME:(SYS$USERS) 2015-08-11 17:40:28.940
 

*** 2015-08-11 17:40:28.940
ORA-12012: ִҵ 609 

                  ORA-28001: ʧЧ
ORA-06512: SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: SYS.DBMS_IREFRESH", line 685
ORA-06512: SYS.DBMS_REFRESH", line 195
ORA-06512: ine 1

ORA-28001错误查看

[oracle@test01 ~]$ oerr ora 28001
28001, 00000, "the password has expired"
// *Cause:   The user's account has expired and the password needs to be
//           changed
// *Action:  change the password or contact the DBA
//

原来是源库用户密码过期导致的物化视图自动刷新任务失败。

发表评论