upgrade solaris from 9 to 10

upgrade solaris from 9 to 10 - Oracle issues?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yoram Ayalon - 26 Apr 2006 21:51 GMT

Hi,

We are planning to upgrade our Solaris box, running oracle 9.2.0.5,
from solaris 9 (5.9) to 10, this to take advantage of better TCP/IP
stack on Solaris 10 , and the Network trunking feature, multiplexing
network cards to same IP, which is non-standard in Solaris 9.

Our DB does not run in a cluster, and uses local disks only.

any issue we should be aware of? would all our system settings, like
disk, init and /etc/system remain unchanged? any estimate of down time?
I am assuming we would have to shut down oracle while running the
upgrade.

thanks!

Reply to this Message

hpuxrac - 26 Apr 2006 22:43 GMT

Don't you have to change away from /etc/system for solaris 10?

Certainly I would get a backup of the database and the software before
the upgrade and shutdown oracle.

Relink at least after the upgrade is complete.

Probably opening a tar with oracle is the best course of action along
with getting recommendations from people who have completed it already.

Reply to this Message

Yoram Ayalon - 26 Apr 2006 22:47 GMT

Don't you have to change away from /etc/system for solaris 10?
----------------------------------------
that's why I am asking! this might be significant change!

Relink at least after the upgrade is complete.
-----------------------------------
which relink are you refering to?

Probably opening a tar with oracle is the best course of action along
with getting recommendations from people who have completed it already
---------------------------------
well, I'm hoping to get someone who completed same upgrade

Reply to this Message

JEDIDIAH - 27 Apr 2006 05:14 GMT

> Don't you have to change away from /etc/system for solaris 10?
> ----------------------------------------
[quoted text clipped - 3 lines]
> -----------------------------------
> which relink are you refering to?

    Oracle has a nice long migration readme for this.

    For base case, it pretty much boils down to...

    reseting your oracle home to 10g
    starting up your database in upgrade mode
    creating your sysaux tablespace
    running catupgrd.sql

    Relinking is not required. I can't think of why you
would need to do this after migrating the database.

    Just make sure you adequately test your app with 10g
to ensure no issues with compatability to execution plan
changes.

> Probably opening a tar with oracle is the best course of action along
> with getting recommendations from people who have completed it already
> ---------------------------------
> well, I'm hoping to get someone who completed same upgrade

Signature

Apple: Because a large harddrive is for power users.
|||
/ | \

Reply to this Message

hpuxrac - 27 Apr 2006 13:20 GMT

Wake up please.

The OP is referring to upgrading solaris not upgrading the database.

Reply to this Message

NetComrade - 27 Apr 2006 18:57 GMT

>Don't you have to change away from /etc/system for solaris 10?
>----------------------------------------
[quoted text clipped - 3 lines]
>-----------------------------------
>which relink are you refering to?

as oracle user
$relink all

this might take advantage of Sol10 libraries/features (I think)

but as others have stated, backup DB and Oracle software directories
test on some other node if possible

>Probably opening a tar with oracle is the best course of action along
>with getting recommendations from people who have completed it already
>---------------------------------
>well, I'm hoping to get someone who completed same upgrade

.......
We run Oracle 9.2.0.6 on RH4 AMD
we are currently looking for a DBA
remove NSPAM to email

Reply to this Message

zebra64 - 28 Apr 2006 20:21 GMT

Hi,

we are running on Solaris10 Zones with Oracle 9.2.0.6 in one Zone and
the application tier of the Oracle E-Business Suite on the other.

Running very smooth since 2005,12 with no major or minor issues except
one - closing the application tier from the global zone stalls. The same
script goes ok if run from the application zone, not the global one.

Oracle support said it was an Solaris10 issue and we did not get it
solved anyway. We close the application tier from the application tier
zone instead.

Otherwise Zones are great. prstat -Z says what Zone is taking what
resources. If someone needs a server and the storage is at hand - a Zone
is created for him and he has its own virtual server.

Greetings
Remigiusz Boguszewicz

Reply to this Message