Re: internal error when selecting from V$PWFILE

From: Tom Pall <tom_at_cdproc.com>
Date: Wed, 18 Oct 2000 08:42:09 -0500
Message-Id: <10653.119638@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_12B1_01C038DF.4D81AB60 Content-Type: text/plain;

charset="x-user-defined"
Content-Transfer-Encoding: quoted-printable

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 -----=20 From: Amar Kumar Padhi=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, October 18, 2000 4:06 AM Subject: internal error when selecting from V$PWFILE_USERS.

  Hi,=20
  I am getting ora-600 when I give a select from v$pwfile_users from = sql*plus.=20
  The same statement is working when I connect as sysdba in svrmgr30.=20   My remote_login_passwordfile is set to 'EXCLUSIVE' and I have used = orapwd80 to create a password file.=20

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,=20
  Amar=20
  00-971-50-7883254=20
  ts2017_at_emirates.com=20
  amar_padhi_at_hotmail.com=20
  amar_padhi_at_musclemail.com=20

------=_NextPart_000_12B1_01C038DF.4D81AB60 Content-Type: text/html;

charset="x-user-defined"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>internal error when selecting from =
V$PWFILE_USERS.</TITLE>
<META content=3D"text/html; charset=3Dx-user-defined" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>There's a known bug that has to do with =

arraysize in sql*plus that causes the ora-0600 when</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>selecting from v$pwfile_users.  Be =
very=20
careful.  A select * from v$pwfile_users not only caused = a</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>fatal error in one of our DBA's =
sessions, but also=20
crashed a production database.</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:TS2017_at_emirates.com" = title=3DTS2017_at_emirates.com>Amar Kumar=20   Padhi</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, October 18, = 2000 4:06=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> internal error when = selecting=20
  from V$PWFILE_USERS.</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3D"Courier New" size=3D2>Hi,</FONT> <BR><FONT = face=3D"Courier New"=20
  size=3D2>I am getting ora-600 when I give a select from v$pwfile_users = from=20
  sql*plus.</FONT> <BR><FONT face=3D"Courier New" size=3D2>The same = statement is=20
  working when I connect as sysdba in svrmgr30.</FONT> <BR><FONT=20   face=3D"Courier New" size=3D2>My remote_login_passwordfile is set to = 'EXCLUSIVE'=20
  and I have used orapwd80 to create a password file.</FONT> </P>   <P><FONT face=3D"Courier New" size=3D2>I am not able to think of any = remote=20
  possibility as to why it should be happening. Any ideas? scripts = missed out=20
  during installation etc. etc.</FONT></P>   <P><FONT color=3D#000000 face=3D"Courier New" size=3D2>Thanks,</FONT> =
<BR><B><FONT=20

  color=3D#000000 face=3D"Courier New" size=3D2>Amar</FONT><I></I></B> =
<BR><FONT=20

  color=3D#008080 face=3D"Courier New" size=3D2>00-971-50-7883254</FONT> =
<BR><FONT=20

  color=3D#008080 face=3D"Courier New" = size=3D2>ts2017_at_emirates.com</FONT> <BR><FONT=20   color=3D#008080 face=3D"Courier New" = size=3D2>amar_padhi@</FONT><B><FONT=20
  color=3D#008080 face=3D"Courier New" size=3D2>hot</FONT></B><FONT = color=3D#008080=20
  face=3D"Courier New" size=3D2>mail.com</FONT> <BR><FONT = color=3D#008080=20
  face=3D"Courier New" size=3D2>amar_padhi@</FONT><B><FONT = color=3D#008080=20
  face=3D"Courier New" size=3D2>muscle</FONT></B><FONT color=3D#008080=20   face=3D"Courier New" size=3D2>mail.com</FONT> = Received on Wed Oct 18 2000 - 08:42:09 CDT

Re: internal error when selecting from V$PWFILE_USERS.