Hi I had a query concerning oratab. Do we need to have dbname or instance name in it and what is the benefit of using one over the other. I know that if I want to use oraenv, i need to make it insance name. What are the drawback of changing the default dbname to instance name. TIA Sanjay ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ