Script: 查看datafile 的HWM,估算resize 最小size
数据文件如果有2g，先create一个大表占了1G,后来建了个几M小表，再把大表drop 掉加purge选项，向把数据文件resize到100M，往往会失败，在磁盘紧张的情况下，想知道数据文件最小值是多少？就要计算datafile HWM
ORACLE 9i-23ai
数据库oracle
How to list all events?（oracle事件列表）
其中有两个编号段比较特殊
1，错误编号-10000到-10999 不是真正的错误，是保留下来用于debug使用
2，错误编号-20000到-20999是自定义异常，错误信息最大2048B
hanganalyze 分析 dbms_ijob.broken无效的问题
HANG ANALYSIS:
==============
Open chains found:
Chain 1 : :
<0/1777/32406/0x5275fca0/13913/SQL*Net message from client>
— <0/1477/37455/0x5275e4e8/16043/enq: TX - row lock contention>
ora-600 [3708] [910] internal error issue
SQL> shutdown immediate
ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []
Basically this error is raised because LGWR timmed out.
ORA-00600 [keltnfy-ldmInit] internal error issue
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
oracle 用UTL_SMTP 发预警邮件
对于每个数据库不同级别的错误可以做不同的处理，如短信、邮件等
About Columns Order(列先后顺序)
有时总是忽略在列的顺序带来的性能开销，还有列的null值字段的位置,想理解这个问题要首先程序列数据是如何在block上存储的，并且是如何定位的？
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
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
Result:
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
Oracle 11g R2 RAC addnode (增加RAC节点) 实践和注意事项
1，配置OS环境
2，安装GRID （clusterware）到第三个节点
3，安装ORACLE RDBMS SOFTWARE到第三个节点
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.
Files:
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…
揭秘 Oracle 11gR2 RAC ASM Instance 启动
存储asm instance spfile到asm，听上去很奇怪，启动自身，首先要解决的几个问题
1,asm diskgroup 没mount,如何读spfile?
2,在oracle_home/dbs下没有参数文件，如何知道spfile在哪?
3,不知道spfile，怎么知道的asm_diskstring?
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.