Re: ORA-01012: not logged on
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jan 2008 03:09:06 +0530
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@xxxxxxxxx> 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
Other related posts:
