Re: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Rachel Carmichael
I used it recently on a W2K box, worked fine, no problems, no hassles... took a while to do the upgrade so don't panic if it seems to be taking a long time --- Vladimir Barac [EMAIL PROTECTED] wrote: Hi I'm about to upgrade 8.1.7 db to 9.2 db. Platform is AIX. Database Upgrade

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread April Wells
We did AIX 4.3... financials instances Upgrade takes HOURS... it upgrades to 901 first, if you read the logs, and then to 9.2 Process took half a day for one of our instances, then several hours to recompile invalids, then we had to upgrade spatial, intermedia. But... yes, pretty straight forward

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread DENNIS WILLIAMS
Vladimir - Since I don't see a reply posted to your question, I'll make an attempt. I haven't had much direct experience with this tool, but like any tool it may cause problems under some circumstances. I think Oracle has laudable goals for giving everything a GUI interface to please those who

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti
I was told that the tool creates, and uses, SPFILE after the upgrade... - Kirti -Original Message- Sent: Wednesday, April 02, 2003 7:09 AM To: Multiple recipients of list ORACLE-L I used it recently on a W2K box, worked fine, no problems, no hassles... took a while to do the upgrade

Re: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Igor Neyman
Kirti, Is it a bad thing? Igor - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 10:28 AM I was told that the tool creates, and uses, SPFILE after the upgrade... - Kirti -Original Message- Sent:

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread April Wells
Is if you aren't expecting it -Original Message- Sent: Wednesday, April 02, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Kirti, Is it a bad thing? Igor - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 02,

Re: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Stephen Andert
I'm not using the dbua since I cannot use X applications from home due to the firewall we have. I've now upgraded 3 8.1.7.3 databases to 9.2.0.2. One of these was a very little play database I created just to test the upgrade process. The other 2 are fairly small (35-40 GB) test databases.

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti
Igor, It depends. If you are not aware of what the tool does, you will get caught by surprise (like my co-worker;) May be there is an option to not create the SPFILE.. I didn't use the tool when I upgraded a few my databases to 9i. But, AFIAC, I am staying away from SPFILE, as long as

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Gogala, Mladen
Only if you're not aware of it. I started editting init$ORACLE_SID.ora like crazy and parameter changes would have no effect whatsoever. I thought for a moment that I've enterd the twilight zone but then I resorted to the unthinkable: I read the documentation. I know I shouldn't have done it, but,

Re: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Igor Neyman
Kirti, Thanks. My question was not in regards to the tool, but in regards to use of SPFILE in general. Igor - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 12:23 PM Igor, It depends. If you are not aware of what the