oracle rac 环境，2个节点 os无法登陆，需要手动重启主机

gzsujj

oracle rac 环境，2个节点 os无法登陆，需要手动重启主机。

时间:2014-10-12 13:00

database version :11.2.0.3.9

OS version: RHEL 6.1

附件有所有日志。

gzsujj

相关附件及分析

ALLSTARS_ORACLE

对于这种os 都无法登陆的问题， osw  和 操作系统日志 恐怕才是最需要的

gzsujj

没有oswatch，但是有os message，但是message没有信息。

gzsujj

os message

harryzhang

执行 sar

gzsujj

harryzhang 发表于 2014-10-21 18:33
执行 sar

什么是sar？

ALLSTARS_ORACLE

SAR(1)                        Linux User’s Manual                       SAR(1)

NAME
       sar - Collect, report, or save system activity information.

SYNOPSIS
       sar  [  -A  ] [ -b ] [ -B ] [ -c ] [ -d ] [ -i interval ] [ -p ] [ -q ] [ -r ] [ -R ] [ -t ] [ -u ] [ -v ] [ -V ] [ -w ] [ -W ] [ -y ] [ -n { DEV | EDEV | NFS | NFSD | SOCK | ALL } ] [ -x { pid | SELF | ALL } ] [ -X { pid |
       SELF | ALL } ] [ -I { irq | SUM | ALL | XALL } ] [ -P { cpu | ALL } ] [ -o [ filename ] | -f [ filename ] ] [ -s [ hh:mm:ss ] ] [ -e [ hh:mm:ss ] ] [ interval [ count ] ]

DESCRIPTION
       The sar command writes to standard output the contents of selected cumulative activity counters in the operating system. The accounting system, based on the values in the count and interval  parameters,  writes  information
       the  specified  number of times spaced at the specified intervals in seconds.  If the interval parameter is set to zero, the sar command displays the average statistics for the time since the system was started. The default
       value for the count parameter is 1. If its value is set to zero, then reports are generated continuously.  The collected data can also be saved in the file specified by the -o filename flag, in addition to  being  displayed
       onto the screen. If filename is omitted, sar uses the standard system activity daily data file, the /var/log/sa/sadd file, where the dd parameter indicates the current day.  By default all the data available from the kernel
       are saved in the data file. Exceptions are interrupts and disks data, for which the relevant options must be explicitly passed to sar (or to its backend sadc ) when the data file is created (see options below).

       The sar command extracts and writes to standard output records previously saved in a file. This file can be either the one specified by the -f flag or, by default, the standard system activity daily data file.

       Without the -P flag, the sar command reports system-wide (global among all processors) statistics, which are calculated as averages for values expressed as percentages, and as sums otherwise. If the -P flag  is  given,  the
       sar command reports activity which relates to the specified processor or processors. If -P ALL is given, the sar command reports statistics for each individual processor and global statistics among all processors.

       You can select information about specific system activities using flags. Not specifying any flags selects only CPU activity.  Specifying the -A flag is equivalent to specifying -bBcdqrRuvwWy -I SUM -I XALL -n ALL -P ALL.

       The  default  version  of the sar command (CPU utilization report) might be one of the first facilities the user runs to begin system activity investigation, because it monitors major system resources. If CPU utilization is
       near 100 percent (user + nice + system), the workload sampled is CPU-bound.

       If multiple samples and multiple reports are desired, it is convenient to specify an output file for the sar command.  Run the sar command as a background process. The syntax for this is:

       sar -o datafile interval count >/dev/null 2>&1 &

       All data is captured in binary form and saved to a file (datafile).  The data can then be selectively displayed with the sar command using the -f option. Set the interval and count parameters  to  select  count  records  at
       interval second intervals. If the count parameter is not set, all the records saved in the file will be selected.  Collection of data in this manner is useful to characterize system usage over a period of time and determine
       peak usage hours.

livelin

这种情况，一般OS系统资源设定有问题时出现的比较多.
列下/etc/security/limits.conf看看吧。