CNDBA社区
1.删除oracle 用户，出现ORA-01940错误
sys@node01 10:18:49> drop user apprptmfgmmcs cascade;
drop user apprptmfgmmcs cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
Elapsed: 00:00:00.05
2.占用当前用户的会话
sys@node01 10:19:11> select username,sid,serial#,paddr from v$session where username='APPRPTMFGMMCS';
USERNAME SID SERIAL# PADDR
-------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- ----------------
APPRPTMFGMMCS 453 46726 00000000AE416370
Elapsed: 00:00:00.01
sys@node01 10:20:08> select PROGRAM from v$process where addr='00000000AE416370';
PROGRAM
------------------------------------------------
oracle@node02
Elapsed: 00:00:00.00
3.杀掉会话
sys@node01 10:20:36> alter system kill session '453,46726';
System altered.
Elapsed: 00:00:00.01
4.查看会话是否还存在
sys@node01 10:21:41> select saddr,sid,serial#,paddr,username,status from v$session;
SADDR SID SERIAL# PADDR USERNAME STATUS
---------------- ---------- ---------- ---------------- -------------------------------------------------------------------------------------------------------------------------------- ----------
00000000AE58C810 1 7445 00000000AE3AC5E0 ACTIVE
00000000AE58EFF8 2 46782 00000000AE3B7160 ACTIVE
00000000AE5917E0 3 24242 00000000AE3C1CE0 ACTIVE
00000000AE593FC8 4 41087 00000000AE3CC860 ACTIVE
00000000AE59B780 7 28899 00000000AE3D73E0 ACTIVE
00000000AE59DF68 8 30306 00000000AE3F7660 ACTIVE
00000000AE5A2F38 10 62956 00000000AE4021E0 ACTIVE
00000000AE5A7F08 12 65315 00000000AE40CD60 ACTIVE
00000000AE629C40 64 4557 00000000AE3ADB50 ACTIVE
00000000AE62C428 65 44554 00000000AE3B86D0 ACTIVE
00000000AE62EC10 66 21492 00000000AE3C3250 ACTIVE
00000000AE6313F8 67 25465 00000000AE3D8950 ACTIVE
00000000AE6363C8 69 14210 00000000AE3F8BD0 ACTIVE
00000000AE63B398 71 38721 00000000AE403750 ACTIVE
00000000AE63DB80 72 40857 00000000AE40E2D0 ACTIVE
00000000AE6C7070 127 40706 00000000AE3A4540 ACTIVE
00000000AE6C9858 128 55111 00000000AE3AF0C0 ACTIVE
00000000AE6CC040 129 37235 00000000AE3B9C40 ACTIVE
00000000AE6CE828 130 1067 00000000AE3C47C0 ACTIVE
00000000AE6D1010 131 50550 00000000AE3D9EC0 ACTIVE
00000000AE6D5FE0 133 54815 00000000AE3FA140 ACTIVE
00000000AE6D87C8 134 1013 00000000AE40F840 ACTIVE
00000000AE6DAFB0 135 58036 00000000AE404CC0 ACTIVE
00000000AE7644A0 190 6389 00000000AE3A5AB0 ACTIVE
00000000AE766C88 191 23368 00000000AE3B0630 ACTIVE
00000000AE769470 192 62196 00000000AE3BB1B0 ACTIVE
00000000AE76BC58 193 2443 00000000AE3C5D30 ACTIVE
00000000AE770C28 195 42717 00000000AE3D08B0 ACTIVE
00000000AE773410 196 10574 00000000AE3DB430 ACTIVE
00000000AE775BF8 197 14698 00000000AE3FB6B0 ACTIVE
00000000AE77ABC8 199 61199 00000000AE410DB0 ACTIVE
00000000AE77FB98 201 62124 00000000AE406230 ACTIVE
00000000AE8018D0 253 45653 00000000AE3A7020 ACTIVE
00000000AE8040B8 254 18354 00000000AE3B1BA0 SYS ACTIVE
00000000AE8068A0 255 11618 00000000AE3BC720 ACTIVE
00000000AE809088 256 28498 00000000AE3C72A0 ACTIVE
00000000AE80B870 257 38274 00000000AE3D1E20 ACTIVE
00000000AE80E058 258 57354 00000000AE3DC9A0 ACTIVE
00000000AE815810 261 41473 00000000AE3FCC20 ACTIVE
00000000AE817FF8 262 25291 00000000AE412320 ACTIVE
00000000AE81CFC8 264 49779 00000000AE4077A0 ACTIVE
00000000AE89ED00 316 45704 00000000AE3A8590 ACTIVE
00000000AE8A14E8 317 20898 00000000AE3B3110 ACTIVE
00000000AE8A3CD0 318 6750 00000000AE3BDC90 ACTIVE
00000000AE8A64B8 319 52249 00000000AE3C8810 ACTIVE
00000000AE8AB488 321 57806 00000000AE3D3390 ACTIVE
00000000AE8ADC70 322 19061 00000000AE3DDF10 ACTIVE
00000000AE8B2C40 324 13783 00000000AE3FE190 SYS ACTIVE
00000000AE8B7C10 326 2228 00000000AE408D10 ACTIVE
00000000AE8BCBE0 328 39321 00000000AE413890 ACTIVE
00000000AE93C130 379 65277 00000000AE3A9B00 ACTIVE
00000000AE93E918 380 2084 00000000AE3B4680 ACTIVE
00000000AE941100 381 5200 00000000AE3BF200 ACTIVE
00000000AE9438E8 382 37620 00000000AE3C9D80 ACTIVE
00000000AE9488B8 384 49408 00000000AE40A280 ACTIVE
00000000AE950070 387 56563 00000000AE3DF480 ACTIVE
00000000AE95C7F8 392 43533 00000000AE3D4900 ACTIVE
00000000AE9D9560 442 33712 00000000AE3D5E70 ACTIVE
00000000AE9DBD48 443 41466 00000000AE3AB070 ACTIVE
00000000AE9DE530 444 24394 00000000AE3B5BF0 ACTIVE
00000000AE9E0D18 445 8722 00000000AE3C0770 ACTIVE
00000000AE9E3500 446 36917 00000000AE3CB2F0 ACTIVE
00000000AE9E84D0 448 3815 00000000AE3F60F0 ACTIVE
00000000AE9EFC88 451 44786 00000000AE40B7F0 ACTIVE
64 rows selected.
Elapsed: 00:00:00.01
5.再次删除用户
sys@node01 10:22:22> drop user apprptmfgmmcs cascade;
User dropped.
Elapsed: 00:00:01.08
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle
