Database Reference
In-Depth Information
Before Direct NFS can be used with the database, it needs to be enabled. In Oracle Database 11g Release 2, this
is easily done by recompiling binaries with the
make
command. Listing 3-14 shows you have to execute the
make
command and enable Direct NFS within the Oracle Database.
Listing 3-14.
Recompile with make
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dnfs_on
Before recompiling, all databases need to be shut down, and then recompiling of the binaries can be done using
make
. After the recompile is complete, additional databases can be brought back online. After starting the instances,
the database instance alert.log will show that Direct NFS is enabled (see Listing 3-15).
Listing 3-15.
Entry in the alert.log
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0
Once Direct NFS is configured for the database and verified in the alert log, you can create tablespaces on the
now accessible NFS storage. Listing 3-16 illustrates how to create a new tablespace and show the status of the file on a
Direct NFS mount.
Listing 3-16.
Create Tables on Direct NFS
SQL> create tablespace archive_data datafile
'/oranfsarch/archive_data01.dbf' SIZE 40960M;
Tablespace created.
SQL> select file#, name, status from v$datafile;
FILE# NAME STATUS
------ --------------------------------------------- -------
1 +DATA/pbrb/datafile/system.272.781351553 SYSTEM
2 +DATA/pbrb/datafile/sysaux.273.781351557 ONLINE
3 +DATA/pbrb/datafile/undotbs1.274.781351561 ONLINE
4 +DATA/pbrb/datafile/undotbs2.276.781351569 ONLINE
5 +DATA/pbrb/datafile/users.277.781351571 ONLINE
6 +DATA/pbrb/datafile/users.bigfile ONLINE
7 /oranfsarch/nfs/archive_data01.dbf ONLINE
With the ability to add additional storage space by Direct NFS on the Oracle Database Appliance, you now have a
powerful and expandable environment to run your Oracle Database.
Summary
With a little planning and preparation, the Oracle Appliance Manager (OAM) allows you to quickly deploy a new
system in a few hours. Full RAC deployments can be online and ready in a fraction of the time it takes to build a
system using the traditional methods from in the past. The OAM can be accessed via a VNC session, allowing you to
deploy from most platforms without the need for installing the X-window system. This saves time, while still allowing
you to rapidly deploy the system.
