Home : Products : OPS SQL : Enable WIMS to view/kill its client sessions in Oracle
Q10028 - HOWTO: Enable WIMS to view/kill its client sessions in Oracle

In Oracle, the OPSROOT user needs to be granted a SELECT privilege on a system table called sys.v_$session
This table contains information about client connections to WIMS.

You will not be able to log into WIMS, unless this privilege has been granted.

This privilege also matters during Database Upgrade, since WIMS will need to be able to kill its client connections in order to prevent a failure during the upgrade process.

To do this :
1) Contact your Oracle database administrator to perform this task.
2) Run sqlplus sys/change_on_install@oradev
-where change_on_install is the default password for the oracle sys user. You most likely will have to acquire this password from the database administrator.
-where oradev is the name of the oracle database

Note : ORACLE 9i and onward requires sys login to use AS SYSDBA.
Example : sqlplus "sys/change_on_install@oradev as SYSDBA"

NOTE: MAKE SURE YOU USE THE DOUBLE QUOTES AS SHOWN IN THE EXAMPLE ABOVE!


3) execute
grant select on v_$session to OPSROOT;

4) execute grant select on dba_segments to OPSROOT; 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/22/2004 11:51 AM.
Last Modified on 5/15/2014 3:27 PM.
Last Modified by Scott Dorner.
Article has been viewed 5576 times.
Rated 6 out of 10 based on 18 votes.
Print Article
Email Article