Can someone tell me why does Oracle gives a ORA-00600 error when u select from v$pwfile_users view through SQL*Plus.
If we give select against the v$pwfile_users view through SVRMGR by using internal...it shows me the output.Can anyone tell me the reason for it.
I am running Oracle 8i version 8.1.5 on IBM AIX-Unix.Yesterday I gave a query in sql*plus logged in as sys and the instance crashed.The same query if I give as internal it works fine....
Is there any bug .
It is kinda bug. I have confirmed with Oracle when I got the same error. One they upgraded the features, they didn't clean up the old stuff/views(usually Oracle lazy to clean relevant old features when they upgrade the features) which nturn gives the Ora-600 error. You are safe. Don't worry.
I will try looking into my tar and post any relevant info later...