|
Home > Archive > Unix True 64 > March 2004 > UNIX upgrade for Oracle
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
UNIX upgrade for Oracle
|
|
|
| UNIX Upgrade Question
We have Oracle 8.0.5 Running on a Digital Compaq Alpha Server 8400
under Digital UNIX 4.0e.
We plan on migrating our DB from 8.0 to 9i (9.2).
What version of Oracle 9i would we need for the upgrade and would we
need to upgrade from the UNIX 4.0e OS in order to install 9i?
Also,
If a new version of UNIX is required, would it be better to move to
HP-UX.
Thanks
Stan
| |
| Max Zinal 2004-03-12, 2:36 pm |
| stan wrote:
> We have Oracle 8.0.5 Running on a Digital Compaq Alpha Server 8400
> under Digital UNIX 4.0e.
>
Oh, those old nice 8400s...
> We plan on migrating our DB from 8.0 to 9i (9.2).
>
AFAIK you will have to replace your hardware.
Oracle 9i will not run on EV5 CPUs which are likely to be installed in
your server.
> What version of Oracle 9i would we need for the upgrade and would we
> need to upgrade from the UNIX 4.0e OS in order to install 9i?
>
You will have to move on something more modern. On Alphas, Tru64 5.1B
would be a correct choice. I don't think you would like an idea to
become a VMS man  .
> Also,
> If a new version of UNIX is required, would it be better to move to
> HP-UX.
>
It's really hard to get a good answer for this question because "better"
or "worse" cannot be measured and are really subjective. I suppose it
would be more easy to upgrade your OS to a newer version than to replace
it with a completely different OS. But it depends very much on your
applications and configuration you are currently using.
IMHO Alpha-based servers can give you a better perfomance in comprasion
to PA-RISC-based ones with similiar price ranges. If you are really
thinking about a global switch, perhaps you should look at servers
by Sun and IBM - ORACLE will run nicely there. Or maybe even try
something like multiprocessor Xeon box - if your perfomance
requirements are not too high.
| |
|
| i have and alphaserver 8400 with 8 cpu at 633 and i can install oracle 9i.
"Max Zinal" <Zlat0@mail.ru> wrote in message
news:1079118372.845795@smtp.tvcom.ru...
> stan wrote:
>
> Oh, those old nice 8400s...
>
>
> AFAIK you will have to replace your hardware.
> Oracle 9i will not run on EV5 CPUs which are likely to be installed in
> your server.
>
>
> You will have to move on something more modern. On Alphas, Tru64 5.1B
> would be a correct choice. I don't think you would like an idea to
> become a VMS man .
>
>
> It's really hard to get a good answer for this question because "better"
> or "worse" cannot be measured and are really subjective. I suppose it
> would be more easy to upgrade your OS to a newer version than to replace
> it with a completely different OS. But it depends very much on your
> applications and configuration you are currently using.
>
> IMHO Alpha-based servers can give you a better perfomance in comprasion
> to PA-RISC-based ones with similiar price ranges. If you are really
> thinking about a global switch, perhaps you should look at servers
> by Sun and IBM - ORACLE will run nicely there. Or maybe even try
> something like multiprocessor Xeon box - if your perfomance
> requirements are not too high.
| |
| Max Zinal 2004-03-15, 12:36 pm |
| cesar wrote:
> i have and alphaserver 8400 with 8 cpu at 633 and i can install oracle 9i.
Could you please tell me the exact ORACLE version you are running,
your CPU model and `uname -a` result? I am highly interested in
upgrading to ORACLE 9i, but our hardware (yes, 8-CPU AlphaServer 8400)
doesn't seem to be supported.
| |
|
| Max Zinal <Zlat0@mail.ru> wrote in message news:<1079118372.845795@smtp.tvcom.ru>...
> stan wrote:
>
> Oh, those old nice 8400s...
>
>
> AFAIK you will have to replace your hardware.
> Oracle 9i will not run on EV5 CPUs which are likely to be installed in
> your server.
I am not sure if we have the EV5 CPUs.
Our UNIX administrator says we have the 5/625's (2 CPUs)
>
>
> You will have to move on something more modern. On Alphas, Tru64 5.1B
> would be a correct choice. I don't think you would like an idea to
> become a VMS man .
>
>
> It's really hard to get a good answer for this question because "better"
> or "worse" cannot be measured and are really subjective. I suppose it
> would be more easy to upgrade your OS to a newer version than to replace
> it with a completely different OS. But it depends very much on your
> applications and configuration you are currently using.
>
> IMHO Alpha-based servers can give you a better perfomance in comprasion
> to PA-RISC-based ones with similiar price ranges. If you are really
> thinking about a global switch, perhaps you should look at servers
> by Sun and IBM - ORACLE will run nicely there. Or maybe even try
> something like multiprocessor Xeon box - if your perfomance
> requirements are not too high.
Or is windows not the best solution?
The reason we are thinking windows is that the target sites are
migrating their other applications to Windows and would like to stay
with that OS.
| |
|
| psrinfo -v
Status of processor 0 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 1 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 2 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 3 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 4 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 5 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 6 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
Status of processor 7 as of: 03/15/04 22:30:54
Processor has been on-line since 02/26/2004 18:05:53
The alpha EV5.6 (21164A) processor operates at 613 MHz,
has a cache size of 4194304 bytes,
and has an alpha internal floating point processor.
_root_/> uname -a
OSF1 xxxxx V5.1 2650 alpha
xxxxx_root_/> su - oracle
xxxxxx> sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 15 22:31:14 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name:
best regards.
"Max Zinal" <Zlat0@mail.ru> wrote in message
news:1079370525.858622@smtp.tvcom.ru...
> cesar wrote:
9i.[color=darkred]
>
> Could you please tell me the exact ORACLE version you are running,
> your CPU model and `uname -a` result? I am highly interested in
> upgrading to ORACLE 9i, but our hardware (yes, 8-CPU AlphaServer 8400)
> doesn't seem to be supported.
| |
|
| "cesar" <adfadf@adfaf.com> wrote in message news:<c357e6$o5v$1@nsnmrro2-gest.nuria.telefonica-data.net>...[color=darkred]
> psrinfo -v
> Status of processor 0 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 1 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 2 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 3 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 4 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 5 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 6 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> Status of processor 7 as of: 03/15/04 22:30:54
> Processor has been on-line since 02/26/2004 18:05:53
> The alpha EV5.6 (21164A) processor operates at 613 MHz,
> has a cache size of 4194304 bytes,
> and has an alpha internal floating point processor.
>
> _root_/> uname -a
> OSF1 xxxxx V5.1 2650 alpha
> xxxxx_root_/> su - oracle
> xxxxxx> sqlplus
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 15 22:31:14 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter user-name:
>
>
> best regards.
>
>
>
> "Max Zinal" <Zlat0@mail.ru> wrote in message
> news:1079370525.858622@smtp.tvcom.ru...
> 9i.
I guess Max and I are looking at doing something similar...
Our 8400 system shows…
# psrinfo -v
Status of processor 0 as of: 03/16/04 07:52:12
Processor has been on-line since 03/11/2004 14:42:35
The alpha EV5.6 (21164A) processor operates at 613 MHz,
and has an alpha internal floating point processor.
Status of processor 1 as of: 03/16/04 07:52:12
Processor has been on-line since 03/11/2004 14:42:35
The alpha EV5.6 (21164A) processor operates at 613 MHz,
and has an alpha internal floating point processor.
# uname -a
OSF1 xxxxxx V4.0 1091 alpha
Cesar,
What type of storage are you using for your database?
We have a StorageWorks RAID Array 7000 (18) 9.1 GB 10000 RPM Disks.
The current Data TS is mirrored and stripped across 3 drives. It is
about at 45% capacity. This seems to be optimal for our current DB
running under Oracle8. We have not changed the size since our last
upgrade in June 2000.
I guess the question is, if we upgrade the UNIX OS to Tru64 5.1b ..
Can we use the current hardware or do we have to upgrade the
processors, RAID, memory, controllers, etc?
Or for an OS, is MS Windows a solution on a Dell Server?
The reason we are thinking windows is that the target sites are
migrating their applications to Windows and would like to stay on
windows.
However, I have heard that MS Windows (Server / Advanced Server 2000)
is not the best OS platform to run Oracle on.
| |
| Max Zinal 2004-03-16, 12:35 pm |
| stan wrote:
> I am not sure if we have the EV5 CPUs.
> Our UNIX administrator says we have the 5/625's (2 CPUs)
>
You have EV5.6, it's a better thing then 'pure' EV5. Quite old, though.
> Or is windows not the best solution?
> The reason we are thinking windows is that the target sites are
> migrating their other applications to Windows and would like to stay
> with that OS.
As usual - it depends . Not a great platform at all, although it will
work just fine if you don't need the 'holy five nines'. I don't trust
MS when they tell they can get it.
|
|
|
|
|