Re: internal error when selecting from V$PWFILE_USERS.

That's what happened.

The DBA issued, from an NT sql*plus client, a select * from v$pwfile_users. Client received Ora-600, then end-of-communication message. Oracle server created a trace file listing the sql and process information, logged the Ora-600 and creation of the trace file in the alert log, aborted all of the Oracle processes, removed $ORACLE_HOME/dbs/sgadef.dat.

I restarted the database with svrmgrl, connect internal, startup.

I was not shocked that the Ora-600 brought down the Oracle Server. 18 months before, I was DBA to an Oracle 7.3.4 database on NT. There were lots of communication problems and the database often stopped, with Ora-600 [12333] errors. [12333] errors typically just stop the dedicated server (sql*net) process, not the entire database. ----- Original Message -----
From: Afanassiev, Alex <Alex.Afanassiev_at_team.telstra.com> To: <tom_at_cdproc.com>
Cc: <ORACLE-L_at_fatcity.com>
Sent: Wednesday, October 18, 2000 6:59 PM Subject: RE: internal error when selecting from V$PWFILE_USERS.

> Hi Tom
>
> Could please provide a little bit more info on how 'select * from
> v$pwfile_users' crashed your production database.
> What did actually happened ? What do mean with the 'crashed' ?
>
>
> 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 1:45 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: internal error when selecting from V$PWFILE_USERS.
> >
> > There's a known bug that has to do with arraysize in sql*plus that causes
> > the ora-0600 when
> > selecting from v$pwfile_users. Be very careful. A select * from
> > v$pwfile_users not only caused a
> > fatal error in one of our DBA's sessions, but also crashed a production
> > database.
> >
> > ----- Original Message -----
> > From: Amar Kumar Padhi <mailto:TS2017_at_emirates.com>
> > To: Multiple recipients of list ORACLE-L
> > <mailto:ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, October 18, 2000 4:06 AM
> > Subject: internal error when selecting from V$PWFILE_USERS.
> >
> >
> > 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
Received on Thu Oct 19 2000 - 08:02:41 CDT