Brconnect check DB

[PD11]

Hi,

I am trying to execute "CheckDB" & "Update Statistics" in DB13, and

getting following error:

Job started

Step 001 started (program RSDBAJOB, variant &0000000001978, user ID JAGADISHC)

No application server on database host - rsh will be used

Execute logical command BRCONNECT On host dbRP1

Parameters: -u / -c -f check

BR0801I BRCONNECT 6.40 (15)

BR0252E Function fopen() failed for '/oracle/RP1/sapcheck/cectkkap.chk' at location main-9

BR0253E errno 2: No such file or directory

BR0121E Processing log file /oracle/RP1/sapcheck/cectkkap.chk failed

BR0806I End of BRCONNECT processing: cectkkap.chk2010-03-11 12.32.17

BR0280I BRCONNECT time stamp: 2010-03-11 12.32.17

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Regards,

Jagadish

[former_member524429]

Hi,

BR*Tools version in use?

SAP_BASIS patch level ?

Any DB related Activities were done before/after coming this error ?

Are you able to perform other DB related Jobs successfully ?

Have you tried to re-run CheckDb or DB Statistic Job after patching BR*Tools with latest available patch level ?

Regards,

Bhavik G. Shroff

[Former Member]

Hello,

Make sure that the directory /oracle/SID/sapcheck exist with 775 permissions.

check the umask it should be 022.

oraSID> umaks

022

Check the permission of brtools and make sure you have your SID under directory /oracle with owner oraSID:dba and with permissions 775.

Please check if this solves your issue. Make the thread answered.

Thanks,

Nick S

[Former Member]

Hi,

Try running ./saproot.sh from root user. It will set standard permissions of brtools.

After that also check the permissions of sapcheck directory. Set it to 755.

Regards,

Ankit

[ashish_vikas]

Hi,

I still want to to try this with 777 permission to /oracle/RP1/sapcheck directory. If this correct this error..please review what should correct permission and check.

thanks

ashish

[Former Member]

Hello,

It means file cectkkap.chk doesn't exist in the path /oracle/SID/sapcheck.Also ensure orasid is the owner and sapsys is the group

Please touch the file cectkkap.chk and also ensure that orasid is the owner and sapsys is the group .

Finally schedule the job again.

Regards,

Gopi L.

[ashish_vikas]

HI,

Please give write permission to /oracle/RP1/sapcheck directory. It will correct this error..

thanks

ashish

[PD11]

i have done all steps as per Note:113747.

Still same problem.

[ashish_vikas]

Hi,

Could you please show me permission of /oracle/RP1/sapcheck directory..and give a try with 777 permission once(just for verifying if permision issue is there or not).

Also with what id you run Brconnect and from where ..crontab / DB13 / BRTOOLS?

thanks

ashish

[fidel_vales]

Hi,

show the output of the following commands (executed as user <sid>adm)

1) find where your br*tools are located

> which brconnect

2) do an ls on that directory: for example

> ls -ls /sapmnt/RP1/exe/br*

3) do

> ls -ls /oracle/RP1

> ls -ls $ORACLE_HOME/bin/oracle

[PD11]

hi,

in other server we have setting like below

orard1 dba 8055424 Oct 10 2004 brconnect

above settings are working.

[fidel_vales]

Hello,

Have you read and applied the note I mentioned?

> orard1 dba 8055424 Oct 10 2004 brconnect

This is telling me nothing.

You do not show the authorizations for the program.

The group is NOT correct.

It may be that in that server, instead of setting the correct authorizations for the BR*Tools you change the authorization of the destination folder.

Please, read the note I mentioned

Please apply the note I mentioned.

Then, let us know.

[fidel_vales]

Hi,

That is quite a typical error, so I assume that you have not used the top left "search" field.

The problem is related to the authorizations of BR*TOOLS.

Check the owner, group, and access authorizations for BR*Tools in accordance with Note 113747.