ORA-01012: not logged on

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 May 2005 00:25:55 +0530

Any command I give, gives the same error. I saw all the BP. All are
running fine.

Any idea why this is happening?

SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01012: not logged on


SQL> desc v$database;
ERROR:
ORA-01034: ORACLE not available


SQL> select count(*) from v$session;
select count(*) from v$session
*
ERROR at line 1:
ORA-01012: not logged on

Regards - Chirag
--
//www.freelists.org/webpage/oracle-l

Other related posts: