Implementing the Oracle Database File System

The Oracle Database File System (DBFS), included with Oracle Database 11g Enterprise Edition, creates a standard file system interface on top of files and directories that are stored in database tables. DBFS is similar to NFS in that it provides a shared network file system that looks like a local file system. Like NFS, there is a server component and a client component. If you use Oracle DBFS at your site, PeopleTools provides the infrastructure to use DBFS as the Report Repository with your PeopleSoft system.

For detailed information about Oracle DBFS and its architecture, see the Oracle DBFS documentation in Oracle® Database SecureFiles and Large Objects Developer's Guide 11g Release 2 (11.2).

Oracle DBFS must be licensed, installed, and enabled before you can set up your PeopleSoft system to take advantage of this feature. For detailed information about installing DBFS, see Installing DBFS in Oracle® Database SecureFiles and Large Objects Developer's Guide 11g Release 2 (11.2)

The following configuration is required to implement DBFS:

• The DBFS Report Repository must be on a mounted Linux File System.

• The PeopleSoft Webserver must be installed on Linux.

• The PeopleSoft Application Server and the PeopleSoft Database can be installed on any other supported system (Windows/Unix/Linux).

To implement DBFS on your PeopleSoft system, complete the following steps:

1. Using SQLPlus, connect as SYSDBA and grant permission for the creation of secure files.

   For example:

   SQL> show parameter db_securefile
   NAME                          TYPE                VALUE
   \-----------------------\  -----------------   \-------------\
   db_securefile                string              PERMITTED
   

2. Using SQLPlus, connect as SYSDBA and grant the DBFS role to ACCESSID.

   For example:

   SQL> grant dbfs_role to SYSADM;

3. Using SQLPlus, connect as ACCESSID and create the tablespace for the DBFS Report Repository.

   For example:

   SQL> connect SYSADM/SYSADM
   SQL> create tablespace dbfs_tbs datafile 'd:\orattach\oradata\Pt852GA\dbfs_tbs1.dbf' size 500M reuse autoextend on next 200M segment space management auto; 
   
   Tablespace created.
   

4. For Oracle 12c only, using SQLPlus, connect as SYSDBA and grant unlimited quota to the DBFS Report Repository tablespace for ACCESSID.

   For example:

   SQL> alter user SYSADM quota unlimited on dbfs_tbs;

5. Using SQLPlus, connect as ACCESSID and create, register, mount, and set read/write access for the DBFS Report Repository.

   For example:

   SQL> connect SYSADM/SYSADM
   
   CREATE FILESYSTEM REPORT REPOSITORY:
   SQL> @D:\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\dbfs_create_filesystem.sql dbfs_tbs ReportRepository
   No errors.
   \-------\
   CREATE STORE:
   begin dbms_dbfs_sfs.createFilesystem(store_name => 'FS_REPORTREPOSITORY',
   tbl_name => 'T_REPORTREPOSITORY', tbl_tbs => 'dbfs_tbs', lob_tbs => 'dbfs_tbs',
   do_partition => false, partition_key => 1, do_compress => false, compression =>
   '', do_dedup => false, do_encrypt => false); end;
   \-------\
   REGISTER STORE:
   begin dbms_dbfs_content.registerStore(store_name=> 'FS_REPORTREPOSITORY',
   provider_name => 'sample1', provider_package => 'dbms_dbfs_sfs'); end;
   \-------\
   MOUNT STORE:
   begin dbms_dbfs_content.mountStore(store_name=>'FS_REPORTREPOSITORY',
   store_mount=>'ReportRepository'); end;
   \-------\
   CHMOD STORE:
   declare m integer; begin m := dbms_fuse.fs_chmod('/ReportRepository', 16895);
   end;
   No errors.
   

6. Mount the DBFS Report Repository using the DBFS Client on Linux.

   For example:

   [oracle@<hostname>]$export LD_LIBRARY_PATH=/products/oracle/11.2.0/dbhome_1/lib:/usr/lib
   [oracle@<hostname>]$mount
   
   [oracle@<hostname>]$echo "SYSADM" > dbfspassword
   [oracle@<hostname>]$nohup dbfs_client SYSADM@PT852GA /mnt/dbfs < dbfspassword &
   
   [oracle@<hostname>]$mount
   
   dbfs on /mnt/dbfs type fuse (rw,nosuid,nodev,max_read=1048576,default_permissions,user=oracle)
   
   

7. Use the mount point /mnt/dbfs/ReportRepository as the Report Repository location while configuring the PeopleSoft Web Server Domain.

   For example:

   ReportRepository /mnt/dbfs/ReportRepository
   

   You can specify the location for the Report Repository Path on the General page of the Web Profile during installation.

See the product documentation for PeopleSoft 9.2 Application Installation for Oracle for information on installing the PeopleSoft Pure Internet Architecture, setting up the Report Repository, and defining ReportRepositoryPath.

See the product documentation for PeopleTools: Process Scheduler for more information about Creating Server Definitions.