Database shutdown

[yotot]

Hi!

My production database was shutting down on ABORT
But I don't known who did it.

How can I know, who is connected to the database before the database was shutting down.

Is there a trace of the listener.

Thank you for answering.

[Kishore]

Why are you shutting down production Serverusing ABORT option?

[yotot]

I didn't shut down the database myself.

Someone did it, but I don't know who did it.

In alert log, I 've just know when the database was shutting
down on ABORT.
So I would like to know who was connected to database
with SVRMGRL.

I've heard that it is possible to know who was connected to the database with the trace of the LISTENER, but I don't know more.

If someone have a little idea, can he ou she suggest me
where can I investigate ?

Thanks

[sree_sri]

First Check which users have the Privileges(SYS AND SYSTEM).

[yotot]

I know who have got the privilege SYS and SYSTEM

But I need proof to be sur that it was him

[armel]

$ORACLE_HOME/network/log/listener_name.log

u can find in that file all connection time and client IP ...
just got to find the last connection before shutdown
hope that will help

Armel