What opposite for fertile?

Yes - it means dry or lifeless. It can also mean sterile (as in a woman who is unabel to have children for medical reasons can be called barren).