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
