once in a while support comes thru quickly :)
From: <TESTAJ3_at_nationwide.com>
Date: Tue, 16 Mar 2010 14:26:37 -0400
Message-ID: <OFDFECDC07.38FFD72E-ON852576E8.006502E4-852576E8.0065508D_at_lnotes-gw.ent.nwie.net>
during an upgrade from 9.2.0.8 to 11.1.0.7, the sysaux tablespace was created without using auto segment management, so during startup upgrade and then running catupgrd.sql, it barfs and says SYSAUX not correct.
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
Date: Tue, 16 Mar 2010 14:26:37 -0400
Message-ID: <OFDFECDC07.38FFD72E-ON852576E8.006502E4-852576E8.0065508D_at_lnotes-gw.ent.nwie.net>
during an upgrade from 9.2.0.8 to 11.1.0.7, the sysaux tablespace was created without using auto segment management, so during startup upgrade and then running catupgrd.sql, it barfs and says SYSAUX not correct.
Well, couldn't drop it, ora-00600 error, support had me insert a row into sys.props$ and create the recyclebin manually, then i was able to drop the sysaux tablespace and get it created correctly.
I know we've had some serious problems with oracle support during the migration but I like to sing the praises when they come through for me.
If anyone wants the more of the specifics let me know.
joe
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 16 2010 - 13:26:37 CDT