oracle ORA-01940 報錯的處理方法

刪除使用者時報錯，提示有此使用者的會話在連線。
SQL> drop user tran cascade;
drop user tran cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

查詢會話資訊，查詢不到此使用者的會話資訊。
SQL> select * from v$session where username='ACCT';

[oracle@host149 bk]$ lsnrctl stop

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 1653518336 bytes
Fixed Size    2213896 bytes
Variable Size 1358956536 bytes
Database Buffers  285212672 bytes
Redo Buffers    7135232 bytes
Database mounted.
Database opened.

成功刪除使用者。

SQL> drop user tran cascade;


User dropped.
啟動監聽。

[oracle@host149 bk]$ lsnrctl start