Oracle 普通用户毗连hang住处理方法

一、现象说明

1. $ sqlplus / as sysdba
3. SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 18 16:49:19 2024
4. Version 19.11.0.0.0
6. Copyright (c) 1982, 2020, Oracle.  All rights reserved.
9. Connected to:
10. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
11. Version 19.11.0.0.0
13. SQL> conn Test/Oracle123    ---一直hang在这里

复制代码

二、处理方法

1. SQL> select flashback_on from v$database;
3. FLASHBACK_ON
4. ------------------
5. YES
7. SQL> select name from v$restore_point;
9. NAME
10. ---------------------------------------------------------
11. AUTOUPGRADE_9212_WIND2121020
13. SQL> drop restore point AUTOUPGRADE_9212_WIND2121020;
15. Restore point dropped.
17. SQL> alter database flashback off;
19. Database altered.

复制代码

此时 Test 用户可以毗连了。
附录（现实处理过程记录）：

1. SQL> select name,open_mode from v$database;
3. NAME      OPEN_MODE
4. --------- --------------------
5. STUDY     READ WRITE
7. SQL> select flashback_on from v$database;
9. FLASHBACK_ON
10. ------------------
11. YES
13. SQL> alter database flashback off;
15. Database altered.
17. SQL> select flashback_on from v$database ;
19. FLASHBACK_ON
20. ------------------
21. RESTORE POINT ONLY
23. SQL> select name from v$restore_point;
25. NAME
26. ---------------------------------------------------------
27. AUTOUPGRADE_9212_WIND2121020
29. SQL> drop restore point AUTOUPGRADE_9212_WIND2121020;
31. Restore point dropped.
33. SQL> alter database flashback off;
35. Database altered.
37. SQL> select flashback_on from v$database;
39. FLASHBACK_ON
40. ------------------
41. NO

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。