Sunday, September 13, 2009

_disable_interface_checking

sqlplus / as sysasm

SQL> startup
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:check if cable failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: skgxpcini1
ORA-27303: additional information: requested interface eth1 interface not running set _disable_interface_checking = TRUE to disable this check for single instance cluster. Check output from if
"_disable_interface_checking" supports on Oracle Database since 10.2.0 (FALSE)

SQL> show parameter "_disable_interface_checking"
...Nothing...

When Private Interconnect is down in RAC, that make ASM doesn't start.
If need to start ASM(some node) anyway... To bypass by set: _disable_interface_checking = true

SQL> show parameter "_disable_interface_checking"
NAME TYPE VALUE
------------------------------------ ----------- ---------
_disable_interface_checking boolean TRUE

4 comments:

Anonymous said...

Thanks, but how do you actually set that parameter ? I;ve have tried and the ASM instance does not seem to like it.

Surachart Opun said...

SQL> alter system set "_disable_interface_checking"=TRUE scope=spfile;

System altered.

This parameter ... we have to restart ASM anyway.

Anonymous said...

Thanks, but i cant get that far, as to set that parameter I need ASM up. But it will not start. So I have tried setting a text pfile with this parameter and this is message I get:

ORA-15021: parameter "_disable_interface_checking" is not valid in asm instance

Surachart Opun said...

oh ... Oracle Version.
I tested on 11.2

SQL> create pfile='/tmp/asm1.txt' from spfile;

File created.

SQL> alter system set "_disable_interface_checking"=TRUE scope=spfile;

System altered.

Stop/Start ASM

SQL> show parameter "_disable_interface_checking"

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_disable_interface_checking boolean TRUE