VMware Communities : Thread List - Virtualizing Oracle

Oracle RAC - Cannot Ping from RAC1 to RAC2

tadcs — Wed, 18 Nov 2009 11:02:50 GMT

Hi all,

I've created two VMs (RAC1 and RAC2) on VMware Server2 for Oracle 10g RAC.
Each VM has 2 network adapters:

eth0: public
eth1: private

But, Into RAC1, when I try a ping to RAC2, I got the error destination host unreachable.
The subnet and the net mask is OK, I've set the /etc/hosts.

From my Host PC, I cannot to perform ping to RAC1 and RAC2 too.

I've tryed to set the ethernet to hostonly and bridged, but I got the same problem.

Is there any configuration we need to do?

thank you very much!!!!

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

Moving Oracle - P2V Not Working - 2nd Option

emcclend — Sat, 31 Oct 2009 17:42:05 GMT

We are getting ready to migrate our first oracle server, however we are
having trouble. When using converter, it gets to about 95% and fails.
When looking at the physical server we see that it has rebooted and and
come back with and unexpected shutdown error. So rather than continue
on and end up with a possible bad conversion, we are thinking about
rebuilding the server from scratch as a VM, however I'm not an oracle
guy and I have to try and get the oracle guy comfortable with
virtualization. I don't know enough about oracle to even ask the right
questions to our oracle person to help them along in the process.

What I was thinking was build a new VM from scratch. We have mulitple
drives on the physical server so I would mimic that in the new VM with
the same drive letters. After that I was thininking about using
Robocopy to move the data over to the new VM drives. From there I was
thinking the oracle person can then install oracle, and point it the
copied data that is now on the VM. I'm not sure how to move an oracle
DB from one server to another and it sounds like my oracle person does
not know how to either. Any help would be appreciated.

Thanks

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

Oracle EBS and VMware

Ashishdit — Thu, 01 Oct 2009 23:15:06 GMT

I am looking for any document which can help me to install the Oracle Applications (EBS) on vmware. I am having a windows Vista and on top of VISTA planning to install the vmware and then in VMware create a virtual machine running the linux redhat where i will configure the oracle application. Now ion VM i will run the servers and then need to access the application in Vista. Please let me know how to setup the various IP's for vm and then network it preoperly, if there any pointer for any document that will be much appreciated.

~ Ashish

To Hyperthread or Not.

K-MaC — Tue, 20 Oct 2009 05:06:11 GMT

Hello all. We are going to be virtualizing an Oracle database on a new server with a single Xeon E5540 processor. All of the documentation that I have read so far states that it is best to disable Hyperthreading. However, I have been unable to find a concrete answer as to why to run with it disabled. Could someone with experience let me know the advantages and disadvanges of Hyperthreading as it relates to running a virtualized instance of Oracle.

We will be using ESX4 standard edition and the Oracle server will be lightly utilized.

Thanks in advance for any and all insight.

Cheers

Kevin

Oracle "Capacity On Demand" and vSphere Essentials

J1mbo — Mon, 10 Aug 2009 14:23:13 GMT

Afternoon all

Obviously this comes up all the time, but I wanted to focus in specifically on the part of the Oracle license model below when operating vmware vSphere Essentials (or plus) licensing:

Oracle recognizes a trend in the industry to pay for server usage based on the number of CPUs that are actually turned on - the "Capacity on Demand," or "Pay as You Grow" models. In keeping with the changes in the hardware industry and the way customers pay for services, we allow customers to license only the number of CPUs that are turned on to run Oracle.

When looking at an Oracle per-CPU license, the Essentials vm license restriction of 4 vCPUs surely must meet that crieria "to license only the number of CPUs that are turned on to run Oracle", i.e. 4, but conversly immediately preclude the use of Oracle Standard One edition?

Any thoughts or experience with this?

Many thanks!

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

Can VMWare be made to use a single core or processor to meet Oracle licensing?

johnnyIsVirtual — Wed, 08 Jul 2009 19:08:36 GMT

Can VMWare in a quad core be made to use two of those cores? Oracle licensing, I believe, will allow two cores to be counted as one for their license of "one" processor. I could use the other two cores for something else with another VMWare instance. Thanks.

Snapshots with Oracle = Safe?

grittyminder — Tue, 13 May 2008 01:16:39 GMT

We recently completed virtualization of a few Oracle 10.x Windows servers. This is a huge deal--a few people did not want this project to be carried out.

Here is where things went wrong. We are (were?) backing up or VMs using scripted snapshots and disk exports (we have no SAN at this point). We didn't realize that snapshots do not play nicely with Oracle DBs (we did not notice anything unusual during the testing phase). A few days after deploying the backup scripts into production our main Oracle DB crashed while being snapshotted. Now there is a huge snapshot 'backlash'--snapshots are forbidden to be used with Oracle DBs.

At this point, I feel I need to give a bit of background information. One of the objectives with virtualization for us was to reduce the manual/attended portion of the backup job. The previous non-virtualized system backups went something like this: backup Oracle DB to tape, run DB batch job, backup Oracle DB to tape again. This entire process would be completed at midnight every night. With the introduction of virtualization we were hoping to eliminate the first Oracle tape backup and use snapshoting instead (if something goes wrong with the DB batch job we simply roll back the snapshot). However, thanks to the 'backlash' we are now carrying out a complete DB export prior to the DB batch job (the tape backup system was eliminated as part of the refresh), which takes much longer time-wise. 1AM to be exact.

Now for the question. Is there a way to safely use snapshots with an Oracle database that guarantees that data integrity will be maintained always? Is there a best practices document I can read? Also, if I am a risk-adverse manager, can you explain to me in simple and rational language why snapshotting would be a more desirable alternative to database exporting (the present mentaility: snapshots=fast, yet unfamiliar and risky. DB exports=slow, yet familiar and safe)?

Oracle or VM resources tunning?

edzava — Mon, 14 Sep 2009 22:39:09 GMT

I have a VM with windows server 2003 standard edition running 4 instances of oracle database 10g (version 10.2.0.4) in esxi 3.5 R4.

I assigned 2 virtual proccessor (3ghz) and 3gb of memory to the VM.

Each oracle service consumes 450mb of ram and there are 2 or 3 total connections to the databases on the server.

I see that the proccesor is always nearly 80% of utilization and the memory is full used and the access is very slowly.

When the VM is restarted and the databases start up the access is very slowly too and there isn't active connectios on any databases.

The DBA reviewed the performance view, alerts, trace logs of all instances and were OK.

I attached some outputs of esxtop (the 2178 ID belongs to the affected VM)

What can you suggeest me to do?

Eduardo

RAID configuration for SQL SERVER 2005

findigno74 — Wed, 05 Aug 2009 20:43:11 GMT

What is a good RAID configuration for SQL SERVER 2005 on vmware ESX 4. The host has RAID 10 install and I want to install Windows 2008 and SQL 2005 server as guests.

I need a disk layout example.

Thanks

Problem with Virtualized Oracle 8.1

pheonixman — Tue, 28 Jul 2009 11:51:01 GMT

Hi All

Hope someone can help or point me in the right direction to resolving an issue we are currently experiencing with Oracle 8.1 and vmware. We currently have a production oracle database that we recently converted to vmware from a physical windows box, since the conversion the application that connects to the oracle database seems to be disconnecting the users randomly from the database. I'm not sure what direction to take as this only started happening when we virtualized the servers which host the application.

Hope someone can advise

Virtualizar máquina física Oracle con volumen presentado de EVA 4400

vmflu — Fri, 15 May 2009 13:58:34 GMT

Hola a todos,

Quería hacer una migración de físico a virtual de un servidor con Windows 2003 Server y Oracle9i. El problema es que este servidor tiene presentado por Fiber Channel una LUN de una cabina EVA 4400 donde guarda toda la información de la base de datos Oracle. La migración del servidor a virtual es sencilla con Vmware vConverter, pero ...¿se puede presentar esta LUN de la cabina con los datos de la base de datos para que lo vea la nueva máquina virtual o es necesario realizar una migración de los datos de la LUN a un nuevo almacenamiento RAW o SCSI?

Muchas gracias.

Saludos,

Oracle 9i will not install on VMware Server2

griffos — Mon, 27 Jul 2009 23:54:08 GMT

I am running Host OS - Ubuntu 9.04

Guest Windows Server 2003.

When I try to install oracle it maxs out cpu at 100% and doesn't proceed. It doesn't freeze/lock the system its just oracle not installing.

I have the same setup on other servers and it worked no problems at all. Its just the install on 2 servers that this happens to.

Any ideas?

I would like an answer ASAP please.

Oracle and vmware

Rhidian — Wed, 15 Jul 2009 13:58:43 GMT

Hi,

What is Oracle's current position on support for virtualization?

Regards,

Oracle 10g direct path write too slow

nikipanch — Fri, 10 Jul 2009 17:50:13 GMT

Hi All,

Are there any specific changes required to the Oracle parameters to improve performance when running Oracle 10g on Solaris Virtual Machine? Our problem is that direct path writes to both datafiles and to temps is running at 1 MB/s. Storage is RADI1, internal with HP SmartArray, host OS is ESXi. Oracle datablock size is 8K, VMFS is 1 MB. What makes me look for any Oracle settings is that file copy or ftp runs pretty fast. Problem is when there are database writes. Even a simple CREATE TABLE AS SELECT... statement for a 0.5 GB table takes 9 minutes. I am suspecting the interaction between Oracle and VMFS is causing the slow down, but have not been able to find any documentation about any best practice about it. Any hints?

Thanks,

Nikhil

Oracle Licensing + VMware ESX + Quadcore

CyberV — Thu, 26 Jun 2008 02:04:24 GMT

Hi !
I have a very good question for all the Oracle "GURU" here ... Here is the scenario :

We have 2 x VMware ESX server (HP DL380 G5) - Each have 2 x Intel Quaq-core.

We want to virtualize under VMware 4 x Oracle server :

1 x Server de BD Oracle 10g (linux)
1 x Application Server Oracle 10g AS (Infrastructure) (linux)
2 x Application Server Oracle 10g AS (Middle-Tier) (linux)

SO my question is How many license i will need for these 4 Oracle server on my 2 new VMware ESX server with 2 Quadcore in each ?

Not an easy one ... I know.

Any help will be apprecited

Thanx

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

Oracle 11g RAC on ESX 3.5 "cluster in a box": reservation conflict, reboot

Stefano Giuliano — Mon, 25 Aug 2008 10:01:35 GMT

We created 2 Linux RedHat 5 virtual machines on the same ESX 3.5 and installed Oracle 11g RAC.
Boot disk of every machine is in local storage of the ESX server, while shared disks are on a VMFS on SAN (EMC CX3-10).
The shared disks are on dedicated SCSI controller set to "virtual bus sharing".
Installation was ok, and the RAC seems to work, but sometimes a machine reboot unexpectedly.

From the /var/log/messages I see:
Aug 25 06:38:33 ttsc-rac2 kernel: sd 1:0:1:0: reservation conflict
Aug 25 06:38:33 ttsc-rac2 kernel: sd 1:0:1:0: SCSI error: return code = 0x00000018
Aug 25 06:38:33 ttsc-rac2 kernel: end_request: I/O error, dev sdd, sector 81
Aug 25 06:38:33 ttsc-rac2 logger: Oracle clsomon failed with fatal status 12.
Aug 25 06:38:33 ttsc-rac2 logger: Oracle CSSD failure 134.
Aug 25 06:38:33 ttsc-rac2 logger: Oracle CRS failure. Rebooting for cluster integrity.

/dev/sdd is the voting disk.

On Oracle log (/u01/app/crs/11.1.0/crs/log/ttsc-rac1/alertttsc-rac1.log) I see a lot of lines saying that "voting file is offline", but not time related with the error above. After many errors the voting disk returns online.

Any idea?

Thanks,
Stefano

Oracle support issue....

Bastien_P — Mon, 11 May 2009 14:43:05 GMT

Hi,

Well after about 2 years of running Oracle on ESX without any major problem/issue. We now have a trouble that our DBA is rushing to fix... And since it's a real problem this time Oracle too is having problem finding something.. And she did get the dreaded: Well it's on a Vm server, recreate the problem on a physical then we will talk to you again...

It's a patch that wont install on that server but install ok on 4 other server (all virtual)... So she and I really doubt it's a vm issue.....

This lack of support from vendor will eventually kill ESX for production server. I have the same type of question/problem with my virtual Exchange. On the exchange/microsoft front, at least the SVVP is suppose to give us support but experience tell us that it's not that easy. http://communities.vmware.com/thread/207283

I was wondering if someone figured out a way to have better support from Oracle?

thanks

Remember: If you find this information useful, please award points for "correct" or "helpful".

Migrate Oracle 11i app servers to vmware

oraappsdba — Wed, 27 May 2009 19:22:17 GMT

Hi,

We are planning to migrate our Oracle 11i EBS (11.5.10.2) web servers (including concurrent tiers and forms/web tiers) to VMWare. I didn't find any specific documents on this subject. We don't want to do convert current physical servers to virtual using VMware utilities. It will take lot of time. We are planning to build new VMs, mount shared appl_top and then add node using autoconfig. Once all the VMs are added, then retire the physical servers. Has anybody followed similar method ? We want to follow this method because we have so many web servers to virtualize.

Does anybody know other efficient methods ?

Appreciate any responses.

Thanks,

Question on Oracle processor licensing.

NTRAW — Tue, 26 May 2009 10:49:49 GMT

Hi,

Our current production environment both E-Business Suite 11i & Database 9i on 8 CPU Solaris box, now we are planning to Upgrade/migrate to R12 on AIX. As part of the upgrade project we want to build a development environment on VMWare - 2 - CPU P5 AIX 5.3 LPAR. My question is do we have to buy new licenses for 10g database for this new build inspite of being a license customer of earlier release?

Regards

Attn Oracle DBAs

vmNewb35 — Thu, 30 Aug 2007 14:38:25 GMT

We are getting ready (or at least entertaining the idea of) to switch to Oracle 11g on RHEL. We understand that this is a very successful configuration in the IT world currently. We are wanting to run this on ESX and will thus be adding additional licensed copies to our environment should this be the final direction.

1. Is this a good fit for VMWare (i.e. are you folks doing it currently?)
2. We will be running EPM (PeopleSoft) on this and we understand that it is fairly intensive model building and data warehousing.
3. We have been told that it will require major cpu and ram but, like everything else, this is generally not the case once you put it on VMWare as you end up seeing how little of it gets used.

I would appreciate any and all answers/thoughts. We will also be looking at professional help for this implementation should we go down this path so any suggestions you have along these lines would be appreciated too.

Thanks!

Oracle Licensing on ESX Hosts

RobBuxton — Sun, 20 Jul 2008 23:21:02 GMT

I'm guessing I'm not going to like the answer to the question but here goes.

I'm looking at virtualising a server that has an Oracle database as the backend. This server has two single cores. Our VMware ESX environment has 6 hosts each with 2 x dual cores..

Looking at the Oracle license blurb as well as various posts, Oracle says I'll need to license it for the full 24 cores, but at 50%. That still leaves licensing for 12 CPUs versus 2.

I've looked at the Named User, but that still seems to insist that there's an underlying processor constraint, and taking the previous blurb, that would again mean I have to take into account all of the available cores.

So how have people handled virtualising oracle databases from a license perspective, especially where the number of cores in the ESX infrastructure is considerably more than the original server?

TIA Rob

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

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

ISsue shile virtualizing ORacle

DRGoyal — Sat, 21 Mar 2009 19:43:22 GMT

We have virtualized oracle 10G environment on VM . While accessing through IIS6.0 web site through ASP pages (ODBC Connectivity).we are not able to access the ORacle while from same m/c i am able to connect to Database through ORacle Client tools. What can be the reason of not connecting oracle through IIS.

Same environment is woprking perfectly in Physical M/C,s.

Thoughts and experience of virtualising Oracle? OracleVM anyone?

edgrigson — Thu, 12 Mar 2009 11:16:12 GMT

After this week's meeting where the show of hands indicated that nobody is even using Xen of Hyper-V, I'm wondering what people's experience/perception is of Oracle VM (which is based on Xen anyway). We run Oracle and would like to consider virtualisation BUT Oracle don't support VMWare, only their own solution. Given that we've already have a significant investment in VMWare, this could force us to run both hypervisors and that's something I'd like to avoid if possible (management overhead, dissimilar functionality and features, increased training etc). The pitch from VMWare is that Oracle works just fine and they can help push Oracle to provide support, but I'm not sure this 'best effort' approach will convince the CIO that's it's a feasible solution for running mission critical services.

Has anyone else tackled this issue, or used VMWare for Oracle in production? Any feedback would be much appreciated.

Thanks,

Ed.

ESXi and Shared storage Oracle RAC

Arokh — Mon, 03 Nov 2008 16:00:18 GMT

I've been trying to setup a Oracle RAC scenario using two VM Servers on a single host machine. I've installed the OS for both VM's and prepared them both to receive the Oracle Clusterware. My problem comes when I start adding the disks to the first machine and attempting to make them virtual so that the second server will be able to see the raw partition for the OCR and Voting disk. The Host machine has 2 processors, 16GB of RAM, 500G of internal storage with no SAN attached.

Steps I've done to try and resolve this issue.

1. Used the RCLI utility to zero out the hard drive file.

2. Used the RCLI to create the drive and zero it out as well.

The error I get when I try to change the second SCSI controller (The first controller has the OS partition assigned 0:1) to Virtual is "Invalid configuration on device 1"

What am I missing here? Any help would be greatly appreciated.

Install Oracle RAC on VMWARE

lucotuslim — Thu, 12 Mar 2009 02:30:46 GMT

I tried to install Oracle RAC using VMWARE using this guideline http://startoracle.com/2007/09/30/so-you-want-to-play-with-oracle-11gs-rac-heres-how/

But when I about to install Oracle database software, it will fail at Remote Operation because one of the Virtual Machine will fail (powered off).

I manually scp the Oracle Software from Machine 1 to Machine 2, I noticed that I will also cause one of the Virtual Machine to fail (automatic power off).

Has anyone encounter the same problem ?

Clone Oracle

doubleH — Wed, 14 Jan 2009 20:29:09 GMT

Hello,

Wondering if anyone has tried taking a production windows 2003 oracle server running on ESX3.5 and cloned it to make a development environment. I need to do this and not sure what is required on the Oracle side.

Thanks!

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.

Oracle 9i for 1 CPU as VM under ESX 3.5 licence question..

FMorales — Tue, 13 Jan 2009 11:55:58 GMT

Hello..

We have one oracle 9i licence for only 1 phisycal CPU under windows 2003 server

Cound I migrate this installation to a VM in a Dell Power Edge with 2 physical CPU´s (Intel quad) under a ESX 3.5??? and

assing only only 1 vCPU to this VM??

Is this is not possible .... it would be a good idea to install it on a ESX 3.5 with only one CPU?

Thanks a lot

Francisco Morales López de Gamarra

Vmware VCP | LPI - CCNA

Oracle Performance Practices

proden20 — Fri, 12 Sep 2008 12:50:47 GMT

We have a 10g server being used for development. Recently, as activity has increased, Oracle has begun to refuse connections, and we cannot identify the bottleneck. Some facts about this VM:

It is assigned 4GB RAM & 2 vCpus (2.0GHz cores)
This VM does not have any reservations, nor do any VM's on the cluster (it's an ad-hoc Dev environment 50% servers / 50% VDI)
I fear that setting a reservation will cause the HA admittance algorithm to throw me into a yellow or red state and trigger isolation response for the VM's that are already running
Its storage is a vmdk file, not an RDM LUN
It has one virtual network adapter, hosts in cluster have 4-6 nics for virtual machine network
It is on a DRS-enabled cluster, commonly sharing space with 15+ other virtual machines (Quad core 2GHz / 32 GB RAM PE2950 hosts)
Protocol analyzer shows a few tcp retransmissions to/from this host
The VC graphs aren't showing anything alarming, and the guest usually has 1.5GBRAM+ avail.
No other VM's are having issues

I will be completely honest I do not know Oracle, but if anyone has any suggestions on improving the performance of this VM to the point where I can rule out VMWare as the culprit of the refused connections, that would be great. According to the DBA, Oracle is not throwing any errors and his traces aren't showing anything wrong.

Thanks!

How to convert vmware image to oracleVM format ？

ultrasoul — Wed, 18 Feb 2009 17:04:36 GMT

Hi, All

I have installed oracle VM 2.1.2 server and I want to try convert vmware image to oracle VM format.　what is the right way to do it?

Also, what is the way to convert oracle VM format to vmware image? did the oracle VM support ovf format?

Kindly please advise.

Gryan

How can i cluster Oracle 10g RAC on 2 Linux VM?

johnny.yammine@magirus.com — Wed, 29 Oct 2008 13:55:46 GMT

Is there any detailed documentation on how to cluster Oracle 10g RAC on 2 Linux VM? I need to know how the second virtual machine will be able to access the shared storage while this storage is locked for the first VM. Is there any script should be run?

Thanks in advance

Oracle licensing (AS / DB): other experiences ?

MartijnLo — Thu, 18 Oct 2007 07:31:14 GMT

Referring to my blogposts on the matter: http://virtualize.wordpress.com/2007/10/17/oracle-licensing-not-ok/ and http://virtualize.wordpress.com/2007/09/20/oracle-licensing-a-new-chapter/

As this has gone up to VP Level at Oracle US (according to my contact) I would like to know if others have had different experiences or solutions to their Oracle licensing for Virtual Machines.

If someone from VMWare could chime in on the status of the Technology Alliance with Oracle ( http://www.vmware.com/partners/alliances/technology/oracle.html ) that would be great as well because as a customer of both we are not seeing a lot of benefits at the moment.

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%.

Does it always make sense to virtualize Oracle?

timcoote — Thu, 18 Dec 2008 12:42:48 GMT

Hullo

I can see value in virtualizing small Oracle instances. However, unlike SQL Server, Oracle's architecture and commercial terms favour large, single instance installs, and I can see some challenges with larger scale virtualization:

you've got to track all Oracle instances in the estate under the terms of the licence agreement
I think that the licensing terms mean that every Oracle instance on an ESX server would incur licensing and support costs for every physical CPU on the server.
cache cannot be shared between Oracle instances
There's a higher admin cost of multiple Oracle installs.
RAC's scaling and failover capabilities are tailored to the DBMS' needs and ought to be more effective
Production Oracle installs actually span multiple machines, which need to be treated as a single entity - I don't think that virtualisation is much worse than native install here, unless someone accidentally moves one of the VMs with that whizzy GUI.

I guess that the maximum VM size is quite small for a large DB, too. Conversely, overall Oracle performance may be better in a virtualised environment, rather than consolidated if the DBMS performance is non-linear.

Has anyone done any analysis of whether it is always worth virtualising Oracle? Is there a cutover point? Is it beyond the size of the largest organisation ?

Tim

Virtualizing Oracle on Windows Server Operating System

OracleNooby — Wed, 17 Dec 2008 18:07:42 GMT

Hi,

My Organisation has a transactional Oracle database residing on an IBM AIX Unix box. Management want a reporting database on our (development) infrastructure so that queries and reports can be run without hurting the operational system. My question is can I virtualise the operational environment (IBM AIX Unix) environment on a Windows server platform. By the way both will be Oracle 10g. If I can't (which I suspect), does anyone have any advice on how to get around this other than buying an IBM AIX Unix box for our development environment?

Thanks in advance for any replies.

VMDK file with Oracle Enterprise Linux

VMWARE NOVOICE — Tue, 11 Nov 2008 11:07:31 GMT

Dear All,

I need a VMDK file with Oracle enterprise linux . Where can I download the same?

Please help

regards

Latha

RAC on VI3

Stefano Giuliano — Thu, 27 Nov 2008 13:15:30 GMT

Hello all,
how about Oracle RAC on Vmware Virtual Infrastructure 3 on production? Is it now certified by Oracle/Vmware, or anyone knows if it will be certified in the future? Does someone have RAC on production on Vmware?
We have a 2 node Oracle 11 RAC on one VI3 cluster (2 ESX 3.5.0 + SAN EMC cx3-10) that works ok (for testing).
Do you know if it possible to have more than 2 RAC nodes on VI3?
Or do you still suggest physical server for RAC?

Thanks,
bye
Stefano

Oracle EBS and VMware

jferrin — Fri, 14 Nov 2008 16:51:49 GMT

I am curious if anyone has successfully run Oracle E-Business Suite R12 on ESX 3.5? The initial installation (default configuration, no tweaking) was really slow when put under load...

Does anyone have any words of advice?

Rhel5.2 Cluster on esx 3.5

bhoros — Wed, 15 Oct 2008 21:49:24 GMT

I want to set up a RHEL 5.2 Cluster to mirror what I am trying to setup in production.

Any one have some input or know of a guide

Shared Disk options

Fencing option Cluster config

GFS

We are not having much luck on the physical build so I was hoping to get some guidance in the virtual space

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 E-Biz on ESX?

benspencer — Mon, 10 Dec 2007 10:23:35 GMT

This past weekend, we moved our Oracle E-Biz installation from physical hardware (3.6 Ghz; 2 CPU + HT) to VM's.
This went well (not suprising) except we are seeing high (higher then expected) CPU usage on the database.
The database was moved to a 2 CPU vSMP VM. Per Virtual Center, the average CPU usage of the database guest is
about 50% with no users actually using the application (E-Biz always did seem a bit chatty).

When we first moved the application, we tried, 1, 2 and 4 vCPU guests and a slight increased performance with each CPU we added.

Is anyone else running E-Biz on ESX? Are you seeming similar results?

Thanks

Benji

Oracle 10g Conversion Gotchas

VStar650 — Wed, 23 Jul 2008 20:24:46 GMT

Hello,

We are getting ready to test convert our Oracle 10g server from a physical Windows 2000 server to a virtual server on ESX 3.0.2.

I was wondering if anyone has tried this and have anything to share with regards to things we should be looking out for before we do the actual conversion?

Thanks in advance.

Oracle on VM Workstation

jezkaz — Mon, 14 Jul 2008 01:42:51 GMT

I'm using vmware workstation 5.5.5 to try and learn Oracle 11g. Oracle is successfully installed on my laptop under RH Linux and I would like to connect to it using the client tools installed on my laptop. However I can't get it to talk to it. Anyone know what to do. I've tried using localhost and Microsoft loop back adapter but with no luck

thanks

Oracle RAC on ESX 3.0.2

chrisjdeane — Thu, 31 Jan 2008 18:34:00 GMT

Hello,

I have 2 Linux servers on 1 Datastore (1 LUN) on iscsi.

I want to set up Oracle RAC (clustering)

Ive read several articles but nothing appears to be apply.

Do I need to create 3 new luns and used RDM?

Or do I create 3 virtual disks per Linux server and create a new controller and set them up for sharing - so both servers can see each others disk?

The oracle RAC bit doesnt work like this - error 4.

I would be grateful for any assistance.

Kind Regards

First Oracle Virtualization

matt4130 — Fri, 06 Jun 2008 15:31:29 GMT

Afternoon All!

I'm about to virtualize my first Oracle Server, I've never really worked with Oracle before so I was wondering whether there are any special considerations?

The Server has databases across 4 different partitions + the OS. I was planning on just virtualising the OS Volume, creating the disks and copying the files over. Does this sound like a good idea?

Also, should I have a seperate volume for the Page / Swap file? and if so should I put this on a Seperate LUN?

Many Thanks

Matt

Oracle and backups/recovery of VM Server

jfakka — Wed, 13 Feb 2008 04:48:21 GMT

Hi all

I am having difficulty in finding doco on whats required for backing up oracle thats running within a VM

Links / thoughts / experiences ??

thanks

Sizing of Oracle with SAN

Daemegil — Thu, 10 Apr 2008 13:45:32 GMT

I plan to install some Oracle Database servers 9i on VMWare ESX 3.5. I use an EMC CX3-10 SAN. I want to split the installation into three parts on the SAN : Oracle software / Database / logs.
My questions :

is it a good idea for performance / availability in accessing my data ?
Should i use vmfs for those the 3 Luns i want to create ?
If my system partition is sized at 10 GB, My data 50 GB and my logs 10GB how much space should i count on the luns (20 GB / 100 GB / 20 GB for snapshots ?)
If i install 4 Oracle servers, should i create 4x3 = 12 LUNS ?

Thank you for your answers

Windows XP Laptop - wanting to run Linux and Oracle using vmware

sevans29 — Tue, 18 Mar 2008 14:57:43 GMT

Hi,

I have a laptop running Windows XP. Is it possible to install vmware and run linux and Oracle upon the Windows laptop?

thanks
Steve

Ten Reasons Why Oracle Databases Run Best on VMware

JohnTroyer — Wed, 14 Nov 2007 23:29:12 GMT

New from VMware's performance team:

http://blogs.vmware.com/performance/2007/11/ten-reasons-why.html

Ten Reasons Why Oracle Databases Run Best on VMware

We're really excited about the buzz around Oracle in virtualized environments. One of the best kept secrets is just how well Oracle performs on VMware ESX. This didn't happen by accident - there are a number of features and performance optimizations in the VMware ESX server architecture, specifically for databases.

In this blog, I'll walk through the top ten most important features for getting the best database performance. Here are a few of the performance highlights:

Near Native Performance: Oracle databases run at performance similar to that of a physical system
Extreme Database I/O Scalability: VMware ESX Server's thin hypervisor layer can drive over 63,000 database I/Os per second (fifty times the requirement of a typical database)
Multi-core Scaling: Scale up using SMP virtual machines and multiple database instances
Large Memory: Scalable memory - 64GB per database, 256GB per host

We've continued to invest a great deal of work towards optimizing Oracle performance on VMware, because it's already one of the most commonly virtualized applications. The imminent ESX 3.5 release is our best database platform to date, with several new advanced optimizations.

In this blog article we'd like to explain the unique and demanding nature of database applications such as Oracle produces and show the performance capabilities of ESX Server on this type of workload.

Oracle 10 G and ESX 3.5

wahlert — Mon, 04 Feb 2008 14:25:58 GMT

Hi out there,

we run ESX 3.0.1 in production and (at the Moment) 3.5 for eval.
Next step for us, is the virtualization of our Oracle 10G Databases under RedHat Adv Server.

I heard about paravirtualization in ESX 3.5. How can i setup this in RedHat Adv Server?? Or can anyone point me to a Docu??

friendly regards from vienna

A. Wahlert

esx vminstance w/win2003&oracle 10g boot-up - a slow dog. Need help

rachlitz — Fri, 04 Jan 2008 19:03:06 GMT

Hello,

I just virtualized (esx) a system that I'm running Oracle 10g and an application called Dimensions - a config mgt java application served out with tomcat. I'm on Win2003 R2.

I'm the dba, not vmware admin. Problem - the vminstance when booted, starts all services, but is dog slow for a few hours. It seems like it needs to "ramp-up". I see no evidence of this on a similar stand-alone win2003 box w/the same software installed. The services, such as Oracle and Dimensions application are so slow and unresponsive as to be impossible to use. After a few hours everything is fine. Very good response and everything is fine.

Was wondering if anyone else had the same problems and if anyone can suggest oracle init param changes or vmware config changes to help this boot-up problem. The virtual instance was set-up w/4 CPU and 4 GB ram, just like the orig box it was virtualixed from. The vmbox has 2 quad core CPUs and I think 12 GB ram (not sure). Also there are maybe 6 other virtualized OSes on the vmserver. We have a single EMC lun holding all virtualized OSes.

Thanks,

Mark

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

Oracle Design Question

doubleH — Mon, 12 Nov 2007 18:24:27 GMT

Howdy,

We will be implementing a new GIS application that will store all it's data in an Oracle 10R2 spatial database. Database server will be running Windows 2003 R2. There will be 10 users using the application with future growth increasing it to 25. I've read many posts about Oracle licensing and supportability and I am comfortable with this aspect. My questions revolve around design and hoping you guys can offer some suggestions.

Current Hardware

ESX Hosts (2)

Model: HP DL385 G2

CPU: (2) AMD Opteron 2218-Dual Core

RAM: 22GB

HBA: QLogic 4052c

NIC: NC360T (Dual Port)

SAN

EqualLogic PS100E, Raid50

I will be ordering a new PS100E and it will be configured for RAID 10 to ensure that the SAN is configured for optimal disk access. This SAN will also be used for future databases such as Exchange (100 users) in the future.

The OS will reside in a VMDK, but I'm not sure if I should be using VMDKs or RDMs for the database disk. Or should I create a LUN, install the MS iSCSI initiator in the guest and connect directly to the LUN. I've read that this is best option for performance and is recommended by EqualLogic.

How do the above guest configurations affect VMotion/HA/DRS?

http://www.equallogic.com/news/release_display.aspx?id=462

Oracle

macneej — Wed, 29 Nov 2006 21:03:25 GMT

One of my clients are looking to put their Oracle 9 and 8 production servers on ESX 3.0.1.
Does anyone know what issues Oracle have with licensing on VMware? Can you point me to some documentation on this?
Also has anyone had any experience with running Oracle databases on virtual machines. We would be running the Oracle DB inside RHL 4.0.