| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: internal error when selecting from V$PWFILE_USERS.
Just want to chime in that yours is not an isolated incident. In fact, I
had the same problem after running a query I copied from an article on
Metalink! Had fun explaining to management how an Oracle supplied query
just crashed production...
Steve
-----Original Message-----
From: Tom Pall [mailto:tom_at_cdproc.com]
Sent: Wednesday, October 18, 2000 10: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.
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
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any Received on Wed Oct 18 2000 - 14:02:25 CDT
 |
 |