11gRAC Admin,Policy Managed管理和配置
Oracle RAC databaseAdmin ManagedPolicy Managed
GPFS File systems disable auto mount
Don't auto start all filesystemtouch /var/mmfs/etc/ignoreStartupMountFs fs2 don't auto start when os startup:touch /var/mmfs/etc/ignoreStartupMount.fs2 Or you can use gpfs mount filesystem optional:- Create entry in auto.master file and use an indirect mapfile for GPFS automoun...
Oracle 用户权限获取Procedure
CREATE OR REPLACE PROCEDURE grant_priv /* grant select and dml privilege to ...
AIX7.1 VMO 参数默认设置
AIX 5.3AIX6.1 到 AIX7.1 几乎所有的Oraclec 内存参数已经不用DBA 或 SA 手动设置就直接可以安装Oracle 10g /11g RAC 了。下面是AIX7.1 VMO 的参数默认值,大家感受一下:(在oracle 10g RAC 和11g RAC 安装时,都...
GPFS Persistent Reserve 的设置对Oracle RAC 的影响
Use of Persistent ReserveStarting GPFS version 3.2 (and higher releases), the introduction of Persistent Reserve (PR)option reduces GPFS recovery time from node failures, thus allowing Oracle OCR ad V...
Oracle 隐藏参数(9i,10g,11g,12c)
Oracle 9i,10g,11g 隐藏参数: SELECT a.ksppinm Param, b.ksppstvl SessionVal, c.ksppstvl InstanceVal, &...
listener QUEUESIZE 参数默认值
LISTENER.ORA: QUEUESIZEThe QUEUESIZE parameter determines the number of concurrent connection requests the Listener can store while it works to establish those connections.If the number of incoming re...
12c linux 安装参数配置
Oracle 12c 出来从安装来看并没有发生大的变化,Packages 和 各内存参数也基本和11gR2 保持一致。具体安装请参考下面列表:install Packages :binutils-2.20.51.0.2-5.11.el6 (x86_64)glibc-2.12-1.7.el6 (x86_64)...
PowerHA 自动测试功能
配置完成后执行smitty hacmp_testtool_menu,选择Autotest procedure 就可以自动完成下面9 个功能块的测试,简单方便。1. NODE_UP -- Each node one at a time.2. NODE_DOWN_GRACEFUL – Same as above.3. NODE_UP –...
北京被培训
培训三天,感觉比自己培训别人还累。