| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: internal error when selecting from V$PWFILE_USERS.
I cannot speak for Tom, but in my case, crash meant the database was no
longer open, no one could access the database, SHUTDOWN IMMEDIATE did not
work, and I had to SHUTDOWN ABORT and STARTUP the database. Automatic
recovery then occured.
The interesting thing that happened to me was that it did not crash my test instance, but it did crash production.
Steve
> -----Original Message-----
> From: Afanassiev, Alex [mailto:Alex.Afanassiev_at_team.telstra.com]
> Sent: Wednesday, October 18, 2000 9:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: internal error when selecting from V$PWFILE_USERS.
>
>
> 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
> > (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: Afanassiev, Alex
> INET: Alex.Afanassiev_at_team.telstra.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
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Received on Thu Oct 19 2000 - 08:14:46 CDT
 |
 |