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>
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-lReceived on Wed Jan 02 2008 - 15:19:58 CST