Configure Exadata

Configuring Oracle Exadata for a Sun ZFS Storage Appliance

This section contains sample scripts showing how to attach a Sun ZFS Storage Appliance to an Oracle Exadata. These scripts are designed to support a database named dbname in a one-pool and a two-pool Sun ZFS Storage Appliance configuration.

General Implementation Steps

The implementation steps are:

1. Set up the directory structure (mount points) to mount the shares on the host.

2. Update /etc/fstab to mount the shares exported from the Sun ZFS Storage Appliance to the appropriate mount points.

3. Create an init.d service to automate the process of mounting and unmounting the shares.

4. Update the oranfstab file to access the Sun ZFS Storage Appliance exported shares or set mount on boot in /etc/fstab.

5. Mount the shares on the host.

6. Change the permissions of the mounted shares to match the permission settings of ORACLE_HOME.

7. Optionally, restart the Oracle Database instance to pick up the changes to the oranfstab file.

Note: If you used the Oracle Exadata Backup Configuration Utility, all steps except for step 4 and step 7 have already been performed for you. In the next section, "Detailed Implementation Steps," you may optionally perform Updating oranfstab to Access Sun ZFS Storage Appliance Exports and step 2 of Setting the Ownership of the Mounted Shares.

Detailed Implementation Steps

Topics in this section:

• Setting Up the Directory Structure to Mount the Shares on the Host

• Updating the /etc/fstab File

• Creating an init.d Service

• Updating oranfstab to Access Sun ZFS Storage Appliance Exports

• Mounting the Shares on the Host

• Setting the Ownership of the Mounted Shares

Setting Up the Directory Structure to Mount the Shares on the Host

Set up mount points for the shares on the host as shown:

mkdir -p /zfssa/dbname/backup1

mkdir -p /zfssa/dbname/backup2 mkdir -p /zfssa/dbname/backup3 mkdir -p /zfssa/dbname/backup4

Updating the /etc/fstab File

To update the /etc/fstab file, use one of the following options.

Note: The UNIX new-line escape character (\) indicates a single line of code has been wrapped to a second line in the listing below. When entering a wrapped line into fstab, remove the \ character and combine the two line segments, separated by a space, into a single line.

For a one-pool configuration:

192.168.36.200:/export/dbname/backup1 /zfssa/dbname/backup1 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0
192.168.36.200:/export/dbname/backup2 /zfssa/dbname/backup2 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0
192.168.36.200:/export/dbname/backup3 /zfssa/dbname/backup3 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0
192.168.36.200:/export/dbname/backup4 /zfssa/dbname/backup4 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0

For a two-pool configuration:

192.168.36.200:/export/dbname/backup1 /zfssa/dbname/backup1 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0
192.168.36.201:/export/dbname/backup2 /zfssa/dbname/backup2 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0
192.168.36.200:/export/dbname/backup3 /zfssa/dbname/backup3 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0
192.168.36.201:/export/dbname/backup4 /zfssa/dbname/backup4 nfs \   
rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \   3,timeo=600 0 0

Creating an init.d Service

Create an init.d service using the appropriate following option.

#!/bin/sh
#
# zfssa_dbname: Mount ZFSSA project dbname for database dbname
#
# chkconfig: 345 61 19
# description: mounts ZFS Storage Appliance shares
#

start()

  mount /zfssa/dbname/backup1
  mount /zfssa/dbname/backup2
  mount /zfssa/dbname/backup3
  mount /zfssa/dbname/backup4
  echo "Starting $prog: "

stop()

  umount /zfssa/dbname/backup1
  umount /zfssa/dbname/backup2
  umount /zfssa/dbname/backup3
  umount /zfssa/dbname/backup4
  echo "Stopping $prog: "

case "$1" in

  start)
     start
     ;;
  stop)
     stop
     ;;
  restart)
     stop
     start
     ;;
  status)
     mount
     ;;
   *)
      echo "Usage: $0 {start|stop|restart|status}"
     exit 1

esac

(Optional) Enable the init.d service for start-on-boot by entering:# chkconfig zfssa_dbname on

(Optional) Start and stop the service manually using the service commands:# service zfssa_dbname start# service zfssa_dbname stop

Updating oranfstab to Access Sun ZFS Storage Appliance Exports

To update the oranfstab file to access Sun ZFS Storage Appliance exports, use the appropriate following option.

Note: If you used the Oracle Exadata Backup Configuration Utility, you may optionally perform this procedure.

For a one-pool configuration:

server: 192.168.36.200

path: 192.168.36.200 export: /export/dbname/backup1 mount: /zfssa/dbname/backup1 export: /export/dbname/backup2 mount: /zfssa/dbname/backup2 export: /export/dbname/backup3 mount: /zfssa/dbname/backup3 export: /export/dbname/backup4 mount: /zfssa/dbname/backup4

For a two-pool configuration:

server: 192.168.36.200

path: 192.168.36.200 export: /export/dbname/backup1 mount: /zfssa/dbname-2pool/backup1 export: /export/dbname/backup3 mount: /zfssa/dbname-2pool/backup3 server: 192.168.36.201 path: 192.168.36.201 export: /export/dbname/backup2 mount: /zfssa/dbname-2pool/backup2 export: /export/dbname/backup4 mount: /zfssa/dbname-2pool/backup4

Mounting the Shares on the Host

To mount the shares on the host, enter one of the following two options:

# service mount_dbname startor  # dcli -l root -g /home/oracle/dbs_group service mount_dbname start

Setting the Ownership of the Mounted Shares

Change the permission settings of the mounted shares to match the permission settings of ORACLE_HOME. In this example, the user and group ownerships are set to oracle:dba.

Note: If you used the Oracle Exadata Backup Configuration Utility, you may optionally perform step 2; step 1 has already been performed for you.

1. Enter one of the following two options:# chown oracle:dba /zfssa/dbname/*or# dcli -l root -g /home/oracle/dbs_group chown oracle:dba/zfssa/dbname/*

2. Restart the Oracle Database instance to pick up the changes that were made to the oranfstab file using one of the following options:

Restart one instance at a time (rolling upgrade), for example:

• $ srvctl stop instance -d dbname -i dbname1

• $ srvctl start instance -d dbname -i dbname1

• $ srvctl stop instance -d dbname -i dbname2

• $ srvctl start instance -d dbname -i dbname2

• $ srvctl stop instance -d dbname -i dbname3

• $ srvctl start instance -d dbname -i dbname3

• $ srvctl stop instance -d dbname -i dbname4

• $ srvctl start instance -d dbname -i dbname4

• $ srvctl stop instance -d dbname -i dbname5

• $ srvctl start instance -d dbname -i dbname5

• $ srvctl stop instance -d dbname -i dbname6

• $ srvctl start instance -d dbname -i dbname6

• $ srvctl stop instance -d dbname -i dbname7

• $ srvctl start instance -d dbname -i dbname7

• $ srvctl stop instance -d dbname -i dbname8

• $ srvctl start instance -d dbname -i dbname8

Restart the entire database, for example:

• $ srvctl stop database -d dbname

• $ srvctl start database -d dbname