提供综合数据库运维服务与优化方案(不限Oracle MySQL PG GaussDB GoldenDB OceanBase等), 微信/Tel:(+86)134-365-60330
数据库oracle
[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
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
SCAN简化了客户端连接的配置，只需指定SCAN Name在客户端的tnsnames.ora，不需要知道每个节点的vip就可以实现负载均衡
每个节点上的pmon会经常的发送本节点的负载情况到scan listener…
存储asm instance spfile到asm，听上去很奇怪，启动自身，首先要解决的几个问题
1,asm diskgroup 没mount,如何读spfile?
2,在oracle_home/dbs下没有参数文件，如何知道spfile在哪?
3,不知道spfile，怎么知道的asm_diskstring?
从oracle 11R2版本起在网格计算领域引进了新特性，其中之一就是grid Oracle Local Registry(OLR)，做为oracle clusterware的一部分，有些人喜欢叫Oracle Local Repository，因为这repositery记录了本地资源的信息和配置..
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.
ERROR at line 2:
ORA-02299: cannot validate (ICME.UK_PROJECT_SCORE) – duplicate keys found
LVM在后期因先前指定的路径空间不够时调整起来很方便，也可以就用于ASM，但是并不推荐ASM安装在LVM之上，因为LVM的功能在ASM上已存在。
11G前有sql profile、outline可以稳定执行计划，但有些文档中指出有时outline指定了但也有要能走新的执行计划，所以11g的BASELINE是OUTLINE的改进版。一般应用在版本升级或稳定特定SQL的执行计划，也可以修改指定SQL的执行计划，当OUTLINE与BASELINE有同时指定时BASELINE有优先权。
利用rman 可以方便的把datafile,tablespace,database在本地文件系统和ASM之间转换
[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
启用物化视图的重写有两个条件QUERY_REWRITE_ENABLED=true and materialized view enable query rewrite.
在CBO对查询sql 重写后估算cast后直接查询mv
[ohasd(4507)]CRS-2807:Resource ‘ora.asm’ failed to start automatically.
SQL> startup nomount
ORA-27102: out of memory
PRVF-5184 : Check of following Udev attributes of “rac2:/dev/asm-diskc” failed: “[Owner: Found=’root’ Expected=’grid’, Group: Found=’root’ Expected=’asmadmin’, Permissions: Found=’0600′ Expected=’0660′]”
Oracle Error :: INS-35171
Target database memory (stringMB) exceeds at least one of the selected nodes available shared memory (string MB).
OUI默认是带域名的名称如znode1.anbob.com/znode1-vip.anbob.com,去掉改为了znode1/znode1-vip 新增加的znode2/znode2-vip，再下一步到检查的时，检查通过。
注意当用veriable变量绑定时sqlplus autotrace有可能显示的执行计划不是实际的，用dbms_xplan.display_cursor查看
Start of resource “ora.asm -init” failed
Failed to start ASM
Failed to start Oracle Clusterware stack
ins-40719 ipaddress configured for single client access name(scan):
rac-scan.anbob.com is already assigned to another system
数据库在运行一段时间后crash,遭遇ORA-00600: internal error code, arguments: [SKGMFAIL], [2], [4], [4], [1]，重启后又可以正常运行。