|
Re: Unable to start second node in RAC [message #499964 is a reply to message #499941] |
Thu, 17 March 2011 00:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Connect to ASM instances (on both nodes) and execute:
select a.name dg_name, state, total_mb, offline_disks
from v$asm_diskgroup a
order by 1
/
select d.name disk_name,
case
when mount_status = 'CLOSED' and header_status in ('CANDIDATE', 'FORMER')
then 'Free'
else d.state
end state,
d.mount_status, d.header_status, d.total_mb, g.name group_name
from v$asm_disk d, v$asm_diskgroup g
where g.group_number = d.group_number
order by 1
/
Regards
Michel
[Updated on: Thu, 17 March 2011 00:25] Report message to a moderator
|
|
|
Re: Unable to start second node in RAC [message #500083 is a reply to message #499964] |
Thu, 17 March 2011 13:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/57313d81976ce2d8e3a5e9d2ddb6043f?s=64&d=mm&r=g) |
akshay_johari
Messages: 4 Registered: March 2011 Location: INDIA
|
Junior Member |
|
|
Thanks for reply. Following is the output of the given command
SQL> set head off;
SQL> set lines 1000;
SQL> set pages 0;
SQL> select a.name dg_name, state, total_mb, offline_disks
2 from v$asm_diskgroup a
3 order by 1
4 /
select d.name disk_name,
case
when mount_status = 'CLOSED' and header_status in ('CANDIDATE', 'FORMER')
then 'Free'
else d.state
end state,
d.mount_status, d.header_status, d.total_mb, g.name group_name
from v$asm_disk d, v$asm_diskgroup g
where g.group_number = d.group_number
order by 1
/DATA MOUNTED 297555 0
INDEX MOUNTED 195321 0
SQL> 2 3 4 5 6 7 8 9 10 11
VOL1 NORMAL CACHED MEMBER 297555 DATA
VOL2 NORMAL CACHED MEMBER 195321 INDEX
The output is same on both nodes.
Thanks, Aky
|
|
|
|
|
|
Re: Unable to start second node in RAC [message #500110 is a reply to message #500104] |
Thu, 17 March 2011 15:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/57313d81976ce2d8e3a5e9d2ddb6043f?s=64&d=mm&r=g) |
akshay_johari
Messages: 4 Registered: March 2011 Location: INDIA
|
Junior Member |
|
|
I restarted the 2nd machine and after that I am able to connect to start database with nomount option. But when I try to mount the database, it gives the following:
SQL> startup;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084296 bytes
Variable Size 385876536 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14692352 bytes
ORA-00600: internal error code, arguments: [kccchb_3], [4555], [4535], [0], [],
[], [], []
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
`alter database mount
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kccchb_3], [4555], [4535], [0], [],
[], [], []
SQL>
Also, I found the following in listener status :
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Instance "LCLCLKS2", status BLOCKED, has 2 handler(s) for this service...
Thanks, Aky
|
|
|
|
|
|