NON-RAC Database Startup Giving Error ORA-29702
(Doc ID 433310.1)
Last updated on DECEMBER 04, 2019
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***
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document