Operating System commands
The following commands are a useful snapshot and quick ref for determining problems within oracle from a operating system point of view: - for example if you find process hanging such as a crsd or listener search for the pid and then piping the following commands to a trace file would provide invaluable information for Oracle Support to provide RCA Root Cause Analysis
1. Ps –ef | grep : List information of the pid – this can be used to determine a session with in the database via gv$session or find the identity of the top process from topas
2. Procmap –l : Prints the address space map of a process, this will also show the read/write/execute permissions of the library’s that are particular oracle process is using
3. Procstack : Displays the hexadecimal address and symbolic names for each stack fromes of the current thread in processes
4. Truss –o -f : Think of truss as a utility that allows you to monitor a process or command and how the system uses that process or command to call something. Invaluable to Oracle support if a processes is hanging as it may show where the error is
5. Ps –f : Show the processes currently running including cpu information
6. Proctree –a : The proctree command prints the process tree containing the specified process id’s or users – this includes any child processes.
7. Topas : This invokes the top utility to list the current performance metrics of a system
8. ps -ef | egrep "crsd|ocssd|evmd|oprocd" : Check if CRS is running
Operating System commands
No comments