| upgrading from 8i to 10g [message #400336] |
Mon, 27 April 2009 12:23  |
nani_ar
Messages: 58
Registered: March 2006
|
Member |
|
|
Hi,
Our database is going to be upgraded from 8i(8.1.7.4) to 10gR2 by the vendor. After upgrading, what are the various aspects that we need to check for the successful upgradations, from the application perspective.
Is it ok to have the count,status,num_rows of the objects tallied? Anything else needs to be looked?
Are there any scripts to verify the successful upgradation from the data perspective?
please excuse if posing the questions in a wrong way.
Kindly provide me your valuable thoughts.
Thanks,
Nani
|
|
|
|
|
|
| Re: upgrading from 8i to 10g [message #400338 is a reply to message #400337] |
Mon, 27 April 2009 12:37  |
nani_ar
Messages: 58
Registered: March 2006
|
Member |
|
|
Hi,
Thanks for the quick reply.
Before testing the applications in a full fledged manner, is there any way of testing the upgradation using the database queries?
Are there any look up points that we need to concentrate upon?
for eg datatypes,any code variations....
Kindly let me know the same.
Thanks,
Nani
|
|
|
|
|
|
|
|
| Re: upgrading from 8i to 10g [message #400355 is a reply to message #400336] |
Mon, 27 April 2009 15:34 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
You really should have had a test plan for checking whether your application runs correctly after upgrade. At our company, we tested for two months in a test environment.
You can't really expect to do an upgrade without having a test plan in place.
Checking the number of rows in tables or number of objects does not really help, unless you see that the number has gone down drastically, but I have never seen an upgrade change data.
You will need to do an exhaustive test of your app.
One thing you will notice is that any reports relying on implicit ordering of output because the existence of a GROUP BY statement without an ORDER BY statement will now most likely give you different results.
|
|
|
|
| Re: upgrading from 8i to 10g [message #400378 is a reply to message #400355] |
Mon, 27 April 2009 23:39 |
nani_ar
Messages: 58
Registered: March 2006
|
Member |
|
|
Hi Joy,
I agree with you. We are upgrading in the test server itself. We need to check the application over a period of time. However, I would like to know of the different checks that we need to perform from the database side immediately after upgradation. Once the checks are confirmed, we can go ahead with testing the application over a period of time and check for any anomalies. The count of objects which I was referring is for the application owner.
Thanks for all your useful comments.
Regards
nani
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
