ORA-02399: exceeded maximum connect time, you are being logged off
hi all,
i have a oracle 12c SE on Windows Server 2012 R2 Standard.
i have a problem whit the SQL_PROFILE for my user DB:
CREATE USER ABACO_DS
IDENTIFIED BY xxxxxxxxxxxx
PROFILE ABACO_DS_PROFILE;
select profile, resource_name, limit from dba_profiles where profile ='ABACO_DS_PROFILE';
CONNECT_TIME 45
i try the connection duration:
conn ABACO_DS/xxxxxxxxx
Elapsed: 00:00:00.07
10:30:14 SQL> Declare
10:30:27 2 v_cnt number;
10:30:27 3 Begin
10:30:27 4 For i in 1..100000
10:30:27 5 Loop
10:30:27 6 select count(*) into v_cnt from all_objects;
10:30:27 7 End Loop;
10:30:27 8 End;
10:30:27 9 /
Declare
*
ERROR at line 1:
ORA-02399: exceeded maximum connect time, you are being logged off
ORA-06512: at line 6
Elapsed: 00:31:25.72