it hurt like so much

Recently at the weekend there I was having a sleepover with the boy I'm seeing, bare in mind this is the first sleepover I had as my parents are totally against this. So right
Me and him were cuddling, and we were both drunk and he was getting horny so he just started to rub, he tried to finger me but it was too sore, I was very wet but I could have actually cried with pain.
I am a vergin and never had sex, or intercourse before.. is it normal for this pain? Any tips or tricks to stop the pain or anything as he was upset we couldn't do anything