Re: system user locked after crash

Comments embedded.
On Sep 28, 8:04 am, "fp" <francesco.pi..._at_hotmail.it> 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 Received on Fri Sep 28 2007 - 09:50:43 CDT