Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / April 2008

Tip: Looking for answers? Try searching our database.

Moving and upgrading DB at the same time

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick Denoire - 27 Apr 2008 23:35 GMT
In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv.
Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux
Ent. Ed. V 4 64 bit) I will move all files of the shut down DB to a
new server where the target version of Oracle is istalled and take
care that datafile paths on the new server are the same as on the old
one (no need to rename anything in the controlfile of the cold copy).

Since on the new server only the new Version of Oracle is installed,
the only thing I can do is just upgrade the DB copy without being able
to open it in order to check that everything is all right.

May I assume that there won't be any platform related issues?
I just don't know if this switch is considered a platform change.
After all, both Linux boxes are rather different versions of Redhat
(running on Intel hardware).

Even if there is no platform issue, which are going to be the pits and
falls?

I would like to avoid exp/imp because for a schemawise transfer I
would need to precreate users with all privileges, tablespaces, etc.
Full exp/imp is not adequate when going to a different version of
Oracle.

Thanks in advance

Rick Denoire
Carlos - 28 Apr 2008 08:19 GMT
> In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv.
> Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux
[quoted text clipped - 23 lines]
>
> Rick Denoire

I think RMAN is your friend here.

Cheers.

Carlos.
joel garry - 28 Apr 2008 20:27 GMT
> In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv.
> Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux
[quoted text clipped - 23 lines]
>
> Rick Denoire

See metalink Note:62290.1

exp/imp is adequate for me, but YMMV.

jg
--
@home.com is bogus.
“I thought that was a dumb thing to say.  My brain couldn't register
that it was real.” Diana Noble of San Marcos was swimming 10 to 20
feet behind David Martin when she heard someone yell, “Shark!”   They
were part of a group of triathletes training, when a Great White bit
through both Martin's legs, leaving a massive pool of blood.  First
person to die from a shark attack in the area for 50 years.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.