处理办法:禁用登录延迟

alter system set "_sys_logon_delay"=0 scope=spfile sid='*';

需申请停机时间,重启库生效。

SQL> show parameter logon;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE
SQL> select a.ksppinm name,b.ksppstvl value,a.ksppdesc description
    from x$ksppi a,x$ksppcv b
    where a.indx = b.indx
    and a.ksppinm like '_sys_logon_delay';

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_sys_logon_delay
1
The failed logon delay for the database instance


SQL> alter system set "_sys_logon_delay"=0 scope=both sid='*';                                         
alter system set "_sys_logon_delay"=0 scope=both sid='*'
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set "_sys_logon_delay"=0 scope=spfile sid='*';

System altered.

SQL> 

相关参考:

https://blog.csdn.net/m0_37625564/article/details/128798375

https://www.modb.pro/db/20928

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐