当我们登录数据库时候,提示当前用户已登录,而我们有不知道谁在登录,而我们又要登
录,我们可以迁出这个用户以利我们登录
步骤:
1. su - oralce
input passpd
2. sqlplus / as sysdba
3. desc $vsession
4. select username,SID,SERIAL# from v$session;
5. alter system kill session '152,21669';
note: make sure the user you want to kill sid=152; serial#=21669.
6. system return: System altered.
7. The user has been killed, so you can login to oracle
wish you luck
阅读(1543) | 评论(0) | 转发(0) |