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

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: RAMA KORADA <RKORAD@xxxxxxxxxxxxxxx>
  • Date: Fri, 13 May 2005 00:48:48 +0530

Rama,

This really worked. We have our internal tool where you need to just
select the database and it will set all the environment varialble
correctly. Might be some error this time.

Anyway, Thanx.. It really worked for me. :-)

Regards - Chirag Majmundar

On 5/13/05, RAMA KORADA <RKORAD@xxxxxxxxxxxxxxx> wrote:
> set oracle_sid / export oracle_sid=3Dxxxxx
> and try...
>=20
> RK
>=20
> >>> chiragdba@xxxxxxxxx 05/12/05 02:06PM >>>
> Yup. Thats why got this error....!!! I think that is why I can access
> all v=3D
> iews.
>=20
> Regards - Chirag
>=20
> 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=3D
> ve
> > to do is to log on to the database in question with  your username
> and
> > password.
> >=3D20
> > Just a thot,
> > Ruth
> >=3D20
> > -----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
> >=3D20
> > Any command I give, gives the same error. I saw all the BP. All are
> > running fine.
> >=3D20
> > Any idea why this is happening?
> >=3D20
> > SQL> select open_mode from v$database;
> > select open_mode from v$database
> > *
> > ERROR at line 1:
> > ORA-01012: not logged on
> >=3D20
> > SQL> desc v$database;
> > ERROR:
> > ORA-01034: ORACLE not available
> >=3D20
> > SQL> select count(*) from v$session;
> > select count(*) from v$session
> > *
> > ERROR at line 1:
> > ORA-01012: not logged on
> >=3D20
> > Regards - Chirag
> > --
> > http://www.freelists.org/webpage/oracle-l
> >=3D20
> >
>=20
>

Other related posts: