标签归档:linux

tune Linux physical memory

32G memory的Linux,跑一些application batch report,把archive redo log 搬到Tape上面,以及每天的Rman Full database backup,physical free memory只有35M

zzz ***Mon Dec 21 08:57:00 HKT 2009
MemTotal:     32889900 kB
MemFree:         35348 kB
Buffers:        109088 kB
Cached:       28892412 kB
SwapCached:       8592 kB
Active:        7049552 kB
Inactive:     24023160 kB
HighTotal:           0 kB
HighFree:            0 kB
LowTotal:     32889900 kB
LowFree:         35348 kB
SwapTotal:    16777208 kB
SwapFree:     16466904 kB
Dirty:            1628 kB
Writeback:           0 kB
Mapped:        6811368 kB
Slab:           839432 kB
CommitLimit:  33222156 kB
Committed_AS: 14507408 kB
PageTables:     801492 kB
VmallocTotal: 536870911 kB
VmallocUsed:    273416 kB
VmallocChunk: 536597367 kB
HugePages_Total:     0
HugePages_Free:      0
Hugepagesize:     2048 kB

通过调整vm参数来保证至少2G的physical free memory,避免负载上升时发生Swap导致CPU100%和node reboot

sysctl -w vm.min_free_kbytes=2097152
sysctl -w vm.vfs_cache_pressure=200

cd /proc/sys/vm
cat min_free_kbytes
cat vfs_cache_pressure

REF:http://www.oraclefans.cn/forum/showtopic.jsp?rootid=12006

oracle RAC 10.2 installation on Vmware

Ref:
http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnCentos4UsingVMware.php
http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/toc.htm

折腾了一个星期,终于把RAC装上了。贴出来纪念一下。
环境是
Host和Guest都装了Redhat Linux 5(2.6.18-128.el5)
host:

Guest:

终于装完了啊.

机器被我折磨的要死了.一个Guest Vm应该给一个CPU就好了,我给了两个,感觉明显比配一个慢了.

丰收的时刻

[oracle@rac1 bin]$ env | grep SID
ORACLE_SID=SIDRAC1
[oracle@rac1 bin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 17 13:24:09 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> col host_name for A20
SQL> select instance_name, host_name from gv$instance;

INSTANCE_NAME    HOST_NAME
---------------- --------------------
SIDRAC1          rac1.localdomain
SIDRAC2          rac2.localdomain

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production