How to move Oracle DB from NFS Share to Pure Storage iSCSI Volumes

/How to move Oracle DB from NFS Share to Pure Storage iSCSI Volumes

How to move Oracle DB from NFS Share to Pure Storage iSCSI Volumes

This blog post on how to move Oracle DB from NFS Share to Pure Storage iSCSI Volumes is the second part of the previous blog post Add Pure Storage iSCSI to Linux CentOS.

In the previous article, I add Pure Storage Volumes to the Linux CentOS v7, and now I will move all Oracle configurations(Oracle Installation and Oracle Databases) from the NetApp NFS to the new Pure Storage iSCSI Volumes.

As we can check in the previous article, all mount points, volumes, and permissions are already set. Here we will only focus on Oracle.

I will make this move without any Oracle changes, and all the changes will be done in Linux.

What will be done in this process?

Copy from Oracle from NetApp to Pure Storage

  • Stop Oracle Database and Listener
  • Copy all files from NetApp NFS mount points netapp-Ora01, netapp-Ora02 to Pure Storage iSCSI mount points Pure-Ora01, Pure-Ora02.
  • unmount NetApp volumes
  • unmount Pure Storage devices
  • mount back Pure Storage devices to original /u01 and /u02
  • Change the fstab to boot with the new devices in original mount points.
  • Reboot
  • Start Oracle and Listener and test Oracle and check if DB was ok and data was accessible.

We will start the process by checking Oracle installation and its parameters by running opatch.

Login as Oracle (or the user you have for Oracle install and admin).

Now Oracle DB and Listener should be stopped. Check first what is running.

As we can see above, DB and Listener are running (some unrelated records were removed from the list above); stop both.

Listener

Oracle Database

Recheck the running processes and check if any Oracle is running. If all is stopped, then we can start our copy/move of Oracle to the new mount points.

We will start by moving the app folder.

Return to Root user to perform the next steps.

As we can see in the next commend, all permissions and user/groups on these new volumes were already set in my previous article Linux iSCSI. If you did not set the permissions, do it now.

Copy Oracle first.

Next, copy Oracle Database.

Note: If you are copying large files and big data, you can use rsync so that if it breaks or you have a timeout, you can start where it stops. Most of the time, cp is more than enough to copy the files.

Double-check if files and permissions(should have Oracle user as owner and oinstall group) were copied and then start to unmount all mount points(old and new).

Then mount the new volumes again but in the original mount points.

Change the fstab to use the new mount device for Oracle mounts and delete\comment the NetApp NFS mounts.

Now Reboot the server.

After Reboot, login with Oracle and start DB and listener.

Start Oracle Database.

For a final test, I remotely connected to my Oracle DB using Oracle SQL Developer and run some queries, and it runs without any issues. So everything seems ok and running without any problems.

You can now destroy NFS Shares from your previous Storage System(NetApp or other) and delete the folder created for the temporary move to Pure Storage. In my case was /Pure-Ora01 and /Pure-Ora02.

With this final test, we finished the process for how to move Oracle DB from NFS Share to Pure Storage iSCSI Volumes.

I hope these two articles did help you to move your Linux Oracle Database from an NFS Share to an iSCSI Volumes, regardless of Storage System you use. The process is the same for every Storage System, and it could change on some parameters that your Storage vendor could have different.

For the Oracle Installation and Oracle Database move, the process is the same regardless if you are moving from Storage, or local disks, or even new Folders.

Both articles:

Share this article if you think it is worth sharing. If you have any questions or comments, comment here, or contact me on Twitter.

©2021 ProVirtualzone. All Rights Reserved
By | 2021-03-28T23:59:41+02:00 March 28th, 2021|Olher, Storage|0 Comments

About the Author:

I am over 20 years’ experience in the IT industry. Working with Virtualization for more than 10 years (mainly VMware). I am an MCP, VCP6.5-DCV, VMware vSAN Specialist, Veeam Vanguard 2018/2019, vExpert vSAN 2018/2019 and vExpert for the last 4 years. Specialties are Virtualization, Storage, and Virtual Backups. I am working for Elits a Swedish consulting company and allocated to a Swedish multinational networking and telecommunications company as a Teach Lead and acting as a Senior ICT Infrastructure Engineer. I am a blogger and owner of the blog ProVirtualzone.com

Leave a Reply

%d bloggers like this: