Re: system user locked after crash

Comments embedded.
On Sep 28, 8:04 am, "fp" <francesco.pi...@xxxxxxxxxx> wrote:
Hi, we have an application running with OracleXE 10g on Windows.

Interesting. Which release of Windows? What sort of application
would this be? I suspect it's a fairly small application given that
you're using XE and there are database size limitations.

It's not unusual that the application runs in the same pc which host the db
server.

It may not be unusual in your shop but I certainly wouldn't recommend
such a practice.

It happened that, after a sudden crash of the system and after the windows
reboot, the Oracle system user was locked.


You're assuming the SYSTEM user account was unlocked prior to the
crash, and that may not be the case. The SYSTEM user may have been
locked prior to the crash and you only discovered this after the
system was restarted. Do you possess logs from any scheduled tasks
which could prove otherwise? We really need more information than you
have currently provided.

Ok, now i've unlocked the user but still don't know why this happened.
I can only imagine a series of wrong user/pwd connections,

As I would also suspect.

but it seems this isn't the case.

What evidence do you have to support this claim? Read no more into
that question than what is written, as I am merely asking for further
proof of your assertion. We certainly cannot infer from your
description what may have happened apart from that which would appear
obvious. If you have information which could suggest otherwise please
post it.


Thanks in advance for any answer to my doubt

--
francesco pighi



David Fitzjarrell

.