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-----
From: Juan Guillermo Rodriguez [mailto:jgrb16_at_tid.es] Sent: Wednesday, 18 October 2000 23:46
To: Multiple recipients of list ORACLE-L Subject: Re: internal error when selecting from V$PWFILE_USERS.

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