Linux Operating System (MOSC)

MOSC Banner

[How to] Find [Linux] OS user from [Database listed] OS ID?

edited Oct 25, 2021 12:00AM in Linux Operating System (MOSC) 1 commentAnswered ✓

We are investigating who performed a shutdown the database. Per the alert logs a shutdown immediate was done by OS ID 31676

Shutting down instance (immediate) (OS id: 31676)


I already checked the /etc/passwd for that UID. Is there a way we can find out the OS user from this OS ID?


I also try using it as PID and didn't work.

select b.spid,a.sid, a.serial#,a.username, a.osuser

from v$session a, v$process b

where a.paddr= b.addr

and b.spid='&spid'

order by b.spid;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center