This discussion is archived
5 Replies Latest reply: Mar 13, 2013 2:36 AM by user12053556 RSS

Permission to files available in Oracle database dump location

user12053556 Newbie
Currently Being Moderated
Hello,

Could someone make me to understand how the trace files available in trace location of 11g database(dump location in 10g or below)are having permission 640 in some databases and 660(UNIX flavored systems) . As these are the files getting created by default with database operation, what is the parameter responsible for it?
  • 1. Re: Permission to files available in Oracle database dump location
    vlethakula Expert
    Currently Being Moderated
    It depends on umask set in user's profile. Looks like it determines the permissions of trace files.


    [oracle@test env_file]$ umask
    0022


    tracefiles_public=true, this parameter allows other than DBA also to read the trace files
  • 2. Re: Permission to files available in Oracle database dump location
    user12053556 Newbie
    Currently Being Moderated
    My assumption was also the same that umask value controls it until i came across few Oracle database servers where umask value is set to 027 and still in some cases trace files are getting generated with permission value 660 and in some servers with 640. so just wondering any other parameter responsible for it as well? I know setting umask value to 0027 is not recommended by Oracle but still that does not explain why file permission value are changing from server to server.
  • 3. Re: Permission to files available in Oracle database dump location
    user12053556 Newbie
    Currently Being Moderated
    just wanted to add this for reference.. and here we can see some are getting created with 640 and some are with 660 with same umask value.

    scrbmetdkbry211[PRE-PRODUCTION]:/opt/oracle/admin/METSD/bdump (METSD1)> ls -ld .
    drwxr-xr-x 2 oracle dba 115712 Jan 31 07:51 .
    scrbmetdkbry211[PRE-PRODUCTION]:/opt/oracle/admin/METSD/bdump (METSD1)> umask
    027
    scrbmetdkbry211[PRE-PRODUCTION]:/opt/oracle/admin/METSD/bdump (METSD1)>ls -lrt | head -23
    -rw-r----- 1 oracle dba 822 Dec 19 17:47 metsd1_lgwr_10720.trc
    -rw-r----- 1 oracle dba 848 Dec 19 17:47 metsd1_lmd0_10698.trc
    -rw-r----- 1 oracle dba 1172 Dec 21 16:10 metsd1_dm00_10226.trc
    -rw-r----- 1 oracle dba 777 Dec 21 16:21 metsd1_dw01_1098.trc
    -rw-r----- 1 oracle dba 1401 Dec 21 16:25 metsd1_dm00_1053.trc
    -rw-r----- 1 oracle dba 709 Jan 10 20:00 metsd1_mmon_9011.trc
    -rw-r----- 1 oracle dba 6439 Jan 15 22:00 metsd1_pz99_10817.trc
    -rw-r----- 1 oracle dba 1728 Jan 17 02:00 metsd1_m000_2597.trc
    -rw-rw---- 1 oracle dba 1730 Jan 20 00:00 metsd1_m000_20598.trc
    -rw-rw---- 1 oracle dba 759 Jan 20 02:48 metsd1_mmnl_9034.trc
    -rw-r----- 1 oracle dba 1872 Jan 20 02:57 metsd1_smon_8997.trc
    -rw-r----- 1 oracle dba 320606 Jan 20 03:00 metsd1_lmon_8958.trc
    -rw-r----- 1 oracle dba 644791 Jan 20 03:00 metsd1_lmd0_8968.trc
    -rw-r----- 1 oracle dba 5083521 Jan 20 03:16 metsd1_lms1_8977.trc
    -rw-rw---- 1 oracle dba 16552 Jan 20 03:16 metsd1_lck0_9813.trc
    -rw-r----- 1 oracle dba 4962730 Jan 20 03:17 metsd1_lms0_8970.trc
    -rw-r----- 1 oracle dba 277166 Jan 20 03:17 metsd1_lgwr_8993.trc
    -rw-rw---- 1 oracle dba 826 Jan 22 12:33 metsd1_j000_10268.trc
    -rw-rw---- 1 oracle dba 759 Jan 23 02:25 metsd1_q000_10347.trc
    -rw-rw---- 1 oracle dba 2888 Jan 26 06:00 metsd1_pz99_11021.trc
    -rw-rw---- 1 oracle dba 7310 Jan 28 20:20 metsd1_lns1_14783.trc
    -rw-rw---- 1 oracle dba 1406 Jan 28 20:20 metsd1_arcp_29560.trc
    -rw-rw---- 1 oracle dba 834 Jan 28 20:31 metsd1_arcr_29641.trc
    scrbmetdkbry211[PRE-PRODUCTION]:/opt/oracle/admin/METSD/bdump (METSD1)>
  • 4. Re: Permission to files available in Oracle database dump location
    Sunthar Tharmalingam Explorer
    Currently Being Moderated
    whats the value Set for TRACEFILES_PUBLIC
    thanks
  • 5. Re: Permission to files available in Oracle database dump location
    user12053556 Newbie
    Currently Being Moderated
    TRACEFILES_PUBLIC is false.
    However I gave gone through numerous documents on it during this time.. and those are pointing to..

    umask value may be changed.
    OEM logs may come with different file permission.
    and Oracle internally choose what should be the permission of datafiles and redologs. (not sure if that is true with trace files)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points