Database Reference
In-Depth Information
ASM Cluster File System created on /dev/asm/orahomevol-137 successfully. Run the generated
ACFS registration script /u01/app/grid/cfgtoollogs/asmca/scripts/acfs_script.sh as
privileged user to register the ACFS with Grid Infrastructure and to mount the ACFS. The
ACFS registration script needs to be run only on this node: rac12node1.
The script creates the ACFS file system, registers it as a resource with Clusterware, and starts it. The final
configuration of the file system is:
[grid@rac12node1 ~]$ srvctl config filesystem -d /dev/asm/orahomevol-137
Volume device: /dev/asm/orahomevol-137
Canonical volume device: /dev/asm/orahomevol-137
Mountpoint path: /u01/app/oracle
User:
Type: ACFS
Mount options:
Description:
Nodes:
Server pools:
Application ID:
ACFS file system is enabled
[grid@rac12node1 ~]$
Installing the Shared Database Binaries
When you have made sure that the database binaries have been mounted on each host, you need to install the
database binaries. Again, you should install the binaries for a single instance only. This way you are protected from
accidentally starting a database as a cluster database, which would constitute to a license violation. When selecting
the location for the database installation, double-check that you are installing on the newly created ACFS, instead of
a local file system.
The installation of the database binaries is completely identical to an installation to a non-shared file system.
You can read more about installing the database binaries for a single instance Oracle database in Chapter 6.
Creating the Database
With the Oracle Home created on a shared ACFS device, you can now start the Database Configuration Assistant
from it. To make maximum use of the shared file system you should consider placing the diagnostic destination to the
cluster file system as well. All other database related files should be placed into ASM. Remember that the database
must be a single instance Oracle database.
If your engineering department has supplied a database template, the configuration of the database could not be
easier. Here is an example for a single instance database creation in which the default data file location is set to disk
group DATA and the fast recovery area is defined in disk group +RECO. Also note how the audit file destination and
diagnostic destination are explicitly placed on the ACFS file system:
[oracle@rac12node1 ~]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/bin/dbca \
> -silent -createDatabase -templateName active_passive.dbc -gdbName apclu \
> -sysPassword sys -createAsContainerDatabase true -numberOfPDBs 1 \
> -pdbName apress -systemPassword sys -storageType ASM -diskGroupName DATA \
> -recoveryGroupName RECO -totalMemory 1536
Enter PDBADMIN User Password:
Search WWH ::
Custom Search