Oracle Audio Technologies Retail Data Warehouse 13 - Manual (Page 13)

Alter Directory Ownership and Privileges
Database Installation Guide 5
2. Create RDW database directory structure:
ƒ Log in to the database server as UNIX user rdwdba. This user owns the database
directory structure.
ƒ Extract the files from the downloaded zip file. FTP (in binary mode) the tar file,
rdw13_db.zip, to <database_directory> on the UNIX server where the rdw13
database will be created. The <database_directory> directory is a working
directory that should be designated at this time. As the rdwdba user, extract the
rdw13_db.zip file by typing the following at the UNIX prompt:
unzip rdw13_db.zip
3. Create RDW code directory structure:
ƒ Log in to the database server as the UNIX user oretail. This user owns the code
directory structure.
ƒ FTP (in binary mode) the file rdw13_code.zip to a base directory where you wish
to permanently store the RDW code directory. This base directory should be on
the UNIX server where the RDW database will be created. The base directory is
a working directory that you should designate at this time. As the oretail user,
extract the rdw13_code.zip file in the base directory specified above by entering
the following at the UNIX prompt:
unzip rdw13_code.zip
Note: It is highly recommended that clients have a separate
server for production installations. To set up a production
environment; create a prd directory, then copy the dev
directory structure to the production server, and use the
<base_directory>/rdw13.0/prd as the code directory
structure on that server. A prd group is needed and a
separate prd user should be created as well.
Alter Directory Ownership and Privileges
For added security, alter the directory ownership and privileges.
1. Log in as the root user (in the <base_directory>/rdw13.0 directory).
2. Change the following as indicated in the table below:
ƒ the ownership (chown –R <owner> <directory>)
ƒ the group (chgrp –R <user group> <directory>)
ƒ the privileges (chmod –R <privs> <directory>)
Directory Owner Group Privilege
retek oretail dba 775
dev rdw13dev dev 775
dbasql rdwdba – Oracle dba 774
For example: cd <base_directory>/rdw13.0
chown –R rdw13dev dev
chgrp –R dev dev
chmod –R 775 dev