Mailing List Archive

HP-UX NFSv3 and ONTAP
I have a client that has an old HP-UX (11.23) server that currently has FC
mounts to an even older CX3. It has already been ruled out on moving this
workload to FCP on their ONTAP cluster (9.6P3) as the system is outside of
the IMT. What I am proposing to them is moving this workload over to NFS
and see if it would meet the very low application requirements. The main
workload is an Oracle 8i (8.17) database that has extremely low
transactions.

My question is are there any gotchas or specific settings that should be
employed regarding NFS mounts and HPUX? I have reviewed TR-4067 (quickly)
and KB and the two items that stuck out (qtree exports and NFSv4) are items
that I was not proposing on using. Anything else to be aware of?

Many thanks in advance


Regards,
André M. Clark
Re: HP-UX NFSv3 and ONTAP [ In reply to ]
Use Oracle?s DNFS client. Should be okay I would think.

Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Toasters <toasters-bounces@teaparty.net> on behalf of Andr? M. Clark <andre.m.clark@gmail.com>
Sent: Wednesday, July 15, 2020 9:39:13 AM
To: toasters@teaparty.net <toasters@teaparty.net>
Subject: HP-UX NFSv3 and ONTAP

I have a client that has an old HP-UX (11.23) server that currently has FC mounts to an even older CX3. It has already been ruled out on moving this workload to FCP on their ONTAP cluster (9.6P3) as the system is outside of the IMT. What I am proposing to them is moving this workload over to NFS and see if it would meet the very low application requirements. The main workload is an Oracle 8i (8.17) database that has extremely low transactions.

My question is are there any gotchas or specific settings that should be employed regarding NFS mounts and HPUX? I have reviewed TR-4067 (quickly) and KB and the two items that stuck out (qtree exports and NFSv4) are items that I was not proposing on using. Anything else to be aware of?

Many thanks in advance


Regards,
Andr? M. Clark
RE: HP-UX NFSv3 and ONTAP [ In reply to ]
I personally managed servers as old as HP-UX 11.11 with Oracle running in NFSv3 exports from ONTAP. No problems.

Make sure you read https://www.netapp.com/us/media/tr-3633.pdf for a few things about TCP/IP, ethernet, and mount options.

From: Toasters <toasters-bounces@teaparty.net> On Behalf Of André M. Clark
Sent: Wednesday, July 15, 2020 8:39 AM
To: toasters@teaparty.net
Subject: HP-UX NFSv3 and ONTAP

NetApp Security WARNING: This is an external email. Do not click links or open attachments unless you recognize the sender and know the content is safe.


I have a client that has an old HP-UX (11.23) server that currently has FC mounts to an even older CX3. It has already been ruled out on moving this workload to FCP on their ONTAP cluster (9.6P3) as the system is outside of the IMT. What I am proposing to them is moving this workload over to NFS and see if it would meet the very low application requirements. The main workload is an Oracle 8i (8.17) database that has extremely low transactions.

My question is are there any gotchas or specific settings that should be employed regarding NFS mounts and HPUX? I have reviewed TR-4067 (quickly) and KB and the two items that stuck out (qtree exports and NFSv4) are items that I was not proposing on using. Anything else to be aware of?

Many thanks in advance


Regards,
André M. Clark
RE: HP-UX NFSv3 and ONTAP [ In reply to ]
Jeff and Tim,

Thanks for your quick responses. I am actually reviewing TR-3633 right now.
Any other tips regarding data protection and replication? I know SnapCenter
is not an option; is SnapCreator still a possibility? Minimally they are
looking to do SnapMirrors to a DR system throughout the day and consistent
Snapshots, while not a requirement, would be a plus. They already have a
procedure where they shut down the database nightly to perform a cold
backup but if we can provide any improvements on this it would be a win.

Regards,
André M. Clark


On July 15, 2020 at 09:58:38, Jeffrey Steiner, (jeffrey.steiner@netapp.com)
wrote:

I personally managed servers as old as HP-UX 11.11 with Oracle running in
NFSv3 exports from ONTAP. No problems.



Make sure you read https://www.netapp.com/us/media/tr-3633.pdf for a few
things about TCP/IP, ethernet, and mount options.



*From:* Toasters <toasters-bounces@teaparty.net> *On Behalf Of *André M.
Clark
*Sent:* Wednesday, July 15, 2020 8:39 AM
*To:* toasters@teaparty.net
*Subject:* HP-UX NFSv3 and ONTAP



*NetApp Security WARNING*: This is an external email. Do not click links or
open attachments unless you recognize the sender and know the content is
safe.



I have a client that has an old HP-UX (11.23) server that currently has FC
mounts to an even older CX3. It has already been ruled out on moving this
workload to FCP on their ONTAP cluster (9.6P3) as the system is outside of
the IMT. What I am proposing to them is moving this workload over to NFS
and see if it would meet the very low application requirements. The main
workload is an Oracle 8i (8.17) database that has extremely low
transactions.



My question is are there any gotchas or specific settings that should be
employed regarding NFS mounts and HPUX? I have reviewed TR-4067 (quickly)
and KB and the two items that stuck out (qtree exports and NFSv4) are items
that I was not proposing on using. Anything else to be aware of?



Many thanks in advance





Regards,

André M. Clark
Re: HP-UX NFSv3 and ONTAP [ In reply to ]
AFAIK dNFS was introduced in Oracle 11g (September 2009).

If this is really an Oracle 8i (August 2000, EOS Extended 2006), it
doesn't have dNFS available.

You might want to check ancient TRs also and/or just make sure, the
instructions apply to your version...


Sebastian


On 15.07.2020 15:54, Tim McCarthy wrote:
> Use Oracle?s DNFS client. Should be okay I would think.
>
> Get Outlook for iOS <https://aka.ms/o0ukef>
> ------------------------------------------------------------------------
> *From:* Toasters <toasters-bounces@teaparty.net> on behalf of Andr? M.
> Clark <andre.m.clark@gmail.com>
> *Sent:* Wednesday, July 15, 2020 9:39:13 AM
> *To:* toasters@teaparty.net <toasters@teaparty.net>
> *Subject:* HP-UX NFSv3 and ONTAP
> I have a client that has an old HP-UX (11.23) server that currently
> has FC mounts to an even older CX3. It has already been ruled out on
> moving this workload to FCP on their ONTAP cluster (9.6P3) as the
> system is outside of the IMT. What I am proposing to them is moving
> this workload over to NFS and see if it would meet the very low
> application requirements. The main workload is an Oracle 8i (8.17)
> database that has extremely low transactions.
>
> My question is are there any gotchas or specific settings that should
> be employed regarding NFS mounts and HPUX? I have reviewed TR-4067
> (quickly) and KB and the two items that stuck out (qtree exports and
> NFSv4) are items that I was not proposing on using. Anything else to
> be aware of?
>
> Many thanks in advance
>
>
> Regards,
> Andr? M. Clark
>
>
> _______________________________________________
> Toasters mailing list
> Toasters@teaparty.net
> https://www.teaparty.net/mailman/listinfo/toasters
Re: HP-UX NFSv3 and ONTAP [ In reply to ]
On 15 Jul, Andr? M. Clark wrote:
> ...
> Any other tips regarding data protection and replication? I know SnapCenter
> is not an option; is SnapCreator still a possibility? Minimally they are
> looking to do SnapMirrors to a DR system throughout the day and consistent
> Snapshots, while not a requirement, would be a plus. They already have a
> procedure where they shut down the database nightly to perform a cold
> backup but if we can provide any improvements on this it would be a win.

Oracle 8 is quite old, I think it probably pre-dates things like
SnapCreator, SnapCenter ... probably anything other than Snapshots :).

I once did something similar i.e. implemented hot backups of a running
Remedy AR System database on Oracle 8 on ONTAP.

As far as I can recall there was a NetApp Whitepaper or TR describing how to
implement this so that the backup was consistent at the database level and
could be recovered from, but I cannot locate that doc now.

Basically it is pretty simple, you need to script the following:

1. Check that the Oracle instance is running/available

2. Tell Oracle to place all the tablespaces that are to be backed up into
backup or "archive log mode"

3. Tell Oracle to dump the currently "active" contents of its redo logs to
its archives

4. Make a backup of the instance control file

5. Tell Oracle to write a set of instance re-creation statements to its
trace file

6. Connect to the NetApp and create a new Snapshot of the volume(s) where
the Oracle data is stored

7. Tell Oracle to take the tablespace back out of backup mode

8. Log the results

Most of those steps are fairly simple SQL commands. You run the above a
couple of times a day and the NetApp snapshot which get created contain
everything needed to restart/recreate the Oracle instance at the time that
they were created.

You should backup the archived redo logs, but not the live/current redo
logs. It's not a problem to back these up, but it doesn't bring any benefit
and during a restore you might accidentally overwrite the current versions.
Which would be bad.

Cheers,
Robb.

_______________________________________________
Toasters mailing list
Toasters@teaparty.net
https://www.teaparty.net/mailman/listinfo/toasters
Re: HP-UX NFSv3 and ONTAP [ In reply to ]
Thanks again all for these tips. I am working with my client in setting
up the environment to test everything out.

Regards,
André M. Clark


On July 16, 2020 at 07:21:47, Walfherder (toasters@tson.de) wrote:


On 15 Jul, André M. Clark wrote:
> ...
> Any other tips regarding data protection and replication? I know
SnapCenter
> is not an option; is SnapCreator still a possibility? Minimally they are
> looking to do SnapMirrors to a DR system throughout the day and
consistent
> Snapshots, while not a requirement, would be a plus. They already have a
> procedure where they shut down the database nightly to perform a cold
> backup but if we can provide any improvements on this it would be a win.

Oracle 8 is quite old, I think it probably pre-dates things like
SnapCreator, SnapCenter ... probably anything other than Snapshots :).

I once did something similar i.e. implemented hot backups of a running
Remedy AR System database on Oracle 8 on ONTAP.

As far as I can recall there was a NetApp Whitepaper or TR describing how
to
implement this so that the backup was consistent at the database level and
could be recovered from, but I cannot locate that doc now.

Basically it is pretty simple, you need to script the following:

1. Check that the Oracle instance is running/available

2. Tell Oracle to place all the tablespaces that are to be backed up into
backup or "archive log mode"

3. Tell Oracle to dump the currently "active" contents of its redo logs to
its archives

4. Make a backup of the instance control file

5. Tell Oracle to write a set of instance re-creation statements to its
trace file

6. Connect to the NetApp and create a new Snapshot of the volume(s) where
the Oracle data is stored

7. Tell Oracle to take the tablespace back out of backup mode

8. Log the results

Most of those steps are fairly simple SQL commands. You run the above a
couple of times a day and the NetApp snapshot which get created contain
everything needed to restart/recreate the Oracle instance at the time that
they were created.

You should backup the archived redo logs, but not the live/current redo
logs. It's not a problem to back these up, but it doesn't bring any benefit
and during a restore you might accidentally overwrite the current versions.
Which would be bad.

Cheers,
Robb.