Hi Tom
What do you actually mean with 'kill' ? Do you know what process died ? Did
you have/analyse any trace files ???
Are sure that 'select * from v$pwfile_users' caused the database crash but
something else ?
With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations
Tel: (03) 8 661 20 61
Fax: (03) 9 650 36 74
> -----Original Message-----
> From: Tom Pall [SMTP:tom_at_cdproc.com]
> Sent: Thursday, October 19, 2000 11:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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 -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 18, 2000 4:52 PM
>
>
> > 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
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tom Pall
> INET: tom_at_cdproc.com
>
> 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
Received on Wed Oct 18 2000 - 19:09:01 CDT
