itspace
- 浏览: 981787 次
- 性别:
- 来自: 杭州
-
文章分类
最新评论
-
孤星119：
好熟悉的数据库字段啊， 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace：
quxiaoyong 写道遇到个问题，网上一搜，全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong：
遇到个问题，网上一搜，全他妈这篇文章。你转来转去的有意思吗？
数据库连接错误ORA-28547 -
hctech：
关于version count过高的问题，不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace：
invalid 写道写的不错，我根据这个来安装，有点理解错误了 ...
AIX 配置vncserver
一节点root.sh日志输出信息
二节点root.sh日志输出信息
一节点升级至10205输出信息
crsd日志信息
二节点crsd日志信息
一节点asm mount磁盘组信息
二节点asm mount磁盘组信息
引用
root@racsvr1 crs]# sh root.sh
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
CSS is inactive on these nodes.
racsvr2
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
CSS is inactive on these nodes.
racsvr2
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.
二节点root.sh日志输出信息
引用
[root@racsvr2 crs]# sh root.sh
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
racsvr2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
/oracle/app/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
assigning default hostname racsvr1 for node 1.
assigning default hostname racsvr2 for node 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
node 2: racsvr2 racsvr2_priv racsvr2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw2
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
racsvr1
racsvr2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
/oracle/app/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
一节点升级至10205输出信息
引用
[root@racsvr1 install]# ./root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/app/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
.
.
.
.
.
.
.
.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/oracle/app/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /oracle/app/product/10.2.0/crs/install/paramfile.crs
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/app/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/app/product/10.2.0' is not owned by root
WARNING: directory '/oracle/app/product' is not owned by root
WARNING: directory '/oracle/app' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
.
.
.
.
.
.
.
.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: racsvr1 racsvr1_priv racsvr1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/oracle/app/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /oracle/app/product/10.2.0/crs/install/paramfile.crs
crsd日志信息
引用
2010-08-04 11:01:23.579: [ CRSD][6764224]0ENV Logging level for Module: OCRUTL 0
2010-08-04 11:01:23.581: [ CRSD][6764224]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:01:23.582: [ CRSD][6764224]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:01:23.585: [ CRSD][6764224]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:01:23.588: [ CRSD][6764224]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:01:23.590: [ CRSD][6764224]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:01:23.590: [ CRSMAIN][6764224]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr1.pid
[ clsdmt][2863922064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr1DBG_CRSD))
2010-08-04 11:01:23.618: [ CRSOCR][6764224]0OCR api procr_open_key failed for key SYSTEM.crs.10.2.0.5.0. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
[ default][6764224]CRS resource ora.racsvr1.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:01:23.966: [ CRSMAIN][6764224]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:01:24.404: [ CRSMAIN][6764224]0Initializing RTI
2010-08-04 11:01:24.633: [ CRSOCR][6764224]0OCR api procr_open_key failed for key CRS.STAGE.node1. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:01:24.858: [CRSTIMER][2842942352]0Timer Thread Starting.
2010-08-04 11:01:24.895: [ CRSRES][6764224]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:01:24.895: [ CRSMAIN][6764224]0Initializing EVMMgr
2010-08-04 11:01:25.121: [ CRSMAIN][6764224]0CRSD locked during state recovery, please wait.
2010-08-04 11:01:25.329: [ CRSMAIN][6764224]0CRSD recovered, unlocked.
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.344: [ CRSMAIN][6764224]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:01:25.373: [ CRSMAIN][6764224]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr1_priv)(PORT=49896))
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0Starting Threads
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0CRS Daemon Started.
2010-08-04 11:01:25.374: [ CRSMAIN][2780003216]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:01:25.374: [ CRSMAIN][2769513360]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:01:25.397: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.453: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.520: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.557: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.602: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.649: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.782: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:25.807: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.vip` on member `racsvr1`
2010-08-04 11:01:30.053: [ CRSRES][2738043792]0Start of `ora.racsvr1.vip` on member `racsvr1` succeeded.
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Returned from grpstat with event 1
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Doing grpstat on crs_version group
2010-08-04 11:01:30.570: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:30.728: [ CRSRES][2706574224]0startRunnable: setting CLI values
2010-08-04 11:01:30.739: [ CRSRES][2675104656]0startRunnable: setting CLI values
2010-08-04 11:01:30.974: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.gsd` on member `racsvr1`
2010-08-04 11:01:31.326: [ CRSRES][2706574224]0Attempting to start `ora.racsvr1.ons` on member `racsvr1`
2010-08-04 11:01:31.358: [ CRSRES][2675104656]0Attempting to start `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:01:34.902: [ CRSRES][2738043792]0Start of `ora.racsvr1.gsd` on member `racsvr1` succeeded.
2010-08-04 11:01:36.171: [ CRSRES][2706574224]0Start of `ora.racsvr1.ons` on member `racsvr1` succeeded.
2010-08-04 11:01:38.054: [ CRSRES][2675104656]0Start of `ora.racsvr2.vip` on member `racsvr1` succeeded.
2010-08-04 11:01:23.581: [ CRSD][6764224]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:01:23.582: [ CRSD][6764224]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:01:23.585: [ CRSD][6764224]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:01:23.588: [ CRSD][6764224]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:01:23.590: [ CRSD][6764224]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:01:23.590: [ CRSMAIN][6764224]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr1.pid
[ clsdmt][2863922064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr1DBG_CRSD))
2010-08-04 11:01:23.618: [ CRSOCR][6764224]0OCR api procr_open_key failed for key SYSTEM.crs.10.2.0.5.0. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
[ default][6764224]CRS resource ora.racsvr1.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][6764224]CRS resource ora.racsvr1.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:01:23.966: [ CRSMAIN][6764224]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:01:24.404: [ CRSMAIN][6764224]0Initializing RTI
2010-08-04 11:01:24.633: [ CRSOCR][6764224]0OCR api procr_open_key failed for key CRS.STAGE.node1. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:01:24.858: [CRSTIMER][2842942352]0Timer Thread Starting.
2010-08-04 11:01:24.895: [ CRSRES][6764224]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:01:24.895: [ CRSMAIN][6764224]0Initializing EVMMgr
2010-08-04 11:01:25.121: [ CRSMAIN][6764224]0CRSD locked during state recovery, please wait.
2010-08-04 11:01:25.329: [ CRSMAIN][6764224]0CRSD recovered, unlocked.
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.331: [ CRSMAIN][6764224]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:01:25.344: [ CRSMAIN][6764224]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:01:25.373: [ CRSMAIN][6764224]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr1_priv)(PORT=49896))
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0Starting Threads
2010-08-04 11:01:25.374: [ CRSMAIN][6764224]0CRS Daemon Started.
2010-08-04 11:01:25.374: [ CRSMAIN][2780003216]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:01:25.374: [ CRSMAIN][2769513360]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:01:25.397: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.453: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.520: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.557: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.602: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.649: [ CRSRES][6764224]0 startup = 1
2010-08-04 11:01:25.782: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:25.807: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.vip` on member `racsvr1`
2010-08-04 11:01:30.053: [ CRSRES][2738043792]0Start of `ora.racsvr1.vip` on member `racsvr1` succeeded.
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Returned from grpstat with event 1
2010-08-04 11:01:30.498: [ CLSVER][39017360]0Doing grpstat on crs_version group
2010-08-04 11:01:30.570: [ CRSRES][2738043792]0startRunnable: setting CLI values
2010-08-04 11:01:30.728: [ CRSRES][2706574224]0startRunnable: setting CLI values
2010-08-04 11:01:30.739: [ CRSRES][2675104656]0startRunnable: setting CLI values
2010-08-04 11:01:30.974: [ CRSRES][2738043792]0Attempting to start `ora.racsvr1.gsd` on member `racsvr1`
2010-08-04 11:01:31.326: [ CRSRES][2706574224]0Attempting to start `ora.racsvr1.ons` on member `racsvr1`
2010-08-04 11:01:31.358: [ CRSRES][2675104656]0Attempting to start `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:01:34.902: [ CRSRES][2738043792]0Start of `ora.racsvr1.gsd` on member `racsvr1` succeeded.
2010-08-04 11:01:36.171: [ CRSRES][2706574224]0Start of `ora.racsvr1.ons` on member `racsvr1` succeeded.
2010-08-04 11:01:38.054: [ CRSRES][2675104656]0Start of `ora.racsvr2.vip` on member `racsvr1` succeeded.
二节点crsd日志信息
引用
2010-08-04 11:12:06.538: [ CSSCLNT][14083776]clsssInitNative: connect failed, rc 9
2010-08-04 11:12:06.538: [ CRSRTI][14083776]0CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version from OCR:10.2.0.1.0
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version is less than Software Version
2010-08-04 11:12:19.569: [ CLSVER][14083776]0Registered in CSS group crs_version
2010-08-04 11:12:19.571: [ CRSMAIN][14083776]0Initializing OCR
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Monitoring the crs_version group for AV change notification
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:19.572: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.763: [ OCRRAW][14083776]proprioo: for disk 0 (/dev/raw/raw1), id match (1), my id set (1669906634,1028247821) total id sets (1), 1st set (1669906634,1028247821), 2nd set (0,0) my votes (2), total votes (2)
2010-08-04 11:12:23.048: [ CRSD][14083776]0ENV Logging level for Module: allcomp 0
2010-08-04 11:12:23.223: [ CRSD][14083776]0ENV Logging level for Module: default 0
2010-08-04 11:12:23.560: [ CRSD][14083776]0ENV Logging level for Module: COMMCRS 0
2010-08-04 11:12:24.108: [ CRSD][14083776]0ENV Logging level for Module: COMMNS 0
2010-08-04 11:12:24.520: [ CRSD][14083776]0ENV Logging level for Module: CRSUI 0
2010-08-04 11:12:24.581: [ CRSD][14083776]0ENV Logging level for Module: CRSCOMM 0
2010-08-04 11:12:24.627: [ CRSD][14083776]0ENV Logging level for Module: CRSRTI 0
2010-08-04 11:12:24.755: [ CRSD][14083776]0ENV Logging level for Module: CRSMAIN 0
2010-08-04 11:12:25.606: [ OCRMAS][3044850576]th_master: Deleted ver keys from cache (non master)
2010-08-04 11:12:25.836: [ CRSD][14083776]0ENV Logging level for Module: CRSPLACE 0
2010-08-04 11:12:26.275: [ CRSD][14083776]0ENV Logging level for Module: CRSAPP 0
2010-08-04 11:12:26.674: [ CRSD][14083776]0ENV Logging level for Module: CRSRES 0
2010-08-04 11:12:27.325: [ CRSD][14083776]0ENV Logging level for Module: CRSOCR 0
2010-08-04 11:12:27.344: [ CRSD][14083776]0ENV Logging level for Module: CRSTIMER 0
2010-08-04 11:12:27.403: [ CRSD][14083776]0ENV Logging level for Module: CRSEVT 0
2010-08-04 11:12:27.418: [ CRSD][14083776]0ENV Logging level for Module: CRSD 0
2010-08-04 11:12:27.433: [ CRSD][14083776]0ENV Logging level for Module: CLUCLS 0
2010-08-04 11:12:27.448: [ CRSD][14083776]0ENV Logging level for Module: CLSVER 0
2010-08-04 11:12:27.462: [ CRSD][14083776]0ENV Logging level for Module: OCRRAW 0
2010-08-04 11:12:27.479: [ CRSD][14083776]0ENV Logging level for Module: OCROSD 0
2010-08-04 11:12:27.495: [ CRSD][14083776]0ENV Logging level for Module: CSSCLNT 0
2010-08-04 11:12:27.507: [ CRSD][14083776]0ENV Logging level for Module: OCRAPI 0
2010-08-04 11:12:27.524: [ CRSD][14083776]0ENV Logging level for Module: OCRUTL 0
2010-08-04 11:12:27.537: [ CRSD][14083776]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:12:27.560: [ CRSD][14083776]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:12:27.980: [ CRSD][14083776]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:12:28.142: [ CRSD][14083776]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:12:28.184: [ CRSD][14083776]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:12:28.184: [ CRSMAIN][14083776]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr2.pid
[ clsdmt][2854194064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr2DBG_CRSD))
[ default][14083776]CRS resource ora.racsvr2.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:12:34.163: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Returned from grpstat with event 8
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Recieved GRPPRIV event
2010-08-04 11:12:34.169: [ CLSVER][40627088]0AV got from version group: 10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Stopped monitoring the version group
2010-08-04 11:12:34.169: [ CLSVER][40627088]0New Active Version:10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Active Version changed to 10.2.0.5.0
2010-08-04 11:12:34.492: [ CRSMAIN][14083776]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:12:35.064: [ CRSMAIN][14083776]0Initializing RTI
2010-08-04 11:12:35.730: [ CRSOCR][14083776]0OCR api procr_open_key failed for key CRS.STAGE.node2. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:12:36.299: [CRSTIMER][40627088]0Timer Thread Starting.
2010-08-04 11:12:36.329: [ CRSRES][14083776]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:12:36.329: [ CRSMAIN][14083776]0Initializing EVMMgr
2010-08-04 11:12:37.163: [ CRSMAIN][14083776]0CRSD locked during state recovery, please wait.
2010-08-04 11:12:37.418: [ CRSMAIN][14083776]0CRSD recovered, unlocked.
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.527: [ CRSMAIN][14083776]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:12:37.577: [ CRSMAIN][14083776]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr2_priv)(PORT=49896))
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0Starting Threads
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0CRS Daemon Started.
2010-08-04 11:12:37.579: [ CRSMAIN][2780765072]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:12:37.582: [ CRSMAIN][2770275216]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:12:37.865: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:38.035: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:39.257: [ CRSRES][2738805648]0StopResource: setting CLI values
2010-08-04 11:12:39.382: [ CRSRES][2738805648]0Attempting to stop `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:12:39.884: [ CRSRES][2738805648]0Stop of `ora.racsvr2.vip` on member `racsvr1` succeeded.
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.vip` on member `racsvr2`
2010-08-04 11:12:44.537: [ CRSRES][2738805648]0Start of `ora.racsvr2.vip` on member `racsvr2` succeeded.
2010-08-04 11:12:46.126: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:46.299: [ CRSRES][2696846224]0startRunnable: setting CLI values
2010-08-04 11:12:46.319: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.gsd` on member `racsvr2`
2010-08-04 11:12:46.452: [ CRSRES][2696846224]0Attempting to start `ora.racsvr2.ons` on member `racsvr2`
2010-08-04 11:12:48.974: [ CRSRES][2738805648]0Start of `ora.racsvr2.gsd` on member `racsvr2` succeeded.
2010-08-04 11:12:50.403: [ CRSRES][2696846224]0Start of `ora.racsvr2.ons` on member `racsvr2` succeeded.
2010-08-04 11:12:06.538: [ CRSRTI][14083776]0CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version from OCR:10.2.0.1.0
2010-08-04 11:12:19.566: [ CLSVER][14083776]0Active Version is less than Software Version
2010-08-04 11:12:19.569: [ CLSVER][14083776]0Registered in CSS group crs_version
2010-08-04 11:12:19.571: [ CRSMAIN][14083776]0Initializing OCR
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Monitoring the crs_version group for AV change notification
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.571: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:19.572: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:19.763: [ OCRRAW][14083776]proprioo: for disk 0 (/dev/raw/raw1), id match (1), my id set (1669906634,1028247821) total id sets (1), 1st set (1669906634,1028247821), 2nd set (0,0) my votes (2), total votes (2)
2010-08-04 11:12:23.048: [ CRSD][14083776]0ENV Logging level for Module: allcomp 0
2010-08-04 11:12:23.223: [ CRSD][14083776]0ENV Logging level for Module: default 0
2010-08-04 11:12:23.560: [ CRSD][14083776]0ENV Logging level for Module: COMMCRS 0
2010-08-04 11:12:24.108: [ CRSD][14083776]0ENV Logging level for Module: COMMNS 0
2010-08-04 11:12:24.520: [ CRSD][14083776]0ENV Logging level for Module: CRSUI 0
2010-08-04 11:12:24.581: [ CRSD][14083776]0ENV Logging level for Module: CRSCOMM 0
2010-08-04 11:12:24.627: [ CRSD][14083776]0ENV Logging level for Module: CRSRTI 0
2010-08-04 11:12:24.755: [ CRSD][14083776]0ENV Logging level for Module: CRSMAIN 0
2010-08-04 11:12:25.606: [ OCRMAS][3044850576]th_master: Deleted ver keys from cache (non master)
2010-08-04 11:12:25.836: [ CRSD][14083776]0ENV Logging level for Module: CRSPLACE 0
2010-08-04 11:12:26.275: [ CRSD][14083776]0ENV Logging level for Module: CRSAPP 0
2010-08-04 11:12:26.674: [ CRSD][14083776]0ENV Logging level for Module: CRSRES 0
2010-08-04 11:12:27.325: [ CRSD][14083776]0ENV Logging level for Module: CRSOCR 0
2010-08-04 11:12:27.344: [ CRSD][14083776]0ENV Logging level for Module: CRSTIMER 0
2010-08-04 11:12:27.403: [ CRSD][14083776]0ENV Logging level for Module: CRSEVT 0
2010-08-04 11:12:27.418: [ CRSD][14083776]0ENV Logging level for Module: CRSD 0
2010-08-04 11:12:27.433: [ CRSD][14083776]0ENV Logging level for Module: CLUCLS 0
2010-08-04 11:12:27.448: [ CRSD][14083776]0ENV Logging level for Module: CLSVER 0
2010-08-04 11:12:27.462: [ CRSD][14083776]0ENV Logging level for Module: OCRRAW 0
2010-08-04 11:12:27.479: [ CRSD][14083776]0ENV Logging level for Module: OCROSD 0
2010-08-04 11:12:27.495: [ CRSD][14083776]0ENV Logging level for Module: CSSCLNT 0
2010-08-04 11:12:27.507: [ CRSD][14083776]0ENV Logging level for Module: OCRAPI 0
2010-08-04 11:12:27.524: [ CRSD][14083776]0ENV Logging level for Module: OCRUTL 0
2010-08-04 11:12:27.537: [ CRSD][14083776]0ENV Logging level for Module: OCRMSG 0
2010-08-04 11:12:27.560: [ CRSD][14083776]0ENV Logging level for Module: OCRCLI 0
2010-08-04 11:12:27.980: [ CRSD][14083776]0ENV Logging level for Module: OCRCAC 0
2010-08-04 11:12:28.142: [ CRSD][14083776]0ENV Logging level for Module: OCRSRV 0
2010-08-04 11:12:28.184: [ CRSD][14083776]0ENV Logging level for Module: OCRMAS 0
2010-08-04 11:12:28.184: [ CRSMAIN][14083776]0Filename is /oracle/app/product/10.2.0/crs/crs/init/racsvr2.pid
[ clsdmt][2854194064]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=racsvr2DBG_CRSD))
[ default][14083776]CRS resource ora.racsvr2.ons upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.vip upgraded from 10.2.0.1.0 to 10.2.0.5.0
[ default][14083776]CRS resource ora.racsvr2.gsd upgraded from 10.2.0.1.0 to 10.2.0.5.0
2010-08-04 11:12:34.163: [ CLSVER][40627088]0Returned from grpstat with event 1
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Doing grpstat on crs_version group
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Returned from grpstat with event 8
2010-08-04 11:12:34.164: [ CLSVER][40627088]0Recieved GRPPRIV event
2010-08-04 11:12:34.169: [ CLSVER][40627088]0AV got from version group: 10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Stopped monitoring the version group
2010-08-04 11:12:34.169: [ CLSVER][40627088]0New Active Version:10.2.0.5.0
2010-08-04 11:12:34.169: [ CLSVER][40627088]0Active Version changed to 10.2.0.5.0
2010-08-04 11:12:34.492: [ CRSMAIN][14083776]0Using Authorizer location: /oracle/app/product/10.2.0/crs/crs/auth/
2010-08-04 11:12:35.064: [ CRSMAIN][14083776]0Initializing RTI
2010-08-04 11:12:35.730: [ CRSOCR][14083776]0OCR api procr_open_key failed for key CRS.STAGE.node2. OCR error code = 4 OCR error msg: PROC-4: The cluster registry key to be operated on does not exist.
2010-08-04 11:12:36.299: [CRSTIMER][40627088]0Timer Thread Starting.
2010-08-04 11:12:36.329: [ CRSRES][14083776]0Parameter SECURITY = 1, running in USER Mode
2010-08-04 11:12:36.329: [ CRSMAIN][14083776]0Initializing EVMMgr
2010-08-04 11:12:37.163: [ CRSMAIN][14083776]0CRSD locked during state recovery, please wait.
2010-08-04 11:12:37.418: [ CRSMAIN][14083776]0CRSD recovered, unlocked.
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.422: [ CRSMAIN][14083776]0QS socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=ora_crsqs))
2010-08-04 11:12:37.527: [ CRSMAIN][14083776]0CRSD UI socket on: (ADDRESS=(PROTOCOL=ipc)(KEY=CRSD_UI_SOCKET))
2010-08-04 11:12:37.577: [ CRSMAIN][14083776]0E2E socket on: (ADDRESS=(PROTOCOL=tcp)(HOST=racsvr2_priv)(PORT=49896))
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0Starting Threads
2010-08-04 11:12:37.578: [ CRSMAIN][14083776]0CRS Daemon Started.
2010-08-04 11:12:37.579: [ CRSMAIN][2780765072]0Starting runCommandServer for (UI = 1, E2E = 0). 0
2010-08-04 11:12:37.582: [ CRSMAIN][2770275216]0Starting runCommandServer for (UI = 1, E2E = 0). 1
2010-08-04 11:12:37.865: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:38.035: [ CRSRES][14083776]0 startup = 1
2010-08-04 11:12:39.257: [ CRSRES][2738805648]0StopResource: setting CLI values
2010-08-04 11:12:39.382: [ CRSRES][2738805648]0Attempting to stop `ora.racsvr2.vip` on member `racsvr1`
2010-08-04 11:12:39.884: [ CRSRES][2738805648]0Stop of `ora.racsvr2.vip` on member `racsvr1` succeeded.
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:39.917: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.vip` on member `racsvr2`
2010-08-04 11:12:44.537: [ CRSRES][2738805648]0Start of `ora.racsvr2.vip` on member `racsvr2` succeeded.
2010-08-04 11:12:46.126: [ CRSRES][2738805648]0startRunnable: setting CLI values
2010-08-04 11:12:46.299: [ CRSRES][2696846224]0startRunnable: setting CLI values
2010-08-04 11:12:46.319: [ CRSRES][2738805648]0Attempting to start `ora.racsvr2.gsd` on member `racsvr2`
2010-08-04 11:12:46.452: [ CRSRES][2696846224]0Attempting to start `ora.racsvr2.ons` on member `racsvr2`
2010-08-04 11:12:48.974: [ CRSRES][2738805648]0Start of `ora.racsvr2.gsd` on member `racsvr2` succeeded.
2010-08-04 11:12:50.403: [ CRSRES][2696846224]0Start of `ora.racsvr2.ons` on member `racsvr2` succeeded.
一节点asm mount磁盘组信息
引用
Wed Aug 04 11:53:08 EDT 2010
SQL> CREATE DISKGROUP datadg External REDUNDANCY DISK '/dev/raw/raw3' SIZE 964M ,
'/dev/raw/raw4' SIZE 1153M
Wed Aug 04 11:53:08 EDT 2010
NOTE: initializing header on grp 1 disk DATADG_0000
NOTE: initializing header on grp 1 disk DATADG_0001
NOTE: PST update: grp = 1
Wed Aug 04 11:53:08 EDT 2010
NOTE: group DATADG: initial PST locations: disk 0000 (PST copy 0)
Wed Aug 04 11:53:08 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x390d2f07
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: cache creating group 1/0x390D2F07 (DATADG)
NOTE: cache mounting group 1/0x390D2F07 (DATADG) succeeded
NOTE: allocating F1X0 on grp 1 disk DATADG_0000
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting group 1/0x390D2F07 (DATADG)
Wed Aug 04 11:53:12 EDT 2010
kjbdomdet send to node 1
detach from dom 1, sending detach message to node 1
freeing rdom 1
Wed Aug 04 11:53:12 EDT 2010
NOTE: detached from domain 1
Wed Aug 04 11:53:13 EDT 2010
SUCCESS: diskgroup DATADG was created
NOTE: cache registered group DATADG number=1 incarn=0x4bad2f09
Wed Aug 04 11:53:13 EDT 2010
NOTE: Hbeat: instance first (grp 1)
Wed Aug 04 11:53:20 EDT 2010
NOTE: start heartbeating (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:20 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (first) group 1/0x4BAD2F09 (DATADG)
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:20 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache recovered group 1 to fcn 0.0
Wed Aug 04 11:53:21 EDT 2010
NOTE: LGWR attempting to mount thread 1 for disk group 1
NOTE: LGWR mounted thread 1 for disk group 1
NOTE: opening chunk 1 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache mounting group 1/0x4BAD2F09 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM1';
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM2';
Wed Aug 04 11:53:22 EDT 2010
NOTE: recovering COD for group 1/0x4bad2f09 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad2f09 (DATADG)
NOTE: enlarging ACD for group 1/0x4bad2f09 (DATADG)
SUCCESS: ACD enlarged for group 1/0x4bad2f09 (DATADG)
Wed Aug 04 11:53:29 EDT 2010
NOTE: X->S down convert bast on F1B3 bastCount=2
SQL> CREATE DISKGROUP datadg External REDUNDANCY DISK '/dev/raw/raw3' SIZE 964M ,
'/dev/raw/raw4' SIZE 1153M
Wed Aug 04 11:53:08 EDT 2010
NOTE: initializing header on grp 1 disk DATADG_0000
NOTE: initializing header on grp 1 disk DATADG_0001
NOTE: PST update: grp = 1
Wed Aug 04 11:53:08 EDT 2010
NOTE: group DATADG: initial PST locations: disk 0000 (PST copy 0)
Wed Aug 04 11:53:08 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x390d2f07
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:09 EDT 2010
NOTE: cache creating group 1/0x390D2F07 (DATADG)
NOTE: cache mounting group 1/0x390D2F07 (DATADG) succeeded
NOTE: allocating F1X0 on grp 1 disk DATADG_0000
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting group 1/0x390D2F07 (DATADG)
Wed Aug 04 11:53:12 EDT 2010
kjbdomdet send to node 1
detach from dom 1, sending detach message to node 1
freeing rdom 1
Wed Aug 04 11:53:12 EDT 2010
NOTE: detached from domain 1
Wed Aug 04 11:53:13 EDT 2010
SUCCESS: diskgroup DATADG was created
NOTE: cache registered group DATADG number=1 incarn=0x4bad2f09
Wed Aug 04 11:53:13 EDT 2010
NOTE: Hbeat: instance first (grp 1)
Wed Aug 04 11:53:20 EDT 2010
NOTE: start heartbeating (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:20 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (first) group 1/0x4BAD2F09 (DATADG)
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 1
Wed Aug 04 11:53:20 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache recovered group 1 to fcn 0.0
Wed Aug 04 11:53:21 EDT 2010
NOTE: LGWR attempting to mount thread 1 for disk group 1
NOTE: LGWR mounted thread 1 for disk group 1
NOTE: opening chunk 1 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:21 EDT 2010
NOTE: cache mounting group 1/0x4BAD2F09 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM1';
Wed Aug 04 11:53:21 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY SID='+ASM2';
Wed Aug 04 11:53:22 EDT 2010
NOTE: recovering COD for group 1/0x4bad2f09 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad2f09 (DATADG)
NOTE: enlarging ACD for group 1/0x4bad2f09 (DATADG)
SUCCESS: ACD enlarged for group 1/0x4bad2f09 (DATADG)
Wed Aug 04 11:53:29 EDT 2010
NOTE: X->S down convert bast on F1B3 bastCount=2
二节点asm mount磁盘组信息
引用
Wed Aug 04 11:50:58 EDT 2010
SQL> ALTER DISKGROUP ALL MOUNT
* allocate domain 1, invalid = TRUE
freeing rdom 1
Received detach msg from node 0 for dom 1
* allocate domain 1, invalid = TRUE
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskstring='' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
SQL> /* OracleOEM */ alter diskgroup datadg MOUNT
Wed Aug 04 11:53:23 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x4bad1a80
Wed Aug 04 11:53:23 EDT 2010
NOTE: Hbeat: instance not first (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:23 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (not first) group 1/0x4BAD1A80 (DATADG)
Wed Aug 04 11:53:23 EDT 2010
kjbdomatt send to node 0
Wed Aug 04 11:53:24 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:24 EDT 2010
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: ACD expansion required for disk group 1
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: LGWR mounted thread 2 for disk group 1
NOTE: opening chunk 2 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:29 EDT 2010
NOTE: cache mounting group 1/0x4BAD1A80 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:32 EDT 2010
NOTE: recovering COD for group 1/0x4bad1a80 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad1a80 (DATADG)
SQL> ALTER DISKGROUP ALL MOUNT
* allocate domain 1, invalid = TRUE
freeing rdom 1
Received detach msg from node 0 for dom 1
* allocate domain 1, invalid = TRUE
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskstring='' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
ALTER SYSTEM SET asm_diskgroups='DATADG' SCOPE=MEMORY;
Wed Aug 04 11:53:23 EDT 2010
SQL> /* OracleOEM */ alter diskgroup datadg MOUNT
Wed Aug 04 11:53:23 EDT 2010
NOTE: cache registered group DATADG number=1 incarn=0x4bad1a80
Wed Aug 04 11:53:23 EDT 2010
NOTE: Hbeat: instance not first (grp 1)
NOTE: cache opening disk 0 of grp 1: DATADG_0000 path:/dev/raw/raw3
Wed Aug 04 11:53:23 EDT 2010
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATADG_0001 path:/dev/raw/raw4
NOTE: cache mounting (not first) group 1/0x4BAD1A80 (DATADG)
Wed Aug 04 11:53:23 EDT 2010
kjbdomatt send to node 0
Wed Aug 04 11:53:24 EDT 2010
NOTE: attached to recovery domain 1
Wed Aug 04 11:53:24 EDT 2010
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: ACD expansion required for disk group 1
NOTE: LGWR attempting to mount thread 2 for disk group 1
NOTE: LGWR mounted thread 2 for disk group 1
NOTE: opening chunk 2 at fcn 0.0 ABA
NOTE: seq=2 blk=0
Wed Aug 04 11:53:29 EDT 2010
NOTE: cache mounting group 1/0x4BAD1A80 (DATADG) succeeded
SUCCESS: diskgroup DATADG was mounted
Wed Aug 04 11:53:32 EDT 2010
NOTE: recovering COD for group 1/0x4bad1a80 (DATADG)
SUCCESS: completed COD recovery for group 1/0x4bad1a80 (DATADG)
0
顶
顶
0
踩
踩
分享到：
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 584BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 495Oracle管理云服务（OMC）的大数据平台，自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 5312019年7月22日，受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 835某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1471性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 528从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 2145数据库的启动是一个相当复杂的过程。比如，Oracle在启动之前 ... -
怎么样彻底删除数据库？
2018-09-18 11:10 608Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 871LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1240“一朝被蛇咬，十年怕井绳”。在没被“蛇”咬之前，很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1137在DTCC 2018发表《如何落地智能化运维》演讲，主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 587问题一：ping不通问题 在虚拟机上安装好linux系统后， ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 954即日起，不定期更新《OracleDBA实战攻略》一书电子版，请 ... -
Oracle 12c新特性
2018-05-11 10:33 907查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3990操作系统：RHEL6.5 数据库版本：11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 70311g rac安装在二节点跑脚本一般会报此错误： 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 805故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2656由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1776数据库中的log file sync等待事件指的是，当user ...
相关推荐
### 手把手教你用VMware在Linux下安装Oracle 10g RAC #### 一、准备工作 在开始安装Oracle 10g RAC之前，需要确保已经做好充分的准备工作。这包括安装必要的软件和配置合适的环境。 ##### 必备软件 1. **VMware ...
在本教程中，我们将深入探讨在Linux AS5操作系统环境下，如何进行Oracle 10g RAC的安装和实施。 首先，安装前准备是关键。在Linux AS5环境下，你需要确保系统满足Oracle 10g RAC的硬件和软件需求。这包括足够的内存...
在Linux环境下安装Oracle数据库10g是一项复杂但必要的任务，对于数据库管理员（DBA）和想要学习如何在Linux平台上安装和配置Oracle数据库的IT专业人员来说，这是一项基础技能。以下是在Linux上安装Oracle 10g的详细...
在本文中，我们将深入探讨如何在Virtual Box环境下安装Oracle 11g RAC，这是一个高可用性数据库解决方案，用于在多台服务器上分布式部署Oracle数据库。我们选择Oracle Linux 6.7作为操作系统，因为它是Oracle官方...
Oracle 10g RAC（Real Application Clusters）在Linux AS 4上的安装是一个复杂而精细的过程，涉及多个步骤和组件。以下是对该主题的详细解释： **Oracle 10g RAC概述** Oracle RAC是一种数据库高可用性解决方案，...
在Red Hat Enterprise Linux 5.5 (RHEL5.5) 上部署Oracle 10g RAC，需要一系列特定的软件包和配置步骤。以下是对提供的文件名列表及其对应知识点的详细解释： 1. **ocfs2-2.6.18-194.el5-debuginfo-1.4.7-1.el5.i...
在Linux平台上安装Oracle 10g RAC涉及多个步骤，涵盖了操作系统准备、网络配置、存储设置、集群软件安装以及数据库创建等多个环节。 1. **系统需求与准备**：在开始安装前，确保Linux系统满足Oracle 10g RAC的硬件...
根据提供的文档信息，本文将详细解析Oracle 11g R2 RAC（Real Application Clusters）在Linux环境下的安装配置过程。此文档适用于希望在Linux平台上部署Oracle 11g R2 RAC集群的IT专业人士。 ### Oracle 11g R2 RAC...
Oracle 10g for Linux是针对在Linux操作系统上部署和管理Oracle数据库的全面教程。Oracle数据库是世界上最流行的关系型数据库管理系统之一，而Linux作为开源且稳定的服务器操作系统，是许多企业和开发人员的选择。...
### Oracle Database 11g RAC on Linux：关键技术与实施指南 #### 一、概述 《Pro Oracle Database 11g RAC on Linux》是一本深入探讨如何在Linux环境下实现Oracle Real Application Clusters (RAC)的专业书籍。...
本文将深入讲解如何在 VMware 虚拟环境中使用 Linux 操作系统来搭建 Oracle 10g RAC 环境。这一过程涉及多个步骤，包括虚拟机配置、Linux 安装、Oracle RAC 相关软件的安装和配置，以及故障排查。 首先，虚拟机的...
在IT领域，Oracle 11g RAC (Real Application Clusters) 是一种高可用性和可扩展性的数据库解决方案，尤其适用于Windows平台上运行的Linux系统。RAC允许多个实例同时访问同一数据库，提供故障切换和负载均衡，确保...
为Oracle RAC环境规划磁盘空间，包括创建三个2GB大小的CRS磁盘、三个10GB的DG DATA磁盘和两个5GB的DG RECOVERY磁盘，用于存储数据库实例的关键数据和恢复信息。 ##### 4. 创建Grid与Oracle用户 接下来，创建Grid...
总之，配置Oracle 10g RAC在VMware Server上的Linux Red Hat 4环境中是一项复杂但重要的任务，涉及多个层面的技术，包括操作系统、虚拟化、数据库管理和集群技术。在实际操作中，需要对每个环节都有深入理解和实践...
Oracle 11g Release 1是Oracle数据库的一个重要版本，引入了诸如快速应用故障切换、自动工作负载管理、数据守护等新特性，增强了数据库的安全性和效率。 三、Linux环境下的RAC部署 在Linux环境中部署Oracle RAC，...
通过这个详尽的教程，你可以逐步学习并掌握在Oracle Enterprise Linux 6.4上安装Oracle Database 12c RAC的过程，这对于获得OCP（Oracle Certified Professional）或OCM（Oracle Certified Master）认证也是重要的...
在本教程中，我们将深入探讨如何在Red Hat Enterprise Linux (RHEL) 5环境中安装Oracle 10g Real Application Clusters (RAC)。Oracle RAC是一种高可用性解决方案，允许多台服务器共享同一个数据库实例，从而提供...