about parallel

目前机器通常都是多core CPU,单个进程未开并行只会在一个core上运行,未完全发挥多core的特性,有时在统计查询,DML,DDL时需要开启并行提高效率

配置11Gr2 physical dataguard,11203 RAC 到single instance

primary db是2nodes 11203 RAC,physical standby是11203 的single instance,Primary db有用到ASM存储文件,Single instance只用local filesystem

impdp network_link 在11201中导入分区表时行记录为0 rows?

. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P23″ 0 rows
. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P24″ 0 rows
. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P21″ 0 rows
. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P22″ 0 rows

GoldenGate 小测试initial load,extract change

模拟一种主库不停机,做个备库并initial load,并同步改变数据
源机启用本地Extract 进程抽取变化生成本地trail文件

remove a node from 11g r2 rac on OEL5(删除节点)

[grid@znode1 bin]$ cluvfy stage -post nodedel -n racnode3 -verbose
Performing post-checks for node removal
Checking CRS integrity…
Clusterware version consistency passed
The Oracle Clusterware is healthy on node “znode2”
The Oracle Clusterware is healthy on node “znode1”
CRS integrity check passed
Node removal check passed
Post-check for node removal was successful.

10g r2 audit_trail db_extended 的错误提示

ORA-00096: invalid value db,extended for parameter audit_trail, must be from among extended, xml, db_extended, false, true, none, os, db

Configuring ACFS in ORACLE 11G R2(配置ACFS)

ACFS storage management design that extends Oracle Automatic Storage Management (Oracle ASM) technology to support all application data

Add a node to RAC 11203(手动篇)

2,安装GRID (clusterware)到第三个节点
4, 增加oracle instance 到第三个节点

ORA-01078: failure in processing system parameters when srvctl start instance

[grid@znode1 ~]$ srvctl start instance -d rac -i rac1
PRCR-1013 : Failed to start resource ora.rac.db
PRCR-1064 : Failed to start resource ora.rac.db on node znode1
CRS-5017: The resource action “ora.rac.db start” encountered the following error:
ORA-01078: failure in processing system parameters


11203 RAC addNode.sh 遇PRKC-PRCF-2015 PRCF-2023

PRCF-2023 : The following contents are not transferred as they are non-readable.
1) /u01/app/11.2.0/grid/OCRDUMPFILE
2) /u01/app/11.2.0/grid/locr.lst


修改11g r2 RAC SCAN IP

SCAN简化了客户端连接的配置,只需指定SCAN Name在客户端的tnsnames.ora,不需要知道每个节点的vip就可以实现负载均衡
每个节点上的pmon会经常的发送本节点的负载情况到scan listener…

11gR2 RAC ASM 启动疑惑

存储asm instance spfile到asm,听上去很奇怪,启动自身,首先要解决的几个问题
1,asm diskgroup 没mount,如何读spfile?


11G R2 Oracle Local Registry(OLR)

从oracle 11R2版本起在网格计算领域引进了新特性,其中之一就是grid Oracle Local Registry(OLR),做为oracle clusterware的一部分,有些人喜欢叫Oracle Local Repository,因为这repositery记录了本地资源的信息和配置..

move rdbms from local file(no-ASM) to ASM instance

one asm instance can support multiple rdbms instances,and it is possible to run more than one asm instance to which the rdbms instance could connect,this potential many-to-many relationship btween the instance types is resolved by the cluster services.

about modify unique constraint

ERROR at line 2:
ORA-02299: cannot validate (ICME.UK_PROJECT_SCORE) – duplicate keys found

oracle ASM on LVM (linux卷管理),配置LVM


oracle 11g BaseLine(基线)指定application中不可修改sql的执行计划

11G前有sql profile、outline可以稳定执行计划,但有些文档中指出有时outline指定了但也有要能走新的执行计划,所以11g的BASELINE是OUTLINE的改进版。一般应用在版本升级或稳定特定SQL的执行计划,也可以修改指定SQL的执行计划,当OUTLINE与BASELINE有同时指定时BASELINE有优先权。

noarchive model,迁tablespace从ASM到Local files fs

利用rman 可以方便的把datafile,tablespace,database在本地文件系统和ASM之间转换

10gGridControl failed to start a managed process after the maximum retry limit

[oracle@dbserver1 bin]$ ./opmnctl startall
failed to start a managed process after the maximum retry limit
[error 13079] [ecid: -] No matching CACHE element found in

sqlserver 游标小例

总忘,小记 declare @c int declare @seq int set @seq=54000101 […]