Re: ORA-01012: not logged on

Hi all,

I could figure out the issue, The problem was due to maximum number of processes exceeded and for any new session it was not allowing. I am increasing the session parameter and bounce when the downtime arises.

Thanks,
Ann

On Jan 3, 2008 2:49 AM, Shastry(DBA) <shastry17_at_gmail.com> wrote:

> 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