After applying patch set 7 on existing oracle (9.2.0.5) to upgrade to 9.2.0.8. The “Ora-32700 error occurred in DIAG Group Service “ occurred at the time of startup database with migrate option.

=========Error===========

SQL> startup migrate

ORACLE instance started.

Total System Global Area  581505840 bytes

Fixed Size                   451376 bytes

Variable Size             402653184 bytes

Database Buffers          167772160 bytes

Redo Buffers               10629120 bytes

ORA-32700: error occurred in DIAG Group Service

=======End Of Error=========

The region behind this :-

The Oracle Universal Installer (OUI) detects this and assumes RAC is being installed, even if it is not.

Solution:-

To Resolve the problem follow these steps to turn RAC off

$ cd $ORACLE_HOME/rdbms/lib 

$ make -f ins_rdbms.mk rac_off ioracle