Do sex supposed to hurt?

Do sex supposed to hurt?

For the first time I know for sure cause your body not use to that type of pain but when do that pain stop? How long do it last?