LINUX+ORACLE常用的环境设置

LINUX+ORACLE常用的环境设置 http://metalink.oracle.com/metal ... d=NOT&p_id=265262.1 Give general information about oracle on linux SCOPE & APPLICATION Provide information about limitation and features available for oracle version on different linux distributions Gerenal information about oracle on linux Linux Information Library <185752> Oracle Installation Guides SuSE Step by step Installation of RAC on linux (<184821>) Quick Start Guides (<201370>, <176865>, <114141>) 9iR2 RAC/NetApp/Red Hat Max os file size 2Gb (filesystem ext2): <= linux 2.2 >2Gb: >= linux 2.4 Large File Support Ext2, ReiserFS, JFS, XFS, OCFS <=16Tb: (kernel 2.4 limit) Raw device OS Header No header Max Oracle file size 2Gb: <=8.1.7 >2Gb: >= 9.0.1 Max SGA size Summary About the Large SGA & Address Space on Linux <260152> Red Hat adv Server Specific Async IO Yes for ext2, ext3, raw Yes for OCFS ≥ 1.0.9-4 but not yet activated in Oracle (as of 9.2.0.4) Red Hat AS 2.1+ <225751>(patch for RH3) UnitedLinux 1.0 aio-max-size must be <= 524288 RAC & Filesystems (<183408>) RH2.1+ & United Linux: OCFS Raw Devices on RedHat Advanced Server - FAQ <224302> Max IO Size . Must be >= db_file_multiblock_read_count*db_block_size db_file_direct_io_count*db_block_size hash_multiblock_io_count*db_block_size sort_multiblock_read_count*db_block_size aio-max-size (<225751>) Find it yourself! 256K (default VxVM Maximum I/O Size) and VxFS 3.4 Disk & File System layout fdisk -l Shared libraries support in PRO*C? Yes glibc 2.06 + List of dynamic libraries in executable file /usr/bin/ldd OS version /usr/bin/uname -s -r cat /proc/version cat /etc/issue Linux Memory Management linux-mm swap status /sbin/swapon -s free -t xosview cat /proc/swaps Swap Space on RedHat Advanced Server - FAQ (<225451>) Amount of RAM, hardware config cat /proc/meminfo cat /proc/cpuinfo /bin/dmesg cat /var/log/dmesg How to Read '/proc/meminfo' Output (<233753>) OS kernel parameters files (<68862>) /sbin/sysctl -a /etc/sysctl.conf /usr/src/linux/include/* /usr/src/linux/include/linux/shm.h for shared memory /usr/src/linux/include/linux/sem.h for semaphores How to permanently set kernel parameters on Linux (<242529>) OS kernel parameters values /sbin/sysctl -a ipcs -l Am I on a 32 or 64 bit OS? more /proc/cpuinfo Max number of semaphores sets (SEMMNI) /usr/bin/ipcs -ls (max number of arrays) /sbin/sysctl kernel.sem (4th & last value) awk '{print $4}' /proc/sys/kernel/sem Linux: How to Check Current Shared Memory, Semaphore Values (<226209>) Max number of semaphores per set (SEMMSL) /usr/bin/ipcs -ls (max semaphores per array) /sbin/sysctl kernel.sem (1st value) awk '{print $1}' /proc/sys/kernel/sem Max number of semaphores systemwide (SEMMNS) /usr/bin/ipcs -ls (max semaphores system wide) /sbin/sysctl kernel.sem (2nd value) awk '{print $2}' /proc/sys/kernel/sem Max number of shared segments /sbin/sysctl kernel.shmmni /usr/bin/ipcs -lm (max number of segments) cat /proc/sys/kernel/shmmni Max shared segment size /sbin/sysctl kernel.shmmax /usr/bin/ipcs -lm (max seg size (kbytes)) cat /proc/sys/kernel/shmmax (max value=4Gb) Max number of procs per user/system wide ?/MAX_TASKS_PER_USER (default NR_TASKS/2) From /usr/src/linux/include/linux/tasks.h Max number of open files per user/system wide /sbin/sysctl fs.file-nr Buffer cache size bdflush and buffermem parameters From /usr/src/linux/Documentation/sysctl/vm.txt cat /proc/sys/vm/buffermem (in % of RAM: buffer cache min size/prune(unused)/buffer cache max size) How to Get/Set Network parameters Get parameter value: /sbin/sysctl parameter Set parameter to value: /sbin/sysctl -w parameter value TCP keepalive parameters net.ipv4.tcp_keepalive_time (seconds) net.ipv4.tcp_keepalive_intvl (seconds) net.ipv4.tcp_keepalive_probes TCP tuning parameters send buffer size: net.core.wmem_default/net.core.wmem_max (128 to 256k recommended) receive buffer size: net.core.rmem_default/net.core.rmem_max (128 to 256k recommended) Auto tuning mode min/default/max send buffer size: net.ipv4.tcp_wmem min/default/max receive buffer size: net.ipv4.tcp_rmem low/default/max system memory for TCP stack (in pages): net.ipv4.tcp_mem UDP tuning parameters send/receive buffer sizes : same as TCP Process Limits (<188149>) ulimit -a Administration tool /bin/linuxconf System log file /var/log/messages Display system/error messages dmesg List of OS errors /usr/src/linux/include/asm/errno.h man errno Package installation rpm -Uvh or rpm -ivh Updating the Software RPM (Red Hat Package Manager (<233060>) Package deinstallation rpm -e Installed packages list rpm -qa To which package belongs file fname? rpm -qf fname Ex: rpm -qf /usr/lib/libm.so gives a result similar to glibc-devel-2.1.3-15 Latest kernel level/OS patch UL1.0 SLES8 x86: SP2a(2.4.19-304), SP3 (2.4.21-138) includes hangcheck-timer RedHat AS 2.1 x86: 2.4.9-e.38 RHEL 3.0 Update 1 Relinking Kernel cd /usr/src/linux;make config or make xconfig Debug and Miscellaneous /usr/bin/strace (system calls) - List of OS calls /usr/bin/ltrace (dynamic library calls) /usr/bin/vmstat (Memory Consumption tracing) the /proc File System The Linux Trace Toolkit hdparm for faster IO on IDE disk cat /proc/meminfo (Memory usage details <233753>) Top-level Files in the proc File System Core analysis (<1812>) /usr/bin/gdb -c core (gdb) type backtrace for stacktrace 1812>233753>233060>188149>226209>242529>68862>233753>225451>225751>224302>183408>225751>260152>114141>176865>201370>184821>185752>

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/257699/viewspace-815210/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/257699/viewspace-815210/