VMware Communities : Unanswered Threads - Virtualizing Oracle

Convert OVM image to VMWare Image

cunyzng — Mon, 09 Nov 2009 19:54:01 GMT

Hi, I wonder if there is any easy way to convert an Oracle VM image to a VMWare server image? Any help is greatly appreciated!

Application with Oracle 9i doesn't work after migrate from esx 3.0.1 to 3.5 update 4

dokfvd1 — Wed, 04 Nov 2009 14:03:55 GMT

Hi there,

We've got at the company 2 Esx clusters. The first cluster is a ESX 3.0.1 cluster (build-34176), the otherone is a ESX 3.5 update 4 cluster.

We've got a virtual machine with windows 2003 standard edition with a oracle 9i database. The application is also running on this virtual machine.

Last week ik migrated the virtual machine from the esx 3.0.1 version to the esx 3.5 version. (remove from inventory -> add to inventory). We also updated the vmware tools to the latest version (build 184236).

If we want to start the application it isn't possible on the esx 3.5 cluster. If i do a remove from inventory and add the virtual machine to the 3.0.1 cluster, the application is running again. ((this had been done with the latest vmware tools (build 184236).

I've chat with the company but the don't give official support on the application on vmware.

The hardware from the 3.0.1 and 3.5 are the same.

Has someone an idea? I heard something that it can come because tcp/ip ports aren't open.

note: the dutch version is writte here: http://www.vmug.nl/modules.php?name=Forums&file=viewtopic&t=4410

greets Frans

Oracle Runaway Process Consumes All vCPUs

TimothyGaray — Wed, 28 Oct 2009 13:28:21 GMT

A question was posed to us by our DBAs in regards to Oracle 10g running in a VM.

When the server was physical, if one Oracle process took off, it did not chew up all available computing resources - just the CPU that the particular process was running on.

Now that the server is virtual, if an Oracle process takes off, it chews up both vCPUs doing whatever.

We were considering giving it 4 vCPUs but their concern is that if someone submits a huge query then it will just consume 4 vCPUs at 100%.

Does anyone have any thoughts or experience with this? I'm not very familiar with Oracle.

Thanks!

-Tim

java.sql.SQLException: I/O Error: Connection reset

ricochang — Tue, 29 Sep 2009 00:54:04 GMT

Dear all,

It's still a POC phase to validate virtulized Oracle DB server in ESX environment. We got the below error frequently:

{MSSQLAdapter:loadValue error : I/O Error: Connection reset
java.sql.SQLException: I/O Error: Connection reset
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:)

{Can't check data ... : ART00011115632929364
java.sql.SQLException: I/O Error: Connection reset
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:)

Any comments will be appreciated.

Best Regards,

Rico

Another RAC 10g shared disks on VMware problem (haven't found such a case)

Funky — Fri, 19 Jun 2009 03:06:20 GMT

Hi!

I have tried on Oracle forums but AFAIK all say this is pure VMware problem so now I'm comming here in a hope to get rid of big problem.

RAC 10.2, on RHEL 5.3 EE, in VmWare server 2.01 on Windows 2003 server EE. I'm trying to avoid
deprecated RHEL 4.X raw devices service and to test ASMLib for DB instance. I have two nedes.

Problem is that Oracle use clufvy to test sharednes of disks and this (in my case returns PARTIALY bad results). Here is brief explanation of the situation:

oracle@ishacrac2x ~$ ls -l /dev/sd*
brw-r----- 1 root disk 8, 0 Jun 15 2009 /dev/sda
brw-r----- 1 root disk 8, 1 Jun 14 22:16 /dev/sda1
brw-r----- 1 root disk 8, 2 Jun 15 2009 /dev/sda2
brw-rw---- 1 oracle dba 8, 16 Jun 15 2009 /dev/sdb
brw------- 1 oracle dba 8, 17 Jun 14 22:16 /dev/sdb1
brw-rw---- 1 oracle dba 8, 32 Jun 15 2009 /dev/sdc
brw------- 1 oracle dba 8, 33 Jun 14 22:16 /dev/sdc1
brw-rw---- 1 oracle dba 8, 48 Jun 15 2009 /dev/sdd
brw------- 1 oracle dba 8, 49 Jun 14 22:16 /dev/sdd1
brw-rw---- 1 oracle dba 8, 64 Jun 15 2009 /dev/sde
brw------- 1 oracle dba 8, 65 Jun 14 22:16 /dev/sde1

root@ishacrac2x ~# fdisk -l

Disk /dev/sda: 6442 MB, 6442450944 bytes
255 heads, 63 sectors/track, 783 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 652 5237158+ 83 Linux
/dev/sda2 653 783 1052257+ 82 Linux swap / Solaris

Disk /dev/sdb: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 522 4192933+ 83 Linux

Disk /dev/sdc: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 522 4192933+ 83 Linux

Disk /dev/sdd: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdd1 1 5221 41937651 83 Linux

Disk /dev/sde: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sde1 1 5221 41937651 83 Linux

Lets make some check from Oracle point of view (one node at a time):

oracle@ishacrac2x ~$ export MYNODES=ishacrac1x
oracle@ishacrac2x ~$ export MYSHARED=/dev/sdb1,/dev/sdc1,/dev/sdd1,/dev/sde1
oracle@ishacrac2x ~$ /u01/install/clusterware/cluvfy/runcluvfy.sh comp ssa -n $MYNODES -s $MYSHARED
Verifying shared storage accessibility

Checking shared storage accessibility...

"/dev/sdb1" is shared.
"/dev/sdc1" is shared.
"/dev/sdd1" is shared.
"/dev/sde1" is shared.

Shared storage check was successful on nodes "ishacrac1x".

Checkin on node 2 node 2:
oracle@ishacrac2x ~$ export MYNODES=ishacrac2x
oracle@ishacrac2x ~$ /u01/install/clusterware/cluvfy/runcluvfy.sh comp ssa -n $MYNODES -s $MYSHARED
Verifying shared storage accessibility

Checking shared storage accessibility...
"/dev/sdb1" is shared.
"/dev/sdc1" is shared.
"/dev/sdd1" is shared.
"/dev/sde1" is shared.

Shared storage check was successful on nodes "ishacrac2x".

Verification of shared storage accessibility was successful.

All looks good, bu when you ty to check them together then verification failed:

oracle@ishacrac2x ~$ export MYNODES=*ishacrac2x,ishacrac1x*
oracle@ishacrac2x ~$ /u01/install/clusterware/cluvfy/runcluvfy.sh comp ssa -n $MYNODES -s $MYSHARED

Verifying shared storage accessibility
Checking shared storage accessibility...

ERROR: /dev/sdb1
Unable to determine the sharedness of /dev/sdb on nodes:
ishacrac2x,ishacrac1x

ERROR: /dev/sdc1
Unable to determine the sharedness of /dev/sdc on nodes:
ishacrac2x,ishacrac1x

ERROR: /dev/sdd1
Unable to determine the sharedness of /dev/sdd on nodes:
ishacrac2x,ishacrac1x

ERROR: /dev/sde1
Unable to determine the sharedness of /dev/sde on nodes:
ishacrac2x,ishacrac1x

Shared storage check failed on nodes "ishacrac2x,ishacrac1x".
Verification of shared storage accessibility was unsuccessful on all the nodes.

This all leads me to installer rerror shown on picture http://i44.tinypic.com/22zs7n.jpg.

I try to make a workaround and to install one node (in clusterware) and then another using addNode.sh AND THIS WORKED!

VOW!!!Clesterware is up and ruining without problems! sdb1 is for CRS and sdc1 is for voting disk-all fine! So far so good but not for a long time.

But then when I come to install ASM instance, I got the same problem Oracle doesn't see the shared disks (where spfile should be placed and seen by all ASM instances). The best fact is that Oracle doesn't see shared disks REGARDLESS fact that clusterware is up and running on sdb1 and sdc1 as shared disk for that very same cluster!!!

Obviously the way Oracle test this is "courios" and need some other part for success, regardless it doesn't measure the real situation.

Now I'm really tired of making one simple installation in several weeks terms.. so kindly ask what parameter in VMware can I established to anounce Oracle that I really have shared disks in my system? Any help comment ...anything...

THX,

Funky

problem in copying the virtual machine to create 2nd virtual

shomilb — Wed, 22 Apr 2009 22:27:14 GMT

Hi,

I am trying to install 10grac on Oracle Linux 5 on VMware workstation
6.5

I am facing
a problem in copying the virtual machine to create second virtaul machine (rac-2
node)

I copy all the files from rac-1 folder
to rac-2 folder, after shutting down the first machine.

I change the name
of my second virtual machine to rac-2.

I do all the n/w configuration and
change the hostname to rac2.

After this I shut down my second
machine.

Now if I start the first machine the hostname changes to rac2
(instead of rac1) and all the network settings also changes to what i had made
for second machine.

As such I am not able to
create two machine.

thanks
shomil

setting up my san for use with oracle 10g

Ranger.rkm — Wed, 22 Apr 2009 15:57:12 GMT

Hello,

I would like some help from people that are already running Oracle on vmware.

I'm currently in the process of setup my san. I have all of my other server already planned ou, but they are not as IO needy as a database server.

So if you can please help me with my san design, or provide me with lessons learned from your deployment.

Thanks,

-Mike

How to deal with Oracles Support stance for VMWare

Rkelly — Wed, 11 Mar 2009 20:00:28 GMT

Get a special arrangement with your company and Oracle. Bet you did not know that Oracle was doing this, but they are.
Switch to MS SQL or MYSQL Server and drop Oracle completly
Give Oracle an Ultamatim that your company will begin to reduce it's orders and renewalls until it is fully supported.
Run it anyway, we all know it works fine, and get support from VMWare directly.

Anymore ideas? Let's work together to pressure Oracle to stop this unfair business practice.

Virtualize Microsoft - Oracle

ROBUS — Wed, 07 Jan 2009 13:44:44 GMT

Dear all

I'm writing this thread to post some of our problems virtualizing Microsoft virtual machines with Oracle Databases.

The virtual machine was created with Windows 2003 Server R2 and 8GB RAM 4 Processori, the oracle installato software installed is
Oracle Application Server Ver. 10.1.3.1.0

we made 2 test see below :

In the first test (start), the default is as follows:
1. Start Windows Server, the paging file and 'equal to 138MB
2. Start Oracle application server (two containers OC4J 1GB each) the allocation of the paging file is as follows: 7.52 GB
3rd Physical memory equal to 1.76 GB
Under these conditions, the virtual servers, consumes 80% of
physical memory, leaving only 1.76 GB of memory, making the virtual
machine slower.

Consider that the value you get the service started with the Oracle OC4J Instances 2.
In the second test (shutdown), then the default is as follows:
Stop Oracle Application Server, the allocation of the page file
down to 5.4 GB (2 GB of free memory for the detention of 2 instances
OC4J).
Oracle stop service under Windows, the paging file remains at a value of 5.4 GB Physical memory increases to 2.27 GB.

Conclusion:
It was performed the same test on a physical machine .The results are as follows: the paging file
shows allocated with a value of 900MB / 1 GB, while the physical memory
used to show 30%.

Oracle Collaboration Suite on VMWARE!

smkrt — Tue, 14 Oct 2008 16:46:39 GMT

I have successfully test Oracle EBS on VMWARE and we found the results very satisfactory, now I have to work with Oracle Collaboration Suite on VMWARE ESX 3.5.

I found the documents that provided me some of the configuration like setting kernel parameter and others for running Oracle EBS on ESX based Virtual Machine.

But after through research I couldn't find any such document that help me in deploying OCS on VMWARE.

Suggestion are required for the same, please help.

Oracle Xen VM Server & Manager v VMware Server running Oracle DB guests

osde.info — Sun, 18 Nov 2007 09:12:37 GMT

Has anyone got any "public" performance stats comparing these two and proving the Oracle VM Server claims that it is three times faster ?

Interestingly it would seem that Oracle VM Manager DOES let you manage a cluster of VM Servers ! and Oracle are also promising to publish pre-built Oracle VM Server Oracle 10g DB software appliance virtual machine guests ! Now that would be handy for DBAs and sysadmins !
regards
clive
http://www.osde.info