SP2-0618: Cannot find the Session Identifier.
[oracle@trade1 ~]$ sqlplus user1/user1
SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 6 14:31:15 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set autot traceonly;
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
确认一下库里并没有该角色,PLUSTRACE并不会在建库的时候自动创建。
SQL> select * From dba_roles where role = 'PLUSTRACE' ;
no rows selected
运行脚本plustrce.sql ,创建角色。
SQL> @?/sqlplus/admin/plustrce.sql
SQL>
SQL> drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
SQL> create role plustrace;
Role created.
SQL>
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>
SQL> set echo off
SQL>
SQL>
SQL> grant plustrace to hcpay;
Grant succeeded.
至此已经解决完
最新文章
- git版本控制管理实践-3
- sql索引组织
- scala多个构造函数的定义方法
- (转载)OC学习篇之---类的三大特性:封装,继承,多态
- zookeeper[2] zookeeper原理(转)
- JavaScript在智能手机上的应用-判断是否为移动浏览器
- 你需要了解的高可用方案之使用keepalived搭建双机热备一览
- 长连接锁服务优化实践 C10K问题 nodejs的内部构造 limits.conf文件修改 sysctl.conf文件修改
- Linux Curl命令
- 【特性】MySQL 8 新特性
- Saiku权限控制(四)
- Grunt相关
- php初中高阶段
- Linux setenforce命令详解[SeLinux操作]
- java内部类之成员内部类
- Codeforces 578.C Weakness and Poorness
- js 利用事件委托解决mousedown中的click
- 爬虫之FileCookieJar
- 北京Uber优步司机奖励政策(2月28日)
- 初探angular