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

一、现象说明

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

二、处理方法

SQL> select flashback_on from v$database;FLASHBACK_ON
------------------
YESSQL> select name from v$restore_point;NAME
---------------------------------------------------------
AUTOUPGRADE_9212_WIND2121020SQL> drop restore point AUTOUPGRADE_9212_WIND2121020;Restore point dropped.SQL> alter database flashback off;Database altered.

此时 Test 用户可以连接了。

附录（实际处理过程记录）：

SQL> select name,open_mode from v$database;NAME      OPEN_MODE
--------- --------------------
STUDY     READ WRITESQL> select flashback_on from v$database;FLASHBACK_ON
------------------
YESSQL> alter database flashback off;Database altered.SQL> select flashback_on from v$database ;FLASHBACK_ON
------------------
RESTORE POINT ONLYSQL> select name from v$restore_point;NAME
---------------------------------------------------------
AUTOUPGRADE_9212_WIND2121020SQL> drop restore point AUTOUPGRADE_9212_WIND2121020;Restore point dropped.SQL> alter database flashback off;Database altered.SQL> select flashback_on from v$database;FLASHBACK_ON
------------------
NO