instance name ~ I can't think of any reason you'd use dbname. oratab is used by oraenv, dbstart and dbshut. it's also often used by shell scripts or to quickly check what ORACLE_HOME's are installed. (although the inventory can do this too, slightly better.) -Jeremy On Tue, Apr 29, 2008 at 6:29 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote: > 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://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ> > -- Jeremy Schneider Chicago, IL http://www.ardentperf.com/category/technical