Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
Duncan Edmonstone
Honored Contributor

Re: HPUX Oracle 10g multipath

What sort of storage subsystem do you have?

HTH

Duncan

HTH

Duncan
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?
Duncan Edmonstone
Honored Contributor
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

HTH

Duncan
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
Occasional Visitor

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.