true tightness of vagina is found rarely. mostly the condition is vaginismus
which is a psychosomatic condition - temporary spasm due to stimulation of sex organs or due to fear/underlying fear of sex. just relax and proceed slowly during act, be cool, the problem will go. If it does not, consult a gynec.