Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00600 Error on "Create User"
Turns out we needed to update sys.user$. There is a row in there with name
= '_NEXT_USER' which keeps track of the next user number. I have no idea
how it got corrupted. It is a known bug (bug # 407371)
Ken.
-----Original Message-----
From: William_Dong_at_gelco.com [mailto:William_Dong_at_gelco.com]
Sent: Friday, August 25, 2000 10:57 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-00600 Error on "Create User"
Do you have a valid password file? if not create one or change the
remote_login_passwordfile to none. This may or may not help. We have
experienced
a problem that we can not drop user, and solved.
Good luck!
I wish you good luck on getting ay support for that version :)
joe
"Fowler, Kenneth R" wrote:
>
> Hi,
>
> I have an Oracle database (7.1.5.2.3) running on VMS (Alpha) V6.2-1H3.
Just
> lately when I try to create a user (any user) I get an ORA-00600 error as
in
> the trace file below. Have been waiting on support all day now so I was
> wondering if anyone on the list has seen this?? Here is the trace file...
Received on Fri Aug 25 2000 - 13:32:27 CDT