Check Database Failed

[Former Member]

Dear Friends,

After the refresh of QAS from PRD, When I am running "CHECK DATABASE" or "Check and update optimizer statistics" from DB13 it gives following error:

Job started

Step 001 started (program RSDBAJOB, variant &0000000001777, user ID BCHBASIS)

Execute logical command BRCONNECT On host bchqas

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

BR0801I BRCONNECT 7.00 (43)

BR0805I Start of BRCONNECT processing: cedjdcad.chk 2010-06-02 15.51.39

BR0252E Function fopen() failed for 'K:\oracle\QAS\sapcheck\cedjdcad.chk' at location main-11

BR0253E errno 13: Permission denied

BR0121E Processing of log file K:\oracle\QAS\sapcheck\cedjdcad.chk failed

BR0280I BRCONNECT time stamp: 2010-06-02 15.51.45

BR0301E SQL error -1017 at location db_connect-2,SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance QAS failed

BR0806I End of BRCONNECT processing: cedjdcad.chk2010-06-02 15.51.45

BR0280I BRCONNECT time stamp: 2010-06-02 15.51.45

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Except this everthings is running fine, Please help me.

[Former Member]

Aditionally I also feel apart from OPS$ user there is a permission issue for sapcheck directory.

Please note sidadm should be able to write on this directory /oracle/SID/sapcheck

Regards

Kausik

[Former Member]

BR0301E SQL error -1017 at location db_connect-2,SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance QAS failed

Problem with your OPS$ user dsitribution, check below SAP notes and create/correct them.

SAP Note 50088

SAP Note 400241

Regards,

Nick Loy