[askdba] Re: ORA-01012: not logged on

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx>
  • Date: Fri, 13 May 2005 00:36:08 +0530

Yup. Thats why got this error....!!! I think that is why I can access all v=
iews.

Regards - Chirag



On 5/13/05, Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx> wrote:
> I know this sounds too easy, but did  you log on?  The first thing you ha=
ve
> to do is to log on to the database in question with  your username and
> password.
>=20
> Just a thot,
> Ruth
>=20
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA
> Sent: Thursday, May 12, 2005 2:56 PM
> To: askdba@xxxxxxxxxxxxx; Oracle-L Freelists
> Subject: ORA-01012: not logged on
>=20
> Any command I give, gives the same error. I saw all the BP. All are
> running fine.
>=20
> Any idea why this is happening?
>=20
> SQL> select open_mode from v$database;
> select open_mode from v$database
> *
> ERROR at line 1:
> ORA-01012: not logged on
>=20
> SQL> desc v$database;
> ERROR:
> ORA-01034: ORACLE not available
>=20
> SQL> select count(*) from v$session;
> select count(*) from v$session
> *
> ERROR at line 1:
> ORA-01012: not logged on
>=20
> Regards - Chirag
> --
> http://www.freelists.org/webpage/oracle-l
>=20
>

Other related posts: