Re: internal error when selecting from V$PWFILE_USERS.

It killed a Solaris 2.6 (this happened a year ago), Oracle 8.0.5.0 EE database.

It also got the DBA's privs on the production databases lifted. After I brought the database back up, I did some investigating, found what had crashed the database.

Knowing who would be issuing such queries, I asked the DBA (who did not know the database had crashed). The OCP DBA, replied that he tried the query in his play database on NT and it crashed his database. So to verify, he tried the query out in

1. A development database? No.
2. A test database? No.
3. The most critical of our production databases? Yes.

But he also, when I was talking about a particular database and stating that the table data took up about 30 GB, indexes took about 45 GB, asked how it could be possible for the indexes to take up more space than tables.

He is no longer with us.

• Original Message ----- From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 18, 2000 4:52 PM Subject: RE: internal error when selecting from V$PWFILE_USERS.

> Hi Amar,
>
> I've also had this problem.
>
> I found that on NT under 81505 the query caused a non-fatal ora-600. ie the
> instance stayed up and functional.
> After "upgrading" to 81511 the query now causes the instance to die.
>
> What version / platform are you on?
>
> As suggested, doing a select * from v$pwfile_users order by 1; will not
> cause the crash.
>
> Regards,
> Bruce Reardon
> mailto:bruce.reardon_at_comalco.riotinto.com.au
>
>
> -----Original Message-----
> Sent: Wednesday, 18 October 2000 23:46
> To: Multiple recipients of list ORACLE-L
>
>
> Hi, Amar.
>
> Probably bug 425862. Calling suppport for confirming this is a good idea, as
> suggested.
>
> If you got the bud, there are currently a couple of workarounds:
> + Execute the query from svrmgrl.
> + In sqlplus, use an ORDER BY clause with your select statement.
>
> Hope it helps,
> Juan Guillermo.
>
> Amar Kumar Padhi wrote:
>
> >
> >
> > Hi,
> > I am getting ora-600 when I give a select from v$pwfile_users from
> sql*plus.
> > The same statement is working when I connect as sysdba in svrmgr30.
> > My remote_login_passwordfile is set to 'EXCLUSIVE' and I have used
> orapwd80 to
> > create a password file.
> >
> > I am not able to think of any remote possibility as to why it should be
> > happening. Any ideas? scripts missed out during installation etc. etc.
> >
> > Thanks,
> > Amar
> > 00-971-50-7883254
> > ts2017_at_emirates.com
> > amar_padhi_at_hotmail.com
> > amar_padhi_at_musclemail.com
> >
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Juan Guillermo Rodriguez
> INET: jgrb16_at_tid.es
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Reardon, Bruce (CALBBAY)
> INET: Bruce.Reardon_at_comalco.riotinto.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Oct 18 2000 - 18:27:24 CDT