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