cancel
Showing results for 
Search instead for 
Did you mean: 

New data file permissions

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

....

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Then umask shouldn't matter.

regards