七、操作系统查看7
查看CPU 参数,相关信息是否匹配 “prtconf"
方式: “prtconf"
类似结果如下：
# prtconf
System Model: IBM,8204-E8A
Machine Serial Number: ********
Processor Type: PowerPC_POWER6 (power 芯片类型，为power6)
Processor Implementation Mode: POWER 6
Processor Version: PV_6_Compat
Number Of Processors: 4 （CPU core 个数 4个，即2个双核的物理CPU）
Processor Clock Speed: 3503 MHz （CPU 主频 3.5G）
CPU Type: 64-bit
Kernel Type: 64-bit （内核版本 64位）
LPAR Info: 1 zzrac1
Memory Size: 16384 MB（内存大小16G）
Good Memory Size: 16384 MB
Platform Firmware level: EL350_049
Firmware Version: IBM,EL350_049
Console Login: enable
Auto Restart: true
Full Core: false
Network Information
Host Name: zzrac1
IP Address: 10.220.97.51
Sub Netmask: 255.255.255.0
Gateway: 10.220.97.254
Name Server:
Domain Name:
Paging Space Information
Total Paging Space: 8192MB
Percent Used: 1%
Volume Groups Information
==============================================================================
rootvg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk0 active 546 248 79..00..00..60..109
==============================================================================
0516-010 : Volume group must be varied on; use varyonvg command.
==============================================================================
0516-010 : Volume group must be varied on; use varyonvg command.
==============================================================================
arch1vg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk5 active 812 1 00..00..00..00..01
==============================================================================
INSTALLED RESOURCE LIST
The following resources are installed on the machine.
+/- = Added or deleted from Resource List.
* = Diagnostic support not available.
解决方法：
如何和产品不符，咨询厂家实际情况并修复问题（更换内存？CPU？）
八、操作系统查看8
查看是否属于夏时制（不要是夏时制）[确认tz那行对应的不是TZ=1而是TZ=BEIST-8]
方法：”more /etc/environment”
类似结果:
# more /etc/environment
# @(#)18
1.25 src/bos/etc/environment/environment, cmdsh, bos53A, a2004_
35B6 8/23/04 04:13:11
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos53A src/bos/etc/environment/environment 1.25
#
# Licensed Materials - Property of IBM
#
# (C) COPYRIGHT International Business Machines Corp. 1989,1994
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: (CMDSH) Shell related commands
#
# ORIGINS: 27
#
# (C) COPYRIGHT International Business Machines Corp. 1989, 1994
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
################################################################
# System wide environment file. This file should only contain
# 1. comment lines which have a # in the first column,
# 2. blank lines, and
# 3. Lines in the form name=value.
#
# WARNING: This file is only for establishing environment variables.
# Execution of commands from this file or any lines other
# than specified above may cause failure of the initialization
# process.
#
# Searching the current directory last is usually a BIG time saver.
# If /usr/ucb is at the beginning of the PATH the BSD version of commands will
# be found.
#
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/us
r/java14/bin
TZ=1
LANG=en_US
LOCPATH=/usr/lib/nls/loc
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LC__FASTMSG=true
# ODM routines use ODMDIR to determine which objects to operate on
# the default is /etc/objrepos - this is where the device objects
# reside, which are required for hardware configuration
ODMDIR=/etc/objrepos
TERM=vt100
#
解决方法:
||||||||||||||||||
若时区不是”BEIST-8”，则通过smitty chtz 改时区（改完时区之后需要重启才能生效）
Smitty chtz-> Use DAYLIGHT SAVINGS TIME?(选择no)-> CUT (Coordinated Universal Time) Time Zone (选择”(BEIST-8) Peoples Rep. China (CUT +8)”)
|||||||||||||||||||
九、操作系统查看9
检查rac两节点是否时间同步，用“date ”命令查看（首先确认时区要一致）
结论，若不同步， 通过smitty date改 时间
十、数据库查询1
数据库版本检查，是否为最新: 检查数据库版本和crs的版本是否打到最新(10.2.0.5):
方法:
"sqlplus -version"， 查看software版本
"crsctl query crs softwareversion" 查看crs版本
类似结果
$ sqlplus -version
SQL*Plus: Release 10.2.0.5.0 – Production
# crsctl query crs softwareversion
CRS software version on node [zzrac1] is [10.2.0.5.0]
解决方案：
||||||||||||||
如果补丁集较低，建议升级补丁:
1>、应用备份数据
2>、升级rac crs
3>、升级oracle software
4>、升级库版本
5>、编译无效的对象
||||||||||||||||
十一、数据库查询2
（数据文件如果采用裸设备的方式）检查是否数据库文件关闭了自动扩展（建议关闭自动扩展)（用toad上去观察)
方案: 使用toad检查问价系统状态
类似结果:
解决方案：
关闭相应的数据文件的自动扩展:
ALTER DATABASE TEMPFILE '/dev/rrac_temp_2G' AUTOEXTEND OFF;
十二、数据库查询3
检查数据库文件是否已经和lv大小相近似(建议扩充文件系统，接近到可扩充的最大文件）
方法：使用toad检查
类似结果
解决方案：（rac_temp_2G对应了8个pp）
# lsvg -l oraclevg
oraclevg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
rac_ocr_raw_1G raw 4 4 1 open/syncd N/A
rac_vote_raw_1G raw 4 4 1 open/syncd N/A
rac_system_2G raw 8 8 1 open/syncd N/A
rac_sysaux_2G raw 8 8 1 open/syncd N/A
rac_undotbs1_2G raw 8 8 1 open/syncd N/A
rac_undotbs2_2G raw 8 8 1 open/syncd N/A
rac_temp_2G raw 8 8 1 open/syncd N/A
rac_users_2G raw 8 8 1 open/syncd N/A
rac_redo11_4G raw 16 16 1 open/syncd N/A
rac_redo12_4G raw 16 16 1 open/syncd N/A
rac_redo31_4G raw 16 16 1 open/syncd N/A
rac_redo32_4G raw 16 16 1 open/syncd N/A
rac_redo21_4G raw 16 16 1 open/syncd N/A
rac_redo22_4G raw 16 16 1 open/syncd N/A
rac_redo41_4G raw 16 16 1 open/syncd N/A
rac_redo42_4G raw 16 16 1 open/syncd N/A
rac_con1_512m raw 2 2 1 open/syncd N/A
rac_con2_512m raw 2 2 1 open/syncd N/A
rac_con3_512m raw 2 2 1 open/syncd N/A
rac_spfile_512m raw 2 2 1 closed/syncd N/A
查看pp大小（1个pp大小为256M）
# lsvg oraclevg
VOLUME GROUP: oraclevg VG IDENTIFIER: 00c976b500004c00000001296240e915
VG STATE: active PP SIZE: 256 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 6143 (1572608 megabytes)
MAX LVs: 256 FREE PPs: 5951 (1523456 megabytes)
LVs: 20 USED PPs: 192 (49152 megabytes)
OPEN LVs: 19 QUORUM: 2 (Enabled)
TOTAL PVs: 1 VG DESCRIPTORS: 2
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 1 AUTO ON: no
Concurrent: Enhanced-Capable Auto-Concurrent: Disabled
VG Mode: Concurrent
Node ID: 1 Active Nodes:
MAX PPs per VG: 28448
MAX PPs per PV: 7112 MAX PVs: 4
LTG size (Dynamic): 1024 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
#
所以rac_temp_2G 可以扩展到2G（8*256M）
如果没有扩展到适应大小，用下面命令：（确认lv大小）
ALTER DATABASE TEMPFILE '/dev/rrac_temp_2G' RESIZE 2000M;
|||||||||||||||||||
