Hi,

We have at my workplace a 1 terabyte Oracle 9i database.
It is currently running on a "big" solaris machine with 30Gb memory,
and 20 processors.


This setup is obviously not very flexible for testing purposes, and
we'd like to virtualize this environment, maybe with vmware.

Would anyone have any experience with that?
What do you think are the minimum requirement for a 1 terabyte
database?


Thanks for your advices !

nicolas.rolland@gmail.com wrote:
> Hi,
>
> We have at my workplace a 1 terabyte Oracle 9i database.
> It is currently running on a "big" solaris machine with 30Gb memory,
> and 20 processors.
>
>
> This setup is obviously not very flexible for testing purposes, and
> we'd like to virtualize this environment, maybe with vmware.
>
> Would anyone have any experience with that?
> What do you think are the minimum requirement for a 1 terabyte
> database?
>
>
> Thanks for your advices !

Why not move toward RAC. Likely a decent cluster would cost less than
just the maintenance agreement on that monster.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

nicolas.rolland@gmail.com wrote:
> Hi,
>
> We have at my workplace a 1 terabyte Oracle 9i database.
> It is currently running on a "big" solaris machine with 30Gb memory,
> and 20 processors.
>
>
> This setup is obviously not very flexible for testing purposes, and
> we'd like to virtualize this environment, maybe with vmware.
>
> Would anyone have any experience with that?
> What do you think are the minimum requirement for a 1 terabyte
> database?
>
>
> Thanks for your advices !

Nicolas, I've done some VMware stuff with Oracle, but nothing along
your scale (not even without VMware!).

Somebody should correct me if I'm wrong, but I believe you can now
create ESX Server virtual machines with up to 4GB of memory - once
again, just from memory. We do nothing close to that where I work.

There are other facilities for giving VMs direct access to physical
disk - once again, something we just don't do where I'm at so somebody
please correct me if I'm wrong.

I think your best bet would be to contact VMware and/or hit their site
at http://www.vmware.com. Something tells me they'de love to help you
out on that one.

Charles R. Whealton
Charles Whealton @ pleasedontspam.com

nicolas.rolland@gmail.com wrote:
> Hi,
>
> We have at my workplace a 1 terabyte Oracle 9i database.
> It is currently running on a "big" solaris machine with 30Gb memory,
> and 20 processors.
>
>
> This setup is obviously not very flexible for testing purposes, and
> we'd like to virtualize this environment, maybe with vmware.
>
> Would anyone have any experience with that?
> What do you think are the minimum requirement for a 1 terabyte
> database?
>
>
> Thanks for your advices !

Nicolas, you are saying that you'de like to create a SECOND, (this
time) virtualized environment for testing, right?

Charles R. Whealton
Charles Whealton @ pleasedontspam.com

nicolas.rolland@gmail.com wrote:
> Hi,
>
> We have at my workplace a 1 terabyte Oracle 9i database.
> It is currently running on a "big" solaris machine with 30Gb memory,
> and 20 processors.
>
>
> This setup is obviously not very flexible for testing purposes, and
> we'd like to virtualize this environment, maybe with vmware.
>
> Would anyone have any experience with that?
> What do you think are the minimum requirement for a 1 terabyte
> database?
>
>
> Thanks for your advices !
>

Running Oracle in a VM was recently discussed in this forum. Please
follow this link to see what was previously written:

http://groups.google.com/group/comp....5a97f86ce648f7

The minimum requirement for a 1TB database can vary widely. It depends
on your data access patterns from the application and/or users.

Since you are running Solaris, have you looked into partitioning the OS?
To me, that would be a better option than running a VM on the server.


HTH,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Exact replca of THAT env in VM ???
I would be very surprised if that's at all possible.

Just go to their discussion forum, pick their highest-end product and
they'll tell you straight out if that';s possible.

Hello,

Thank you all for your responses.

The primary problem is that our "test" environment is down 95% of the
time, because of cross usage for maintenance, patch, tests etc.

So ideally having a second (3rd, nth..) virtualized environment for
testing would be the ideal solution as it would help each division to
test their feature without interfering with each others.

Obviously I don't hope to have a perfect replica of such a machine, but
I wonder how easy it is to strip down the hardware to a point which is
virtualisation-capable.

I must say I have no idea on what it takes to serve a 1 Terabyte Oracle
database....


N


Chuck Whealton wrote:
> nicolas.rolland@gmail.com wrote:
> > Hi,
> >
> > We have at my workplace a 1 terabyte Oracle 9i database.
> > It is currently running on a "big" solaris machine with 30Gb memory,
> > and 20 processors.
> >
> >
> > This setup is obviously not very flexible for testing purposes, and
> > we'd like to virtualize this environment, maybe with vmware.
> >
> > Would anyone have any experience with that?
> > What do you think are the minimum requirement for a 1 terabyte
> > database?
> >
> >
> > Thanks for your advices !
>
> Nicolas, you are saying that you'de like to create a SECOND, (this
> time) virtualized environment for testing, right?
>
> Charles R. Whealton
> Charles Whealton @ pleasedontspam.com

nicolas.rolland@gmail.com wrote:
> Hello,
>
> Thank you all for your responses.
>
> The primary problem is that our "test" environment is down 95% of the
> time, because of cross usage for maintenance, patch, tests etc.
>
> So ideally having a second (3rd, nth..) virtualized environment for
> testing would be the ideal solution as it would help each division to
> test their feature without interfering with each others.
>
> Obviously I don't hope to have a perfect replica of such a machine, but
> I wonder how easy it is to strip down the hardware to a point which is
> virtualisation-capable.
>
> I must say I have no idea on what it takes to serve a 1 Terabyte Oracle
> database....
>
>
> N

Please do not top post. Scroll to the bottom to reply.

What it takes to host a 1TB Oracle database is a minimum of 1.002 TB
of disk space. All other considerations are dependant upon what you
choose to do with it after it is opened.

I know virtualization is the cool word of the day ... like XML was
yesterday and Java was last year. But there is no advantage I can
think of and several disadvantages to doing what you propose.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

DA Morgan wrote:
> I know virtualization is the cool word of the day ... like XML was
> yesterday and Java was last year. But there is no advantage I can
> think of and several disadvantages to doing what you propose.
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group

Testing database upgrades are one reason. Virtualization can be a good
solution, especially for a test environment.

Regards,

Steve

Steve Howard wrote:
> DA Morgan wrote:
>> I know virtualization is the cool word of the day ... like XML was
>> yesterday and Java was last year. But there is no advantage I can
>> think of and several disadvantages to doing what you propose.
>> --
>> Daniel Morgan
>> University of Washington
>> Puget Sound Oracle Users Group
>
> Testing database upgrades are one reason. Virtualization can be a good
> solution, especially for a test environment.
>
> Regards,
>
> Steve

And what can it do that having a second instance on the same
machine does not allow?

And I might add ... in an Oracle supported environment.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group