-- first create a profile
create profile restrict_user_single_session limit sessions_per_user 1;

-- assign this profile to the user.

alter user < userName > profile restrict_user_single_session;

-- add the following in your inti< sid >.ora and restart the database

resource_limit = true