We can see, the sessions_per_user allowed for this users in 2. New 1: select a.username,b.PROFILE,b.RESOURCE_NAME,b.limit from dba_users a, dba_profiles b where a.profile=b.profile and b.RESOURCE_NAME='SESSIONS_PER_USER' and a.username='TEST9' Old 1: select a.username,b.PROFILE,b.RESOURCE_NAME,b.limit from dba_users a, dba_profiles b where a.profile=b.profile and b.RESOURCE_NAME='SESSIONS_PER_USER' and a.username='&USER_NAME' Select a.username,b.PROFILE,b.RESOURCE_NAME,b.limit from dba_users a, dba_profiles b where a.profile=b.profile and b.RESOURCE_NAME=’SESSIONS_PER_USER’ and a.username=’&USER_NAME’ Enter value for user_name: TEST9 Check the value of SESSIONS_PER_USER for this user New 1: SELECT count(*) as connections,username FROM v$session where username='TEST9' GROUP BY usernameĢ. Old 1: SELECT count(*) as connections,username FROM v$session where username='&USER_NAME' GROUP BY username SELECT count(*) as connections,username FROM v$session where username=’&USER_NAME’ GROUP BY username SQL> SELECT count(*) as connections,username FROM v$session where username='&USER_NAME' GROUP BY username
Check how many sessions were already existed for that user: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit SOLUTION:ġ. While connecting to the database, getting error:
0 kommentar(er)
