BR0252E Function fopen() failed for '/oracle/SID/sapbackup/.user.pas' at location BrToolCall-2

[Former Member]

Hi all,

I am working on setting up the DB13/BRTOOLS integration.

I am trying to run a db check from sidadm user through brtools and getting the below error.

BR0280I BRTOOLS time stamp: 2014-04-24 09.35.56

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0252E Function fopen() failed for '/oracle/PB1/sapbackup/.user.pas' at location BrToolCall-2

BR0253E errno 13: Permission denied

I changed the permissions for br* to 755 as below

but still I am getting the same error.

ustrlxpb1db80:pb1adm 73>  ls -l br*

-rwxr-xr-x 1 pb1adm sapsys 5736689 Sep  7  2011 brarchive

-rwxr-xr-x 1 pb1adm sapsys 5854578 Sep  7  2011 brbackup

-rwxr-xr-x 1 pb1adm sapsys 7577045 Sep  7  2011 brconnect

-rwxr-xr-x 1 pb1adm sapsys 6279708 Sep  7  2011 brrecover

-rwxr-xr-x 1 pb1adm sapsys 2227868 Sep  2  2011 brrestore

-rwxr-xr-x 1 pb1adm sapsys 8033945 Sep  7  2011 brspace

-rwxr-xr-x 1 pb1adm sapsys 3090793 Sep  2  2011 brtools

What might be the issue?

Thanks

vimal

[former_member182657 · Accepted solution]

Hi Vimal,

It's completely related with permission as well as ownership issue .Provide oracle dba ownerships to the br tools as like below:

chown ora<sid>:dba br*

Please verify permissions & ownership for sapbackup dir ,best would be to check for oracle directory.

Also please follow SCN links

Error using BRTOOLS | SCN

Regards,

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

Thanks for your information.

I changed the persmissions for sapbackup and sapcheck to 775 and I can able to start the dbcheck via brtools through sidadm user.

But it got stuck with a below sql error , with insufficient privileges

BR0280I BRTOOLS time stamp: 2014-04-24 10.36.06
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 7.20 (17)
BR0805I Start of BRCONNECT processing: censafis.chk 2014-04-24 10.36.06
BR0484I BRCONNECT log file: /oracle/PB1/sapcheck/censafis.chk
BR0477I Oracle pfile /oracle/PB1/112_64/dbs/initPB1.ora created from spfile /oracle/PB1/112_64/dbs/spfilePB1.ora

BR0280I BRCONNECT time stamp: 2014-04-24 10.36.08
BR0813I Schema owners found in database PB1:
APPQOSSYS, DBSNMP, DIP, OPS$ORAPB1, OPS$PB1ADM, OPS$SAPSERVICEPB1, ORACLE_OCM, OUTLN, SAPSR3*, SYS,
SYSTEM

BR0280I BRCONNECT time stamp: 2014-04-24 10.36.09
BR0814I Number of tables/partitions in schema of owner SAPSR3: 25128/247
BR0836I Number of tables treated as info cubes for owner SAPSR3: 1676
BR0814I Number of tables/partitions in schema of owner SYS: 890/298
BR0814I Number of tables/partitions in schema of owner SYSTEM: 151/39

BR0280I BRCONNECT time stamp: 2014-04-24 10.36.12
BR0815I Number of indexes/partitions in schema of owner SAPSR3: 33103/502
BR0815I Number of indexes/partitions in schema of owner SYS: 965/242
BR0815I Number of indexes/partitions in schema of owner SYSTEM: 212/52

BR0280I BRCONNECT time stamp: 2014-04-24 10.36.13
BR0816I Number of segments in schema of owner DBSNMP: 8
BR0816I Number of segments in schema of owner OPS$PB1ADM: 1
BR0816I Number of segments in schema of owner OUTLN: 9
BR0816I Number of segments/LOBs in schema of owner SAPSR3: 21553/2395
BR0816I Number of segments/LOBs in schema of owner SYS: 2714/144
BR0816I Number of segments/LOBs in schema of owner SYSTEM: 407/22

BR0280I BRCONNECT time stamp: 2014-04-24 10.36.13
BR0961I Number of conditions found in DBCHECKORA: 128
BR0280I BRCONNECT time stamp: 2014-04-24 10.36.13

BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement:
'PREPARE stmt_5 FROM'
'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYPE = 'TABL' AND DIFFKIND IN ('02', '61', '99') ORDER BY OBJNAME'
ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: censafis.chk 2014-04-24 10.36.13
BR0280I BRCONNECT time stamp: 2014-04-24 10.36.13
BR0804I BRCONNECT terminated with errors

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 3

Thanks

Vimal

[former_member188883 · Accepted solution]

Hi Vimal,

Please try it out with orasid user and post the results.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

I can execute brtools via orasid user

but the same sql error.

BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement:

'PREPARE stmt_5 FROM'

'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYPE = 'TABL' AND DIFFKIND IN ('02', '61', '99') ORDER BY OBJNAME'

ORA-01031: insufficient privileges

Need to check on missing privileges.

Thanks

Vimal.

[Former Member]

I am working on setting up the DB13/BRTOOLS integration.

There is no such additional activities that customer to perform for this!

If you have your users/permissions in place then it should work automatically.

After kernel update, did you run the saproot.sh and oraroot.sh scripts?

If not, just follow SAP note 113747 and correct the permissions to all BR* components.

Regards,

Nick Loy

[former_member182657]

Hi Vimal,

ORA-01031: insufficient privileges

Refer SAP Note 400241and follow SCN link ORA-01031: insufficient privileges | SCN

Thanks,

Gaurav

[willi_eimler]

Hi Vimal,

please execute:

pb1adm> cdexe

pb1adm> pwd

pwd provides you <exe_Path>

root> cd <exe_Path>

root> ./oraroot PB1

If oraroot doesn't exists do

root> ./saproot PB1

These statements will adjust the perminnions of the br-files.

Best regards

Willi Eimler

[Former Member]

Hi eimler,

Thnaks for your suggestions.

It worked out for me.

I ran the .sh scripts and the permissions were set correctly for Brtools and now I can run it from sidadm.

This is to run the jobs in db13 via sidadm.

Thanks everyone.

Vimal

[former_member188883]

Hi Vimal,

I am trying to run a db check from sidadm user through brtools and getting the below error.

brtools should be always executed using orasid user. Also as mentioned in the response above owner has to be orasid:dba

Please adjust the permissions and execute brtools using orasid user.

Hope this helps.

Regards,

Deepak Kori