Orace user settings
请确认是否对ORACLE做了如下配置
1.用internal用户(缺省的口令是oracle)进入SQLPLUS
$ sqlplus internal/oracle
2.运行ORACLE的安装路径下的/rdbms/admin/xaview.sql
SQL>@/oracle/ rdbms/admin/xaview.sql
3.授权
SQL>grant select on v$xatrans$ to public with grant option;
SQL>grant select on v$pending_xatrans$ to public with grant option;
4.用system用户(缺省的口令是manager)连接并授权
SQL>connect system/manager
SQL>grant select any table to public;


<< Home