What type of noun is prayer?

If spelled with a small g, it is a common noun.

If spelled with a capital G, it can be considered either a common or proper noun. A proper noun means the actual name of a person, place, or thing. Some people consider "God" to be a proper noun, while others have more specific names that they use.