NON-RAC Database Startup Giving Error ORA-29702 (Doc ID 433310.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 15-Jun-2012***
***Checked for relevance on 27-Aug-2014***

Symptoms

While starting up the database, Getting error ORA-29702

Messages in the Alert Log file:

Cluster communication is configured to use the following interface(s) for this instance  192.168.193.2
Wed May 23 16:00:55 2007
cluster interconnect IPC version:Oracle UDP/IP (generic)
WARNING: Failed to set buffer limit on IPC interconnect socket Oracle requires that the
SocketReceive buffer size be tunable upto 1MB
Please make sure the kernel parameterwhich limits SO_RCVBUF value set by applications is atleast 1MB
MMNL started with pid=15, OS id=14908
Wed May 23 16:00:56 2007
starting up 1 shared server(s) ...
USER: terminating instance due to error 29702
Instance terminated by USER, pid = 14841

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms