SP2-0618、SP2-0611 PLUSTRCE授权错误
来源:互联网 发布:centos7 源码安装php 编辑:程序博客网 时间:2024/06/04 00:47
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
第一反应是授予用用户plustrace角色
SQL> conn / as sysdba
Connected.
SQL> grant plustrace to oe;
grant plustrace to oe
*
ERROR at line 1:
plustrace角色在数据库创建时并不会创建
这个角色可通过运行下面的sql来创建
$@?/sqlplus/admin/plustrce.sql
SQL> drop role plustrace;
Role dropped.
SQL> create role plustrace;
Role created.
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL> set echo off
授予用户plustrace角色
SQL> grant plustrace to oe;
Grant succeeded.
至此问题解决
SP2-0611: Error enabling STATISTICS report
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
第一反应是授予用用户plustrace角色
SQL> conn / as sysdba
Connected.
SQL> grant plustrace to oe;
grant plustrace to oe
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
plustrace角色在数据库创建时并不会创建
这个角色可通过运行下面的sql来创建
$@?/sqlplus/admin/plustrce.sql
SQL> drop role plustrace;
Role dropped.
SQL> create role plustrace;
Role created.
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.
SQL> grant select on v_$statname to plustrace;Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL> set echo off
授予用户plustrace角色
SQL> grant plustrace to oe;
Grant succeeded.
启用oe用户autotrace
SQL>conn oe/oe
SQL> set autotrace on至此问题解决
0 0
- SP2-0618、SP2-0611 PLUSTRCE授权错误
- SP2-0618和_SP2-0611错误处理 plustrce权限问题
- sp2
- sp2
- 解决 Oralce 执行set autotrace on时的SP2-0618和SP2-0611错误
- SP2-0618
- set autotrace 时SP2-0618和_SP2-0611错误处理
- SP2-0618和_SP2-0611错误处理(转)
- sql*plus中SP2-0618和SP2-0611的解决方法
- set autotrace on(SP2-0618,SP2-0611,ORA-01919)
- sp2-0612错误
- server 2003 sp2错误修复
- Oracle 10g Auto Trace安装及SP2-0618和_SP2-0611错误处理
- Oracle设置AUTOTRACE时出现SP2-0611错误
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabl
- Oracle 使用scott用户 set autotrace on报错 SP2-0618,SP2-0611
- SQL*PLUS中开启SQL TRACE时报错SP2-0618和SP2-0611的解决方法
- set autotrace 报错sp2-0613&sp2-0618
- Tiny210v2( S5PV210 )平台下创建基本根文件系统
- android ViewPager详解
- "0x00a1bdb3" 指令引用的 "0x00000001" 内存。该内存不能为 "read"。
- springMVC3学习(八)--全局的异常处理
- uva 11270 插头DP
- SP2-0618、SP2-0611 PLUSTRCE授权错误
- 南阳 966 选择不相交区间
- PHP解决URL中文GBK乱码问题
- IP分片原理及分析
- httpRequest与httpwebrequest区别
- 张静初挺黄海波:他口无遮拦得罪不少人
- 分水岭图像分割算法
- hello.c
- JavaScript绑定事件时的闭包问题