DBA:CHECKDB job failing

[Former Member]

Hello All,

DBA job is failing due to below error.I searched in SCN but i could get exact solution .

Job started

Step 001 started (program RSDBAJOB, variant &0000000000128, user ID BASIS@ORIGIN)

Execute logical command BRCONNECT On host beevsprd

Parameters: -jid CHECK20080528230000 -u / -c -f check

BR0801I BRCONNECT 7.20 (36)

BR0805I Start of BRCONNECT processing: ceqfmpfw.chk 2015-04-05 23.00.04

BR0252E Function fopen() failed for '/oracle/PRD/sapcheck/ceqfmpfw.chk' at location main-6

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/PRD/sapcheck/ceqfmpfw.chk failed

BR0806I End of BRCONNECT processing: ceqfmpfw.chk2015-04-05 23.00.04

BR0280I BRCONNECT time stamp: 2015-04-05 23.00.05

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

when i login to OS level and checked i could not find file ceqfmpfw.chk.

-rw-r--r-- 1 oraprd dba     2431 Mar 15 10:04 ceqbksic.sta

-rw-r--r-- 1 oraprd dba     2499 Mar 15 10:10 ceqbksky.sta

-rw-r--r-- 1 oraprd dba      274 Mar 15 11:17 connPRD.log

-rw-r--r-- 1 oraprd dba 24516876 Mar 15 11:17 ceqbkuwn.sta

Above files are are only available in the directory.

so If i change permissions of rw-r--r-- 1 oraprd dba 24516876 Mar 15 11:17 ceqbkuwn.sta as below will it be succesful.

rw-r--r-- 1 oraprd sapsys 24516876 Mar 15 11:17 ceqbkuwn.sta

Please suggest me on this.

Regards

Shekar

[Fabrizio_Irmici]

Hi Shekar,

I recently had the same problem.

First of all,as James suggested, read SAP note 113747 in order to check the brtools permission and the group ownership of sidadm and orasid.

After this read the following SAP note too:

134592 - Import of SAPDBA role (sapdba_role.sql)

I downloaded the role and I imported it executing the script as explained in the note.

Cheers,

Fabrizio

[JamesZ]

Hi Shekar,

Please refer to SAP note 113747 for the authorization of brtools.

Cheers,
James

[Reagan]

Things you can check.

1 - Check the permissions and ownership of BR*Tools

2 - Check the groups of ora<SID> and <SID>adm

[Former Member]

Hello Benjamin,

-rwxr-xr-x 1 prdadm sapsys  6160317 Mar 29  2014 brrestore

-rwxr-xr-x 1 prdadm sapsys  6763133 Mar 29  2014 brtools

-rwsrwxr-- 1 oraprd sapsys  9374426 Mar 31  2014 brarchive

-rwsrwxr-- 1 oraprd sapsys  9488140 Mar 31  2014 brbackup

-rwsrwxr-- 1 oraprd sapsys 11395315 Mar 31  2014 brconnect

-rwxr-xr-x 1 prdadm sapsys  9942753 Mar 31  2014 brrecover

-rwxr-xr-x 1 prdadm sapsys 11828395 Mar 31  2014 brspace

Check the groups of ora<SID> and <SID>adm: How can i Check this.

Regards

Shekar

[Reagan]

id oraprd

id prdadm

Also what happens when you run the brconnect check command from the OS level as prdadm?

brconnect -u / -c -f check

In the system I have I can see the logs under /oracle/PRD/sapcheck are having oraprd and sapsys and in yours they have dba as the group.

[Former Member]

Hello,

I did not run the job manually,it will run in some time,but it has been failing from long time.

drwxr-xr-x  2 oraprd dba   4096 Mar 15 11:17 sapcheck

:oraprd 129> ls -ltr

total 23956

-rw-r--r-- 1 oraprd dba     2431 Mar 15 10:04 ceqbksic.sta

-rw-r--r-- 1 oraprd dba     2499 Mar 15 10:10 ceqbksky.sta

-rw-r--r-- 1 oraprd dba      274 Mar 15 11:17 connPRD.log

-rw-r--r-- 1 oraprd dba 24516876 Mar 15 11:17 ceqbkuwn.sta

The permissions for *sta should be oraprd:sapsys .

Please let me know to which file permissions should be changed.

Regards

Shekar

[Reagan]

and have you checked the groups of the OS user like I have suggested?

You can execute the brconnect check manually from the OS level and see how it goes.

I have seen in the past that the check works fine from the OS level but fails when executed from SAP. I would change the group from dba to sapsys and see if it works.

[Former Member]

Hello ,

Not sure how to check groups of the OS user .

brconnect -u / -c -f check ,i tried but went to error.

BR0801I BRCONNECT 7.20 (36)

BR0805I Start of BRCONNECT processing: ceqfweyo.chk 2015-04-07 21.53.34

BR0252E Function fopen() failed for '/oracle/PRD/sapcheck/ceqfweyo.chk' at location main-6

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/PRD/sapcheck/ceqfweyo.chk failed

BR0806I End of BRCONNECT processing: ceqfweyo.chk 2015-04-07 21.53.34

BR0280I BRCONNECT time stamp: 2015-04-07 21.53.34

BR0804I BRCONNECT terminated with errors

Even i could not find ceqfweyo.chk

Let me know if i should change permisiions for below dba to sapsys

drwxr-xr-x  2 oraprd dba   4096 Mar 15 11:17 sapcheck

REgards

Chandrashekar

[Reagan]

As root execute these commands.

id oraprd

id prdadm

[Former Member]

Hi,

No root access,any other suggestions.

Regards

Shekar

[Reagan]

su - oraprd

id

exit

su - prdadm

id

exit

These are very basic OS commands and you should search instead of asking for all the steps.

[Former Member]

Hello,

Sorry for asking basic commands,I was confused.

prdadm 51> id

uid=307(prdadm) gid=302(sapsys) groups=302(sapsys),303(oper),304(dba),330(sapssd),20132(sapinst)

oraprd 51> id

uid=306(oraprd) gid=304(dba) groups=304(dba),303(oper),330(sapssd),20132(sapinst)

Regards

Shekar

[Reagan]

Add sapsys as a secondary group to oraprd and re-run the brconnect check command once again. Use the usermod command to add the sapsys group.

Eg: usermod -G dba,oper,sapsys,sapssd,sapinst oraprd

[Former Member]

Hello,

I will let you know output once everything is done.

Thankyou for your inputs and time.

Regards

Shekar

[Former Member]

Hello,

BRCONNECT completed successfully when i execute manually with orasid.

when i tried the same with sidadm it was failing.

So is there anything to do with SIDADM user.can you suggest.

Regards

Shekar

[Reagan]

Have you tried restarting the SAP system?

[Sriram2009]

Hi Shekar

Could you check this SAP KBA for error message "BR0253E errno 13: Permission denied"

1836386 - DBA Planning Calendar jobs fail with the error "BR0253E errno 13: Permission denied"

BR

SS

[Former Member]

hello Sriram,

Log in DB13:

BR0252E Function fopen() failed for '/oracle/PRD/sapcheck/ceqfrnyb.sta' at location file_printout-4

BR0253E errno 2: No such file or directory

when i check file ceqfrnyb.sta it does not exists.

Below files are only exists.

total 23956

-rw-r--r-- 1 oraprd dba     2431 Mar 15 10:04 ceqbksic.sta

-rw-r--r-- 1 oraprd dba     2499 Mar 15 10:10 ceqbksky.sta

-rw-r--r-- 1 oraprd dba      274 Mar 15 11:17 connPRD.log

-rw-r--r-- 1 oraprd dba 24516876 Mar 15 11:17 ceqbkuwn.sta

REgards

Shekar

[Sriram2009]

Hi

Check this SAP KBA

1686530 - CCMS transactions on Oracle RAC - Common problems and errors

BR

SS

[Former Member]

Hello Sriram,

The note is not applicable in my case,it is not RAC.

Regards

Shekar

[Sriram2009]

Hi

Check this SAP KBA 2086963

BR

SS