Skip to Content
author's profile photo Former Member
Former Member

New data file permissions

Hi all,

Recently we migrated our data centre to other loacation. Now while we are running checkdb on our production server we are getting some error, that related to file perission.

Root Cause: Existing all data files had 775 file permissions and previously it worked with proadm/orapro

But after migration, when we are adding a new data file it is taking 700 permission as default.

And checkdb is runnig with proadm/proadm, which havenot actual permissions.

And we find the temporary solution for this as we are changing new added datafiles to 755.

Then it is gettind executed with proadm/proadm.

But we want to fix this permanently. Here i am hiloghting one thing that umask for orapro is 077. should i change the umask to 022? Then with which permissions new data file be created?

Other wise we need to change the executor of checkdb as proadm/orapro. This was the exact one exixt with our old server. With BRTOOLS i am unable to change these executor.

Please find the start parameters of dbcheck

BR0801I BRCONNECT 6.40 (50)

BR0805I Start of BRCONNECT processing: ceaadfxb.chk 2009-02-27 13.00.11

BR0484I BRCONNECT log file: /oracle/PRO/sapcheck/ceaadfxb.chk

BR0101I Parameters

Name Value

oracle_sid PRO

oracle_home /oracle/PRO/920_64

oracle_profile /oracle/PRO/920_64/dbs/initPRO.ora

sapdata_home /oracle/PRO

sap_profile /oracle/PRO/920_64/dbs/initPRO.sap

system_info proadm/proadm phdb7127 HP-UX B.11.11 U 9000/800

oracle_info PRO 9.2.0.8.0 8192 2321 5052958522

sap_info 620 SAPR3 PRO L1907572054 R3_ORA 0020237303

make_info hp_64 OCI_920 Oct 11 2008

command_line brconnect -u / -jid CHECK20080215130000 -c -f check

alert_log /oracle/PRO/saptrace/background/alert_PRO.log

Regards

Nick Loy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2009 at 08:35 AM

    Make sure brconnect has owner orapro and 4775 permissions, as described in SAP note 113747.

    Then umask shouldn't matter.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2009 at 09:02 AM

    Hi Joe,

    Thanks for your quick response.

    Here we have 755 permissions for brconnect, But can you clarify the difference between 755 and 4755.

    And one more thing--Why our dbcheck executing with user proadm/proadm. Can i change the same to proadm/orapro. Because in our earlier system dbcheck was running with proadm/orapro.

    And dbcheck is getting executed after that it is showing the error as below:

    Even dbcheck is also not getting executed, we can change the brconnect permissions as mentioned in note.

    BR0252E Function stat() failed for '/oracle/PRO/sapdata5/btabd_1/btabd.data1' at location BrFileStatGet-1

    BR0253E errno 13: Permission denied

    BR0273E Determination of file status for /oracle/PRO/sapdata5/btabd_1/btabd.data1 failed

    Regards

    Nick Loy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The additional 4 in 4775 does exactly what you need here. The effective user id at run time will be changed to orapro.

      For more info ask your Unix admin, or read manual pages for ls and chmod.

      regards

      Edited by: Joe Bo. on Feb 27, 2009 10:20 AM

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2009 at 10:24 AM

    ....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.