Installing 9i and 8i into some ORACLE_BASE

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 7 Aug 2003 13:54:25 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7040B4258@lnewton.leeds.lfs.co.uk>

If you means doing something like :

login to the 8i user on the sever
exp username/password_at_ALIAS owner=etc etc

where ALIAS is a 920 database then you might have problems.

There is a bug which stops 817 exp exporting from a 920 database (at least when exporting on an HP box using 817 from a 920 database on HP or on Windows !). The fix is to upgrade 920 to 9204 whereupon it 'just works'. The workaround is to use 8.0 exp to export form the 920 database - that 'just works'.

You don't need to run the 8i catexp on the 9i database by the way, it just works when the 9i catexp has been run. (At least, I didn't need to). (Same for using 8.0 exp, the 9i database doesn't need the 8.0 catexp to be run.)

The above refers to 64 bit Oracle 920 running on 64 bit HPux 11.00 by the way. The 817 is also 64 bit on 64 bit. Windows - well, that's something else altogether.

Cheers,
Norman.

-----Original Message-----
From: Chuck [mailto:chuckh_at_softhome.net] Posted At: Thursday, August 07, 2003 1:29 PM Posted To: server
Conversation: Installing 9i and 8i into some ORACLE_BASE Subject: Re: Installing 9i and 8i into some ORACLE_BASE

Dave Hau <davehau_nospam_123_at_nospam_netscape.net> wrote in news:3F31A1D1.2090509_at_nospam_netscape.net:

> Chuck wrote:
>> Big Chuck <ccarson_at_echeeba.com> wrote in news:3f2fb312$1_1_at_corp-
>> news.newsgroups.com:
>> 
>> 

>>>I am running on Solaris 8 64-bit.
>>>
>>>I currently have Oracle 9.2.0.3 64-bit installed with the following:
>>>
>>>ORACLE_BASE=/u01/app/oracle
>>>ORACLE_HOME=$ORACLE_BASE/product/9.2.0.3
>>>
>>>I also need the 8.1.7 client on this machine as well. Is there any
>>>danger with installed it as so:
>>>
>>>ORACLE_BASE=/u01/app/oracle
>>>ORACLE_HOME=$ORACLE_BASE/product/8.1.7
>>>
>>>
>>>Thanks,
>>>CC
>>>
>>>

>> 
>> 
>> Why do you need the 8.1.7 client? The 9.2 client should be able to 
>> connect to any database that 8.1.7 can.
> 
> 
> To export the 9i database to a 8i server somewhere else.
> 
> Cheers,
> Dave
> 
> 

Just use the 8i client on the "somewhere else" server. That would require
more than just using an 8i export utility though. You'd need to run the 8i catexp.sql script to make sure exp sees the views it expects to see in
the 9i database. Received on Thu Aug 07 2003 - 07:54:25 CDT