-
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.
-
Why are you shutting down production Serverusing ABORT option?
Thanks
Kishore Kumar
-
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
yt
-
First Check which users have the Privileges(SYS AND SYSTEM).
sree
-
I know who have got the privilege SYS and SYSTEM
But I need proof to be sur that it was him
yt
-
$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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|