The two years ban is for working again in Doha with a new sponsor. You need NOC to work again without waiting for the 2 years ban. But you can visit anytime you wish. Visa upon arrival is only for certain nationalities. And India is not on the list of countries where its nationals can get visa upon arrival at the airport. You can apply tourist visa through a hotel or travel agency.