ORA-32700

ORA-32700: error occurred in DIAG Group Service


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

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...