Operating System - HP-UX
1748169 Members
4152 Online
108758 Solutions
New Discussion юеВ

HPUX Oracle 10g multipath

 
SOLVED
Go to solution
sk800i
Advisor

HPUX Oracle 10g multipath

Does Oracle 10g (ASM) run on HPUX v11.23 that must order the Secure Path? Any alternative?
9 REPLIES 9

Re: HPUX Oracle 10g multipath

What sort of storage subsystem do you have?

HTH

Duncan

I am an HPE Employee
Accept or Kudo
Robert-Jan Goossens
Honored Contributor

Re: HPUX Oracle 10g multipath

Hi SK,

This depends on;

How do want to setup your raw volumes/disks? Do you want to use the raw disk device files or do want to create raw logical volumes for ASM?

Native 11.23 pvlinks (alternate path) is only possible with LVM, and there is no load balancing between the paths.

With Secure Path you can use the raw disk device files for ASM and you will have load balancing for a better performance.

Hope this helps,
Robert-Jan
Jozef_Novak
Respected Contributor

Re: HPUX Oracle 10g multipath

>> Native 11.23 pvlinks (alternate path) is only possible with LVM, and there is no load balancing between the paths. <<

Actually, there is a limited option of load balancing by manually spreading primary PV paths across HBAs and storage ports. However, with Secure Path, this can be done with much less effort and more effectively.

J.
Steven E. Protter
Exalted Contributor

Re: HPUX Oracle 10g multipath

Shalom,

Oracle ASM needs total control of disk. It removes this from the systems administrator on the OS and hands it to Oracle.

My read on the documentation is that it will work with Secure Path or without it.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
sk800i
Advisor

Re: HPUX Oracle 10g multipath

Since the Secure Path is a cost issue, I would like to find freeware or bundled feature to enable 2 x FC HBA failover connecting to EVA4400 and under the oracle 10g ASM RAC configuration.

Is it PVlink better for this case if I don'[t care the load balance and Oracle 10g RAC can use the PVlink as well?
Solution

Re: HPUX Oracle 10g multipath

OK, first off I am stunned that someone who can afford the horrific licensing costs of Oracle RAC is worrying about the minor cost of some Secure Path licenses.

Storage choices with Oracle can be confusing - throw RAC into the equation and they get more confusing. Let's take it as a given that you are going to use ASM and work from there...

- If you are just implementing a standalone (i.e. non-RAC) database, then you have 2 choices:

i) Use Secure Path for MPIO
ii) Create LVM configurations and use PVlinks for MPIO (allbeit this is only failover rather than load balancing)

- If you are implementing a RAC database your choices are:
i) Use Secure Path for MPIO
ii) If you are also using Serviceguard Extension for RAC (SGeRAC), then you could again use LVM (actually SLVM which allows concurrent access to logical volmes from more than onde node) and use PVlinks for MPIO
If you aren't using SGeRAC, and are just using Oracle Clusterware then your *only* choice for MPIO is Secure Path

Honestly it amazes me that people don't check all this out before costing their solutions...

HTH

Duncan

I am an HPE Employee
Accept or Kudo
Emil Velez
Honored Contributor

Re: HPUX Oracle 10g multipath


If its oracle 10GR2 and you decide to use CFS and SGeRAC then you can use the multipathing that vxvm provides.

sk800i
Advisor

Re: HPUX Oracle 10g multipath

Because I would like to use the existing equipments to enable free cost of Oracle 10g std version on RAC function. Therefore I think can I use the RAC without Secure Path run on HPUX. Thanks all people said the Secure Path can provide more efficiency and load balance feature instead of PVlink.
suri mani
New Member

Re: HPUX Oracle 10g multipath

We have the same concern. We are trying to use Oracle 10g (ASM) on HPUX 11.23 with HP native path to connect to our SAN storage. Are you saying we don't need secure path or service guard. We are not going to use load balancing feature.