gzsujj

0 积分	0 好友	3 主题

发消息

[Exadata常规管理] oracle rac 环境，2个节点 os无法登陆，需要手动重启主机

1^#

发表于 2014-10-21 13:34:03 | 查看: 3443| 回复: 8

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

时间:2014-10-12 13:00

database version :11.2.0.3.9

OS version: RHEL 6.1

附件有所有日志。

分享0

收藏0 回复只看该作者道具举报

livelin

9^#

发表于 2014-10-23 18:04:06

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

回复只看该作者道具举报

ALLSTARS_ORACLE

8^#

发表于 2014-10-22 09:39:47

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.

回复只看该作者道具举报