sqlplus / as sysdba进去，开个10046，conn

10046跟踪信息如下：

[oracle@s-oradb2 trace]$ more  orcl2_ora_45998.trc

Trace file /oracle/database/diag/rdbms/orcl/orcl2/trace/orcl2_ora_45998.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 = /oracle/database/product/11.2.0/db_1

System name:    Linux

Node name:      s-oradb2

Release:        2.6.32-642.el6.x86_64

Version:        #1 SMP Wed Apr 13 00:51:26 EDT 2016

Machine:        x86_64

Instance name: orcl2

Redo thread mounted by this instance: 2

Oracle process number: 126

Unix process pid: 45998, image: oracle@s-oradb2 (TNS V1-V3)

*** 2019-07-09 10:39:44.205

*** SESSION ID:(392.881) 2019-07-09 10:39:44.205

*** CLIENT ID:() 2019-07-09 10:39:44.205

*** SERVICE NAME:(SYS$USERS) 2019-07-09 10:39:44.205

*** MODULE NAME:(sqlplus@s-oradb2 (TNS V1-V3)) 2019-07-09 10:39:44.205

*** ACTION NAME:() 2019-07-09 10:39:44.205

Error in executing triggers on connect internal

*** 2019-07-09 10:39:44.205

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)

----- Error Stack Dump -----

ORA-00604: error occurred at recursive SQL level 1

ORA-01031: insufficient privileges

ORA-06512: at line 68

Error in executing triggers on connect internal

*** 2019-07-09 10:39:44.214

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)

----- Error Stack Dump -----

ORA-00604: error occurred at recursive SQL level 1

ORA-01031: insufficient privileges

ORA-06512: at line 68

*** 2019-07-09 10:42:52.344

WAIT #139720656576920: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1562640172344585

*** 2019-07-09 10:43:04.895

WAIT #139720656576920: nam='SQL*Net message from client' ela= 12550775 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1562640184895432

XCTEND rlbk=0, rd_only=1, tim=1562640184895576

CLOSE #139720656576920:c=0,e=4,dep=0,type=0,tim=1562640184895647

[oracle@s-oradb2 trace]$

[oracle@s-oradb2 trace]$ more orcl2_ora_48729.trc

Trace file /oracle/database/diag/rdbms/orcl/orcl2/trace/orcl2_ora_48729.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 = /oracle/database/product/11.2.0/db_1

System name:    Linux

Node name:      s-oradb2

Release:        2.6.32-642.el6.x86_64

Version:        #1 SMP Wed Apr 13 00:51:26 EDT 2016

Machine:        x86_64

Instance name: orcl2

Redo thread mounted by this instance: 2

Oracle process number: 126

Unix process pid: 48729, image: oracle@s-oradb2 (TNS V1-V3)

*** 2019-07-09 10:43:26.268

*** SESSION ID:(392.885) 2019-07-09 10:43:26.268

*** CLIENT ID:() 2019-07-09 10:43:26.268

*** SERVICE NAME:(SYS$USERS) 2019-07-09 10:43:26.268

*** MODULE NAME:(sqlplus@s-oradb2 (TNS V1-V3)) 2019-07-09 10:43:26.268

*** ACTION NAME:() 2019-07-09 10:43:26.268

Error in executing triggers on connect internal

*** 2019-07-09 10:43:26.268

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)

----- Error Stack Dump -----

ORA-00604: error occurred at recursive SQL level 1

ORA-01031: insufficient privileges

ORA-06512: at line 68

Error in executing triggers on connect internal

*** 2019-07-09 10:43:26.277

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)

----- Error Stack Dump -----

ORA-00604: error occurred at recursive SQL level 1

ORA-01031: insufficient privileges

ORA-06512: at line 68

有个登录触发器:

Error in executing triggers on connect internal

通过查DBA_TRIGGERS限定TRIGGER_TYPE='TRIGGER',然后根据无法登录的时间点过滤出在故障前后时间点有新建或ddl过9个触发器，触发器均删除后还是无法成功登录，报错一样。

select
   OWNER,
   TRIGGER_NAME,
   TRIGGER_TYPE, TRIGGERING_EVENT, STATUS, TRIGGER_BODY
from   DBA_TRIGGERS
where trim(triggering_event) = 'LOGON';

查下登录触发器

确实查到有一个触发器限制了IP登录，谢谢。