Friday, October 16, 2015

ORA-600 raised in ASM I/O path, [ossnet_assign_msgid_1]

Today fought with error in alert log (Database 12.1.0.2.11 on Exadata, image 12.1.2.1.2):
 
ORA-00600: internal error code, arguments: [ossnet_assign_msgid_1], [], [], [], [], [], [], [], [], [], []
ERROR: unrecoverable error ORA-600 raised in ASM I/O path

MOS found nothing direct links about this error.

As of note " 12.1.0.2 Bundle Patches for Engineered Systems and DB In-Memory - List of Fixes in each Bundle (Doc ID 1937782.1) "
this is the bug:
ORA-600 [OSSNET_ASSIGN_MSGID_1] CAUSED BY TO SMALL VALUE _SMM_AUTO_MIN_IO_SIZE

The solution which helped to us:

alter system set "_smm_auto_max_io_size"=2048 scope=both sid='*';
alter system set "_smm_auto_min_io_size"=2040 scope=both sid='*';

 

How to disable/setup autostart parameters for specified instance ?

Q: We have a 4-node RAC. I need to disable autostart of the DB on one node only.    How to do it and how to see autostart parameters, confir...