Rama, This really worked. We have our internal tool where you need to just select the database and it will set all the environment varialble correctly. Might be some error this time. Anyway, Thanx.. It really worked for me. :-) Regards - Chirag Majmundar On 5/13/05, RAMA KORADA <RKORAD@xxxxxxxxxxxxxxx> wrote: > set oracle_sid / export oracle_sid=3Dxxxxx > and try... >=20 > RK >=20 > >>> chiragdba@xxxxxxxxx 05/12/05 02:06PM >>> > Yup. Thats why got this error....!!! I think that is why I can access > all v=3D > iews. >=20 > Regards - Chirag >=20 > On 5/13/05, Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx> wrote: > > I know this sounds too easy, but did you log on? The first thing > you ha=3D > ve > > to do is to log on to the database in question with your username > and > > password. > >=3D20 > > Just a thot, > > Ruth > >=3D20 > > -----Original Message----- > > From: oracle-l-bounce@xxxxxxxxxxxxx > > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA > > Sent: Thursday, May 12, 2005 2:56 PM > > To: askdba@xxxxxxxxxxxxx; Oracle-L Freelists > > Subject: ORA-01012: not logged on > >=3D20 > > Any command I give, gives the same error. I saw all the BP. All are > > running fine. > >=3D20 > > Any idea why this is happening? > >=3D20 > > SQL> select open_mode from v$database; > > select open_mode from v$database > > * > > ERROR at line 1: > > ORA-01012: not logged on > >=3D20 > > SQL> desc v$database; > > ERROR: > > ORA-01034: ORACLE not available > >=3D20 > > SQL> select count(*) from v$session; > > select count(*) from v$session > > * > > ERROR at line 1: > > ORA-01012: not logged on > >=3D20 > > Regards - Chirag > > -- > > //www.freelists.org/webpage/oracle-l > >=3D20 > > >=20 >