Posts Tagged: 11g

11g Default Schema

Posted by & filed under basic.

BACKGROUND When an 11g database is created without tweaking any of the options, using either dbca or the installer, the schema listed in the table below, 36 of them(!), are created by default. This document gives an overview of their purpose and function and, should the functionailty not be required, whether they can be safely… Read more »

Differences between EM10g and EM11g

Posted by & filed under reference.

from: http://blogs.oracle.com/oem/2010/09/differences_between_em10g_and.html For those who have already played with EM11g, you will have noticed that there are quite a few differences in the OMS tech stack between 10g and 11g… To give you all a quickstart on EM11g, here are the key differences you will see: Stopping and starting the OMS and the Middle tier… Read more »

RAC on AIX 实施建议

Posted by & filed under install.

Tune Virtual memory parameters. IBM recommended numbers are: #!/usr/bin/ksh vmo -p -o maxperm%=90; vmo -p -o minperm%=3; vmo -p -o maxclient%=90; vmo -p -o strict maxperm=0; vmo -p -o strict maxclient=1; vmo -p -o lru_file_repage=0; vmo -r -o page_steal_method=1; set AIXTHREAD_SCOPE=S Ensure that AIX processor folding is disabled for Oracle environments. # schedo -o vpm_xvcpus=-1… Read more »

RAC on HP-UX 实施建议

Posted by & filed under install.

主机名不超过8个字符。 设置streams_sqmax=50000能减少gc cr block lost的情况。 Ensure Patch PHKL_40208 applied to avoid RAC hangs on HP UX Itanium Make sure patch phne_35766 s700_800 or its superceded patch 11.23 cumulative arpa transport patch is applied. 参考：RAC Assurance Support Team: RAC Starter Kit and Best Practices (HP-UX) [ID 811303.1]

RAC实施网络建议

Posted by & filed under install.

主机名、域名、网络地址的别名、网关名等相关名称中尽量不要使用下划线(_)。 确保默认网关与VIP地址是同一个子网段。 确保网卡名称在所有主机上一一对应。 尽可能的使用Jumbo Frames（巨帧）。 对于私有网络，不要使用路由。 使所有网卡的配置参数完全一致，如速率、双工等。 使用bonding等网卡冗余技术。 检查交换机或HBA卡是否丢包，通过命令netstat –s|grep udp查看。 为私有网络使用专用的交换机。 为私有网络使用Infiniband，以满足大容量的需求。 把IPC地址配置在listener.ora的最前面。 增加SDU的值。 10g中的listener使用的是OS验证，为防止别人修改，最好给listener加上口令。 参考文档：RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) [ID 810394.1]