Re: ORACLE hangs after query 'select * from v$pwfile_users' in SQL*Plus session

On 9 Nov 1999 15:27:47 GMT, "fumi" <fumi_at_tpts5.seed.net.tw> wrote:

>
>Roger Jackson <rjackson_at_wire.net.au> wrote in message news:806aac$3pc$1_at_caley.wire.net.au...
>> Hi everyone,
>>
>> Database and Platform details.
>>
>> Oracle v8.0.5.2.1 32Bit
>> AIX V4.3.2
>>
>> Has anybody come across this problem?
>>
>> When you run the following query from SQL*Plus
>> select * from v$pwfile_users;
>>
>> All SQL*Plus sessions hang and you have to perform a shutdown abort. You
>> cannot start another SQL*Plus session, you can only access server manager.
>>
>> You also receive an ORA-0600 but I don't have the arguments in front of me.
>> Although there is only one argument.
>>
>> Oracle WWS said it is a known bug and the solution was to perform a shutdown
>> abort. I have been told that this bug has been fixed in v8.0.6 which as far
>> I understood was not going to be released. Can somebody out there confirm
>> this?
>[snip]
>
>
>I receive an error in my Oracle8i on NT sp4:
>ORA-600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []
>But the sessions can go on.
>
>In my Oracle 8.0.4, it's OK.
>
>
>

Its a bug - login as sys and use 'select * from v_$pwfile_users;'

Alex Received on Wed Nov 10 1999 - 03:51:39 CST