[EMAIL PROTECTED] wrote:
I need assistance answering & help my customer with his zones questions!
Meantime I sent him infodoc 71582 to get him started!
thanks in advance for your help.

Irlando

Customer wrote:

We are looking to setup 2 Oracle databases, one for OLTP and one for OLAP.

In the past, we had always allocated 2 different servers, as a
recommendation from Oracle.  We are now trying to see if it makes sense
for us to get 1 server, say a v490 with 4 Dual Core processors with 16 Gb
of RAM, to house these 2 databases.
With zones, I know that we can setup different root disks, as I had done
during training.

Q1.Can we split up the processors, say 0 and 2 to one zone, and 1 and 3 to
   another zone?


Solaris calls each core a processor. The global zone needs at least one processor. So you could do:
Global zone: 0
Zone1: 2, 4, 6
Zone2: 1, 3, 5, 7

They would need two Oracle licenses: one for 3 processors, one for 4.
Unless Oracle has changed its mind recently, the latter would rated at 75%, so the customer would end up needing two licenses, each with 3 processors.

Or, the global zone could share processors with one of the zones:
Global zone and Zone1: 0, 2, 4, 6
Zone2: 1, 3, 5, 7

In that situation you should also use the Fair-Share Scheduler to ensure that the global zone gets at least X% of its processor set, where X is probably about 20%, but depends on a number of factors.

Q2.If we were to have 2 HBAs on the server, can we allocate 1 HBA to 1 zone
   and the other to the second zone?

There is no specific feature to allocate HBAs to zones, but you can put the file systems of one zone on one HBA, and the file systems of another zone on the other HBA.


Q3.As far as networking, would it be possible to allocate 2 ports off a Quad
   network card to 1 zone, and the other 2 ports to another zone?  Or would
   we be better off with single or dual port cards that can be allocated to
   different zones?

You can do either, depending on the networking demands of the workloads. You can also use IPMP or Trunking to improve network availability.


Q4.With zones, would it make sense for us to setup 1 master and 2 'clients',
   where each one of the clients support each database?

This question is unclear to me.

Q5.What would be the limitations of using zones to house these 2 databases.
   One downfall would be if there is a hardware problem, then all
   zones/databases would be out until the hardware issues was resolved.

Fortunately, with Solaris 10 feature sets FMA and SMF, that down time is usually very short if it exists at all.

Q6.Are there any other types of issues with zones?

Please read the FAQ at http://opensolaris.org/os/community/zones/faq/

Q7.As far as best practices, are other users use zoning to support different
   databases?

Yes. A number of BP's are discussed at http://www.sun.com/blueprints/0506/819-6186.pdf

--------------------------------------------------------------------------
Jeff VICTOR              Sun Microsystems            jeff.victor @ sun.com
OS Ambassador            Sr. Technical Specialist
Solaris 10 Zones FAQ:    http://www.opensolaris.org/os/community/zones/faq
--------------------------------------------------------------------------
_______________________________________________
zones-discuss mailing list
zones-discuss@opensolaris.org

Reply via email to