Linux sqlplus权限不足,sqlplus登录用户提示权限不足

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值