If you do exp/imp... grab DDL on package bodies, grab the SYS grants, ... Patrice.
-----Original Message----- Sent: Wednesday, June 04, 2003 6:20 PM To: Multiple recipients of list ORACLE-L Hi Rich, No. I guess by manual I mean I didn't use the gui. I ran the appropriate upgrade script. Gosh I hope it doesn't come to exp/imp... I can't even export my database. Lisa -----Original Message----- Sent: Wednesday, June 04, 2003 2:46 PM To: Multiple recipients of list ORACLE-L Lisa, when you say you "manually" migrated, did you use exp/imp after a fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 1:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Shite of the day > > > Hi Ganesh, > > Thanks for your reply. Still, no dice. Now it thinks it's > in recovery and I can't force it to do an incomplete recovery > with OPEN RESETLOGS. The brilliant response I got from > support is "Restore from backup and try again" > > Lovely. This is the second upgrade I have tried to complete > and failed miserably at. This is NOT giving me a warm fuzzy > about upgrading production. > > Lisa > (Can one more thing go wrong today? Please?) > > -----Original Message----- > Sent: Wednesday, June 04, 2003 1:38 PM > To: Multiple recipients of list ORACLE-L > > > Set the Compatiable Parameter to the Actual Version you > Upgraded and not > to any patch rel that was rel later on. > > HTH > > Best Regards, > Ganesh R > DID : +65-6215-8413 > HP : +65-9067-8474 > =========================================== > Live to learn... forget... and learn again. > =========================================== > > > -----Original Message----- > Lisa > Sent: Wednesday, June 04, 2003 10:40 PM > To: Multiple recipients of list ORACLE-L > > > Oh-My-Gosh. > > Worry free? I just upgraded another 8.1.7.4 database to 9.2. When I > set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make > sense) I get > really messy errors: > > ORA-00402: database changes by release 9.0.1.3.0 cannot be used by > release 135294976 > > ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version > 8.1.7.0.0 > > So then I tried to set it back to 8.1.7, or comment out COMPATIBLE > altogether, and I get the same type of error. It won't open at all. > > I tried initiating recovery. This database is in noarc mode. > It starts > looking for arclogs that *do not* exist. I also tried to > drop the redo > log groups and recreate them. Still, no dice. > > Again, unbreakable my FUNDAMENT. > > So has anyone seen this before? I opened a tar yesterday and promptly > confused support. > > Lisa > > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 7:45 AM > To: Multiple recipients of list ORACLE-L > > > "Trade SQL Server for Oracle9i Database and get up to 100% license > credit > and peace of mind. > > Tired of applying patches? Frustrated with managing mulitple database > servers? > In the time it takes you to apply all Microsoft's patches to your > servers, > you can successfully migrate your database to Oracle9i > Database and be > worry-free. " > > > From > http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764 > 462&Act=16 > > > I don't understand PR of Oracle. The RDBMS has so much > properties which > are > much more better implemented in Oracle than in MS SQL and they choose > 'patching' which *** on both servers. > > JP > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
