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

  • From: "RAMA KORADA" <RKORAD@xxxxxxxxxxxxxxx>
  • To: <chiragdba@xxxxxxxxx>, <rgramolini@xxxxxxxxxxxxxxx>
  • Date: Thu, 12 May 2005 14:12:34 -0500

set oracle_sid / export oracle_sid=xxxxx
and try...

RK

>>> chiragdba@xxxxxxxxx 05/12/05 02:06PM >>>
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: