Upgrade oracle database while keep the old version 2

[uconn1981]

Hi,

I have oracle 8.1.7 and want to upgrade to 9.2. Can I install the oracle 9.2 on a different directory and do the upgrade while keep the 8.1.7 running? When later everything is checked to be ok, then switch to oracle 9.2.

Thanks,

Tim

 

[SantaMufasa]

Absolutely. I have as many as four different versions of Oracle running on the same machine.

The way I do this is do not upgrade the existing software; install a completely new version in another Oracle Home. My OFA-compliant Oracle Homes for two different versions are:

/dbsrv/oracle/app/oracle/product/8.1.7
/dbsrv/oracle/app/oracle/product/9.2

I also create a new database for the new (9.2 in your case) installation. Then I export(from 8.1.7)/import(to 9.2) so that I always have an instantaneous fall-back contingency if I need it.

Let us know what you end up doing.


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com:

Providing remote Database Administration and support services

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[alexhu]

Can I install the oracle 9.2 on a different directory and do the upgrade while keep the 8.1.7 running?

Just to be clear on this....

Yes you can install the new version in a different directory as Dave has said.

You cannot do the upgrade unless you have another copy of your database to do this on.

Alex

 

[uconn1981]

Thank you guys. Your replies really clear my thoughts. I will try to do as you guys suggested: installing multiple oracle software. If I take the oracle 8.1.7 offline and use Upgrade Assistant upgrade to 9.2 in another oracle home, do I still need the copy of my database? If not, after upgrade, will the oracle 8.1.7 still be there?

Tim

 

[alexhu]

I think you are trying to do this ...(correct me if I'm wrong)

You have an 8.1.7 database

You want to upgrade to 9.2

But, if 9.2 proves to be not OK, you want to switch back to the 8.1.7 version

The easiest way to do this is

Create a copy of your 8.1.7 database - shutdown the original

Install the 9.2 version software

Upgrade the copy database to 9.2

If the new database does not work out, shut it down and startup your original 8.1.7

Make sense ?

Alex

 

[uconn1981]

Alex, you are absolutely right. I have one last question if you do not mind:
When you say "copy", do you mean using "export" or something else? Could I use DBUA here?

Thanks,

Tim

 

[alexhu]

When I say copy - I mean physically copy the files and rename the database (if required)

You can do it with export if you like.

I don't use DBUA, so no comment

Alex