ORA-01012: not logged on

From: Shastry(DBA) <shastry17_at_gmail.com>
Date: Thu, 3 Jan 2008 02:49:58 +0530
Message-ID: <5b294dab0801021319x1da46d28la3c06a471697b8e9@mail.gmail.com>


Hi all,

For sometime my production database was not letting me to do any operations:

I found these alerts
SQL> select name from v$database;
select name from v$database
*

ERROR at line 1:
ORA-01012: not logged on

SQL> select * from dba_users;
select * from dba_users
*

ERROR at line 1:
ORA-01012: not logged on

But I could see the ora_ processes were running and even TNS was up and running.

After sometime..I tried it again and is working fine. Is this a bug, Can anyone tell me if you have faced the same problem. The SQL*Plus Release is 9.2.0.4.0.

Thanks,
Ananth

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 02 2008 - 15:19:58 CST

Original text of this message