on 02-27-2009 8:00 AM
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
....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure brconnect has owner orapro and 4775 permissions, as described in SAP note 113747.
Then umask shouldn't matter.
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.