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:

Query to get the package specification

In Oracle E-Business Suite R12.2.10 , if you want to download (export) a package’s source code (specification and body), you can do it usin...