Yup. Thats why got this error....!!! I think that is why I can access all v= iews. Regards - Chirag 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= ve > to do is to log on to the database in question with your username and > password. >=20 > Just a thot, > Ruth >=20 > -----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 >=20 > Any command I give, gives the same error. I saw all the BP. All are > running fine. >=20 > Any idea why this is happening? >=20 > SQL> select open_mode from v$database; > select open_mode from v$database > * > ERROR at line 1: > ORA-01012: not logged on >=20 > SQL> desc v$database; > ERROR: > ORA-01034: ORACLE not available >=20 > SQL> select count(*) from v$session; > select count(*) from v$session > * > ERROR at line 1: > ORA-01012: not logged on >=20 > Regards - Chirag > -- > //www.freelists.org/webpage/oracle-l >=20 >