SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
来源:互联网 发布:linux如何搜索文件夹 编辑:程序博客网 时间:2024/06/05 00:16
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
以前一直用 SYS 用户使用 autotrace, 今天用其它用户使用 autotrace 来获得执行计划报如下错误
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS repor
第一反应是授予用用户 plustrace 角色
SQL> conn / as sysdba
Connected.
SQL> grant plustrace to oak;
grant plustrace to oak
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
报角色不存在错误
plustrace 角色在数据库 创建时并不会创建
这个角色可通过运行下面的 sql 来创建
$ORACLE_HOME/sqlplus/admin/plustrce.sql
授予用户 plustrace 角色
SQL> grant plustrace to oak;
Grant succeeded.
启用 autotrace
SQL> set autotrace on
至此问题解决
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
- plsql(autotrace)-SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabl
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- oracle提示SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618 Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SQL> set autotrace traceonly SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled 报错处理
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier.Check PLUSTRACE role is enabled
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
- 减少Qt编译时间暨简单Qt裁剪
- 音频编解码标准
- Word2003模板损坏
- crontab 命令详解
- mysql 外键 常见的的两个错误 mysql createtable errno 121 150 错误
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enable
- 在debian(sarge)下安装stun server的过程及NAT穿越
- VC小技巧收集
- 怎样查看电脑的配置信息和操作系统
- 编译和警告
- 由于应用程序的配置不正确,应用程序未能启动,重新安装应用程序可能会纠正这个问题
- MVC模式
- 用ini文件实现最近文件MRU
- Java内部类总结(上)