Database Administration (MOSC)

MOSC Banner

ORA-02399: exceeded maximum connect time, you are being logged off

edited Aug 5, 2019 5:07AM in Database Administration (MOSC) 29 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center