Home » RDBMS Server » Server Administration » upgrade database
upgrade database [message #603304] Fri, 13 December 2013 04:21 Go to next message
narang79
Messages: 131
Registered: June 2010
Senior Member
hi

we are using oracle 9.2.0.8 with d2k
now we shift our database from 9.2.0.8 to 10.2.0.4

pls advise what aspect we have to chk data is ok or not
Re: upgrade database [message #603308 is a reply to message #603304] Fri, 13 December 2013 04:35 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
First off: start by reading the upgrade manuals
All necessary steps are well documented.
Re: upgrade database [message #603313 is a reply to message #603304] Fri, 13 December 2013 04:58 Go to previous messageGo to next message
gazzag
Messages: 908
Registered: November 2010
Location: Bristol, UK
Senior Member
Upgrade on a test system first. Then test.
Re: upgrade database [message #603316 is a reply to message #603313] Fri, 13 December 2013 05:11 Go to previous messageGo to next message
narang79
Messages: 131
Registered: June 2010
Senior Member
we have shifted data in new version
now after shifting what we have to chk my data is ok or not
Re: upgrade database [message #603317 is a reply to message #603316] Fri, 13 December 2013 05:14 Go to previous messageGo to next message
gazzag
Messages: 908
Registered: November 2010
Location: Bristol, UK
Senior Member
Do your applications still work as expected?
Re: upgrade database [message #603319 is a reply to message #603316] Fri, 13 December 2013 05:17 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
What were the steps you took?

Did you install a complete new RDBMS and then exp and imp the data out of the old database into the new one?
Or did you upgrade the software and then upgraded the database (the data)?
Or ....?

If you do not tell us what exactly you did it's quite hard to say anything.
Re: upgrade database [message #603365 is a reply to message #603316] Sat, 14 December 2013 02:38 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
narang79 wrote on Fri, 13 December 2013 16:41
we have shifted data in new version
now after shifting what we have to chk my data is ok or not


Do you want to know how to do the data validation? Is it what you are asking for or something else?
Re: upgrade database [message #603370 is a reply to message #603365] Sat, 14 December 2013 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 25849
Registered: January 2009
Location: SoCal
Senior Member
>now we shift our database from 9.2.0.8 to 10.2.0.4
why upgrade from one obsoleted version to a different unsupported version?
Why not upgrade to a supported/current Oracle version?
Re: upgrade database [message #603380 is a reply to message #603370] Sat, 14 December 2013 11:39 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
BlackSwan wrote on Sat, 14 December 2013 20:30
>now we shift our database from 9.2.0.8 to 10.2.0.4
why upgrade from one obsoleted version to a different unsupported version?
Why not upgrade to a supported/current Oracle version?


@BlackSwan : Well, I don't agree with your statement. Because people asking such questions in this forum might not be the stake holder or owner of the DB or application. They might just be developers who are working like any other employee.
Upgrading from 10g to 11g with an enterprise edition licence is not a developer's decision. It is something which the management has to decide.
Re: upgrade database [message #603387 is a reply to message #603380] Sat, 14 December 2013 12:35 Go to previous message
BlackSwan
Messages: 25849
Registered: January 2009
Location: SoCal
Senior Member
Lalit Kumar B wrote on Sat, 14 December 2013 09:39
BlackSwan wrote on Sat, 14 December 2013 20:30
>now we shift our database from 9.2.0.8 to 10.2.0.4
why upgrade from one obsoleted version to a different unsupported version?
Why not upgrade to a supported/current Oracle version?


@BlackSwan : Well, I don't agree with your statement. Because people asking such questions in this forum might not be the stake holder or owner of the DB or application. They might just be developers who are working like any other employee.
Upgrading from 10g to 11g with an enterprise edition licence is not a developer's decision. It is something which the management has to decide.


>Well, I don't agree with your statement
I did NOT make any statement.
I asked two QUESTIONS!

>people asking such questions in this forum might not be the stake holder or owner of the DB or application.
Then again the OP might be stake holder or owner.
But the answers to my question are independent of the position of the poster; so I fail to understand why you interject position.
Previous Topic: Problems logging in as SYSDBA
Next Topic: XMLDB
Goto Forum:
  


Current Time: Sun Feb 18 21:34:50 CST 2018

Total time taken to generate the page: 0.01111 seconds