Re: Oracle in Solaris E3000/420R vs. Intel

But, you can do a full export of the data ( Choose GRANTS=N to avoid having to create all the users in the new database - see later part of response ) from the Sun , create a new database on the Intel box, duplicating the tablespace names ( and, optionally the users - at least the exporter's user - see previous part of comment ) ...this will give you an Oracle instance of with the data from the Sun, but, if you want to test performance, for instance, the dissimilarities between the OSs will introduce a lot of 'guesstimates' instead of facts.. A test of the upgrade will reveal whether you have used code ( in procs or functions for example ) that is no longer supported -- I do not think there was too much of that ( I have moved from 7.3.4 to 8.0.x to 8.1.6 to 8.1.7 in the Intel world with no big issues) - that will not differ between intel and Sun - ( If you have shell scripts for administering the Sun database, you will need to examine them closely and read the Release Notes from Oracle to see if there are changes needed..also check to see if any patches to 2.7 or 8 are needed to run 8.1.7( There usually are some, depending on the exact version of 2.7 or 8 you have))

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"JK Yao" <jkyf0131_at_hotmail.com> wrote in message
>news:93f65984.0106211952.59849cf3_at_posting.google.com...
>> dear all,
>>
>> Our company is plannign to upgrade our Oracle database from 7.3.4 to
>> 8.1.6 in Sun altra Enterprise 420R and E3000 with OS- Solaris2.7. I
>> am planning to copy our database to an Intel personal computer to do
>> the testing first. Anyone know if the Oracle database move from Sun
>> to Intel will have any problem? If I test the upgrading successful in
>> Intel, doesn't that also mean I can do it on Sun 420R/E3000.
>>
>> Another questions. Now our OS is Sun Solaris2.7, if I test the
>> database upgrade in Solaris8. Will that make any different?
>>
>> Please clarify. Thanks a lot.
>>
>> JK
>> Jr. DBA, ModusMedia International Inc.
>> ICQ: 118658328
>
>
>The copy to Intel won't work, as the filesystems are not compatible.
>
>Regards,
>
>Sybrand Bakker, Oracle DBA
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jun 22 2001 - 09:24:14 CDT