Home » RDBMS Server » Server Administration » upgrading from 8i to 10g
upgrading from 8i to 10g [message #400336] Mon, 27 April 2009 12:23 Go to next message
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 #400337 is a reply to message #400336] Mon, 27 April 2009 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>we need to check for the successful upgradations, from the application perspective.
Does the application work as before?
If so, then all is OK.
If not, update your resume!

I suggest you actually test on a different server before proceeding.
Re: upgrading from 8i to 10g [message #400338 is a reply to message #400337] Mon, 27 April 2009 12:37 Go to previous messageGo to next message
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 #400339 is a reply to message #400336] Mon, 27 April 2009 12:50 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
> is there any way of testing the upgradation using the database queries?
SELECT * FROM V$SESSION;
Re: upgrading from 8i to 10g [message #400341 is a reply to message #400339] Mon, 27 April 2009 13:01 Go to previous messageGo to next message
nani_ar
Messages: 58
Registered: March 2006
Member
What does it mean? Kidding!!!!!!!!!!!
Wht can be determined from v$session?

Just try to help in a meaning full way and shud not make fun of others...ok
Re: upgrading from 8i to 10g [message #400355 is a reply to message #400336] Mon, 27 April 2009 15:34 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous messageGo to next message
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
Re: upgrading from 8i to 10g [message #400381 is a reply to message #400336] Mon, 27 April 2009 23:43 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>The count of objects which I was referring is for the application owner.
Oracle version upgrades do not know or care about application schemas.
Previous Topic: DB requires restart once in two days
Next Topic: Challenges of Oracle 10G over oracle 9i
Goto Forum:
  


Current Time: Tue Dec 06 06:35:29 CST 2016

Total time taken to generate the page: 0.14972 seconds