RE: ORA-01012: not logged on

I know this sounds too easy, but did you log on? The first thing you have to do is to log on to the database in question with your username and password.

Just a thot,
Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chirag DBA Sent: Thursday, May 12, 2005 2:56 PM
To: askdba_at_freelists.org; Oracle-L Freelists Subject: ORA-01012: not logged on

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

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l