ss

Oracle Tips by Burleson

Change file owners in UNIX

The UNIX chown command is used by the Oracle DBA to change the group and owner for UNIX files. There are time when a UNIX developer creates or changes a UNIX file for Oracle and the Oracle DBA must change both the UNIX owner and the UNIX group for a file.

In the example below, we change the owner from mario to oracle and the UNIX group from devl to dba for all files in the directory.

root> ls -al

total 56
drwxr-sr-x 2 mario devl 512 Aug 31 1999 ./
drwxr-sr-x 8 mario devl 512 Apr 13 08:28 ../
-rwxrwxr-- 1 mario devl 819 Jun 23 16:11 initmysid1.ora
-rwxrwxr-- 1 mario devl 4435 Jun 26 15:00 initprodserv1.ora

root> chown oracle:dba *

root> ls -al

total 56
drwxr-sr-x 2 oracle dba 512 Aug 31 1999 ./
drwxr-sr-x 8 oracle dba 512 Apr 13 08:28 ../
-rwxrwxr-- 1 oracle dba 819 Jun 23 16:11 initmysid1.ora
-rwxrwxr-- 1 oracle dba 4435 Jun 26 15:00 initprodserv1.ora

The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA