Thanks to the wonderful walkman phone of infinite lives (it needs replacing so badly, I don't even want to explain how much it's been through and what's keeping it working :S it just does!) I've got the following mp3s for different tones:

Ringtone: linkage here.

Text Message tone: Again with the linkage.

Alarm Tone: First/current alarm tone. OR this one works well too.

Generally I try to change my alarm tone quite frequently since I like to wake up and not want to go back to bed, if it's something I hear too often I just sleep through or roll over after hitting the cancel button. Since this is my primary alarm clock it'd better wake me up. Ring tones change as and when I have a whim, for some strange reason the halo 3 theme has been my message tone for a long time now.