Re: Oracle on windows 2003 on vmware
- From: Andrey Kriushin <Andrey.Kriushin@xxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Thu, 04 Jan 2007 21:23:09 +0300
Now: Oracle on Linux. Linux on the hardware. 2 hops.
Then: Oracle on Linux. Linux on VMWare. VMWare on Win2003. Win2003 on
the hardware. 4 hops.
Right?
Perhaps the said kid wants to play with the OS stacking because his life
is too steady and quiet. Or he/she/it thinks that Oracle DBA's life is
too quiet and steady. Or both of them need some extreme urgently... :-) Ron?
In other words - where is an(-y) ADVANTAGE in the new schema? Except an
easy (?) movement to another VMWare server? Do they optimize the movements?
Looks like April the 1st joke, isn't it?
--Andrey
Niall Litchfield wrote:
Perhaps they just like OS's that have a large pool of experienced and
cheap administrators and not OS's that seem to generate a large pool
of expensive evangelists.
On 1/3/07, *Kerber, Andrew* <Andrew.Kerber@xxxxxxx
<mailto:Andrew.Kerber@xxxxxxx>> wrote:
Yeah, my advice is don't do it. Linux to Windows? Is this guy a
MS employee perhaps?
Andrew W. Kerber
Oracle DBA
UMB
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
*From:* oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx> [mailto:
oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx> ] *On Behalf Of *Ron Rogers
*Sent:* Wednesday, January 03, 2007 2:28 PM
*To:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
*Subject:* Oracle on windows 2003 on vmware
List,
Our corporate wiz kid has decided to migrate our Oracle 10g
database from Linux to Windows2003 on Vmware.
Are there any special setup instruction needed to make this work
properly? Any references that I might have missed? I searched the
OTN but did not find anything that jumped out at me.
Linux server. 1 CPU, 4 GIG ram, 3 internal mount points for data.
Oracle setup with 1.6 GIG SGA
Windows VMWARE server. 1 CPU, 4 GIG ram, 3 mount points on SAN(2
fiber channel 1 SATA) data. Oracle setup with 1.6 GIG SGA
Both servers have the same tables, partitions, and data loaded on
one mount point. In the Windows case it is the SATA SAN.
I set timing on.
I run the query select count(*) from a table that has 500,000,000
records and
Linux = 4 min, 24.83 seconds
Windows = 19 min,53.19 seconds
The results are proportionatly the same for the other tables that
have millions of records.
Is there any helpful hints that we might have missed when we set
up the VMWARE ESX server for windows/oracle?
When I google for VMWARE and Oracle the results are for Linux and
RAC not windows. Maybe they are trying to tell me something.
Any usefull suggestions?
Thanks,
Ron Rogers
DBA
Georgia Lottery Corp.
404-215-5072
------------------------------------------------------------------------
*
The information transmitted is intended solely for the individual
or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of or taking action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this email in error
please contact the sender and delete the material from any
computer.
*
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing,
retention, disclosure, distribution or forwarding of the message
or any attached file is not authorized and is strictly prohibited.
If you have received this electronic mail message in error, please
advise the sender by reply electronic mail immediately and
permanently delete the original transmission, any attachments and
any copies of this message from your computer system. Thank you.
==============================================================================
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
- References:
- RE: Oracle on windows 2003 on vmware
- From: Kerber, Andrew
- Re: Oracle on windows 2003 on vmware
- From: Niall Litchfield
Other related posts:
- » Oracle on windows 2003 on vmware
- » RE: Oracle on windows 2003 on vmware
- » RE: Oracle on windows 2003 on vmware
- » Re: Oracle on windows 2003 on vmware
- » RE: Oracle on windows 2003 on vmware
- » RE: Oracle on windows 2003 on vmware
- » Re: Oracle on windows 2003 on vmware
- » Re: Oracle on windows 2003 on vmware
- » Re: Oracle on windows 2003 on vmware
On 1/3/07, *Kerber, Andrew* <Andrew.Kerber@xxxxxxx <mailto:Andrew.Kerber@xxxxxxx>> wrote:
Yeah, my advice is don't do it. Linux to Windows? Is this guy a
MS employee perhaps?
Andrew W. Kerber
Oracle DBA
UMB
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
*From:* oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx> [mailto:
oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx> ] *On Behalf Of *Ron Rogers
*Sent:* Wednesday, January 03, 2007 2:28 PM
*To:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
*Subject:* Oracle on windows 2003 on vmware
List,
Our corporate wiz kid has decided to migrate our Oracle 10g
database from Linux to Windows2003 on Vmware.
Are there any special setup instruction needed to make this work
properly? Any references that I might have missed? I searched the
OTN but did not find anything that jumped out at me.
Linux server. 1 CPU, 4 GIG ram, 3 internal mount points for data.
Oracle setup with 1.6 GIG SGA
Windows VMWARE server. 1 CPU, 4 GIG ram, 3 mount points on SAN(2
fiber channel 1 SATA) data. Oracle setup with 1.6 GIG SGA
Both servers have the same tables, partitions, and data loaded on
one mount point. In the Windows case it is the SATA SAN.
I set timing on.
I run the query select count(*) from a table that has 500,000,000
records and
Linux = 4 min, 24.83 seconds
Windows = 19 min,53.19 seconds
The results are proportionatly the same for the other tables that
have millions of records.
Is there any helpful hints that we might have missed when we set
up the VMWARE ESX server for windows/oracle?
When I google for VMWARE and Oracle the results are for Linux and
RAC not windows. Maybe they are trying to tell me something.
Any usefull suggestions?
Thanks,
Ron Rogers
DBA
Georgia Lottery Corp.
404-215-5072
------------------------------------------------------------------------
*
The information transmitted is intended solely for the individual
or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of or taking action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this email in error
please contact the sender and delete the material from any
computer.
*
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing,
retention, disclosure, distribution or forwarding of the message
or any attached file is not authorized and is strictly prohibited.
If you have received this electronic mail message in error, please
advise the sender by reply electronic mail immediately and
permanently delete the original transmission, any attachments and
any copies of this message from your computer system. Thank you.
==============================================================================
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
- RE: Oracle on windows 2003 on vmware
- From: Kerber, Andrew
- Re: Oracle on windows 2003 on vmware
- From: Niall Litchfield