本帖最后由 last_day_1983 于 2012-4-6 21:11 编辑
vmware OS:Linux4.7 64bit ORACLE10204
还没有创建实例:
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE OFFLINE
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE UNKNOWN rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
[oracle@rac1 ~]$ crs_stop -all
停都停不了
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application ONLINE UNKNOWN rac1
ora.rac1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
强行停掉:
[oracle@rac1 ~]$ crs_stop ora.rac1.ASM1.asm -f
Target set to OFFLINE for `ora.rac1.ASM1.asm`
[oracle@rac1 ~]$ crs_stop ora.rac1.ons -f
Attempting to stop `ora.rac1.ons` on member `rac1`
Stop of `ora.rac1.ons` on member `rac1` succeeded.
[oracle@rac1 ~]$ crs_stat -t 停掉了
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE
[oracle@rac1 ~]$ crs_start -all
Attempting to start `ora.rac1.vip` on member `rac1`
Attempting to start `ora.rac2.ASM2.asm` on member `rac2`
Attempting to start `ora.rac1.ASM1.asm` on member `rac1`
Attempting to start `ora.rac2.vip` on member `rac2`
Start of `ora.rac1.vip` on member `rac1` succeeded.
Attempting to start `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`
Start of `ora.rac2.vip` on member `rac2` succeeded.
Attempting to start `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`
Start of `ora.rac2.ASM2.asm` on member `rac2` failed.
rac1 : CRS-1019: Resource ora.rac2.ASM2.asm (application) cannot run on rac1
Start of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.
Start of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.
Start of `ora.rac1.ASM1.asm` on member `rac1` failed.
rac2 : CRS-1019: Resource ora.rac1.ASM1.asm (application) cannot run on rac2
Attempting to start `ora.rac1.gsd` on member `rac1`
Attempting to start `ora.rac2.gsd` on member `rac2`
Attempting to start `ora.rac1.ons` on member `rac1`
Attempting to start `ora.rac2.ons` on member `rac2`
`ora.rac1.ons` on member `rac1` has experienced an unrecoverable failure.
Human intervention required to resume its availability.
Start of `ora.rac2.gsd` on member `rac2` succeeded.
Start of `ora.rac1.gsd` on member `rac1` succeeded.
Start of `ora.rac2.ons` on member `rac2` succeeded.
CRS-0215: Could not start resource 'ora.rac1.ASM1.asm'.
CRS-0215: Could not start resource 'ora.rac1.ons'.
CRS-0215: Could not start resource 'ora.rac2.ASM2.asm'.
[oracle@rac1 ~]$ srvctl start asm -n rac2 asm2起来了
[oracle@rac1 ~]$ srvctl start asm -n rac1 asm1还是不行。
PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [rac1
ra.rac1.ASM1.asm:
rac1
ra.rac1.ASM1.asm:SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 20:56:26 2012
rac1
ra.rac1.ASM1.asm:
rac1
ra.rac1.ASM1.asm:Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
rac1
ra.rac1.ASM1.asm:
rac1
ra.rac1.ASM1.asm:Enter user-name: Connected to an idle instance.
rac1
ra.rac1.ASM1.asm:
rac1
ra.rac1.ASM1.asm:SQL> ORA-03113: end-of-file on communication channel
rac1
ra.rac1.ASM1.asm:SQL> Disconnected
rac1
ra.rac1.ASM1.asm:
CRS-0215: Could not start resource 'ora.rac1.ASM1.asm'.]]
[PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 20:56:26 2012
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:Enter user-name: Connected to an idle instance.
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:SQL> ORA-03113: end-of-file on communication channel
rac1:ora.rac1.ASM1.asm:SQL> Disconnected
rac1:ora.rac1.ASM1.asm:
CRS-0215: Could not start resource 'ora.rac1.ASM1.asm'.]]
2012-04-06 20:55:48.371: [ RACG][2549198144] [24964][2549198144][ora.rac1.ASM1.asm]:
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 20:54:15 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: Connected to an idle instance.
SQL> ORA-03113: end-of-file on communication channel
SQL> Disconnected
2012-04-06 20:55:48.374: [ RACG][2549198144] [24964][2549198144][ora.rac1.ASM1.asm]: clsrcexecut: env _USR_ORA_PFILE=
2012-04-06 20:55:48.374: [ RACG][2549198144] [24964][2549198144][ora.rac1.ASM1.asm]: clsrcexecut: cmd = /usr/oracle/product/10.2.0/db_1/bin/racgeut -e _USR_ORA_DEBUG=0 -e ORACLE_SID=+ASM1 540 /usr/oracle/product/10.2.0/db_1/bin/racgmdb -s mount
2012-04-06 20:55:48.374: [ RACG][2549198144] [24964][2549198144][ora.rac1.ASM1.asm]: clsrcexecut: rc = 1, time = 2.610s
2012-04-06 20:55:48.374: [ RACG][2549198144] [24964][2549198144][ora.rac1.ASM1.asm]: clsrcasmapp: failed to initiate ASM startup [1]
2012-04-06 20:55:48.374: [ RACG][2549198144] [24964][2549198144][ora.rac1.ASM1.asm]: end for resource = ora.rac1.ASM1.asm, action = start, status = 1, time = 2.660s
2012-04-06 20:55:55.209: [ RACG][2549198144] [25038][2549198144][ora.rac1.ASM1.asm]:
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 20:55:49 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: Connected.
SQL> ASM instance shutdown
SQL> Disconnected
2012-04-06 20:56:29.769: [ RACG][2549198144] [25384][2549198144][ora.rac1.ASM1.asm]:
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 20:56:26 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: Connected to an idle instance.
SQL> ORA-03113: end-of-file on communication channel
SQL> Disconnected
2012-04-06 20:56:29.769: [ RACG][2549198144] [25384][2549198144][ora.rac1.ASM1.asm]: clsrcexecut: env _USR_ORA_PFILE=
2012-04-06 20:56:29.769: [ RACG][2549198144] [25384][2549198144][ora.rac1.ASM1.asm]: clsrcexecut: cmd = /usr/oracle/product/10.2.0/db_1/bin/racgeut -e _USR_ORA_DEBUG=0 -e ORACLE_SID=+ASM1 540 /usr/oracle/product/10.2.0/db_1/bin/racgmdb -s mount
2012-04-06 20:56:29.769: [ RACG][2549198144] [25384][2549198144][ora.rac1.ASM1.asm]: clsrcexecut: rc = 1, time = 3.380s
2012-04-06 20:56:29.769: [ RACG][2549198144] [25384][2549198144][ora.rac1.ASM1.asm]: clsrcasmapp: failed to initiate ASM startup [1]
2012-04-06 20:56:29.770: [ RACG][2549198144] [25384][2549198144][ora.rac1.ASM1.asm]: end for resource = ora.rac1.ASM1.asm, action = start, status = 1, time = 3.420s
2012-04-06 20:56:37.024: [ RACG][2549198144] [25444][2549198144][ora.rac1.ASM1.asm]:
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 20:56:30 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: Connected.
SQL> ASM instance shutdown
SQL> Disconnected
[oracle@rac1 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
[oracle@rac1 ~]$ srvctl remove asm -n rac1
[oracle@rac1 ~]$ srvctl add asm -n rac1 -i ASM1 -o $ORACLE_HOME
[oracle@rac1 ~]$ srvctl start asm -n rac1
PRKS-1009 : Failed to start ASM instance "ASM1" on node "rac1", [PRKS-1009 : Failed to start ASM instance "ASM1" on node "rac1", [rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 21:05:56 2012
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:Enter user-name: Connected to an idle instance.
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:SQL> ORA-03113: end-of-file on communication channel
rac1:ora.rac1.ASM1.asm:SQL> Disconnected
rac1:ora.rac1.ASM1.asm:
CRS-0215: Could not start resource 'ora.rac1.ASM1.asm'.]]
[PRKS-1009 : Failed to start ASM instance "ASM1" on node "rac1", [rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 6 21:05:56 2012
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:Enter user-name: Connected to an idle instance.
rac1:ora.rac1.ASM1.asm:
rac1:ora.rac1.ASM1.asm:SQL> ORA-03113: end-of-file on communication channel
rac1:ora.rac1.ASM1.asm:SQL> Disconnected
rac1:ora.rac1.ASM1.asm:
CRS-0215: Could not start resource 'ora.rac1.ASM1.asm'.]]
还是不行。
dbca建实例
1.jpg (92.98 KB, 下载次数: 1)
2012-4-6 20:59 上传
2.jpg (77.29 KB, 下载次数: 1)
2012-4-6 21:01 上传
3.jpg (88.34 KB, 下载次数: 1)
2012-4-6 21:03 上传
过不去了,继续不了,之前一直是vmware的时间不同步,就是有个节点的系统始终老是落后,半个钟头就落后第二个节点10几分钟,现在装了vmware tool,每3分钟同步一次
,也就落后最后2分钟左右,应该不是问题了。这个实例起不来不知道是什么原因引起的。