First of all, you need CCK module installed to install Content Profile, and after download and place in your modules directory, you need Content Profile and Content Profile User Registration.

By default after install content profile, it auto creates a content type named Profile.